Dynamic generation of database views and class objects for providing access to repository data

• US 9,934,258 B2
• Filed: 03/31/2014
• Issued: 04/03/2018
• Est. Priority Date: 03/31/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Fuglsang, Dennis Floyd, Spiegel, Joshua Jeffrey
• Primary Examiner(s): Alam, Hosain
• Assistant Examiner(s): Allen, Nicholas
• Application Number:
  US14/230,627
• Publication Number:
  US 20150278314A1
• Time in Patent Office: 1,464 Days
• Field of Search: 707736
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/2452 Query translation

Abstract

Techniques for dynamically generating database views and class objects for allowing access to domain data stored in a repository are provided. A computer-implemented method, a system, and/or a machine-readable medium storing instructions executable by one or more processors may include generating a database view and a class object using metadata included in a domain model, and retrieving domain data from a repository using the database view and the class object. For example, a method may include obtaining a domain model from a repository, the domain model including metadata corresponding to a set of domain data stored in the repository, generating a database view of a subset of the set of domain data using the metadata, generating a class object for the subset using the metadata, generating mapping information, and retrieving the subset of domain data from the repository using the database view, the class object, and the mapping information.

Claims

1. A method, comprising:

obtaining, by a computing device, a domain model from a repository, wherein the domain model is generated to include metadata corresponding to a set of domain data stored in the repository and is generated in accordance with an input data description for the set of domain data, wherein the metadata of the domain model defines one or more domain types and one or more attribute definitions for the set of domain data stored in the repository;

generating, by the computing device, a database view of a subset of the set of domain data using the metadata, wherein the database view is generated based on a query statement referencing the subset of domain data and wherein the database view defines a table representing the subset of domain data;

generating, by the computing device, a class object for the subset of domain data using the metadata;

generating, by the computing device, mapping information by mapping the generated database view to the generated class object;

retrieving, by the computing device, the subset of domain data from the repository using the database view, the class object, and the mapping information;

receiving, by the computing device, a user query for the subset of domain data;

determining, by the computing device, a domain type from the user query, the domain type corresponding to a domain type of the subset of domain data defined by the metadata;

determining, by the computing device, the class object for the subset of data based on the domain type determined from the user query;

determining, by the computing device, the database view of the subset of data using the mapping information between the class object and the database view;

performing a query on the database view to retrieve the subset of domain data from the repository;

translating the user query into a structured query language statement using the class object, wherein performing the query on the database view includes performing the structured query language statement on the database view to retrieve the subset of domain data from the repository; and

outputting the subset of domain data as a result of the user query.

2. The method of claim 1, further comprising:

generating a class object and a database view for each domain type of the one or more domain types.

3. The method of claim 1, wherein the query statement is performed on the set of domain data stored in the repository to retrieve the subset of domain data referenced by the database view.

4. The method of claim 3, wherein the query statement includes a structured query language (SQL) statement.

5. The method of claim 1, wherein the set of domain data is stored in the repository in a generic structure with no correspondence to the domain model, and wherein the database view represents the subset of domain data as a virtual table with a specific structure corresponding to the domain model.

6. The method according to claim 1, further comprising translating the user query from a first type data format to a second type data format.

7. The method according to claim 6, wherein the first type data format is a loosely typed data format.

8. The method according to claim 1, wherein the input data description for the set of domain data is defined by a user.

9. A system, comprising:

a memory storing a plurality of instructions; and

one or more processors configurable to;

obtain a domain model from a repository, the domain model is generated to include metadata corresponding to a set of domain data stored in the repository and is generated in accordance with an input data description for the set of domain data, wherein the metadata of the domain model defines one or more domain types and one or more attribute definitions for the set of domain data stored in the repository;

generate a database view of a subset of the set of domain data using the metadata, wherein the database view is generated based on a query statement referencing the subset of domain data and wherein the database view defines a table representing the subset of domain data;

generate a class object for the subset of domain data using the metadata;

generate mapping information by mapping the generated database view to the generated class object;

retrieve the subset of domain data from the repository using the database view, the class object, and the mapping information;

receive a user query for the subset of domain data;

determine a domain type from the user query, the domain type corresponding to a domain type of the subset of domain data defined by the metadata;

determine the class object for the subset of data based on the domain type determined from the user query;

translate the user query into a structured query language query using the class object;

determine the database view of the subset of data using the mapping information between the class object and the database view;

perform the structured query language query on the database view to retrieve the subset of domain data from the repository; and

output the subset of domain data as a result of the user query.

10. The system of claim 9, wherein the one or more processors are further configurable to:

generate a class object and a database view for each domain type of the one or more domain types.

11. The system of claim 9, wherein the query statement includes a structured query language statement performed on the set of domain data stored in the repository to retrieve the subset of domain data referenced by the database view.

12. The system of claim 9, wherein the set of domain data is stored in the repository in a generic structure with no correspondence to the domain model, and wherein the database view represents the subset of domain data as a virtual table with a specific structure corresponding to the domain model.

13. A non-transitory machine-readable medium storing a plurality of instructions executable by one or more processors, the plurality of instructions comprising:

instructions that cause the one or more processors to obtain a domain model from a repository, the domain model is generated to include metadata corresponding to a set of domain data stored in the repository and is generated in accordance with an input data description for the set of domain data, wherein the metadata of the domain model defines one or more domain types and one or more attribute definitions for the set of domain data stored in the repository;

instructions that cause the one or more processors to generate a database view of a subset of the set of domain data using the metadata, wherein the database view is generated based on a query statement referencing the subset of domain data and wherein the database view defines a table representing the subset of domain data;

instructions that cause the one or more processors to generate a class object for the subset of domain data using the metadata;

instructions that cause the one or more processors to generate mapping information by mapping the generated database view to the generated class object;

instructions that cause the one or more processors to retrieve the subset of domain data from the repository using the database view, the class object, and the mapping information;

instructions that cause the one or more processors to receive a user query for the subset of domain data;

instructions that cause the one or more processors to determine a domain type from the user query, the domain type corresponding to a domain type of the subset of domain data defined by the metadata;

instructions that cause the one or more processors to determine the class object for the subset of data based on the domain type determined from the user query;

instructions that cause the one or more processors to translate the user query into a structured query language query using the class object;

instructions that cause the one or more processors to determine the database view of the subset of data using the mapping information between the class object and the database view;

instructions that cause the one or more processors to perform the structured query language query on the database view to retrieve the subset of domain data from the repository; and

instructions that cause the one or more processors to output the subset of domain data as a result of the user query.

14. The machine-readable medium of claim 13, wherein the plurality of instructions further comprise:

instructions that cause the one or more processors to generate a class object and a database view for each domain type of the one or more domain types.

15. The machine-readable medium of claim 13, wherein the query statement includes a structured query language statement performed on the set of domain data stored in the repository to retrieve the subset of domain data referenced by the database view.

16. The machine-readable medium of claim 13, wherein the set of domain data is stored in the repository in a generic structure with no correspondence to the domain model, and wherein the database view represents the subset of domain data as a virtual table with a specific structure corresponding to the domain model.