Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2007-01-30
2007-01-30
Pham, Khanh B. (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000
Reexamination Certificate
active
10224833
ABSTRACT:
A method and computer program are disclosed for measuring the parallelism of an execution step. The method includes determining whether the step operates on rows whose primary index is specified. If the primary index is specified, the parallelism is measured as single. If the primary index is not specified, the method determines whether the step uses an output from a previous step. If an output is used, the number of rows in the output is compared to a specified number. If the number of rows is greater than the specified number, the parallelism is measured as total. In one implementation, the geography of the output is determined and the previous step is compared to specified types such that if the primary index is not specified, the number is rows is not greater than a specified number, the geography does not write output rows to all parallel units, and the previous step is of a specified type, then the parallelism is measured as partial.
REFERENCES:
patent: 5857180 (1999-01-01), Hallmark et al.
patent: 6081801 (2000-06-01), Cochrane et al.
patent: 6192359 (2001-02-01), Tsuchida et al.
patent: 6820262 (2004-11-01), Tellez et al.
Paulsell, Karen, “Sysbase Adaptive Server Enterprise Performance and Tuning Guide: Query Tuning”, Server Publishcation Group, Oct. 1999.
Mahapatra et al., “Oracle Parallel Processing”, O'Reilly Publisher, Aug. 2000, pp. 285.
Au Grace Kwan-On
Fan Sang-Luen Helen
Pederson May Wat
Baker & Botts
Cowart John D.
NCR Corp.
Pham Khanh B.
Stevens III Harden E.
LandOfFree
Method and system for measuring parallelism of a database... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and system for measuring parallelism of a database..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for measuring parallelism of a database... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3814558