Dismiss
InnovationQ will be updated on Tuesday, September 18, from 8-9pm ET. You may experience brief service interruptions during this time. See here for details on our Australian patent collection updates.
Browse Prior Art Database

Method of Making Static Database on On-Line Servicing

IP.com Disclosure Number: IPCOM000122932D
Original Publication Date: 1998-Jan-01
Included in the Prior Art Database: 2005-Apr-04
Document File: 4 page(s) / 100K

Publishing Venue

IBM

Related People

Takahashi, Y: AUTHOR

Abstract

Disclosed is a method of making a static condition of a user database, which was updated continually on on-line servicing, during free time and logically without stopping the on-line service. This function has the following merits: o Unnecessary to change structure of user database o Realization of high-performance using TIMESTAMP

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Method of Making Static Database on On-Line Servicing

      Disclosed is a method of making a static condition of a user
database, which was updated continually on on-line servicing, during
free time and logically without stopping the on-line service.  This
function has the following merits:
  o  Unnecessary to change structure of user database
  o  Realization of high-performance using TIMESTAMP

      Fig. 1 shows the outline of this function.  For example, if
making a static condition of a user database at 0:00am, which timing
is ' STATIC-CHECKPOINT', on on-line servicing, set STATIC-CHECKPOINT
by command (1).  After setting it, if a record on the user database
is updated by '-7000' transaction (2), the record replaced '13000'
from '20000' (3).  At the same time preserving '20000', the record
before updated, into other database, which named 'STACK-DATABASE',
with user database's key field information and so on (4).
Static-image required  program, means to want to process using user
database's image of 0:00am;  can get '20000' from STACK-DATABASE by
this function (5).  If a record  never updates after the
STATIC-CHECKPOINT sets, Static-image required program gets the record
on the user database (6).  About insert recond,  the program a gets
status of 'NOT FOUND' (7).

      Fig. 2 shows a method of preserving static-image into
STACK-DATABASE using TIMESTAMP.  A case of TIMESTAMP of setting
STATIC-CHECKPOINT is 't1' (a) If a record on a user database is
replaced '13000' from '20000', 't1' sets on the replaced record.
And, before-image '20000' is preserved onto the STACK-DATABASE.  (b)
Just after, in case of inputte...