Data management system and method for intercepting and changing database instructions between a database back end and an application front end

• US 20020143764A1
• Filed: 04/03/2001
• Published: 10/03/2002
• Est. Priority Date: 04/03/2001
• Status: Abandoned Application

• Current Assignee: PROVISION6
• Original Assignee: PROVISION6
• Inventors: Martin, Andrew R., Goke, Jeffrey J.
• Application Number:
  US09/825,236
• Publication Number:
  US 20020143764A1
• Time in Patent Office: Days
• US Class Current: 707/8
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

A database method and system use one or more virtual driver interceptors (106) to intercept information and/or queries provided between a database backend system (112) and an end user front end system (102). The interceptors (106) can dynamically alter information or queries that are intercepted in transit between the backend (106) and the applications (102). The effect of altering this information dynamically between the back end and front end is that the system (100) has more functionality, greater flexibility, and/or enhanced performance without the need the change, at great expense and cost, all of the software and/or hardware within the backend (112), standard drivers (110), APIs (104), and applications (102). For example, the changing of instructions via the virtual driver (106) allows for dynamic data versioning, caching, fault tolerance, data backup, statistical data monitoring, load balancing, space planning, data conversion, enhanced security, and/or the like without the need to significantly change the system

Claims

1. (Partial Wrapper claim) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

driver software communicatively coupled between the front end software and back end software, the driver software containing a plurality of classes adapted to service incoming and outgoing information between the front end software and back end software; and

interceptor software operably coupled to a fraction of the plurality of classes, the interceptor software being designed to intercept instructions passing through the driver software and change the instructions to modified instructions before the instruction is passed out of the driver software.

2. The software of claim 1 wherein back end system is a plurality of back end database servers that contain different data for different operations within an enterprise.

3. The software of claim 1 wherein front end system is at least one computer that contains application programming interface software and end user applications that interface to the driver software.

4. The software of claim 1 wherein front end software, the back end software, the driver software, and the interceptor software are all portions of the same software program stored in a common memory bank for execution by a central processing unit.

5. The software of claim 1 wherein the driver interfaces with user specific schema data that assists the driver in determining whether or not to change the instructions to modified instructions before the instruction is passed out of the driver software.

6. The software of claim 1 wherein the driver interfaces with system specific schema data that assists the driver in determining whether or not to change the instructions to modified instructions before the instruction is passed out of the driver software.

7. The software of claim 1 wherein some instructions are changed to modified instructions and other instructions are passed through the driver without change.

8. The software of claim 7 wherein the instructions that are intercepted and changed to modified instructions are only those incoming database requests from the front end system that access data at the backend system whereas all database provisions from the back end system to the front end system are not intercepted or changed.

9. The software of claim 1 wherein the instruction is changed in order to allow data in the back end to be versioned whereby multiple different versions of data from the backend are created and independently accessible and changeable at one time via the creation of modified instructions via the interception software.

10. The software of claim 1 wherein the instruction is changed in order to allow data in the back end to be given different security levels whereby different users are granted different levels of access to data via the creation of modified instructions via the interception software.

11. The software of claim 1 wherein the instruction is changed in order to add tag information to the instruction via the modified instruction.

12. The software of claim 11 wherein the tag information is one or more of:

a time stamp;

an origination identifier, or a date stamp.

14. The software of claim 13 wherein the database instruction is modified in some cases and passed in an unmodified format in other cases.

15. The software of claim 13 wherein the database instruction is modified using control information read from a central user or system property file.

16. The software of claim 13 wherein the database instruction is modified using control information read from a central user or system database table in memory.

17. The software of claim 13 wherein the database instruction is modified using control information read from a local variable stored at the front end system.

18. The software of claim 13 wherein the database instruction is modified using control information read from default location.

19. The software of claim 13 wherein the database instruction is modified using hierarchical control information read from two or more of a central user or system property file, a central user or system database table in memory, local variable stored at the front end system, or default location.

20. The software of claim 13 wherein the database instruction is changed in order to allow data in the back end to be versioned whereby multiple different versions of data from the backend are created and independently accessible and changeable at one time via the creation of modified instructions via the interception software.

21. The software of claim 13 wherein the database instruction is changed in order to allow data in the back end to be given different security levels whereby different users are granted different levels of access to backend data via the creation of modified instructions via the interception software.

