Data compilation method in multiple databases

A data sorting and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem of paying a lot of time and cost, and achieve the effect of improving development efficiency

Inactive Publication Date: 2009-07-22
INSPUR COMMON SOFTWARE
View PDF0 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, enterprise data will involve many databases, and it takes a lot of time and cost to organize and collect the data in the corresponding databases.

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

[0125] ■Invoke this technology in the report system to make reports across database systems.

[0126] The calling code of n_cst_jxc_pub_cx.of_pre_sql() is as follows:

[0127] ...

[0128] / / If you are performing cross-database data collection, then perform pre-processing and return.

[0129] if left(upper(trim(ls_sql)), 2)='P:'then

[0130] n_cst_wd_multi_database lnv_mul

[0131] lnv_mul=create n_cst_wd_multi_database

[0132] get_token(ls_sql, ':')

[0133] li_ret = lnv_mul.of_exec_Pre(ls_sql, is_sjlm, is_value)

[0134] destroy lnv_mul

[0135] return li_ret

[0136] end if

[0137] ....

[0138] ■Call this technique in the timing service n_cst_msg_server service object:

[0139] ■Instance variable: n_cst_wd_multi_database inv_mul / / used for data collection of multiple account sets

[0140] deal with

[0141] ■Calling script part in method of_gen_message():

[0142]  …

[0143] case'PR' / / When it is pre-processing, the method of calling pre...

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 provides a method of arranging and collecting data from a plurality of databases. In the method, script description is used, isomorphic data arrangement is unitized, and heterogeneous data processing is specialized; a plurality of databases are numbered, rules are set in the script, own techniques of the databases are utilized simultaneously to complete the integrated processing of the data, and the real-time collection or timing collection of the data is finished through a real-time calling interface or through the binding with the timing event processing; the invention works during the report development of multi-database or the data intensive collection, and when in use, the method carries out the task description by a simple label script and supports the real-time or timing collection of the data from a plurality of databases. The method of arranging and collecting the data from a plurality of databases has the advantages of providing API finished data results for use, realizing the data template extraction of isomorphic databases, improving the developing efficiency and collecting the isomorphic and heterogeneous databases according to corresponding rules.

Description

technical field [0001] The invention relates to a computer application technology, which is used by professional technicians and can realize the technology of arranging and collecting the data of multiple databases, and provides basic technical support for the development of reports and data collection. Background technique [0002] At present, enterprise data involves many databases, and it takes a lot of time and cost to organize and collect the data in the corresponding databases. This technology establishes a standard data sorting process, and at the same time distinguishes homogeneous or heterogeneous data through data collection, and templates the data collection of homogeneous databases, thereby reducing development costs and improving development quality. Contents of the invention [0003] The purpose of the present invention is to provide a method for sorting and collecting data from multiple databases. [0004] The purpose of the present invention is achieved in...

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 INSPUR COMMON SOFTWARE
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