Emulating a database system

Details Emulating a database system Emulating a database system

2006-12-26

2006-12-26

Alam, Shahid Al (Department: 2162)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C709S204000, C715S700000, C345S215000

Reexamination Certificate

active

07155428

ABSTRACT:
A method and apparatus provides for the extraction of environment information from a target database system. The environment information includes at least one of cost-related information and random sample statistics. The cost-related information and/or random sample statistics are imported to a test system, where the cost-related information and/or random sample statistics are used in query plan analysis by an optimizer.

REFERENCES:
patent: 5303383 (1994-04-01), Neches et al.
patent: 5488570 (1996-01-01), Agarwal
patent: 5508942 (1996-04-01), Agarwal
patent: 5511003 (1996-04-01), Agarwal
patent: 5515296 (1996-05-01), Agarwal
patent: 5640584 (1997-06-01), Kandasamy et al.
patent: 5857192 (1999-01-01), Fitting
patent: 5864841 (1999-01-01), Agrawal et al.
patent: 5864842 (1999-01-01), Pederson et al.
patent: 5884299 (1999-03-01), Ramesh et al.
patent: 6067542 (2000-05-01), Carino, Jr.
patent: 6370522 (2002-04-01), Agarwal et al.
patent: 6401083 (2002-06-01), Agarwal et al.
patent: 6430556 (2002-08-01), Goldberg et al.
patent: 6487547 (2002-11-01), Ellison et al.
patent: 2003/0016237 (2003-01-01), Hickey
Oracle Corporation, “SQL Language: Reference Manual, Version 6.0,” pp. 5-1 to 5-5, 5-96 to 5-97 (1990).
Eugene Wong et al., ACM Transactions on Database Systems, vol. 1, No. 3, “Decomposition-A Strategy for Query Processing,” pp. 223-241 (Sep. 1976).
P. Griffiths Selinger et al., ACM, “Access Path Selection in a Relational Database Management System,” pp. 23-34 (1979).
Masaru Kitsuregawa et al., Institute of Industrial Science, University of Tokyo, “Ouery Execution for Large Relations on Functional Disk System,” pp. 159-167 (1989).
U.S. Appl. No. 09/976,634, filed Oct. 12, 2001.
U.S. Appl. No. 09/976,632, filed Oct. 12, 2001.
U.S. Appl. No. 09/977,038, filed Oct. 12, 2001.
U.S. Appl. No. 09/608,977, filed Jun. 30, 2000.
D.D. Chamberlin et al., “Views, Authorization, and Locking in a Relational Data Base System,” National Computer Conference, pp. 425-430 (1975).
D.D. Chamberlin et al., “Sequel 2: A Unified Approach to Data Definition, Manipulation, and Control,” IBM Journal of Research and Development, vol. 20, pp. 560-575 (Nov. 1976).
M.W. Blasgen et al., “On The Evaluation of Queries in a Relational Data Base System,” IBM Research Report RJ 1745, pp. 1-44 (Apr. 1976).
M.W. Blasgen et al., “Storage and Access in Relational Data Bases,” IBM Systems Journal, No. 4, pp. 363-377 (1977).

Affiliated with

Also associated with

Rating

Emulating a database system does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Emulating a database system, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Emulating a database system will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3696642