A method and device for implementing data update and snapshot in olap database

A data update and database technology, applied in the database field, can solve problems such as not obtaining snapshots

Active Publication Date: 2020-09-18
BEIJING GRIDSUM TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In addition, in many business scenarios, there is such a requirement that users want to get the state of a certain table in the database at a certain point in time before, that is, a snapshot. The purpose may be to restore the data of the table to that point in time, or it may be In order to understand the information of the previous version or to do some version comparison, however, there is currently no snapshot function in the OLAP database

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
  • A method and device for implementing data update and snapshot in olap database
  • A method and device for implementing data update and snapshot in olap database
  • A method and device for implementing data update and snapshot in olap database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the above objects, features and advantages of the present invention more comprehensible, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0055] The main purpose of the present invention is to allow users to perform single-row or multi-row modification and update operations to table data on an OLAP database based on Hadoop (a distributed system infrastructure) like operating a traditional stand-alone database, so as to overcome the OLAP database The biggest defect; In addition, the purpose of the present invention is also to make the user can obtain the snapshot of any table at any point in time in a very simple way when using the OLAP database.

[0056] see figure 1 As shown, the embodiment of the method for implementing data update in the OLAP database provided in the embodiment of the present invention may include the following steps...

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 a method and a device of realizing data updating at an OLAP (Online Analytical Processing) database. The method includes: adding a row identifier column and a time stamp columnin a data table, wherein the row identifier column is used for recording a row identifier of each row in the data table, and the time stamp column is used for recording modification time of each rowin the data table; determining a to-be-modified row in the data table when a modification instruction is received; modifying the to-be-modified row according to the modification instruction, and writing current modification time into the time stamp column of the to-be-modified row to generate a first newly-added row; inserting the first newly-added row into the data table; when a data reading instruction is received, obtaining at least one result row in the data table according to the data reading instruction, acquiring a row, which corresponds to each row identifier and has most recent modification time, in the at least one result row to form a result table, and returning, to a user, parts in the result table after removing the row identifier column and the time stamp column. The invention also discloses a method and a device of realizing a data snapshot at the OLAP database.

Description

technical field [0001] The invention relates to the database field, in particular to a method and device for realizing data update and snapshot in an OLAP database. Background technique [0002] In traditional software development, stand-alone databases (such as Oracle databases, SQL Server databases, etc.) play an extremely critical role in data storage and data computing, but traditional stand-alone databases cannot achieve horizontal expansion in storage and computing Add hardware to store and calculate more data, so it is stretched when dealing with massive data. Therefore, a distributed relational data warehouse has emerged. OLAP (Online Analytical Processing, Online Analytical Processing) database is a mature solution for distributed relational data warehouses. It is good at modification, that is, it only supports data insertion and reading, but does not support data modification and update. In many scenarios, users hope that they can modify single-row or multi-row da...

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/28
CPCG06F16/283
Inventor 廖松博
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap