Abstract data model extension through managed physical statement structures
A method and system for integrating a physical query statement in a data abstraction model comprising a plurality of logical fields are provided. The method involves receiving the physical query statement and parsing the physical query statement to provide physical fields. The next step is determining whether the physical fields can be directly mapped to logical fields in the data abstraction model to yield a first determination result. Following this step, if at least one first physical field cannot be directly mapped to logical fields in the data abstraction model, then the next step is determining whether the first physical field can be determined from fields in the data abstraction model to yield a second determination result. Finally, the method involves providing a representation of the first determination result and a representation of the second determination result.
1. A computer-implemented method of integrating a physical query statement in a data abstraction model comprising a first plurality of logical fields used to expose an underlying physical database, the method comprising:
parsing the physical query statement to identify a plurality of output fields specified by the physical query statement;
upon determining that a first output field of the identified plurality of output fields has a corresponding logical field, of the first plurality of logical fields, mapping the first output field of the physical query statement to the corresponding logical field provided by the data abstraction model;
upon determining that a second output field of the identified plurality of output fields does not have any corresponding logical field, generating a second logical field mapping to the second output field, wherein the second logical field includes an access method mapping the second logical field to the second output field;
upon determining that a naming conflict exists between the second output field and one of the plurality of logical fields:
determining a second name to assign to the second logical field to resolve the determined naming conflict, wherein the second name is different from a first name; and
adding the second logical field having the second name to the plurality of logical fields, wherein the naming conflict is resolved without having to replace any logical field in the data abstraction model; and
upon determining that no naming conflict exists between the second output field and one of the plurality of logical fields:
determining a first name to assign to the second logical field; and
adding the second logical field having the first name to the plurality of logical fields.
2. The method of claim 1 , further comprising:
adding the generated second logical field to the plurality of logical fields; and
providing a query interface to compose abstract queries.
3. The method of claim 1 , wherein the second output field provides data values not exposed by any of the plurality of logical fields.
4. The method of claim 1 , further comprising, providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.
5. The method of claim 1 , wherein the second logical field is generated without requiring any user input specifying to generate the second logical field mapping to the second output field.
6. The method of claim 5 , wherein the second output field provides data values not exposed by any of the plurality of logical fields, wherein the physical query statement is an SQL statement, the method further comprising:
providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.
7. A non-transitory computer readable storage medium storing an application, which, when executed on a processor, performs an operation for integrating a physical query statement in a data abstraction model comprising a first plurality of logical fields used to expose an underlying physical database, the operation comprising:
parsing the physical query statement to identify a plurality of output fields specified by the physical query statement;
upon determining that a first output field of the identified plurality of output fields has a corresponding logical field, of the first plurality of logical fields, mapping the first output field of the physical query statement to the corresponding logical field provided by the data abstraction model;
upon determining that a second output field of the identified plurality of output fields does not have any corresponding logical field, generating a second logical field mapping to the second output field, wherein the second logical field includes an access method mapping the second logical field to the second output field;
upon determining that a naming conflict exists between the second output field and one of the plurality of logical fields:
determining a second name to assign to the second logical field to resolve the determined naming conflict, wherein the second name is different from a first name; and
adding the second logical field having the second name to the plurality of logical fields, wherein the naming conflict is resolved without having to replace any logical field in the data abstraction model; and
upon determining that no naming conflict exists between the second output field and one of the plurality of logical fields:
determining a first name to assign to the second logical field; and
adding the second logical field having the first name to the plurality of logical fields.
8. The computer-readable storage medium of claim 7 , wherein the operation further comprises:
adding the generated second logical field to the plurality of logical fields; and
providing a query interface to compose abstract queries.
9. The non-transitory computer readable storage medium of claim 7 , wherein the second output field provides data values not exposed by any of the plurality of logical fields.
10. The non-transitory computer readable storage medium of claim 7 , wherein the operation further comprises, providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.
11. The non-transitory computer readable storage medium of claim 7 , wherein the second logical field is generated without requiring any user input specifying to generate the second logical field mapping to the second output field.
12. The non-transitory computer readable storage medium of claim 11 , wherein the second output field provides data values not exposed by any of the plurality of logical fields, wherein the physical query statement is an SQL statement, wherein the operation further comprises:
providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.
13. A system, comprising:
a processor; and
a memory storing an application program, which, when executed on the processor, performs an operation for integrating a physical query statement in a data abstraction model comprising a first plurality of logical fields used to expose an underlying physical database, the operation comprising:
parsing the physical query statement to identify a plurality of output fields specified by the physical query statement;
upon determining that a first output field of the identified plurality of output fields has a corresponding logical field, of the first plurality of logical fields, mapping the first output field of the physical query statement to the corresponding logical field provided by the data abstraction model;
upon determining that a second output field of the identified plurality of output fields does not have any corresponding logical field, generating a second logical field mapping to the second output field, wherein the second logical field includes an access method mapping the second logical field to the second output field;
upon determining that a naming conflict exists between the second output field and one of the plurality of logical fields:
determining a second name to assign to the second logical field to resolve the determined naming conflict, wherein the second name is different from a first name; and
adding the second logical field having the second name to the plurality of logical fields, wherein the naming conflict is resolved without having to replace any logical field in the data abstraction model; and
upon determining that no naming conflict exists between the second output field and one of the plurality of logical fields:
determining a first name to assign to the second logical field; and
adding the second logical field having the first name to the plurality of logical fields.
14. The system of claim 13 , wherein the operation further comprises:
adding the generated second logical field to the plurality of logical fields; and
providing a query interface to compose abstract queries.
15. The system of claim 13 , wherein the second output field provides data values not exposed by any of the plurality of logical fields.
16. The system of claim 13 , wherein the operation further comprises, providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.
17. The system of claim 13 , wherein the second logical field is generated without requiring any user input specifying to generate the second logical field mapping to the second output field.
18. The system of claim 17 , wherein the second output field provides data values not exposed by any of the plurality of logical fields, wherein the physical query statement is an SQL statement, wherein the operation further comprises:
providing a query interface to compose abstract queries, wherein the query interface allows a user to select between composing an abstract query from a data abstraction model comprising the first plurality of logical fields and a data abstraction model comprising the plurality of logical fields, the first logical field, and the second logical field.