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

Hybrid database table stored as both row and column store

A database and storage medium technology, applied in the storage field of database information

Active Publication Date: 2013-06-26
SAP AG
View PDF7 Cites 27 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] Despite the various advantages of various database table types, traditionally tables can only be stored in rows or columns at any point in the business life cycle

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
  • Hybrid database table stored as both row and column store
  • Hybrid database table stored as both row and column store
  • Hybrid database table stored as both row and column store

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0042] Described here are techniques that provide a hybrid database table stored as both a row store and a column store. Certain techniques, used alone or in combination, improve hybrid table performance by limiting access to and / or limiting the size of processing-intensive column store data.

[0043] In the following description, for purposes of explanation, embodiments and specific details are set forth in order to provide a thorough understanding of various embodiments. However, it will be apparent to those skilled in the art that the invention defined by the claims may include some or all of the features of these embodiments alone or in combination with other features described below, and may further include the features described herein and Modifications and Equivalents of the Concepts.

[0044] figure 1 A simplified schematic diagram of a mixing table according to an embodiment is shown. The hybrid table 100 includes a first data store 102 that includes data stored ac...

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

A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and / or the size of, the processing-intensive column store data. For example, during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and / or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon consideration such as frequency of access, or underlying business logic. In another technique, querying of a hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.

Description

technical field [0001] The present invention relates to the storage of data in databases, and more particularly to the storage of database information in a hybrid tabular format. Background technique [0002] Unless otherwise indicated, the approaches described in this section are not prior art to the claims in this application and are not admitted to be prior art by incorporation in this section. [0003] A database is an electronic filing system that stores data in a structured manner. The primary storage structure in a database is the table. A database can contain multiple tables, and each table can hold a specific type of information. Database tables store and organize data in horizontal rows and vertical columns. A row usually corresponds to a real-world entity or relationship, which represents a single record in a table. Columns can indicate specific attributes of these entities or relationships, such as "name", "address", or "telephone number". For example, Compa...

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
CPCG06F16/22G06F16/2365G06F16/278G06F16/245
Inventor Y.永C.程J.李C.B.宋Y.S.孔S.Y.且
Owner SAP AG
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