Test data management

Patent metadata

Field	Value
Publication number	US-10866973-B2
Application number	US-201715834180-A
Country	US
Kind code	B2
Filing date	Dec 7, 2017
Priority date	Jun 6, 2016
Publication date	Dec 15, 2020
Grant date	Dec 15, 2020

Abstract

As disclosed herein, a method includes receiving a plurality of datasets from a database, wherein each dataset comprises one or more data fields represented in a single data format, and wherein the data fields from at least two of the datasets are represented in different data formats, combining the plurality of datasets to provide a created data column corresponding to all of the data fields from the plurality of datasets, organizing the data column into data clusters, wherein each data cluster includes data fields represented in a single data format, and wherein each data field belongs to a data cluster, providing a key-value map referencing data fields with respect to their corresponding data formats, and verifying the database with respect to the created column. A corresponding computer program product and computer system are also disclosed.

First claim

What is claimed is:

1. A method comprising:
receiving a plurality of datasets from a database, wherein each dataset comprises one or more data fields represented in a single data format, and wherein the data fields from at least two of the datasets are represented in different data formats;
combining the plurality of datasets to provide a created data column corresponding to all of the data fields from the plurality of datasets;
organizing the created data column into data clusters, wherein each data cluster includes data fields represented in a single data format, and wherein each data field belongs to a data cluster;
providing a key-value map referencing data fields with respect to their corresponding data formats wherein the key-value map is saved in a format such that each bit of the key-value map corresponds to a distinct entry of the created column; and
verifying the database with respect to the created data column by:
executing one or more database operations utilizing data from the created data column to confirm that the database is functional relative to the executed one or more database operations and the different data formats represented in the created data column.

2. The method of claim 1 , wherein the plurality of datasets correspond to datasets from a single data table in the database.

3. The method of claim 1 , wherein each data cluster is saved as a data page indicating which data fields belong to said cluster.

4. The method of claim 1 , wherein verifying a database with respect to the created column comprises executing a set of database operations on the data fields in the created column.

5. The method of claim 4 , wherein verifying a database with respect to the created column further includes providing an indicator of the database's validity.

6. The method of claim 1 , wherein the key-value map is implemented as an array maintained with one or more initial test data fields.

Assignees

• IBM

Inventors

• Barbas Pedro M
• Emanowicz Konrad
• Mccallig Enda
• Nomani Aslam F
• Pan Lei

Classifications

• G06F11/3684 Primary

  for test design, e.g. generating new test cases · CPC title

• G06F16/285 Primary

  Clustering or classification · CPC title

• G06F16/2237

  Vectors, bitmaps or matrices · CPC title

• G06F16/2365

  Ensuring data consistency and integrity · CPC title

• G06F16/221

  Column-oriented storage; Management thereof · CPC title