Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-10-18
2005-10-18
Robinson, Greta (Department: 2167)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06957209
ABSTRACT:
Methods for determining database management system server hardware requirements as a function of user-supplied transactions per second requirements, maximum processor utilization, and server type. Methods are also provided for determining workload requirements as a function of the expected transaction composition of the system including the expected transaction execution rate in transactions per second and the percent of total workload contribution by each statement. In one method, each transaction is further specified as a set of SQL statements each having a parameter list, where the workload contribution of each SQL statement is calculated as a function of the SQL statement parameter list.
REFERENCES:
patent: 4495562 (1985-01-01), Yamaji et al.
patent: 5065360 (1991-11-01), Kelly
patent: 5125088 (1992-06-01), Culley
patent: 5276877 (1994-01-01), Friedrich et al.
patent: 5617514 (1997-04-01), Dolby et al.
patent: 5630025 (1997-05-01), Dolby et al.
patent: 5815662 (1998-09-01), Ong
patent: 5835755 (1998-11-01), Stellwagen, Jr.
patent: 5845279 (1998-12-01), Garofalakis et al.
patent: 5857195 (1999-01-01), Hayashi et al.
patent: 6038664 (2000-03-01), Schumacher et al.
patent: 6067412 (2000-05-01), Blake et al.
patent: 6108700 (2000-08-01), Maccabee et al.
patent: 6138016 (2000-10-01), Kulkarni et al.
patent: 6233602 (2001-05-01), Van Venrooy et al.
patent: 6240463 (2001-05-01), Benmohamed et al.
patent: 6263382 (2001-07-01), Bartlett et al.
patent: 6289334 (2001-09-01), Reiner et al.
patent: 6356887 (2002-03-01), Berenson et al.
patent: 6356902 (2002-03-01), Tan et al.
patent: 6542854 (2003-04-01), Yang et al.
Compaq Computer Corporation, “White Paper”, 5 pages, Jun. 1998.
Kim Shanely, “History and Overview of the TPC”, 14 pages, Feb. 1998.
“TPC-C Results—Revision 3X”, downloaded from www.tpc.org, 4 pages, dated prior to Feb. 29, 2000.
“TPC-R Benchmark”, downloaded from www.tpc.org, 2 pages, dated prior to Feb. 29, 2000.
“TPC-H Benchmark”, downloaded from www.tpc.org, 2 pages, dated prior to Feb. 29, 2000.
Jack Stephens, “TPC-D The Industry Standard Decision Support Benchmark”, 28 pages, dated prior to Feb. 29, 2000.
Select pages from www.tpc.org, 12 pages, downloaded Nov. 2, 1999.
User Guide, Compaq System Sizer v8.1 for Oracle8i NT4.0, Compaq Computer Corporation, Jun. 1999, pp. 1-40.
User Guide, Compaq Sizer 2.30 for Microsoft SQL Server 7.0, Compaq Computer Corporation, Oct. 1999, pp. 1-44.
“TPC-D Benchmark”, downloaded from www.tpc.org, 6 pages, dated prior to Feb. 29, 2000.
Dodds, Jr. Harold E.
Johnson Charles A.
Robinson Greta
Starr Mark T.
Tufte Brian N.
LandOfFree
Sizing servers for database management systems via user... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Sizing servers for database management systems via user..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Sizing servers for database management systems via user... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3463467