By a News Reporter-Staff News Editor at Computer Weekly News -- A patent by the inventors Abed, Sami (Dublin, IE); Clifford, Austin (Dublin, IE); Emanowicz, Konrad (Dublin, IE); Jenkins, Gareth (Dublin, IE), filed on September 11, 2015, was published online on September 26, 2017, according to news reporting originating from Alexandria, Virginia, by VerticalNews correspondents.
Patent number 9773027 is assigned to INTERNATIONAL BUSINESS MACHINES CORPORATION (Armonk, NY).
The following quote was obtained by the news editors from the background information supplied by the inventors: "Various embodiments of this invention relate to database tools and, more particularly, to a data loading tool.
"There is often a requirement to replicate a subset of data in a production database for development, testing or offline point-in-time reporting requirements. This subset of data will generally be a logical subset, for example, all data relating to a specific geographical region or a branch office and perhaps all data in the database for a specific monthly range. Typically, a database designer will attempt to eliminate duplication and store data properties in separate associated tables. Therefore, to extract a logical subset, related data in each associated table must be identified through successive join operations using foreign key relationships between the tables.
"Given the challenging workload requirements on production systems, it is often impractical to run select queries with join operators against the production database directly to extract the datasets.
"Furthermore, a target system will often be much smaller than the full-scale production system and would typically not have enough disk storage available to facilitate a full database restore of the production database, before using a complex structured query language (SQL) statement to extract the required subset dataset.
"Patent publication US20060242205A1, 'Self-contained partial database backups,' outlines an approach for creating a subset of a database, which might be useful in the above situation. The approach involves a database restore operation from the database subset whereby the subset consists of file groups and associated metadata.
"U.S. Pat. No. 6,047,294, 'Logical restore from a physical backup in a computer storage system,' outlines an approach for backing up and restoring data in computer system. A segment of data, such as a virtual disk partition, is backed up at a physical level from a primary storage device, and a logical element within the segment may be restored. The solution assumes the logical element is always a file.
"The main drawback of these previous solutions is that the smallest logical subset a user can extract for the target system is a file. Considering the size of the production systems, the files and file groups of the backup structure are too large for the target test system and do not provide a specific small logical subset of data desired by the user (generally a subset of rows from a set of related tables in the database)."
In addition to the background information obtained for this patent, VerticalNews journalists also obtained the inventors' summary information for this patent: "In a first exemplary embodiment of this disclosure, a method for loading data from a backup image of a database includes selecting a subset statement defining a subset of the data in the database. Tables of the database are identified based on metadata of the database. A target database is written having the structure but not the data of the identified tables. One or more table statements are constructed, by a computer processor, defining a subset of each identified table based on the subset statement. Selected data is unloaded from a backup image into the target database using respective table statements as filters.
"In a second embodiment, a computer program product includes a computer readable storage medium having computer readable program code embodied thereon. The computer readable program code is executable by a processor to perform a method. The method includes selecting a subset statement defining a subset of the data in the database. Further according to the method, tables of the database are identified based on metadata of the database. A target database is written having the structure but not the data of the identified tables. One or more table statements are constructed defining a subset of each identified table based on the subset statement. Selected data is unloaded from a backup image into the target database using respective table statements as filters.
"In a third embodiment, a data loading apparatus for loading data from a backup image of a database includes a selector, an identifier, a writer, a builder, and an unloader. The selector is configured to select a subset statement defining a subset of the data in the database. The identifier is configured to identify tables of the database based on metadata of the database. The writer is configured to write a target database having the structure but not the data of the identified tables. The builder is configured to construct one or more table statements defining a subset of each identified table based on the subset statement. The unloader is configured to unload selected data from the backup image into the target database using respective table statements as filters.
"Additional features and advantages are realized through the techniques of the present invention. Other embodiments and aspects of the invention are described in detail herein and are considered a part of the claimed invention. For a better understanding of the invention with the advantages and the features, refer to the description and to the drawings."
URL and more information on this patent, see: Abed, Sami; Clifford, Austin; Emanowicz, Konrad; Jenkins, Gareth. Data Loading Tool. U.S. Patent Number 9773027, filed September 11, 2015, and published online on September 26, 2017. Patent URL: http://patft.uspto.gov/netacgi/nph-Parser?Sect1=PTO1&Sect2=HITOFF&d=PALL&p=1&u=%2Fnetahtml%2FPTO%2Fsrchnum.htm&r=1&f=G&l=50&s1=9773027.PN.&OS=PN/9773027RS=PN/9773027
Keywords for this news article include: Computers, INTERNATIONAL BUSINESS MACHINES CORPORATION.
Our reports deliver fact-based news of research and discoveries from around the world. Copyright 2017, NewsRx LLC