Invention Grant
- Patent Title: Archiving to a single database table information located across multiple tables
- Patent Title (中): 归档到跨多个表的单个数据库表信息
-
Application No.: US14922259Application Date: 2015-10-26
-
Publication No.: US09588973B2Publication Date: 2017-03-07
- Inventor: Sridhar Shetty , Sugantha Subbiah
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Schmeiser, Olsen & Watts, LLP
- Agent Lisa Ulrich
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
A method, and associated system, for archiving to a single database table information located across multiple database tables. At least one archival data value is identified, wherein each archival data value corresponds to a unique data value of at least one data value residing in a table of the multiple database tables, wherein each archival data value does not exceed a threshold. An end user provides the threshold used to identify the archival data values prior to execution of the method. After identifying the archival data values, the method continues by storing archive files in the single database table, each archive file comprising at least one archive data value. Finally, after storing the archive files in the single database table, the method concludes by removing from the multiple database tables each archival data value.
Public/Granted literature
- US20160048523A1 ARCHIVING TO A SINGLE DATABASE TABLE INFORMATION LOCATED ACROSS MULTIPLE TABLES Public/Granted day:2016-02-18
Information query