Granted Patent B2

US 9,940,392 · App. 14/642,641 · Granted Apr 10, 2018

Inventor: Timothy R. Norman (Overland Park, KS)

Assignee: LockPath, Inc.

G06F17/30864G06F17/30392

Abstract

Claims (40)

1. A method in a computing system for querying user-defined database columns in a database, the method comprising:

receiving a database query referring to one or more database columns, wherein at least some of the one or more database columns referred to in the database query are at least one user-defined database column that is not defined in a data model of the database;

converting at least a portion of the received database query , at least based on the at least one user-defined column, into a first hierarchy;

transforming the first hierarchy into a second hierarchy, the transforming based on the at least one user-defined column and one or more identifiers consistent with the data model of the database;

generating a database query result based on the second hierarchy; and

providing access to the database query result;

wherein the transforming and generating the database query result based on the second hierarchy are performed by providing the first hierarchy to an object relational model engine for generation of relational database instructions that can be applied against the database.

2. The method of claim 1 , wherein the second hierarchy defines a query result object in accordance with an object relational model.

3. The method of claim 1 , further comprising maintaining a contextual type stack during the transformation as a basis for disambiguating, in the transformation, names for database columns.

4. The method of claim 1 , wherein the first hierarchy is an expression tree hierarchy.

5. The method of claim 1 wherein the received database query is a textual database query.

6. The method of claim 1 , further comprising parsing the received database query into portions, wherein the portions are used to generate the first hierarchy as an expression tree hierarchy.

7. A computer-readable device having contents that cause a computing system to perform a method for querying user-defined database columns in a database, the method comprising:

obtaining a first hierarchy, wherein the first hierarchy is based on a received database query,

wherein the database query refers to one or more database columns, wherein at least some of the database columns referred to in the database query are at least one user-defined database column that is not defined in a data model of the database, and

wherein the first hierarchy is based, in part, on the at least one user-defined database column;

transforming the first hierarchy into a second hierarchy, the transforming based on the at least one user-defined column and one or more identifiers defined in the data model of the database, wherein the transforming further uses an object relational model and the first or second hierarchy to generate database instructions that can be applied against the database;

generating a database query result based on the second hierarchy; and

providing access to the database query result.

8. The computer-readable device of claim 7 , wherein the first hierarchy is an expression tree hierarchy.

9. The computer-readable device of claim 8 , wherein the transforming comprises applying an object relational model engine to the expression tree hierarchy to use the object relational model to generate the database instructions for application against the database.

10. The computer-readable device of claim 7 , wherein the method further comprises maintaining a contextual type stack during the transformation as a basis for disambiguating, in the transformation, names for database columns.

11. The computer-readable device of claim 7 , wherein the database query is a textual database query.

12. The computer-readable device of claim 7 , wherein the database query was constructed via a visual query construction user interface.

13. The computer-readable device of claim 7 , wherein the providing access, to the database query result, via the second hierarchy is performed via a programmatic object.

14. A computing system, comprising:

one or more processors; and

a memory storing instructions that, when executed by the one or more processors, cause the computing system to perform operations for querying user-defined database columns in a database, the operations comprising:

obtaining a first hierarchy, wherein the first hierarchy is based on a received input,

wherein the received input defines one or more user-defined columns, and

wherein at least some of the one or more user-defined columns are not present in a data model of the database;

transforming the first hierarchy into a second hierarchy, the transforming based on the one or more user-defined columns and identifiers present in the data model of the database;

generating a database query result based on the second hierarchy;

wherein the transforming or generating uses an object relational model and the first or the second hierarchy to generate database instructions that can be applied against the database; and

storing, in the memory, a programmatic object configured to provide access to the database query result.

15. The system of claim 14 , wherein the input defining the one or more user-defined columns is received via a visual query construction user interface.

16. The system of claim 14 , wherein the second hierarchy defines the database query result object in accordance with the object relational model.

17. The system of claim 14 , wherein the operations further comprise maintaining a contextual type stack during the transformation as a basis for disambiguating, in the transformation, names for database columns.

18. The system of claim 14 , wherein the first hierarchy is an expression tree hierarchy.

19. The system of claim 14 , wherein the operations further comprise parsing the input defining the one or more user-defined columns into portions, wherein the portions are used to generate the first hierarchy.

Assignments (11)

Continuity (2)