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 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
09:47a SAP profits miss forecasts as cloud shift inflates costs
08:49a INTERNATIONAL BUSINESS MACHINES : Best points to ex­pe­ri­ence  and ser­vice to ..
04:58a INTERNATIONAL BUSINESS MACHINES : IBM's revenue beats estimates on cloud, securi..
02:55a CORPORATION (OTCMKTS : CCYPQ) Files An 8-K Regulation FD Disclosure
12:58a Dow closes above 23,000 mark in 54-day run-up
10/18 INTERNATIONAL BUSINESS MACHINES : Fusemachines Inc. Appoints Former IBM Watson T..
10/18 INTERNATIONAL BUSINESS MACHINES : VR/AR Leaders From Amazon, Dell and IBM Finali..
10/18 INTERNATIONAL BUSINESS MACHINES : Dow closes above 23,000 for 1st time
10/18 IBM and Canadian Pacific climb while Electronic Arts drops
10/18 INTERNATIONAL BUSINESS MACHINES : The Weather Company and TripAdvisor to Provide..
More news
News from SeekingAlpha
03:09a IBM - Why Investors Should Not Alter Their Perceptions In The Wake Of Quarter..
02:45a A KISS Dividend Strategy Worth 15% A Year
12:18a J&J : Unattractive
10/18 Top Tech Dividend Dogs Xperi, TiVo, PCTEL, & LSI Shoot For Over 20% October G..
10/18 EDITORS' PICKS DAILY : Income Investing, Market Behavior & An Interesting MLP
Financials ($)
Sales 2017 78 520 M
EBIT 2017 14 632 M
Net income 2017 11 241 M
Debt 2017 34 653 M
Yield 2017 3,68%
P/E ratio 2017 13,34
P/E ratio 2018 12,91
EV / Sales 2017 2,33x
EV / Sales 2018 2,35x
Capitalization 149 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
TrendsBullishNeutralBearish
Income Statement Evolution
Consensus
Sell
Buy
Mean consensus HOLD
Number of Analysts 26
Average target price 160 $
Spread / Average Target 0,24%
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-3.89%148 672
ACCENTURE17.32%88 603
TATA CONSULTANCY SERVICES LIMITED9.64%76 129
AUTOMATIC DATA PROCESSING10.85%50 628
VMWARE, INC.48.10%47 683
COGNIZANT TECHNOLOGY SOLUTIONS31.97%43 671