发明名称 |
Database index design based upon request importance and the reuse and modification of similar existing indexes |
摘要 |
Design of indexes in a relational database management system is based on a workload analysis of all requests in a system. Each request is assigned a value of importance, and requests are broken into expressions, contexts and columns to facilitate identification of candidate indexes. Candidate indexes are compared to existing indexes to determine whether the existing indexes can be reused or modified. Candidate indexes are classified as hashed or sorted. Based on the index design, record placement is selected to be hashed, sorted or by default. Related indexes and tables are clustered and the clusters are sized to fit file areas. Cache buffers are also defined.
|
申请公布号 |
US5404510(A) |
申请公布日期 |
1995.04.04 |
申请号 |
US19920886751 |
申请日期 |
1992.05.21 |
申请人 |
ORACLE CORPORATION |
发明人 |
SMITH, GREGORY S.;PANT, SANGAM |
分类号 |
G06F17/30;(IPC1-7):G06F15/40 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|