Supercharge Your Innovation With Domain-Expert AI Agents!

Database operations on columnar databases

A database and data technology, applied in the field of database operation, can solve the problems of column table shortcomings, multi-storage, consumption, etc.

Active Publication Date: 2019-06-11
SAP AG
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Although columnar tables have advantages, columnar tables can have disadvantages in terms of desired improvement
For example, some database operations may create and consume more storage than expected and cause additional processing load

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
  • Database operations on columnar databases
  • Database operations on columnar databases
  • Database operations on columnar databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0022] figure 1 is an exemplary block diagram of database system 100 . Database system 100 includes at least one memory 102 . Memory 102 may be a non-volatile memory or other type of memory configured to store large amounts of data. Memory 102 may include non-volatile memory such as, for example, flash memory. Memory 102 may also include volatile memory such as, for example, random access memory (RAM). Although memory 102 is illustrated as at least one memory, memory 102 may be composed of multiple memory modules or an array of memory modules. Memory 102 may include storage resources to provide storage pools that may be divided and allocated to support various systems residing in memory 102 .

[0023] Data stored in memory 102 may be organized into database 104 . Database 104 may be referred to as an in-memory database. As discussed above, memory 102 may include storage pools that may be used and allocated as needed to support database 104 . Additionally, as discussed a...

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 computer system includes at least one processor and at least one memory operably coupled to the at least one processor. Storage includes storage pools and databases that are partitioned into multiple fragments. Each of the plurality of fragments is allocated a storage block from the storage pool, and the fragments store compressed data in a columnar table format. A database operation is applied to compressed data in at least one of the plurality of fragments in a compressed format.

Description

technical field [0001] This specification relates to systems and techniques for performing database operations on databases organized in columnar tables. Background technique [0002] Databases can be organized in different formats. For example, a database that supports two-dimensional tables may be organized in a rowtable format, or it may be organized in a list (also known as a column-like table) format. For example, in a database designed in row table format, data is stored row by row. In a database designed in list format, the storage order is column by column. A database formatted as a list may have advantages over a database formatted as a row table. For example, columnar tables can provide advantages when the database contains a large amount of data and the data needs to be aggregated and analyzed. Columnar tables can also provide other advantages over other types of tables. [0003] Although columnar tables have advantages, columnar tables can have disadvantages...

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): G06F16/22G06F16/215
CPCG06F16/221
Inventor 黎文宪董玢魏正隆陈颖宇申永元
Owner SAP AG
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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