Data storage realization method and data warehouse

An implementation method and data storage technology, applied in the database field, can solve the problems of consuming data warehouse 10 equipment resources, wasting data warehouse 10 equipment resources, etc., and achieve the effect of saving resources

Inactive Publication Date: 2011-05-04
CSMC TECH FAB1
View PDF2 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] If Class I ODS is to be implemented, the data warehouse 10 will run a data extraction tool almost every 1 to 2 seconds to extract DB data from DB databases such as DB11 and DB12, which will consume a lot of equipment resources of the data warehouse 10
[0010] For Type II and Type III ODSs, although the above scheme of regularly extracting DB data can be implemented, since the data warehouse 10 will perform data extraction at intervals regardless of whether it is needed, there is also a problem of wasting the resources of the equipment belonging to the data warehouse 10

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 realization method and data warehouse
  • Data storage realization method and data warehouse
  • Data storage realization method and data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0036] Embodiment 1, it is judged whether the business system data is updated according to the time when the business system data is extracted last time.

[0037] image 3 It is a flowchart of a method for realizing ODS in the first embodiment of the present invention, Figure 4 It is a schematic diagram of the structure of the data system of the embodiment of the present invention. In combination with this figure, an implementation process of the above scheme is as follows:

[0038] Step a1, when a user accesses a data object in the data warehouse 20, the data warehouse 20 obtains the latest extraction time of the business system data corresponding to the data object; since the data warehouse 20 generally stores operation records, the extraction time can be Obtained by querying its own operation records, and other acquisition methods can also be used;

[0039] Step a2, judging whether the extraction time is within a predetermined range, if yes, go to step a3, otherwise go t...

Embodiment 2

[0052] Embodiment 2: It is judged whether the business system data is updated according to whether the business system data is actually updated.

[0053] Figure 5 It is a flow chart of the method for realizing ODS in the second embodiment of the present invention, in conjunction with this figure and Figure 4 , another implementation process to realize ODS is:

[0054] Step b1, when the user accesses the data object in the data warehouse 20, the data warehouse 20 inquires whether it has received the business system data update instruction information sent by the business system 21, if received, go to step b2, otherwise go to step b4 The update instruction message can be sent to the data warehouse 20 actively by the business system 21 after updating the data, or the query information sent by the data warehouse 20 to the business system 21 for querying whether the business data is updated, and the business system 21 obtains the query After the information, if updated, then se...

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 data storage realization method and a data warehouse, which can lower resource consumption when an ODS (Operational Data Store) is realized. The method comprises the following steps of: judging whether service system data corresponding to a data object is updated or not when a user accesses the data object; extracting the updated service system data to serve as operational data under the condition of updating; and updating the data object accessed by the user via the operational data and enabling the updated data object to be available for the user access. With the invention, on the one hand, the data object accessed by the user can be ensured to be the updated data, on the other hand, the resource waste can be avoided when the data is extracted at regular timie, and particularly the problem of numerous resource waste in real-time situation can be avoided, thereby saving resources on the condition that the realization of the ODS function is ensured, and particularly saving numerous resources under the condition that the I-type ODS is realized.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data storage (ODS, Operational Data Store) implementation method and a data warehouse. Background technique [0002] figure 1 It is a schematic diagram of the structure of the existing data system. The data system includes several business system databases (DB, Data Bases) and data warehouses 10. In the figure, DB11 and DB12 are shown as a schematic diagram of several DBs. The DBs generally store business department data , such as financial data, etc.; the data warehouse 10 is used to uniformly store the data extracted from DB11 and DB12, so that users can use these data comprehensively. [0003] In order to maintain the time correspondence between the data in the data warehouse 10 and the data in the DB, the industry usually adopts an operation data storage solution in the data warehouse 10 at present, that is, realizes the ODS function. DB data update. [0004] According to the sp...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 张楠
Owner CSMC TECH FAB1
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