1 / 8

Oracle Enterprise Data Quality

Oracle Enterprise Data Quality. Introduction to Parsing. What is Parsing?. “The application of business rules and semantic intelligence to data in order to understand and validate it en masse and, if required, improve its structure in order to make it fit for purpose.”

kiara
Download Presentation

Oracle Enterprise Data Quality

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Enterprise Data Quality Introduction to Parsing

  2. What is Parsing? • “The application of business rules and semantic intelligence to data in order to understand and validate it en masse and, if required, improve its structure in order to make it fit for purpose.” • Commonly used to structure and prepare data before matching.

  3. Typical Business Problems (1) • Data extraction • E.g. who do I sell to? • Extract all customer names into single attribute. • Communicate with accuracy. • Avoid sending inappropriate communications. • E.g. to deceased customers. • Bad public relations and possible legal issues.

  4. Typical Business Problems (2) • Data migration: • Single name field > structured columns. • Data is now structured. Original system New system

  5. Typical Business Problems (3) • Clean Data. • E.g. For better matching. Remove or move inappropriate data. Standardize abbreviations. Remove or move personal names hidden in company names.

  6. Enterprise Data Quality Text Analysis (1) • Application of business rules and semanticintelligence. • Understanding and transforming data: • Names, Addresses, Product descriptions etc. • “Does this list contain onlynames?” • “How good is my data?”

  7. Enterprise Data Quality Text Analysis (2) • Generic capability: • Configure Parse processor to solve specific problem. • Apply own business rules. • Pre-configured Parse Processors are available. • Starting point for tailored parsing.

  8. Example: Parse a Full Name String • Parse free-text Full Name into ordered columns.

More Related