Standardized database access system and method

• US 8,549,026 B2
• Filed: 10/12/2010
• Issued: 10/01/2013
• Est. Priority Date: 10/12/2010
• Status: Active Grant

• Current Assignee: CliniComp International, Inc.
• Original Assignee: CliniComp International, Inc.
• Inventors: Haudenschild, Chris, Lin, Senmao, Chen, Yumin
• Primary Examiner(s): PHAM, KHANH B
• Application Number:
  US12/902,800
• Publication Number:
  US 20120089583A1
• Time in Patent Office: 1,085 Days
• Field of Search: 707/756, 707/760, 707/779
• US Class Current: 707/760
• CPC Class Codes: G06F 16/20 of structured data, e.g. relational data
• CPC Class Codes: G06F 16/2435 Active constructs

Abstract

One embodiment of the present invention relates to a technique for accessing data from a database. The technique may include providing a group of hyper objects each containing a different rule. When a hyper object query language (HOQL) query is received using an HOQL engine, at least one hyper object is selected using the HOQL engine in response to the HOQL query, A data request is sent via the selected hyper object to retrieve data from the database, to be received from the database to be used by the selected hyper object. The requested data is used according to the rule associated with the selected hyper object to provide a desired standardized output.

Claims

1. A standard database access method via a database access system for accessing data from a database, comprising:

providing a group of hyper objects stored in a hyper object library of the access system, each hyper object containing a different rule and including at least one data hyper object and at least one context hyper object;

receiving a hyper object query language (HOQL) query concerning certain data stored in the database, using an HOQL engine;

selecting at least one data hyper object and at least one context hyper object using the HOQL engine in response to the HOQL query;

the context hyper object including a rule for requesting from the database context data which is a selected portion only of the certain data stored in the database regarding an environment of the certain data;

requesting context data from the database using the selected context hyper object;

generating a rule transform command via the selected context hyper object to be used by a transform portion of the selected data hyper object for modifying its rule;

sending a data request for the database from the selected data hyper object in accordance with its transformed rule to retrieve data from the database;

receiving the requested data from the database to be used by the selected data hyper object; and

using the requested data according to the rule associated with the selected hyper object to provide a desired standardized output.

2. The method according to claim 1, further including adapting the data request via an adapter to conform to the structure of a given database, and providing via the adapter the proper translation depending on the context of the HOQL query.

3. The method according to claim 1, further including creating a new hyper object in response to the HOQL.

4. The method according to claim 3, further including storing the new hyper object with the group of hyper objects.

5. The method according to claim 1, wherein the desired standardized output is a report.

6. The method according to claim 5, further including customizing the report using a presentation unit.

7. The method according to claim 1, wherein the HOQL query is received from a HOQL console.

8. The method according to claim 1, wherein the HOQL query is received from an application program interface via a computer.

9. A method according to claim 1, further including updating the hyper objects.

10. A standardized database access method via a database access system, comprising:

providing a database;

providing a group of hyper objects stored in a hyper object library of the access system, each containing a different rule and including at least one data hyper object and at least one context hyper object;

receiving a hyper object query language (HOQL) query concerning certain data stored in the database, using an HOQL engine;

selecting at least one data hyper object and at least one context hyper object using the HOQL engine in response to the HOQL query;

the context hyper object including a rule for requesting from the database context data which is a selected portion only of the certain data stored in the database regarding an environment of the certain data;

requesting context data from the database using the selected context hyper object;

generating a rule transform command via the selected context hyper object to be used by a transform portion of the selected data hyper object for modifying its rule;

sending a data request for the database from the selected data hyper object in accordance with its transformed rule to retrieve data from the database;

receiving the requested data from the database to be used by the selected data hyper object; and

using the requested data according to the rule associated with the selected hyper object to provide a desired standardized output.

11. The method according to claim 10, further including adapting the data request via an adapter to conform to the structure of a given database, and providing via the adapter the proper translation depending on the context of the HOQL query.

12. The method according to claim 11, wherein the selected data hyper object receives the transform command to utilize the desired transformation portion of its rules in response to the transform command and to the HOQL query.

13. The method according to claim 10, further including creating a new hyper object in response to the HOQL.

14. The method according to claim 13, further including storing the new hyper object with the group of hyper objects.

15. The method according to claim 10, wherein the desired standardized output is a report.

16. The method according to claim 15, further including customizing the report using a presentation unit.

17. The method according to claim 10, wherein the HOQL query is received from a HOQL console.

18. The method according to claim 10, wherein the HOQL query is received from an application program interface in a computer.

19. The method according to claim 10, further including updating the hyper objects.

20. The method according to claim 10, further including determining by using the context hyper object whether or not a transformation portion of the rules of at least one of the data hyper objects should be used in response to the HOQL query.

21. The method according to claim 20, wherein the selected data hyper object receives the transform command to utilize the desired transformation portion of its rules in response to the transform command and to the HOQL query.

22. The method according to claim 21, further including in response to receiving requested data from the database, manipulating the received data by the selected data hyper object in accordance with its rule to serve as a pseudo hyper object to the HOQL engine for providing a standardized output.

23. The method according to claim 22, further including creating, deleting, describing and listing hyper objects for management functions.

24. The method according to claim 23, further including retrieving, storing and updating data from the database for data access functions.

25. A standard database access method via a database access system for accessing data from a database, comprising:

providing a group of hyper objects stored in a hyper object library of the access system, each hyper object containing a different rule;

receiving a hyper object query language (HOQL) query concerning certain data stored in the database, using an HOQL engine;

selecting at least one hyper object using the HOQL engine in response to the HOQL query;

the hyper object including a rule for requesting from the database certain data stored in the database as specified in the HOQL query;

requesting data from the database using the selected hyper object;

sending a data request for the database from the selected hyper object in accordance with the rule of the selected hyper object to retrieve data from the database;

receiving the requested data from the database to be used by the selected hyper object; and

using the requested data according to the rule associated with the selected hyper object to provide a desired standardized output.

26. The method according to claim 25, further including adapting the data request via an adapter to conform to the structure of a given database, and providing via the adapter the proper translation depending on the context of the HOQL query.

27. The method according to claim 25, further including creating a new hyper object in response to the HOQL.

28. The method according to claim 27, further including storing the new hyper object with the group of hyper objects.

29. The method according to claim 25, wherein the desired standardized output is a report.

30. The method according to claim 29, further including customizing the report using a presentation unit.

31. The method according to claim 25, wherein the HOQL query is received from a HOQL console.

32. The method according to claim 25, wherein the HOQL query is received from an application program interface via a computer.

33. A method according to claim 25, further including updating the hyper objects.