System and method for semantic exposure of data stored in a dynamic schema
A system and method for providing semantic access of data in a master data management system. Data stored in a dynamic repository schema is exposed in a semantically accurate format. The schema is determined from information received from the master data management system describing the schema. A set of database views is generated based on said schema. A query from an external application in a standard query language is received and the query is performed using at least one database view. The database views are updated when a schema change is detected.
1. A method of providing semantic access of data in a master data management system comprising:
receiving information describing a schema of said master data management system storing information in a data store, wherein said schema is dynamic;
determining said schema from said information;
generating, by a database view manager within an external request manager, a set of database views based on said schema without replicating information in the data store, wherein at least one database view is a client-specific database view for a client, and further wherein said client-specific database view is configured to restrict access to a subset of said data said client is authorized to access;
receiving, at the request manager, a query from an external application in a standard query language;
performing said query using at least one database view in said set of database views;
detecting a change in said schema;
receiving new information describing a new schema;
determining the new schema from said new information;
generating, by the database view manager, an updated set of database views based on the new schema, wherein the updated set of database views includes an updated client-specific database view; and
replacing said set of database views with said updated set of database views.
2. The method of claim 1 , wherein said information comprises table and field names and their properties.
3. The method of claim 1 , wherein said information comprises metadata tables generated by said master data management system.
4. The method of claim 1 , wherein said standard query language is Structured Query Language (SQL).
5. The method of claim 1 , wherein each database view in said set of database views comprises a stored database query.
6. The method of claim 1 , wherein said query is limited to read-only queries.
7. A computer system comprising a special purpose computer, said special purpose computer comprising computer-readable instructions and data stored on a computer-readable medium accessible by said special purpose computer, said computer-readable instructions implementing a process for ordering tasks with complex interrelationships, said system comprising:
a computer;
a non-transitory computer-readable medium coupled to said computer, said computer-readable medium comprising computer-readable instructions and data, said computer-readable instructions and data configured to:
receive information describing a schema of a master data management system storing information in a data store, wherein said schema is dynamic;
determine said schema from said information;
generate, by a database view manager within an external request manager, a set of database views based on said schema without replicating information in the data store, wherein at least one database view is a client-specific database view for a client, and further wherein said client-specific database view is configured to restrict access to a subset of said data said client is authorized to access;
receive, at the request manager, a query from an external application in a standard query language;
perform said query using at least one database view in said set of database views;
detect a change in said schema;
receive new information describing a new schema;
determine the new schema from said new information;
generate, by the database view manager, an updated set of database views based on the new schema, wherein the updated set of database views includes an updated client-specific database view; and
replace said set of database views with said updated set of database views.
8. The computer system of claim 7 , wherein each database view in said set of database view comprises a stored database query.
9. The computer system of claim 7 , wherein said standard query language is SQL.
10. The computer system of claim 7 , wherein said information comprises table and field names and their properties.
11. The computer system of claim 7 , wherein said information comprises metadata tables generated by said master data management system.
12. The computer system of claim 7 , wherein said query is limited to read-only queries.