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 newsofficial PublicationsSector newsTweets
OFFRE ETE Zonebourse : Jusqu'à 6 mois offerts sur tous les portefeuilles

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 CEST

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
06/23INTERNATIONAL BUSINESS MACHINES : U.S. Patents Awarded to Inventors in Delaware ..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : U.S. Patents Awarded to Inventors in Connectic..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : U.S. Patents Awarded to Inventors in Minnesota..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : U.S. Patents Awarded to Inventors in New Hamps..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : U.S. Patents Awarded to Inventors in Vermont (..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : IBM boosts support of cloud-native capabilitie..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : University of Michigan outdoes IBM with world`..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : Artificial Intelligence-Powered Sugar.IQ Diabe..
AQ
06/23IoT in Banking and Finance Services Market Growing at CAGR of +52% by 2023 &n..
AQ
06/23INTERNATIONAL BUSINESS MACHINES : Artificial Intelligence-Powered Sugar.IQ(TM) D..
AQ
More news
News from SeekingAlpha
06/21DIGITAL REALTY : The One Tech Company Everyone Should Have In Their Portfolio 
06/21BLOCKCHAIN ETFS : Why You Should Consider BLOK Before All Others 
06/20Domo Adds A Scary Provision To Its Revised IPO Filing; Regardless Of Price, I.. 
06/20Box +3.1% on IBM agreement, high volume 
06/20Domo Readies Plans For $189 Million IPO 
Financials ($)
Sales 2018 80 813 M
EBIT 2018 14 413 M
Net income 2018 10 812 M
Debt 2018 31 885 M
Yield 2018 4,34%
P/E ratio 2018 12,12
P/E ratio 2019 11,55
EV / Sales 2018 2,00x
EV / Sales 2019 1,97x
Capitalization 130 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
TrendsNeutralBearishNeutral
Income Statement Evolution
Consensus
Sell
Buy
Mean consensus HOLD
Number of Analysts 26
Average target price 168 $
Spread / Average Target 19%
EPS Revisions
Managers
NameTitle
Virginia M. Rometty Chairman, President & Chief Executive Officer
James J. Kavanaugh Chief Financial Officer & Senior Vice President
John E. Kelly Senior VP-Cognitive Solutions & Research
Martin Jetter SVP-Global Technology Services
Sidney Taurel Independent Director
Sector and Competitors
1st jan.Capitalization (M$)
INTERNATIONAL BUSINESS MACHINES CORPORATION-7.93%129 691
ACCENTURE4.27%102 656
TATA CONSULTANCY SERVICES34.00%102 057
AUTOMATIC DATA PROCESSING18.69%61 272
VMWARE, INC.19.70%60 972
COGNIZANT TECHNOLOGY SOLUTIONS11.52%46 110