Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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 storage solution is still used, each table must be fully scanned for any dimension that does not need to be scanned or any aggregation that is not pre-calculated. As a result, the row storage solution is I / O under OLAP applications. O very inefficient

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

no. 2 example

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

[0070] Such as image 3 As shown, for example, T1 is designated as the base subtable, and subtables 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 are used to store the RID value of T1 to maintain the horizontal relationship of each row. For example, when users can insert data by:

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

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

[0073] INSERT INTO T...

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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com