Focus is an accredited reseller and offers expert consulting services for IBM InfoSphere Discovery to help organisations accelerate deployment of information-centric projects such as data archiving, application retirement, data warehousing, data integration, or Master Data Management (MDM). By better understanding data and its relationships across the enterprise, organisations can address the inherent risks in such projects.
Using highly-innovative technologies, InfoSphere Discovery identifies and documents the data you have, where it is located, and how it is related across systems by intelligently capturing relationships, applied transformations and business rules. This process includes a full range of analysis capabilities, including:
- Discovering hidden data relationships to define "business objects" (logical groupings of data)
- Automating the detection of sensitive data
- Prototyping data consolidation rules for new projects
- Accommodates the widest range of enterprise data sources including relational databases and any structured data source that can be represented in a text file format such as hierarchical database
- Using heuristics and sophisticated algorithms that automate an otherwise time consuming manual process
Unique Features of Discovery
|
Cross source column overlap analysis
|
|
Cross compare all the columns across many data sources in order to establish a baseline of overlapping data across multiple sources
|
|
Matching key prototype
|
|
Hypothesise and test the quality of matching keys on multiple data sources simultaneously
|
|
Empty target modeling and prototype
|
|
Drag, drop and combine attributes from data sources to prototype a new unified schema. View the profiling statistics for the prototype target data
|
|
Precedence Discovery
|
|
Automatic generation of attribute matching precedence based on statistical analysis
|
|
Transformation Rule Discovery
|
|
IBM Infosphere discovery features patented algorithms that automate the discovery of complex business rules between two structured data sets:- Substrings, concatenations, cross-references, aggregations, case statements, arithmetic equations etc.
|
|
Automatic matching key discovery
|
|
Algorithms automatically discover the matching key and statistically validates the key between two data sources
|
|
Cross source data preview
|
|
Provides side by side preview of data across multiple data sources for the same logical row and allow the analyst to see values that match the business rules and anomalies that do not
|
|
Integration
|
|
Data relationships established using InfoSphere Discovery are available to other InfoSphere modules and/or serve as essential inputs into information-centric projects such as data integration, master data management, data warehousing test data management and data archiving using IBM Optim products (see below)
|