Fujitsu Corporation

Takayuki Nakazawa

Nobuyuki Takebe

Naohiro Ito

Takafumi Okizuka

Yoshihisa Nakano

Jinshi Annen

Database management involving obtaining a request of update of a record of a database including: (i) pages with records, each including data and transaction identification information (XID) that has a range that is divided by a predetermined range; and (ii) generation identification information (GID) that is increased when the XID's value exceeds the divided range, where the page includes a GID header indicating the earliest GID of the records of the page. Also, reading a page's GID header when switching pages, comparing the GID header with the present GID of the present XID, and performing a freeze process to the record having the XID included in the page's GID header when the GID header's value is less than the difference between the GID's value to which the present XID belongs and a predetermined value.

Database management method and database management apparatus

A database assist method is adapted to a data processing system which includes a first processing unit, an input/output unit which is coupled to the first processing unit, a second processing unit, a database and cache memory. The database assist method assists a database related process which includes selection of items from records stored in the database and includes the steps of (a) forming an execution procedure table which defines a procedure for retrieving information of interest from the database in response to a processing request from a request source, (b) generating at least a column information table which defines item structures within the records and a selection/projection table which defines the items to be extracted and extracting conditions based on the execution procedure table, (c) storing a block group of interest into cache memory from the database based on the column information table and the selection/projection table and carrying out a specified process with respect to the stored block group for a specified item, and (d) returning a result of the specified process carried out in step (c) to the request source by a batch processing.

Growing community of inventors

Kawasaki, Japan

Takayuki Nakazawa