Supercharge Your Innovation With Domain-Expert AI Agents!

Method and mechanism of storing and accessing data and improving performance of database query language statements

A technology for storing data and query language, applied in the field of database management systems, and can solve problems such as complex decompression operations

Inactive Publication Date: 2005-09-07
ORACLE INT CORP
View PDF0 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

So, for simple read access, multiple places in the database need to be accessed, and possibly complex decompression operations

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
  • Method and mechanism of storing and accessing data and improving performance of database query language statements
  • Method and mechanism of storing and accessing data and improving performance of database query language statements
  • Method and mechanism of storing and accessing data and improving performance of database query language statements

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The present invention discloses storing and retrieving data from a data storage system. Rather than compressing data at the file level or at some other granularity, which could result in storage inefficiencies and / or increase the execution time of database query language statements, by reducing or removing duplicate values ​​in data blocks or other storage units to achieve data compression. The invention also discloses improving the performance of the database query language statement. Data duplication information can be used to improve the performance of database query language statements by saving information describing data duplication within data blocks that previously had to be recalculated each time a data block was accessed.

[0035] Database query language statements are often used to create, find, access, retrieve, modify, organize, maintain, manipulate, define, control, add, and / or delete data and structures in a database. A popular database query language i...

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 method and mechanism is disclosed for implementing storage and retrieval of data in a computing system. Data compression is performed on stored data by reducing or eliminating duplicated values in a database block. Rather than writing the duplicated data values to the data storage unit, the on-disk data is configured to reference a copy of each duplicated data value stored in a symbol table. A method and mechanism of improving performance of database query language statements is also disclosed. Information describing data duplication within a data block is maintained. In one embodiment, the data duplication information is used to reduce number of predicate evaluations on data in the data block when a database query language statement is received against the data in the data block. In another embodiment, the data duplication information is used to reduce amount of data accessed by a database query language statement.

Description

technical field [0001] The present invention relates to the field of database management systems. More specifically, the present invention relates to methods and mechanisms for storing and retrieving data in computer systems, and improving the performance of database query language statements. Background technique [0002] As many modern businesses and organizations need to access ever greater volumes of information, the amount of data that must be stored in databases and computer systems increases. A significant portion of the cost of storing large amounts of information is related to the cost of purchasing and maintaining data storage systems. Given such costs, it is recommended that appropriate methods be employed to reduce the amount of space required to store a given amount of data. [0003] Data compression is a technique used in many modern computer systems to reduce the storage cost of data. One common way to achieve compression is to compress data at the granular...

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): G06F12/00G06F17/30
CPCG06F17/30312G06F16/22
Inventor 德米特里·M·波塔波夫塞廷·奥兹布藤
Owner ORACLE INT CORP
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