US5485610A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Physical database design system
Assignee: Oracle International Corp
•
Filing: 1994-08-19
•
Granted: 1996-01-16
•
Expires: 2014-08-19
Abstract
Abstract A physical database designer which is embodied in computer software that generates a physical database design. The designer follows a process which includes the steps of (a) entering a logical schema representing the database to be designed; (b) entering a hierarchial definition of the workload experienced by the database, which includes, for each level of a hierarchy of operations, a separate specification of workload; and (c) applying expert rules to the logical schema and the workload definition to generate the physical database design.
Inventors
- 👤 Michael E. Gioielli
- 👤 James Ravan
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 11:09
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/22; G06F16/2228; G06F16/2272; Y; Y10; Y10S; Y10S707/00; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 6
Claim 1
Independent Claim
329 words
A process implemented by a computer system for generating a physical design for a database, the database to include data records and index records, the index records to access data stored in the data records, comprising: retrieving a set of expert rules from a memory of the computer system; accepting a logical schema as input, said logical schema to describe a logical arrangement of the database; accepting a data volume definition as input, said data volume definition to describe an amount of data to be stored in the database; defining a plurality of first operations, each first operation of said plurality of first operations to access the data of the database; accepting a first workload description as input, said first workload description to specify a first workload for each first operation of said plurality of first operations; grouping selected first operations of said plurality of first operations into a plurality of second operations, each second operation including at least one first operation, and each first operation being grouped in at least one second operation; accepting a second workload description as input, said second workload description to specify a second workload for each second operation of said plurality of second operations; grouping selected second operations of said plurality of second operations into a plurality of third operations, each third operation including at least one second operation, and each second operation being grouped in at least one third operation; accepting a third workload description as input, said third workload description to specify a third workload for each third operation of said plurality of third operations; selectively applying said set of expert rules to said logical schema and said data volume description and said first workload description and said second workload description and said third workload description to generate the physical design of the database, the physical design to specify how the data will be physically stored in the data records and how the data records are accessed by the index records.
Claim 2
Dependent Claim
329 words
A process implemented by a computer system for generating a physical design for a database, the database to include data records and index records, the index records to access data stored in the data records, comprising: retrieving a set of expert rules from a memory of the computer system; accepting a logical schema as input, said logical schema to describe a logical arrangement of the database; accepting a data volume definition as input, said data volume definition to describe an amount of data to be stored in the database; defining a plurality of first operations, each first operation of said plurality of first operations to access the data of the database; accepting a first workload description as input, said first workload description to specify a first workload for each first operation of said plurality of first operations; grouping selected first operations of said plurality of first operations into a plurality of second operations, each second operation including at least one first operation, and each first operation being grouped in at least one second operation; accepting a second workload description as input, said second workload description to specify a second workload for each second operation of said plurality of second operations; grouping selected second operations of said plurality of second operations into a plurality of third operations, each third operation including at least one second operation, and each second operation being grouped in at least one third operation; accepting a third workload description as input, said third workload description to specify a third workload for each third operation of said plurality of third operations; selectively applying said set of expert rules to said logical schema and said data volume description and said first workload description and said second workload description and said third workload description to generate the physical design of the database, the physical design to specify how the data will be physically stored in the data records and how the data records are accessed by the index records.
Claim 3
Dependent Claim
51 words
The process of claim 1 wherein each third operation of said plurality of third operations is a computer program, and each second operation of said plurality of second operations is a recoverable database transaction, and said plurality, of third operations include data read operations, data write operations, and data update operations.
Claim 4
Dependent Claim
72 words
The process of claim 1 wherein said first workload description, said second workload description, and said third workload description further comprises a relative importance and relative frequency of said first operations, said second operations, and said third operations, respectively, and further comprising: annualizing said relative frequencies of said first operations, said second operations, and said third operations; and deriving, after annualizing, an absolute importance and an absolute frequency of said first operations.
Claim 5
Dependent Claim
65 words
The process of claim 1 further comprising: grouping selected third operations of said plurality of third operations into a plurality of fourth operations, each fourth operation of said plurality of fourth operations including at least one third operation; and accepting a fourth workload description as input, said fourth workload description to specify a fourth workload for each fourth operation of said plurality of fourth operations;
Claim 6
Dependent Claim
37 words
The process of claim 1 wherein the steps of accepting said first workload description and accepting said second workload description and accepting said third workload description further comprises: entering an output of an event performance collector software.
References Cited (Backward Citations)
US4468732A
Cited
US4631664A
Cited
JPS6077249A
Cited
US4819160A
Cited
US4956774A
Cited
US5014197A
Cited
US5159687A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-01-15 | 1999-07-17 | 2000-01-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-01-15 | 2003-07-17 | 2004-01-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-01-15 | 2007-07-17 | 2008-01-16 | $7700.00 | Window Closed / Lapsed |