Invention Grant
- Patent Title: Archiving to a single database table information located across multiple tables
-
Application No.: US15397827Application Date: 2017-01-04
-
Publication No.: US09858306B2Publication Date: 2018-01-02
- 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 ; G06F12/14

Abstract:
A method, and associated system, for archiving to a single database table information located across multiple database tables. A threshold number of times specified by the end user and a period of time specified by the end user are received. At least one archival data value is identified. 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. A determination is made that the specified threshold number of times has not been exceeded, within the specified period of time, by a number of times each archival data value has been moved within the multiple database tables. At least one archive file in the single database table is stored. Each archive file of the at least one archive file includes the at least one archive data value.
Public/Granted literature
- US20170116243A1 ARCHIVING TO A SINGLE DATABASE TABLE INFORMATION LOCATED ACROSS MULTIPLE TABLES Public/Granted day:2017-04-27
Information query