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

Data extraction method and device and data management system

A data management system and data extraction technology, applied in the database field, can solve the problems of complicated operation and error-prone, and achieve the effect of ensuring data extraction, ensuring timeliness and completeness, and reducing the error rate

Inactive Publication Date: 2010-06-30
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the embodiment of the present invention is to provide a data extraction method, aiming to solve the problem that manual intervention is required when the data warehouse extracts data from the sub-account set, the operation is cumbersome and error-prone

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 extraction method and device and data management system
  • Data extraction method and device and data management system
  • Data extraction method and device and data management system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] figure 1 The processing flow of the data extraction method provided by the first embodiment of the present invention is shown, and the details are as follows:

[0034] In step S101, it is detected whether there is basic data in the sub-account set that has not established a mapping relationship with the template account set, if yes, execute step S102, otherwise execute step S103.

[0035] In the embodiment of the present invention, codes and / or names may be used to uniquely identify the basic data in the sub-account set. Of course, other methods can also be used to uniquely identify the basic data in the sub-account set, and no examples will be given here.

[0036] In step S102, according to the configured automatic mapping rules, the mapping relationship between the basic data in the sub-account set that has not established a mapping relationship with the template A / C set and the template A / C set is established.

[0037] In the embodiment of the present invention, th...

Embodiment 2

[0045] When extracting data, it is not necessary to extract all the data in the sub-account set into the data warehouse. Therefore, in order to meet the data extraction needs of different users, figure 2 It shows the implementation process of the data extraction method provided by the second embodiment of the present invention, figure 2 Steps S202, S203, S204 and figure 1 The steps S101, S102, and S103 in the data extraction method shown are the same, and will not be described in detail here. The only difference is that step S201 is also included:

[0046] In step S201, configure and save the basic data information in the sub-account set that needs to establish a mapping relationship with the template A / C set.

[0047] That is, configure which data in the sub-account set needs to establish a mapping relationship with the template A / C set, so that the required basic data can be extracted from the sub-account set according to the mapping relationship. At this time, when dete...

Embodiment 3

[0050] In some application systems, in order to clearly show the inclusion relationship between the basic data in the A / C set, different levels are generally set for the basic data. An example is as follows: Assuming that in an application system, the basic data "subject" includes the basic data "current assets", and the basic data "current assets" includes the basic data "cash" and "bank deposits", then the subject-current assets can be obtained Level, subject-current assets-cash level, subject-current assets-bank storage level, etc.

[0051] In an application system with levels set for basic data, in order to reduce the complexity of basic data that needs to establish a mapping relationship with the template A / C set in configuring sub-account sets, and improve configuration efficiency, image 3 It shows the implementation process of the data extraction method provided by the third embodiment of the present invention, and the steps S302, S303, and S304 in the method are respe...

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 is applied to the field of databases and provides a data extraction method, a data extraction device and a data management system. The data extraction method comprises the following steps: detecting whether basic data which does not establish a mapping relationship with a template account set is present in a sub account set; when detecting that the basic data which does not establish the mapping relationship with the template account set is present in the sub account set, establishing a mapping relationship between the basic data which does not establish the mapping relationship with the template account set and the template account set according to the configured automatic mapping rule; and extracting the basic data in the sub account set according to the mapping relationship. The data extraction method, the data extraction device and the data management system realize automatic data extraction of a database to the sub account set, avoid fussy and repeated manual operation, reduce the error rate and implementing cost, and guarantee timely and complete data extraction simultaneously.

Description

technical field [0001] The invention belongs to the field of databases, and in particular relates to a data extraction method, device and data management system. Background technique [0002] Account set refers to an independent and complete data collection, which includes a complete set of independent and complete system control parameters, user rights, basic files, accounting information, account table inquiries, etc., which is an independent database. A data warehouse is a database entity that enables users to conduct unified query and management of multiple account sets. It is mostly used for decision-making analysis and processing of enterprises or organizations. For example, a group enterprise with multiple subsidiaries can collect the data of all subsidiary account sets. to the data warehouse to facilitate decision makers to query the operating conditions of all subsidiaries. [0003] Usually, the data warehouse will set one of the multiple account sets it contains a...

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 KINGDEE SOFTWARE(CHINA) CO LTD
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