13. (intercept only FE to BE Transactions) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

driver software communicatively coupled between the front end software and back end software, the driver software processing information that going to coming from either the back end system or the front end system; and

interceptor software coupled to intercept only database instructions coming from the front end system and destined for the back end system where the interceptor software intercepts these database instructions and determines if the database instruction requires modification before transmission to the back end system.

22. (Stacked Virtual Layer claim) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

driver software communicatively coupled between the front end software and back end software, the driver software processing incoming and outgoing information between the back end software and the front end software; and

a plurality of stacked virtual control software modules coupled between the front end system and the back end system to intercept information and instructions passed through the driver software between the front end system and the back end system, each of the stacked virtual control software modules in the plurality enabling a different database function.

23. The software of claim 22 wherein the plurality of stacked virtual control software modules contain at least two modules and the two modules perform different functions selected from a group consisting of:

caching of data from the back end system;

versioning of data within the backend system;

security of data within the backend system.

25. The software of claim 24 wherein the version control software allows an end user to select in advance those portions of the dynamic data in the back end system what will be used to create a new version and then creates the new version from the those potions.

26. The software of claim 24 wherein the version control software allows an end user to start editing existing data within the dynamic data where as dynamic data within segments of the back end system are changed, these segments are copied to create a new segment so that the existing segment is not changed and the new segment is changed and becomes part of the new version.

27. The software of claim 26 wherein the segments are one or more of:

separate back end servers, separate databases on the backend system, different tables within databases, different records within tables, or different fields within records.

28. The software of claim 26 wherein the segments may be rolled back to any segments of any version created prior to the time the version was created.

29. The software of claim 26 wherein the segments may be rolled forward to any segments of any version created after the time the version was created.

30. The software of claim 26 wherein the segments may be rolled back to any segments of any previous version upon which those segments were historically based.

31. The software of claim 26 wherein the segments may be rolled forward to any segments of any later version that were at one point derived from the current segment data.

24. (Dynamic Versioning) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

version control software that allows dynamic data on the back end to be version controlled whereby multiple different versions of dynamic data are present and separately accessible on the back end system at a given time; and

driver software communicatively coupled between the front end software and back end software, where the driver software ensures that different end users using the front end software may independently and simultaneously access different versions of dynamic data on the back end system.

32. (Nested two-tier versioning) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

first version control software that allows dynamic data on the back end to be version controlled whereby multiple different versions of dynamic data are present and separately accessible on the back end system; and

second version control software that allows each of the multiple different versions of the dynamic data to be further versioned within themselves wherein multiple different versions of the different versions of dynamic data are present and separately accessible on the back end system at a given time.

33. The software of claim 32 wherein the first version control software creates a base version of dynamic data based on user input, and wherein the second version control software creates time-dependent dynamic data backup versions of the base version of dynamic data on certain time intervals.

35. The software of claim 34 wherein the version identification and creation software allows the user to select up front which segments of data from the back end system are needed to create the version.

36. The software of claim 35 wherein the version identification and creation software allows the user to add segments at a later time.

37. The software of claim 35 wherein the version identification and creation software dynamically monitors a user'"'"'s requests to change existing data segments and copies those segments to new version segments once the user request is made.

39. The software of claim 38 wherein the version editing software allows both:

(i) roll back information in a new data version to information in a previous data version or information in the many different segments of back end data;

or (ii) roll forward information in a new data version to newer information associated with the new data version.

40. The software of claim 38 wherein the version editing software allows roll back on a hierarchical level where the user may select a hierarchical segment of data that is to be rolled back, the hierarchical segment selected from a group consisting of:

an entire database, a table in a database, a record type in a table, or fields in records.

41. The software of claim 38 wherein the version editing software allows roll back on performed on a conditional basis for a segment of data, where if data currently within a designated segment of a new data version meets a criterion it is rolled back, else that data is not rolled back.

34. (version creation and changing) Software for communicating database information between a front end system and a back end system that contains many different segments of back end data, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

version identification and creation software that allows a user to identify what select subportions of the back end data are needed to create a new version and accesses the select portions of the back end data and creates the new version from the select portions;

version editing software that allows a user to change the data within the new version while leaving the original back end data and other versions unaffected; and

version access software that allows an end user to access the data within the new version while leaving the original back end data unaccessed by the end user.

