Log in
E-mail
Password
Remember
Forgot password ?
Become a member for free
Sign up
Sign up
Settings
Settings
Dynamic quotes 
OFFON

4-Traders Homepage  >  Equities  >  Nyse  >  International Business Machines Corporation    IBM

SummaryQuotesChartsNewsAnalysisCalendarCompanyFinancialsConsensusRevisions 
News SummaryMost relevantAll newsSector newsTweets

International Business Machines : Patent Issued for Data Loading Tool (USPTO 9773027)

share with twitter share with LinkedIn share with facebook
share via e-mail
0
10/05/2017 | 10:44pm CET

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

(c) 2017 NewsRx LLC, source Technology Newsletters

share with twitter share with LinkedIn share with facebook
share via e-mail
0
Latest news on INTERNATIONAL BUSINESS MAC
08:01p INTERNATIONAL BUSINESS MACHINES : Stonehill Becomes a IBM Registered Business Pa..
03:14p INTERNATIONAL BUSINESS MACHINES : CodeClan appoints new CEO
03:01p Liberty Leaf Holdings and Blox Labs to Develop Blockchain-Based Smart Contrac..
01:32p INTERNATIONAL BUSINESS MACHINES : Digital skills academy CodeClan appoints new c..
11:19a SBERBANK ROSSII : Russias Biggest Bank Pilots Money Transfer on an IBM Blockchai..
11:18a INTERNATIONAL BUSINESS MACHINES : IBM launches Bot Asset Exchange for enterprise..
11:17a INTERNATIONAL BUSINESS MACHINES : Facebook, IBM, Amazon, Microsoft to help Pakis..
11:15a INTERNATIONAL BUSINESS MACHINES : Former IBM vice president to take reins at Cod..
10:36a INTERNATIONAL BUSINESS MACHINES : University of Jyvaskyla - IBM and the Universi..
09:36a INTERNATIONAL BUSINESS MACHINES : Trinity Guard Fills Gap In IBM i Network Secur..
More news
News from SeekingAlpha
12/11 Top 'Safer' Dividend Contender Gains By Axis Capital Per December Broker Targ..
12/11 Where To Invest To Benefit From The Corporate Tax Cut
12/09 The Week That Was In Review - December 8, 2017
12/08 'Safer' Dividend Achiever Top Gains From TC Pipelines, Old Republic & Axis Ca..
12/07 IBM : This Time Is Different
Financials ($)
Sales 2017 78 630 M
EBIT 2017 14 617 M
Net income 2017 11 189 M
Debt 2017 34 538 M
Yield 2017 3,81%
P/E ratio 2017 13,00
P/E ratio 2018 12,60
EV / Sales 2017 2,27x
EV / Sales 2018 2,28x
Capitalization 144 B
Chart INTERNATIONAL BUSINESS MAC
Duration : Period :
International Business Mac Technical Analysis Chart | IBM | US4592001014 | 4-Traders
Technical analysis trends INTERNATIONAL BUSINESS MAC
Short TermMid-TermLong Term
TrendsBullishNeutralNeutral
Income Statement Evolution
Consensus
Sell
Buy
Mean consensus HOLD
Number of Analysts 27
Average target price 163 $
Spread / Average Target 5,0%
EPS Revisions
Managers
NameTitle
Virginia M. Rometty Chairman, President & Chief Executive Officer
James J. Kavanaugh Senior Vice President-Transformation & Operations
Martin J. Schroeter Chief Financial Officer & Senior Vice President
John E. Kelly Senior VP-Cognitive Solutions & Research
Martin Jetter SVP-Global Technology Services
Sector and Competitors
1st jan.Capitalization (M$)
INTERNATIONAL BUSINESS MACHINES CORPORATION-7.48%143 877
ACCENTURE26.87%96 605
TATA CONSULTANCY SERVICES LIMITED9.86%79 005
AUTOMATIC DATA PROCESSING12.75%52 252
VMWARE, INC.48.89%49 519
NETEASE48.76%45 526