Database consistent sample data extraction
AssigneeBusiness Objects Software Ltd.
InventorJohn O'Byrne
Life of this patent
Estimating the term…
Abstract
Various embodiments of systems and methods for database consistent sample data extraction are described herein. The technique uses production data as input and outputs sample data in the same relational schema while preserving the integrity of joins of the different tables in the schema. For a given relational schema, the master tables are found. Then a subset is created by placing selection criteria in a query defining how to sample the data for these master tables. Following the joins, the dependent tables are added to the query automatically.
Claims14
A computer implemented method for database consistent sample data extraction comprising:
- receiving a selection of a source database system;
- receiving a selection of one or more tables from the source database system;
- identifying one or more master tables from the one or more selected tables, the one or more master tables connected to one or more dependent tables by:
- defining oriented cardinalities of tables from a schema comprising the selected tables and their related tables;
- and
- defining paths using the oriented cardinalities;
- receiving a selection of sample data extraction variant for extraction of sample data from the one or more master tables;
- filtering the one or more dependent tables to keep valid joins between the sample data of the one or more master tables and the one or more dependent tables by following join cardinalities to reach the one or more dependent tables starting from the one or more master tables;
- and
- generating a sample database from the sample data of the one or more master tables and the filtered dependent tables.
A computer system for data visualization and interaction including at least one processor for executing program code and memory, the system comprising:
- a source database with one or more fact tables;
- an input device to provide user selection of one or more selected tables from the fact tables;
- an identifier module to identify one or more master tables from the one or more selected tables, the one or more master tables connected to one or more dependent tables by:
- defining oriented cardinalities of tables from a schema comprising the selected tables and their related tables;
- and
- defining paths using the oriented cardinalities;
- an extraction module to extract sample data from the one or more master tables;
- a filtering module to filter the one or more dependent tables to keep valid joins between the sample data of the one or more master tables and the one or more dependent tables by following join cardinalities to reach the one or more dependent tables starting from the one or more master tables;
- and
- a generating module to generate a sample database from the sample data of the one or more master tables and the filtered dependent tables.
An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:
- receive a selection of a source database system;
- receive a selection of one or more tables from the source database system;
- identify one or more master tables from the one or more selected tables, the one or more master tables connected to one or more dependent tables by:
- defining oriented cardinalities of tables from a schema comprising the selected tables and their related tables;
- and
- defining paths using the oriented cardinalities;
- receive a selection of sample data extraction variant for extraction of sample data from the one or more master tables;
- filter the one or more dependent tables to keep valid joins between the sample data of the one or more master tables and the one or more dependent tables by following join cardinalities to reach the one or more dependent tables starting from the one or more master tables;
- and
- generate a sample database from the sample data of the one or more master tables and the filtered dependent tables.
Dependencies are inferred from the claim text.