38. (roll forward and roll back) Software for communicating database information between a front end system and a back end system that contains starting back end data arranged in an information hierarchy, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

version creation software that identifies and creates new data versions from starting back end data and previous data versions; and

version editing software that allows a user to one or either;

(i) roll back information in a new data version to information in a previous data version or information in the many different segments of back end data;

or (ii) roll forward information in a new data version to newer information associated with the new data version.

42. (release concept claim) Software for communicating database information between a front end system and a back end system that contains starting back end data arranged in an information hierarchy, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system;

version creation software that identifies and creates new data versions from starting back end data and previous data versions; and

version editing software that allows a user to change the data within the new version while leaving the original back end data unaffected;

version release software that allows a user to release the data within a version wherein the data in that version is thereafter protected from further data changes, yet that versions remains in a dynamic database format; and

version access software that allows an end user to access the data within the released version.

43. The software of claim 42 wherein a released version may be subsequently changed by creating a new unreleased version from the released version.

44. (data structure claim) A data structure for creating and maintaining many different versions of data that may be independently accesses and manipulated, the data structure comprising:

base data within a back end system that is configured into segments where each segments contains data and field identifiers for the data;

a first data version located at the back end system where data and field identifiers for the fist data version were derived from the base data; and

wherein the first data version and the base data may be independently manipulated and accessed via a set of common application programmers interfaces.

45. The data structure of claim 44 wherein a second data version is located at the back end system where data and field identifiers for the second data version were derived from the base data, the first and second data versions being independently accessible and changeable.

46. The data structure of claim 45 wherein a third data version is located at the back end system where data and field identifiers for the third data version were derived from the base data, the first, second, and third data versions being independently accessible and changeable.

47. The data structure of claim 45 wherein a third data version is located at the back end system where data and field identifiers for the third data version were derived from the base data and one or more of the first and second data versions, the first, second, and third data versions being independently accessible and changeable.

48. The data structure of claim 44 wherein a second data version is located at the back end system where data and field identifiers for the second data version were derived from the base data and the first data version, the first and second data versions being independently accessible and changeable.

49. The data structure of claim 45 wherein a third data version is located at the back end system where data and field identifiers for the third data version were derived from the base data, the first, second, and third data versions being independently accessible and changeable.

50. The data structure of claim 45 wherein a third data version is located at the back end system where data and field identifiers for the third data version were derived from the base data and one or more of the first and second data versions, the first, second, and third data versions being independently accessible and changeable.

51. The data structure of claim 45 wherein a schema database is accessed to determine which of the new data versions are accessible by an end user.

52. (method of FE to BE interception only) A method for accessing a database, the method comprising the steps of:

providing data within a database;

initiating one or more data access instructions from a front end interface;

intercepting the one or more data access instructions at a driver;

using the driver to determine if the data access instruction is an instruction that requires modification due to data versioning performed in the database;

modifying the data access instruction to add version information to the data access instruction and create a modified instruction when the driver detects that the data access instruction is making a versioned access;

providing a database instruction to the database, the database instruction being the modified instruction if versioned access is detected or being an unmodified version of the data access instruction when no version access is detected;

receiving the database information in response to the database instruction at the driver; and

returning the database information to a front end through the driver without interception.

53. (method of roll back) A method for accessing a database, the method comprising the steps of:

providing base data within a database;

creating a first version of data within the database from the base data, the first version of data being capable of independent access and change without affecting the base data;

creating a second version of data within the database from one or more of the base data and the first version of data, the second version of data being capable of independent access and change without affecting the base data or the first version of data;

creating a third version of data within the database from one or more of the base data, the first version of data, and the second version of data, the third version of data being capable of independent access and change without affecting the base data, the first version of data, or the second version of data;

determining that a portion of data in one of the above versions of data needs to be rolled back to a previous set of data from a specific previous version or the base data; and

changing the data in that portion of data to the corresponding older data present within the previous version or the base data to perform a roll back of the data.

54. (Multiple Versions claim) Software for communicating database information between a front end system and a back end system, the software comprising:

front end software that receives information from the front end system and provides information to the front end system;

back end software that receives information from the back end system and provides information to the back end system; and

driver software communicatively coupled between the front end software and back end software, the driver software having routines that allow for the creation and simultaneous access by users to a plurality of dynamic data versions accessible through the back end software where the driver software allows each of the dynamic data version to be changed without affecting the other.