US5764973A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System for generating structured query language statements and integrating legacy systems
Assignee: ENTERWORKS ACQUISITION Inc
•
Filing: 1995-09-13
•
Granted: 1998-06-09
•
Expires: 2015-09-13
Abstract
Abstract The present invention relates to a system for integrating a plurality of data structures by modeling the existing data structures, and creating a data dictionary that links logical elements to data elements in those data structures. A user can simply request logical data elements that he would like to see and the system will calculate the links necessary to return the proper data from the appropriate data structures. This system may integrate most types of data structures including relational databases, object-oriented databases, hierarchical files and flat files. Furthermore, the system can process textual, numeric, audio and visual data.
Inventors
- 👤 Paul Lunceford
- 👤 Robert Huff
- 👤 Mohanaharan Mylvaganam
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 22:52
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/289; G06F16/24; G06F16/242; G06F16/2423; G06F16/2428; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99938; Y10S707/99941; Y10S707/99942
Claims Analysis
Total Claims: 23
Claim 1
Independent Claim
212 words
A system for integrating information from a plurality of different data structures stored in a plurality of different types of storage structures into a single-framework, the system comprising: (a) input means for choosing criteria on which to gather said information; (b) modeling means for modeling an entire problem domain which includes at least one said data structure from said plurality of different types of storage structures, including relations, hierarchical, flat file, and object-oriented database structures, at least some of the data structures including relational tables, the modeling means including means for determining which foreign keys in the relational tables are necessary, for removing unnecessary foreign keys in the relational tables, and for removing tables made only of foreign keys; (c) data dictionary means for tracking locations of said information across said at least one data structure in said problem domain; (d) statement generating means for automatically generating data requests based on said chosen criteria; (e) accessing means for receiving said information independent of said types of storage structures and responsive to said data requests; and (f) interface means for providing a uniform relational view of said problem domain that is consistent across said types of storage structures enabling said data to be manipulated without limitation as to said type of storage structure.
Claim 2
Independent Claim
212 words
A system for integrating information from a plurality of different data structures stored in a plurality of different types of storage structures into a single-framework, the system comprising: (a) input means for choosing criteria on which to gather said information; (b) modeling means for modeling an entire problem domain which includes at least one said data structure from said plurality of different types of storage structures, including relations, hierarchical, flat file, and object-oriented database structures, at least some of the data structures including relational tables, the modeling means including means for determining which foreign keys in the relational tables are necessary, for removing unnecessary foreign keys in the relational tables, and for removing tables made only of foreign keys; (c) data dictionary means for tracking locations of said information across said at least one data structure in said problem domain; (d) statement generating means for automatically generating data requests based on said chosen criteria; (e) accessing means for receiving said information independent of said types of storage structures and responsive to said data requests; and (f) interface means for providing a uniform relational view of said problem domain that is consistent across said types of storage structures enabling said data to be manipulated without limitation as to said type of storage structure.
Claim 3
Dependent Claim
55 words
The system of claim 1, wherein each of said data structures include tables and physical data elements, and said data dictionary means includes logical data elements and pointers, and said chosen criteria comprises said logical elements, such that when such user chooses said criteria in the format of logical elements, physical data elements are retrieved.
Claim 4
Dependent Claim
47 words
The system of claim 2, further comprising means to determine the most accessed of said tables, wherein said statement generating means generates a JOIN statement to link retrieved and returned data based on said chosen logical elements and said most accessed tables and said physical data elements.
Claim 5
Dependent Claim
40 words
The system of claim 2, wherein said statement generating means generates a UNION statement to retrieve and return data responsive to said chosen logical elements and all of said pointers from said logical data elements to said physical data elements.
Claim 6
Dependent Claim
41 words
The system of claim 2, wherein said statement generating means generates a NEITHER statement to retrieve and return all possible combinations of said chosen logical elements using all of said pointers from said logical data elements to said physical data elements.
Claim 7
Dependent Claim
37 words
The system of claim 2, wherein said statement generating means generates a NATURAL statement which retrieves and returns a model of a single chosen logical element wherein the parts of said model are linked to each other.
Claim 8
Dependent Claim
33 words
The system of claim 2, wherein said statement generating means generates standard structured query language (SQL) statements, which consist of at least one SELECT clause, a QUALIFIER clause and an ORDER BY clause.
Claim 9
Dependent Claim
20 words
The system of claim 2, wherein said pointers in said data dictionary means are set up by a system administrator.
Claim 10
Dependent Claim
24 words
The system of claim 2, wherein a system administrator can determine which users can access said physical data elements and said logical data elements.
Claim 11
Dependent Claim
17 words
The system of claim 2, wherein said chosen criteria includes said logical elements, qualifiers and order requests.
Claim 12
Dependent Claim
20 words
The system of claim 1, wherein data accessed in response to said data requests are stored in an object-oriented database.
Claim 13
Dependent Claim
25 words
The system of claim 1, wherein said modeling means comprises a wrapping means for converting said data structures into a format that resembles relational databases.
Claim 14
Dependent Claim
30 words
The system of claim 12, wherein said modeling means further comprises scanning means for scanning said relational databases to determine the structure thereof, and storage means to store said structure.
Claim 15
Dependent Claim
18 words
The system of claim 1, wherein said data dictionary means can store textual, numeric, audio and visual data.
Claim 16
Dependent Claim
20 words
The system of claim 1 wherein said data dictionary means includes a metacatolog for relating said information on multiple levels.
Claim 17
Independent Claim
145 words
A system for integrating information from at least first and second different types of legacy database systems, the legacy database systems having physical data elements stored therein, the system comprising: first and second interfaces for communicating with the first and second different types of legacy database systems; and an object-oriented database management system communicating with the first and second interfaces and including: an object-oriented database, means for modeling the tables and the physical data elements therein in the different databases and types of databases in the legacy systems to generate logical data elements corresponding to the tables in the legacy systems, logical data elements corresponding to the physical data elements, and pointers from the logical data elements to the physical data elements in the legacy systems, and a metacatalog maintained as an object-oriented database for storing the logical data elements generated by the modeling means.
Claim 18
Independent Claim
145 words
A system for integrating information from at least first and second different types of legacy database systems, the legacy database systems having physical data elements stored therein, the system comprising: first and second interfaces for communicating with the first and second different types of legacy database systems; and an object-oriented database management system communicating with the first and second interfaces and including: an object-oriented database, means for modeling the tables and the physical data elements therein in the different databases and types of databases in the legacy systems to generate logical data elements corresponding to the tables in the legacy systems, logical data elements corresponding to the physical data elements, and pointers from the logical data elements to the physical data elements in the legacy systems, and a metacatalog maintained as an object-oriented database for storing the logical data elements generated by the modeling means.
Claim 19
Dependent Claim
53 words
The system of claim 16, wherein at least some of the legacy database systems include relational tables, and wherein the means for modeling includes means for determining which foreign keys in the relational tables are necessary, removing unnecessary foreign keys in the relational tables, and removing relational tables made only of foreign keys.
Claim 20
Dependent Claim
38 words
The system of claim 16, further comprising a user interface, communicating with the object-oriented database management system, for providing to the object-oriented database management system queries from a user to access logical data elements in the object-oriented databases.
Claim 21
Independent Claim
201 words
A method for integrating multiple different types of legacy systems with physical elements into a single object-oriented framework, the method comprising the steps of: scanning header tables from a number of different tables in the legacy systems to create data elements for the tables; storing the data elements created in the scanning step in an object-oriented database; for each table, modeling the physical data elements in the table to create logical data elements; storing the logical data elements created in the modeling step in the objectoriented database; creating pointers from the data element for each table to the logical data elements that represent the physical data elements in the respective tables; determining a datatype for each physical data element based on the header tables of the legacy systems; using the datatype determined in the determining step as the datatype for each logical data element; and creating logical elements in a metacatalog during the scanning and modeling steps to create a logical element in the metacatalog each time a physical element is modeled, the system automatically creating a unified environment from multiple different databases and types of databases in legacy systems to provide a consistent view across all of the legacy systems.
Claim 22
Independent Claim
201 words
A method for integrating multiple different types of legacy systems with physical elements into a single object-oriented framework, the method comprising the steps of: scanning header tables from a number of different tables in the legacy systems to create data elements for the tables; storing the data elements created in the scanning step in an object-oriented database; for each table, modeling the physical data elements in the table to create logical data elements; storing the logical data elements created in the modeling step in the objectoriented database; creating pointers from the data element for each table to the logical data elements that represent the physical data elements in the respective tables; determining a datatype for each physical data element based on the header tables of the legacy systems; using the datatype determined in the determining step as the datatype for each logical data element; and creating logical elements in a metacatalog during the scanning and modeling steps to create a logical element in the metacatalog each time a physical element is modeled, the system automatically creating a unified environment from multiple different databases and types of databases in legacy systems to provide a consistent view across all of the legacy systems.
Claim 23
Dependent Claim
37 words
The method of claim 19, further comprising steps of providing pointers in tables to which foreign keys point, and deleting the data elements that are foreign keys in other tables, the system thereby removing unnecessary foreign keys.
References Cited (Backward Citations)
US4688195A
Cited
US4774661A
Cited
US4805099A
Cited
US5237678A
Cited
US5197005A
Cited
US5335346A
Cited
US5448726A
Cited
US5181162A
Cited
US5442784A
Cited
US5303367A
Cited
US5295256A
Cited
US5212787A
Cited
US5325465A
Cited
US5418957A
Cited
US5390330A
Cited
US5377350A
Cited
US5499371A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-06-08 | 2001-12-08 | 2002-06-09 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-06-08 | 2005-12-08 | 2006-06-09 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-06-08 | 2009-12-08 | 2010-06-09 | $7700.00 | Window Closed / Lapsed |