Patent application number | Description | Published |
20120215815 | TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING - Embodiments of the present invention provide a method, system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a method for test data generation using unique common factor sequencing is provided. The method includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers. | 08-23-2012 |
20140006866 | TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING | 01-02-2014 |
20140059026 | TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING - Embodiments of the present invention provide a system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a computer program product for test data generation using unique common factor sequencing is provided. The computer program product includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers. | 02-27-2014 |
20140059086 | TEST DATA GENERATION AND SCALE UP FOR DATABASE TESTING USING UNIQUE COMMON FACTOR SEQUENCING - Embodiments of the present invention provide a system and computer program product for test data generation using unique common factor sequencing. In an embodiment of the invention, a computer program product for test data generation using unique common factor sequencing is provided. The computer program product includes loading a table for population with test data in a test data generation tool executing in memory of a computer. A column set of multiple columns in the table associated with a key to the table can be selected for processing and different cardinality sequence values are assigned to the columns in the set such that the cardinality sequence values do not share a common factor except for unity as in the case of prime numbers. | 02-27-2014 |
20140136512 | RELATIVE PERFORMANCE PREDICTION OF A REPLACEMENT DATABASE MANAGEMENT SYSTEM (DBMS) - Embodiments of the present invention provide a method, system and computer program product for pre-migration performance prediction of a database management system (DBMS). In an embodiment of the invention, a method for pre-migration performance prediction of a DBMS can include executing a calibration workload in a target DBMS to produce a conversion factor of cost of executing the calibration workload to temporal performance of executing the calibration workload. The method also can include subsequently submitting a sample workload from a database of a source DBMS for evaluation of cost of execution on an empty replica of the database in the target DBMS. Finally, the method can include predicting a temporal performance of the sample workload in the target DBMS as a product of the conversion factor and the cost of execution of the sample workload on the empty replica of the database in the target DBMS. | 05-15-2014 |
20140136516 | RELATIVE PERFORMANCE PREDICTION OF A REPLACEMENT DATABASE MANAGEMENT SYSTEM (DBMS) - Embodiments of the present invention provide a method, system and computer program product for pre-migration performance prediction of a database management system (DBMS). In an embodiment of the invention, a method for pre-migration performance prediction of a DBMS can include executing a calibration workload in a target DBMS to produce a conversion factor of cost of executing the calibration workload to temporal performance of executing the calibration workload. The method also can include subsequently submitting a sample workload from a database of a source DBMS for evaluation of cost of execution on an empty replica of the database in the target DBMS. Finally, the method can include predicting a temporal performance of the sample workload in the target DBMS as a product of the conversion factor and the cost of execution of the sample workload on the empty replica of the database in the target DBMS. | 05-15-2014 |
Patent application number | Description | Published |
20130311446 | PERFORMANCE ANALYSIS OF A DATABASE - A method and system are provided for performance analysis of a database. The method includes receiving a proposed data model, generating a hypothetical query workload using a plurality of sample query templates representing different query constructs for the proposed data model, generating hypothetical optimizer statistics using predefined generating rules that include a projected cardinality for the proposed data model and creating a sample empty database and database schema using the proposed data model. The method also includes applying the hypothetical optimizer statistics to the sample empty database, based on generating the hypothetical optimizer statistics, applying each query construct of the hypothetical query workload to the database schema and estimating a cost of the hypothetical query workload for the proposed data model. | 11-21-2013 |
20150261816 | DYNAMICALLY INDENTIFYING AND PREVENTING SKEWED PARTITIONS IN A SHARED-NOTHING DATABASE - Dynamically identifying and preventing skewed partitions in a shared-nothing database is provided. The database management system software receives a parameter for identifying a threshold value associated with at least one distribution key value. Optimizer statistics are gathered on a first table that is distributed across one or more partitions in the shared-nothing database, wherein the first table includes a first table name. Distribution key skew is identified based on the gathered optimizer statistics indicating the threshold value being exceeded. A second table with an alternate distribution key, is created having a second table name for receiving overflow data rows associated with the at least one distribution key value based on the identified distribution key skew. A union all view is created based on the first and the second table. | 09-17-2015 |
20150261840 | DYNAMICALLY INDENTIFYING AND PREVENTING SKEWED PARTITIONS IN A SHARED-NOTHING DATABASE - Dynamically identifying and preventing skewed partitions in a shared-nothing database is provided. The database management system software receives a parameter for identifying a threshold value associated with at least one distribution key value. Optimizer statistics are gathered on a first table that is distributed across one or more partitions in the shared-nothing database, wherein the first table includes a first table name. Distribution key skew is identified based on the gathered optimizer statistics indicating the threshold value being exceeded. A second table with an alternate distribution key, is created having a second table name for receiving overflow data rows associated with the at least one distribution key value based on the identified distribution key skew. A union all view is created based on the first and the second table. | 09-17-2015 |