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

Storage/query method and device for ROWID mapping table

A query method and mapping table technology, which is applied in the field of computer data backup and disaster recovery, can solve problems such as inability to support a large number of mapping entry queries, and achieve the effect of reducing file holes

Active Publication Date: 2019-09-20
INFORMATION2 SOFTWARE SHANGHAI
View PDF14 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, in the prior art, the storage method of the ROWID mapping table makes it impossible to support a large number of mapping entries and very fast query

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
  • Storage/query method and device for ROWID mapping table
  • Storage/query method and device for ROWID mapping table
  • Storage/query method and device for ROWID mapping table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] The implementation of the present invention is described below through specific examples and in conjunction with the accompanying drawings, and those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific examples, and various modifications and changes can be made to the details in this specification based on different viewpoints and applications without departing from the spirit of the present invention.

[0049] figure 1 It is a flowchart of steps of a method for storing / querying a ROWID mapping table in the present invention. Such asfigure 1 Shown, the storage / query method of a kind of ROWID mapping table of the present invention comprises the following steps:

[0050] Step S1, establish a hierarchical ROWID mapping table storage structure according to the ROWID structure for storing the R...

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

The invention discloses an ROWID mapping table storage / query method and device, and the method comprises the steps: S1, building a hierarchical ROWID mapping table storage structure according to an ROWID structure, so as to store an ROWID mapping table of a source / target end; S2, when the ROWID mapping table is stored / queried, positioning a corresponding directory in an ROWID mapping table storage structure according to a data object number OBJD of a source ROWID; S3, positioning a corresponding FNO file according to the relative file number of the source ROWID; S4, obtaining an index region and a data region of the FNO file, and positioning an actual storage block according to the block number BLKNO of the source ROWID; and S5, storing the target ROWID in a storage block according to the sequence of the source SLOT, or querying the corresponding target ROWID in the storage block according to the line number SLOT of the source ROWID.

Description

technical field [0001] The invention relates to the technical field of computer data backup and disaster recovery, in particular to a storage / query method and device for a ROWID mapping table. Background technique [0002] The ORACLE database is a very widely used database. Each row of records stored in the ORACLE database has a unique identifier called ROWID, which can be used to query this record in the database. [0003] ROWID is divided into four parts, a total of 10 bytes (80 binary bits), these four parts are: [0004] 1. Data object number (OBJD): Indicates the number of the database object to which this row belongs. The data object refers to the partition of the table or partition table. Each data object is uniquely assigned a number when the database is created, and this number only. The data object number occupies 32 bits. [0005] 2. Relative file number (FNO): Indicates the number of the file where the line record is located, and the file number occupies 10 di...

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): G06F16/245G06F16/22
CPCG06F16/22G06F16/245
Inventor 王岚李登科杨锐陈勇铨周华
Owner INFORMATION2 SOFTWARE SHANGHAI