Data processing: database and file management or data structures – Database design – Data structure types
Patent
1998-02-04
2000-11-14
Alam, Hosain T.
Data processing: database and file management or data structures
Database design
Data structure types
707 2, 707 4, 707100, 707103, 707104, G06F 1730
Patent
active
06148296&
ABSTRACT:
A computer program for automatically generating queries to a database management system (DBMS) is disclosed. The computer program receives a high level specification of the data sought to be retrieved from an application program. The high level specification includes the columns from which data is sought, and any constraints on the data to be retrieved from those columns such as filter constraints. The computer program also receives a context for the columns to be queried, so that it can be determined which tables of the DBMS the columns are associated with. The computer program further receives a specification of the schema of the DBMS, with the schema specifying the relationship between the various data storage entities of the DBMS. Using the high level specification and the schema, the computer program automatically generates queries to the DBMS seeking to reduce the complexity of the queries to speed execution, and to reduce the number of round trips between the computer program and the DBMS, also to enhance speed. For this purpose, queries may be separated into primary and secondary queries, and batched together, with secondary queries using data retrieved in a primary query in order to retrieve further data.
REFERENCES:
patent: 5201047 (1993-04-01), Maki et al.
patent: 5377103 (1994-12-01), Lamberti et al.
patent: 5519855 (1996-05-01), Neeman et al.
patent: 5548755 (1996-08-01), Leung et al.
patent: 5548770 (1996-08-01), Bridges
patent: 5590319 (1996-12-01), Cohen et al.
patent: 5590321 (1996-12-01), Lin et al.
patent: 5600831 (1997-02-01), Levy et al.
patent: 5615337 (1997-03-01), Zimowski et al.
patent: 5632015 (1997-05-01), Zimowski et al.
patent: 5666526 (1997-09-01), Reiter et al.
patent: 5806059 (1998-09-01), Tsuchida et al.
patent: 5812840 (1998-09-01), Shwartz
patent: 5842212 (1998-11-01), Ballurio et al.
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 5890150 (1999-03-01), Ushijima et al.
patent: 5893095 (1999-04-01), Jain et al.
patent: 5896530 (1999-04-01), White
patent: 5983237 (1999-11-01), Jain et al.
patent: 5999664 (1999-12-01), Mahoney et al.
Alam Hosain T.
Corrielus Jean M
Microsoft, Inc.
LandOfFree
Automatic generation of database queries does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Automatic generation of database queries, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Automatic generation of database queries will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2075015