Database index design based upon request importance and the reus

Computer graphics processing and selective visual display system – Display driving control circuitry – Controlling the condition of display elements

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

345425, 345934, 36441907, 36441919, 3649746, 364DIG2, 3642821, 364DIG1, G06F 1540

Patent

active

054045100

ABSTRACT:
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.

REFERENCES:
patent: 4468732 (1984-08-01), Raver
patent: 4956774 (1990-09-01), Shibamiya et al.
patent: 5043872 (1991-08-01), Cheng et al.
Rullo et al, "An Automatic Physical Designer for Network Model Databases", IEEE Transactions on Software Engineering, vol. 14, No. 9, Seisterploer, 1988 pp. 1293-1306.
Baraucci et al, "Optimal Selection of Secondary Indexes", IEEE Transactions on Software Engineering, vol. 16, No 1, Jan. 1990, pp. 32-38.
Falkowski, "Comments on an Optimal Set of Inducers for a Realational Data base", IEEE Transactions on Software Engineering, vol. 18, No. 2, Feb. 1992 pp. 168-171.
S. Finkelstein, et al., Physical Database Design for Relational Databases, IBM Almaden Research Center, ACM Transactions on Database Systems, vol. 13, No. 1, Mar. 1988, pp. 91-128.
U.S. Patent Application 485,376, filed Feb. 26, 1990, Applicant, Michael E. Gioielli et al., Title: Physical Database Design System.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Database index design based upon request importance and the reus does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Database index design based upon request importance and the reus, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Database index design based upon request importance and the reus will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2385567

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.