Data processing equipment and data processing method thereof

A data processing device and data processing technology, applied in the database field, can solve problems such as low I/O efficiency, and achieve the effect of good workload and workload saving

Active Publication Date: 2012-10-17
IBM CORP
View PDF2 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In the case of OLAP, for small databases with simple relationships, row storage schemes can also respond to OLAP application requests for information with reasonable efficiency; Several columns are searched and retrieved to integrate data. If the row

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
  • Data processing equipment and data processing method thereof
  • Data processing equipment and data processing method thereof
  • Data processing equipment and data processing method thereof

Examples

Experimental program
Comparison scheme
Effect test

Example

[0069] In the second embodiment, one of the sub-tables can be arbitrarily designated as the reference sub-table, and the row ID of the relevant row of the reference sub-table is added as the RID value to all other sub-tables as the row ID of the corresponding rows of all other sub-tables . image 3 The second embodiment is additionally shown.

[0070] Such as image 3 As shown, for example, T1 is designated as the reference sub-table, and the sub-tables T2 and T3 implicitly contain a RID column (such as image 3 The reference numeral 301 in represents the RID column pointing to the first row, and 302 represents the RID column pointing to the second row), which is used to store the RID value of T1 to maintain the horizontal relationship of each row. For example, when the user can insert data in the following ways:

[0071] -------------------------------------------------- ----------------

[0072] INSERT INTO T VALUES(1,'name','This is a test', 123.90,'Testvalue', NULL);

[0073] IN...

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 data processing equipment and a data processing method thereof, and the data processing equipment and the data processing method are used in a relational database. The data processing method used in the relational database comprises the steps that: at least one table is selected from the relational database; each of the selected at least one table is divided into more than two sub-tables according to columns, wherein at least one of the sub-tables comprises at least two columns; and the sub-tables are written into tables of a corresponding row store database.

Description

technical field [0001] The invention relates to database technology, in particular to a data processing device and a data processing method for a relational database. Background technique [0002] Introduced in the 1970s, the relational database management system (DBMS or "relational model") is known as the basis of existing database management systems, which are based on the knowledge of formal algebra and the associated structural query language ("SQL"). The description query language enables the interaction of data in various tables. [0003] Typically RDBMSs store data according to a relational storage schema in tables, each table being stored as a sequential collection of rows in pages in a data storage mechanism (eg, disk, main memory, or other storage, etc.). Many systems further create indexes as additional data structures to enable fast random access to a particular row or rows. [0004] SQL queries are used in two types of database interactive applications, namel...

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/30592G06F17/30315G06F16/221G06F16/283
Inventor 金毅张皖川李磊王莉莉
Owner IBM CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap