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: 2015-02-04
INT BUSINESS MASCH CORP
View PDF2 Cites 0 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

Embodiments of the invention relate to improved input / output efficiency for online analysis processing in a relational database. An aspect of the invention includes selecting a table from a relational database. The table is split by column into sub-tables, with at least one of the sub-tables including at least two columns. Each sub-table is written into a corresponding table of a row-based storage 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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30592G06F17/30315G06F16/221G06F16/283
Inventor 金毅张皖川李磊王莉莉
Owner INT BUSINESS MASCH 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