Data integration using conceptual modeling framework
AssigneeTata Consultancy Services Limited
InventorsSreedhar Sannareddy REDDY, Prasenjit DAS, Raghavendra Reddy YEDDULA
Life of this patent
Estimating the term…
Abstract
A computer implemented system and method that combines data from multiple sources to provide a unified view of data using multi-layered conceptual modeling framework. The invention provides means to model conceptual data models at multiple levels of abstraction and a means to map them with each other and with physical models. A query rewriting approach adopted in the present invention is capable of translating queries down multiple levels of conceptual models into physical models and Conceptual modeling framework provide a means to capture and process semantic intent of data more accurately thereby reducing data integration errors significantly.
Claims17
1) A method of providing a unified view of data existing in multi layered hierarchical structure in an enterprise application by modeling the data at multiple levels of abstraction and capturing the relationships existing between the modeled data, the said method comprising the processor implemented steps of:
- defining global schema using conceptual modeling framework to provide a aggregated view of the data;
- defining source schema at multiple levels using conceptual model for at least one level and relational model or a conceptual model for subsequent levels;
- capturing relationship between data existing at multiple levels within an hierarchical structure;
- establishing mappings and mapping rules to codify captured relationships existing between defined global schema and set of source schema;
- initializing a query on global schema and rewriting into an equivalent source schema such that the query in source schema is maximally contained in global schema;
- capturing relationship derivation dependencies between the data contained in defined global schema and source schema by constructing directed acyclic graph from established mapping rules and conceptual models;
- processing the directed acyclic graph to construct a mapping system, the said mapping system having alternate GAV and LAV mapping layers;
- translating the queries down multiple levels of conceptual model into physical model queries by applying the obtained alternate GAV and LAV mapping layers and;
- executing the translated physical model query either directly or indirectly by translating the said query into a data flow graph that can optionally be exported into third party ETL tools.
13) A system for providing a unified view of data existing in multi layered hierarchical structure by modeling data at multiple levels of abstraction and capturing the relationships existing between the said data models within an enterprise application, the said system comprising of:
- A processor for executing the program instructions for capturing relationship between defined global schema and source schema and mapping rules governing the mapping between the said global schema and source schema;
- to construct directed acyclic graph to derive relation derivation dependencies based on established mapping rules;
- initialize a query on global schema into equivalent source schema;
- translating the query down multiple hierarchical level for execution within a communication network;
- aggregating the results from the set of source queries during query run time and displaying the translated query and results to the user using a display device;
- and a computer readable program storage device embodying the said program instructions.
17) A system for providing a unified view of data existing in multi layered hierarchical structure wherein the said system is characterized in being capable of executing the query at any of the intermediate levels within an enterprise hierarchy without necessitating the storage and maintenance of data at any of the said intermediate levels.
Dependencies are inferred from the claim text.