Patent US5974418A successfully refreshed from Google Patents.
US5974418A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Database schema independence
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1996-10-16
•
Granted: 1999-10-26
•
Expires: 2016-10-16
Abstract
Abstract An application, such as an online merchant system, provides a name for a query stored in a database. The database accesses the query using the name provided by the application. The database next executes the query to produce an access object having the query results. The application then processes the access object to obtain a selected result. Storing queries in the database provides a level of indirection and flexibility enabling applications to access databases without prior knowledge of their schemas. Thus, applications can access data in a wide variety of existing databases having different schemas and data sublanguages. Modification of the database schema does not require corresponding modification or recompilation of the application accessing the database.
Inventors
- 👤 Arnold Blinn
- 👤 Michael Ari Cohen
- 👤 Michael Lorton
- 👤 Gregory J. Stein
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 07:03
CPC Classifications
G; G06; G06Q; G06Q30/00; G06Q30/06; G06Q30/0601; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/258; G06F16/90; G06F16/95; G06F16/958; G06F16/972; G06Q30/02; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/955; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
144 words
In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising: associating a plurality of database queries with corresponding query names in a cross-reference; obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products; wherein the database queries are formulated to return data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned data table in the online shopping system to obtain the desired product data.
Claim 2
Dependent Claim
144 words
In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising: associating a plurality of database queries with corresponding query names in a cross-reference; obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products; wherein the database queries are formulated to return data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned data table in the online shopping system to obtain the desired product data.
Claim 3
Dependent Claim
16 words
A method as recited in claim 1, wherein the cross-reference is stored in the legacy database.
Claim 4
Dependent Claim
18 words
A method as recited in claim 1, wherein the database queries are written in the SQL data sublanguage.
Claim 5
Dependent Claim
22 words
A method as recited in claim 1, wherein the processing step comprises indexing the returned data table with row and column identifiers.
Claim 6
Dependent Claim
154 words
A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising: associating a plurality of database queries with corresponding query names in a cross-reference; obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having a plurality of information records relating to different products; wherein the database queries are formulated to return access objects whose information records are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned access object in the online shopping system to obtain the desired product data.
Claim 7
Dependent Claim
154 words
A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising: associating a plurality of database queries with corresponding query names in a cross-reference; obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having a plurality of information records relating to different products; wherein the database queries are formulated to return access objects whose information records are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned access object in the online shopping system to obtain the desired product data.
Claim 8
Dependent Claim
18 words
A computer-readable storage medium as recited in claim 5, wherein the cross-reference is stored in the legacy database.
Claim 9
Dependent Claim
20 words
A computer-readable storage medium as recited in claim 5, wherein the database queries are written in the SQL data sublanguage.
Claim 10
Dependent Claim
34 words
A computer-readable storage medium as recited in claim 5, wherein each information record contains one or more fields, and wherein the processing step comprises indexing the returned access object with record and field identifiers.
Claim 11
Dependent Claim
155 words
An online shopping system comprising: a server computer; a legacy database accessible to the server computer, the legacy database having a predefined schema; a cross-reference that associates a plurality of database queries with corresponding query names; an application program that executes on the server computer to implement the online shopping system and to perform steps comprising: obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products; wherein the database queries are formulated to data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned data table in the online shopping system to obtain the desired product data.
Claim 12
Dependent Claim
155 words
An online shopping system comprising: a server computer; a legacy database accessible to the server computer, the legacy database having a predefined schema; a cross-reference that associates a plurality of database queries with corresponding query names; an application program that executes on the server computer to implement the online shopping system and to perform steps comprising: obtaining a particular database query from the cross-reference that corresponds to a particular one of the query names; submitting the particular database query to the legacy database from the online shopping system, wherein the legacy database returns a data table having one or more information records relating to different products; wherein the database queries are formulated to data tables that are formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database; processing the returned data table in the online shopping system to obtain the desired product data.
Claim 13
Dependent Claim
18 words
An online shopping system as recited in claim 9, wherein the cross-reference is stored in the legacy database.
Claim 14
Dependent Claim
20 words
An online shopping system as recited in claim 9, wherein the database queries are written in the SQL data sublanguage.
Claim 15
Dependent Claim
24 words
An online shopping system as recited in claim 9, wherein the processing step comprises indexing the returned data table with row and column identifiers.
Claim 16
Dependent Claim
133 words
In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 17
Dependent Claim
133 words
In an online shopping system that obtains product information from a legacy database having a predefined schema, a method of accessing desired product data from the legacy database, the method comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 18
Dependent Claim
18 words
A method as recited in claim 13, wherein the database query is written in the SQL data sublanguage.
Claim 19
Dependent Claim
26 words
A method as recited in claim 13, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.
Claim 20
Dependent Claim
141 words
A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 21
Dependent Claim
141 words
A computer-readable storage medium containing instructions that implement an online shopping system, wherein the online shopping system obtains product information from a legacy database having a predefined schema, the instructions being executable by a computer to perform steps comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 22
Dependent Claim
20 words
A computer-readable storage medium as recited in claim 16, wherein the database query is written in the SQL data sublanguage.
Claim 23
Dependent Claim
28 words
A computer-readable storage medium as recited in claim 16, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.
Claim 24
Dependent Claim
145 words
An online shopping system comprising: a server computer; a legacy database accessible to the server computer, the legacy database having a predefined schema; an application program that executes on the server computer to implement the online shopping system and to perform steps comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 25
Dependent Claim
145 words
An online shopping system comprising: a server computer; a legacy database accessible to the server computer, the legacy database having a predefined schema; an application program that executes on the server computer to implement the online shopping system and to perform steps comprising: submitting a database query to the legacy database from the online shopping system, wherein the legacy database returns an access object having one or more information records relating to different products; wherein the database query is formulated to return an access object that is formatted as required by the online shopping system rather than being formatted in accordance with the predefined schema of the legacy database, the access object having records and fields; processing the access object in the online shopping system to obtain the desired product data; wherein the processing step comprises indexing the access object with record and field identifiers.
Claim 26
Dependent Claim
20 words
An online shopping system as recited in claim 19, wherein the database query is written in the SQL data sublanguage.
Claim 27
Dependent Claim
28 words
An online shopping system as recited in claim 19, wherein the access object comprises a table, and wherein the record and field identifiers comprise row and column identifiers.
References Cited (Backward Citations)
US5513348A
Cited
US5235701A
Cited
US5659724A
Cited
US5596744A
Cited
US5615367A
Cited
US5701453A
Cited
US5491818A
Cited
US5764973A
Cited
US5692181A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-10-25 | 2003-04-26 | 2003-10-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-10-25 | 2007-04-26 | 2007-10-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-10-25 | 2011-04-26 | 2011-10-26 | $7700.00 | Window Closed / Lapsed |