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

Method for establishing dynamic virtual data base in analyzing and processing system

A technology for analyzing and processing virtual data, applied in the field of establishing dynamic virtual data warehouse, it can solve the problems of limited information changes from multiple perspectives, huge system, and a large amount of equipment investment, so as to achieve low operating environment and maintenance costs, low investment in system equipment, and avoidance of The effect of constant encroachment

Inactive Publication Date: 2009-10-28
CHANGSHA POWERISE TINMO ACCOUNTING SOFTWARE
View PDF0 Cites 31 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This not only greatly reduces the efficiency of data warehouse usage, but also increases maintenance costs
At the same time, it also limits the multi-view changes of decision-making applications to information, and it is difficult to realize real-time online analysis of information, which restricts the efficiency of decision-making applications. It also requires a large amount of equipment investment, making the system larger, and the maintenance costs also increase. Efficiency lower

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] Embodiment 1: Establish a dynamic virtual data warehouse in multiple transactional database collections:

[0028] (1) Define metadata: collect business requirement data from multiple transactional database collections, and divide the collected data into technical metadata and commercial metadata for definition. The specific way to define the above data is as follows:

[0029] ①. Define technical metadata: define objects and data structure information in multiple transactional databases, descriptions of data conversion, mapping from source data to target data, possible calculation methods, user access rights, and information release history as technical metadata. And provide these data defined as technical metadata to the designers and managers of dynamic virtual data warehouses for development and daily management;

[0030] ②. Define business metadata: define the data described from the perspective of enterprise business in multiple transactional databases, that is, d...

Embodiment 2

[0040] Embodiment 2: Establish a dynamic virtual data warehouse in a single small database:

[0041] (1) Define metadata: collect business requirement data from a single transactional database collection, and divide the collected data into two types: technical metadata and business metadata for definition. The specific way to define the above data is as follows:

[0042] ①. Define technical metadata: define objects and data structure information in a single transactional database, description of data conversion, mapping from source data to destination data, possible calculation methods, user access rights, and information release history as technical metadata data. And provide these data defined as technical metadata to the designers and managers of dynamic virtual data warehouses for development and daily management;

[0043] ②. Define business metadata: define the data described from the perspective of enterprise business in a single transactional database, that is, define...

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 method for establishing a dynamic virtual data base in an analyzing and processing system, which comprises the following steps: (1) defining metadata; (2) constructing a dimension indexing table; (3) constructing data marts; (4) instantiating the data marts; (5) constructing and instantiating a plurality of the data marts; and (6) dynamically modeling and instantiating the virtual data base. The method collects service required data from an enterprise database, defines fields with analysis significance into the metadata, carries out dynamic modeling, dynamic extraction and conversion processing on the corresponding metadata, constructs a plurality of the data marts conforming to an analysis subject and instantiates the virtual data base so as to realize the zero storage of the data in the virtual data base, overcome contradictions between system equipment resources and continuously increased information quantities and meet the requirements of high efficiency and data real-time for a management decision database of a decider.

Description

technical field [0001] The invention relates to a method for establishing a dynamic virtual data warehouse in an analysis and processing system. Background technique [0002] Today, with the rapid development of the global economy, whether it is a multinational company, enterprise or government agency, a large amount of data needs to be processed every day. These data are often scattered in transactional databases under various application systems, such as production, sales, finance, etc. data. Decision makers often need to find the data they need from these large amounts of data for analysis in order to make correct and timely decisions. But in the face of such a large amount of data, relying on the traditional data warehouse implementation method cannot achieve the functions of dynamic modeling of data, real-time dynamic extraction of data and real-time online analysis of information. [0003] As we all know, through the use of ERP (the abbreviation of the English full n...

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): G06F17/30
Inventor 马翠萍
Owner CHANGSHA POWERISE TINMO ACCOUNTING SOFTWARE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

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