Unlock instant, AI-driven research and patent intelligence for your innovation.

System and method for moving records between partitions

A technology of recording and partitioning, applied in the field of computer systems

Inactive Publication Date: 2008-02-27
IBM CORP
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For many users, this duration of data unavailability is annoying or unacceptable

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for moving records between partitions
  • System and method for moving records between partitions
  • System and method for moving records between partitions

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] Referring to the drawings, in which like numerals represent like parts throughout the several views, FIG. 1 depicts a high-level block diagram illustration of a server computer system 100 connected to a client computer system 132 via a network 130 in accordance with an embodiment of the present invention. The terms "client" and "server" are used herein for convenience only, and in various embodiments a computer operating as a client in one environment may operate as a server in another, and vice versa. In one embodiment, the hardware components of computer system 100 may be implemented by an eServer iSeries computer system available from International Business Machines Corporation of Armonk, New York. However, those of ordinary skill in the art should appreciate that the mechanisms and devices in the embodiments of the present invention are equally applicable to any suitable computing system.

[0023] The major components of computer system 100 include one or more proc...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

In an embodiment, data is partitioned into partitions, which are divided into levels. The levels are ordered by creation times of the levels. A request is received at a current partition, which includes a key that identifies a field in a record and a value for the key. A determination is made whether the value exists in the field in the current partition. If the determination is false, a message is sent from the current partition to a next-older partition, and the message instructs the next-older partition to move the record with the value from the next-older partition to the current partition. If the determination is true, the record with the value in the field is moved from the current partition to a next-newer partition if the next-newer partition sent the request, and the record is deleted from the current partition.

Description

technical field [0001] Embodiments of the invention relate generally to computer systems having partitioned data, and in particular to moving data records between partitions. Background technique [0002] Basically, computer systems are used for the storage, processing, and analysis of data. One mechanism for managing data is known as a database management system, also known as a database system or simply a database. The most common is often called a relational database (RDB), which organizes data in tables that have rows that represent individual entries or records in the database, and that define what to store Columns in each row, entry, or record. Each table has a unique name within the database, and each column has a unique name within a particular table. The database also has an index, which is a data structure used to inform the database management system where a row is in the table given the indexed column value, which is the same as used to inform the reader on wh...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F17/30952G06F16/9017Y10S707/99933Y10S707/99942Y10S707/99931
Inventor 王浩沈金梅
Owner IBM CORP