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

Data storage method and device, computer equipment and storage medium

A data storage and data technology, applied in the field of data warehouse, can solve the cumbersome development of zippers and other problems, and achieve the effect of simplifying development complexity and reducing storage resources

Active Publication Date: 2019-11-15
NANJING SUNING SOFTWARE TECH CO LTD
View PDF8 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The second method is the slowly changing dimension, which adds an effective start time and end time to the data. When the data changes, a data zipper is added for storage. The data does not change, does not add or update the data, however, using SQL (Structured Query Language , Structured Query Language) to generate zipper development is more cumbersome

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 storage method and device, computer equipment and storage medium
  • Data storage method and device, computer equipment and storage medium
  • Data storage method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the purpose, technical solution and advantages of the present application clearer, the present application will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application.

[0055]It can be understood that the terms "first", "second" and the like used in this application may be used to describe various elements herein, but these elements are not limited by these terms. These terms are only used to distinguish one element from another element. For example, a first client could be termed a second client, and, similarly, a second client could be termed a first client, without departing from the scope of the present application. Both the first client and the second client are clients, but they are not the same client. The term "or / and" describes...

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 relates to a data storage method and device, computer equipment and a storage medium. The method comprises the steps of generating a date data item relationship list of each service identifier according to historical data, wherein the date data item relationship list records a corresponding relationship between data dates of data and data item identifiers; generating a data item content list of each service identifier according to the historical data, wherein the data item content list records a corresponding relationship between the data item identifier and the data content; andgenerating a data limit storage table, wherein the data limit storage table comprises each service identifier, and a date data item relationship list and a data item content list corresponding to each service identifier. The development difficulty can be reduced while storage resources are reduced.

Description

technical field [0001] The present application relates to the technical field of data warehouses, in particular to a data storage method, device, computer equipment and storage medium. Background technique [0002] A data warehouse is a subject-oriented, integrated, relatively stable data collection that reflects historical changes. In the data warehouse, there are some business data changes that account for a small proportion of the overall volume (such as members, organizations, employees, etc.), and each use in the data analysis process requires a full traversal of the current date or the full data status of the specified date. Usually, the data warehouse The methods used are periodic snapshot tables or slow-changing dimension solutions, but these two methods have the following disadvantages: [0003] The first method is a periodic snapshot table, which stores a copy of the current full amount of data every cycle; the implementation is simple, and the small amount of dat...

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): G06F16/28
CPCG06F16/284
Inventor 彭虎傅尚强刘洋孙迁
Owner NANJING SUNING SOFTWARE TECH CO LTD
Features
  • Generate Ideas
  • 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