CN1617138A - Data integration and analysis system and method - Google Patents
Data integration and analysis system and method Download PDFInfo
- Publication number
- CN1617138A CN1617138A CN 200310112162 CN200310112162A CN1617138A CN 1617138 A CN1617138 A CN 1617138A CN 200310112162 CN200310112162 CN 200310112162 CN 200310112162 A CN200310112162 A CN 200310112162A CN 1617138 A CN1617138 A CN 1617138A
- Authority
- CN
- China
- Prior art keywords
- data
- conformity
- formats
- mentioned
- module
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The data integrating and analyzing system includes one data integrating server, several son data bases, one total data base, several branch data bases and several user's computers. The data integrating server includes several software function modules for judging whether the received data are in the same format as that the system sets in advance, classifying the data, analyzing the data, creating multidimensional analysis list, etc. By means of the above said operations, the user can obtain much useful data of the corp. or group in less time and labor.
Description
[technical field]
The present invention relates to a kind of data conformity and analytic system and method, particularly relate to a kind of data conformity and analytic system and method for data being carried out multidimensional analysis.
[background technology]
For some major companies especially some transregional companys, the collection of data and processing are very important, thereby that company all needs all the time is a large amount of, timely, data guarantees the promptness and the correctness of decision-making accurately.And the general problem that these companies face to be data disperse storage because of the dispersion on company operation ground.Along with computing machine, networks development, some relatively independent departments of intra-company, subsidiary company and branch office set up own internal network system gradually, speed and accuracy that inside information is handled have been improved, yet for whole company, data still is the isolated island shape and distributes, therefore want from these data isolated islands, to obtain the integration data, then need to spend great amount of manpower and material resources, financial resources, however, be difficult to also guarantee that collected data is timely and effective.
At present, system or the method for utilizing computing machine, network technology to integrate data disclose in some patent documentations to some extent, as No. 554275 patent of Wise property office in Taiwan in bulletin on September 21st, 2003, patent name is " in order to the management devices and the method for managing a remote data base ", this patent has disclosed a data bank management device, comprise three members: a communication module, one logins an interface module and an operation interface module.This management devices is connected with more than one database via a particular network, uses for a user to connect with this more than one database of management via an end device and network, and stores the communications data of above-mentioned database.
Utilize computing machine and network to carry out the technology of data conformity though above-mentioned patent discloses, especially disclose the technology that how remote data base is managed control.Yet, how to integrate for those data that are stored in different system, how the information after the integration is carried out multi dimensional analysis and how is selected the technology of useful data according to user's request, and above-mentioned patent does not disclose.
[summary of the invention]
Fundamental purpose of the present invention is to provide a kind of data conformity and analytic system and method, the data with different form can be transferred to unified data formats and can carry out multidimensional analysis to it.
For achieving the above object, the invention provides a kind of data conformity and analytic system, it includes: a plurality of subdata bases are used to store the data of different functional departments, subsidiary company or branch office; One data conformity server is used for the data with different form is changed into unified data formats, and the data of changing is carried out multidimensional analysis and set up the multidimensional analysis table and the required form of generation user; One total data storehouse is used to store the whole data that receive; And a plurality of divided data storehouse, be used for storing respectively different classes of data.
Wherein the data conformity server includes: a data receiver module is used to receive the data from different functional departments, subsidiary company or branch office; One data formats judge module, whether the data formats that is used to judge reception is consistent with system predefined data formats; One data formats modular converter is used for transferring the data with different form to predefined data formats; One grouping of data module is used for the data through format conversion is classified; One multidimensional analysis module is used for analysis and generates the multidimensional analysis table; One report generation module is used to select user's required information and generates corresponding form; And a form delivery module, be used to transmit form to corresponding subscriber computer.
The present invention also provides a kind of data conformity and analytical approach, and it includes following steps: (a) receive the data from different functional departments, subsidiary company or branch office; (b) whether the data formats that judge to receive is consistent with system predefined data formats; (c) if the data formats unanimity data is classified; (d) analysis of data and generation multidimensional analysis table; (e) select the required data of user and generate corresponding form; Reach and (f) transmit form to associated user's machine.
By data conformity provided by the invention and analytic system and method, not only can integrate each data isolated island of enterprise or group internal, and can carry out multidimensional analysis to data, for the user provide comprehensively, in time, information accurately, saved the Data acquisition, time greatly and reduced the analysis cost.
[description of drawings]
Fig. 1 is the hardware structure figure of data conformity of the present invention and analytic system.
Fig. 2 is the main software functional block diagram of the data conformity server of data conformity of the present invention and analytic system.
Fig. 3 is the functional block diagram of the multidimensional analysis module of data conformity server of the present invention.
Fig. 4 is data conformity of the present invention and analytical approach process flow diagram.
[embodiment]
As shown in Figure 1, be the hardware structure figure of data conformity of the present invention and analytic system.This data conformity and analytic system include a plurality of subdata base 10, one data conformity servers 11, and connect 12, one total data storehouses 13, a plurality of divided data storehouse 14, one networks 15 and a plurality of subscriber computer 16.Wherein subdata base 10 is used for different functional departments, subsidiary company or branch office etc. and stores data separately, and its form of data of storage can be different in subdata Coorg 10.Generally speaking, its form of data that is stored in different ERP (Enterprise Resource Plan, Enterprise Resources Planning) system is generally different, and promptly a kind of ERP system is corresponding to a kind of data formats.Data conformity server 11 includes a plurality of software function modules, is used for transferring different data formats to unified data formats, and above-mentioned data through format conversion is carried out multidimensional analysis and set up the multidimensional analysis table and generate the required form of user etc.Above-mentioned multidimensional analysis is meant to be analyzed from different perspectives to same document.
Described subscriber computer 16 links to each other with data conformity server 11 by network 15.Network 15 can be intranet (Intranet), also can be the communication network of internet (Internet) or other type.Data conformity server 11 links to each other with total data storehouse 13 by connecting 12.Connecting 12 is that a database connects, as the open type data storehouse connect (Open DatabaseConnectivity, ODBC), or the Java database connect (Java Database Connectivity, JDBC).
As shown in Figure 2, be the main software functional block diagram of the data conformity server of data conformity of the present invention and analytic system.This data conformity server 11 includes a data receiver module 21, one data formats judge modules 22, one data formats modular converters 23, one grouping of data module 24, one multidimensional analysis modules, 25, one report generation modules 26 and form delivery modules 27.
Described data receiver module 21 is used to receive the data from department, branch office, subsidiary company, these departments, branch office, subsidiary company promptly comprise domestic, the data of the database that links to each other with data conformity server 11 also comprises overseas, so long as can both be received.Data formats judge module 22 can judge whether the data formats that received is consistent with system predefined data formats according to the predefined data formats of system, as can in advance data formats being set at the Tiptop form, also can be redefined for SAP form or other similar form, adopt the sort of data formats will be according to application system that group or whole company adopted and decide actually.Above-mentioned Tiptop is a kind of ERP system, and its data formats is the Tiptop form; Above-mentioned SAP is a kind of ERP system, and its data formats is the SAP form, by that analogy.
Data formats modular converter 23 is used for transferring the data with different form to predefined data formats, and above-mentioned data is received by data receiver module 21.For example, predefined data formats is the Tiptop form, and data formats modular converter 23 will transfer non-Tiptop data formats to the Tiptop data formats so, and will be through the data storage of format conversion in total data storehouse 13.Grouping of data module 24 can be classified to above-mentioned data through the Material Name of format conversion and the predefined antistop list that is stored in the total data storehouse 13 automatically by contrast, and classification results is stored in respectively in each divided data storehouse 14.As receive the Material Name through conversion of coming and be " cash flow statement ", then grouping of data module 24 can be according to " cash " in the Material Name, " flow " or keywords such as " cash flows " automatically with among the financial database 14A of its minute to the divided data storehouse 14.If system can not find corresponding divided data storehouse by offset information title and antistop list, then grouping of data module 24 automatic its are transferred among other database 14N.
Multidimensional analysis module 25 is used for carrying out analysis according to predefined dimension, and generates the multidimensional analysis table and simultaneously it is stored in corresponding the divided data storehouse 14 and total data storehouse 13, and the module map of multidimensional analysis module 25 is seen Fig. 3.Report generation module 26 can be according to the Query Information of user by 16 inputs of arbitrary subscriber computer selection data and generate corresponding user's request form from each divided data storehouse 14.Information as user input is " A of branch office and the B2002 of the subsidiary company operation revenue first season ", and report generation module so 26 can be according to keyword " A of branch office ", " B of subsidiary company ", " first season in 2002 ", " operation revenue " etc. selection data and generate the A of branch office and the statement of operating revenue first season in 2002 of the B of subsidiary company from total data storehouse 13 and each divided data storehouse 14 automatically.The form that form delivery module 27 is used for generating is sent to subscriber computer 16 by network 15.
As shown in Figure 3, be the functional block diagram of the multidimensional analysis module of data conformity server of the present invention.Multidimensional analysis module 25 provides the function of same document being carried out multi-angular analysis.Dimension set up scale because of company, investment framework, institutional framework, produce market feature, managerial personnel's preference etc. different.For example can analyze from dimensions such as time, stock, product, clients, and each dimension can be further divided into each sub-dimension, can further be decomposed into year, season, the moon, week etc. again as time dimension a part of data or whole data; Stock's dimension can further be decomposed into sub-dimensions such as stock classification, stock address, tank farm stock again; The product dimension can further be decomposed into sub-dimensions such as product category, manufacturer, main selling market again; Client's dimension comprises sub-dimensions such as customer name, customer address, client's classification.
As shown in Figure 4, be data conformity of the present invention and analytical approach process flow diagram.At first, 21 receptions of data receiver module are from the data (step S401) of all departments, branch office or subsidiary company.Data formats judge module 23 can be judged data formats that institute receives and system predefined data formats whether consistent (step S402) according to the predefined data formats of system.If the data formats and the predefined data formats that receive are inconsistent, data formats modular converter 23 can be converted to above-mentioned data formats the predefined data formats of system (step S403).
If the data formats that receives is consistent with predefined data formats or data formats has been changed and finished, grouping of data module 24 can be classified above-mentioned data through predefined antistop list in the Material Name of format conversion and the total data storehouse 13 automatically by contrast, and sorting result is stored in respectively in each divided data storehouse 14, as, the data storage relevant with finance is in financial database 14A, the data storage relevant with the stock in inventory database 14B, (step S404) by that analogy.Multidimensional analysis module 25 is analyzed data according to predefined dimension, generates the multidimensional analysis table and also is stored in corresponding divided data storehouse 14 and the total data storehouse 13 (step S405).Report generation module 26 can be according to choosing user's required information and generate corresponding form (step S406) in the multidimensional analysis table of query context from each divided data storehouse 14 of user by arbitrary subscriber computer 16 inputs.Form delivery module 27 is sent to corresponding subscriber computer 16 (step S407) with above-mentioned form by network 15.
Claims (7)
1. a data conformity and analytic system, this system can change into the data with different form unified data formats, to carrying out multidimensional analysis through the data of format conversion and setting up the multidimensional analysis table and generate the required form of user, it is characterized in that, comprising:
A plurality of subdata bases are used for storing respectively the data of functional department, branch office, subsidiary company;
One data conformity server comprises:
One data receiver module is used to receive the data from different functional departments, branch office, subsidiary company;
One data formats judge module is used to judge whether the predefined data formats of above-mentioned data formats and system is consistent;
One data formats modular converter is used for transferring the data with different form to unified data formats;
One grouping of data module is used for above-mentioned data is classified;
One multidimensional analysis module is used to analyze above-mentioned classified data and generates many analytical tables; And
One report generation module is used to select the required data of user and generates corresponding report;
One total data storehouse is used to store the data that above-mentioned data receiver module receives; And a plurality of divided data storehouse, be used for storing respectively an above-mentioned classified class data.
2. as claim 1 described data conformity and analytic system, it is characterized in that, also include a plurality of subscriber computers and be used to provide user interface, be convenient to the user carry out browse, inquiry job.
3. as claim 1 described data conformity and analytic system, it is characterized in that wherein the total data storehouse also is used to store an antistop list, the grouping of data module is to classify according to above-mentioned antistop list.
4. as claim 1 described data conformity and analytic system, it is characterized in that wherein the data conformity server comprises that also a form delivery module is used to transmit the form that generates according to user's request.
5. a data conformity and analytical approach is characterized in that, include following steps:
Reception is from the data of different functional departments, branch office, subsidiary company;
Judge whether the predefined data formats of above-mentioned data formats and system is consistent;
If data formats is inconsistent, then transfer above-mentioned data formats to predefined data formats;
With above-mentioned grouping of data;
Analyze classified data and generate the multidimensional analysis table; And
Select the required data of user and generate corresponding form.
6. as claim 5 described data conformity and analytical approachs, it is characterized in that, also comprise and transmit the step of form to associated user's machine.
7. as claim 5 described data conformity and analytical approachs, it is characterized in that wherein the step that above-mentioned data is classified is to classify according to the antistop list that is stored in the total data storehouse.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2003101121626A CN100370458C (en) | 2003-11-12 | 2003-11-12 | Data integration and analysis system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB2003101121626A CN100370458C (en) | 2003-11-12 | 2003-11-12 | Data integration and analysis system and method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1617138A true CN1617138A (en) | 2005-05-18 |
CN100370458C CN100370458C (en) | 2008-02-20 |
Family
ID=34759615
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2003101121626A Expired - Fee Related CN100370458C (en) | 2003-11-12 | 2003-11-12 | Data integration and analysis system and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN100370458C (en) |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101141754B (en) * | 2006-09-05 | 2010-05-12 | 中兴通讯股份有限公司 | Value-added service analysis system and method thereof |
CN101271475B (en) * | 2008-04-02 | 2011-05-18 | 北京邮电大学 | Commercial intelligent system |
CN102222120A (en) * | 2011-06-16 | 2011-10-19 | 河南新创元信息网络有限公司 | Method and system for quickly collecting binary information of dispersion demand |
CN102236667A (en) * | 2010-04-30 | 2011-11-09 | 饶怀圣 | Manpower evaluation query platform |
CN102262640A (en) * | 2010-05-31 | 2011-11-30 | 中国移动通信集团贵州有限公司 | Method and device for full-text retrieval of document database |
CN101197876B (en) * | 2006-12-06 | 2012-02-29 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
CN102682370A (en) * | 2012-05-22 | 2012-09-19 | 苏州奇可思信息科技有限公司 | Enterprise income viewing system |
CN102982084A (en) * | 2011-11-01 | 2013-03-20 | 微软公司 | Multi-dimentional data report |
CN103955483A (en) * | 2014-04-08 | 2014-07-30 | 方芳 | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain |
CN104298779A (en) * | 2014-11-04 | 2015-01-21 | 中国银行股份有限公司 | Processing method and system for massive data processing |
CN105243480A (en) * | 2015-09-28 | 2016-01-13 | 国网浙江宁海县供电公司 | Data information management method, server and system |
CN108876581A (en) * | 2018-07-19 | 2018-11-23 | 武汉杰威鑫创软件技术有限公司 | A kind of financial management system |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2000315239A (en) * | 1999-04-30 | 2000-11-14 | Naoyuki Miyayama | System for receiving merchandise order, recovering cost and distributing merchandise dispatch information |
JP2952771B1 (en) * | 1998-05-15 | 1999-09-27 | 直之 宮山 | Customer information collection and distribution system |
CN1245935A (en) * | 1999-06-21 | 2000-03-01 | 李虹 | Full-automatic recognizing, logging-in and retrieval system of calling cards |
CN1403982A (en) * | 2001-09-12 | 2003-03-19 | 英业达股份有限公司 | Multidimensional production management report servo system and method |
-
2003
- 2003-11-12 CN CNB2003101121626A patent/CN100370458C/en not_active Expired - Fee Related
Cited By (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101141754B (en) * | 2006-09-05 | 2010-05-12 | 中兴通讯股份有限公司 | Value-added service analysis system and method thereof |
CN101197876B (en) * | 2006-12-06 | 2012-02-29 | 中兴通讯股份有限公司 | Method and system for multi-dimensional analysis of message service data |
CN101271475B (en) * | 2008-04-02 | 2011-05-18 | 北京邮电大学 | Commercial intelligent system |
CN102236667A (en) * | 2010-04-30 | 2011-11-09 | 饶怀圣 | Manpower evaluation query platform |
CN102262640A (en) * | 2010-05-31 | 2011-11-30 | 中国移动通信集团贵州有限公司 | Method and device for full-text retrieval of document database |
CN102222120A (en) * | 2011-06-16 | 2011-10-19 | 河南新创元信息网络有限公司 | Method and system for quickly collecting binary information of dispersion demand |
CN102982084B (en) * | 2011-11-01 | 2016-02-24 | 微软技术许可有限责任公司 | Multi-dimentional data report |
CN102982084A (en) * | 2011-11-01 | 2013-03-20 | 微软公司 | Multi-dimentional data report |
CN102682370A (en) * | 2012-05-22 | 2012-09-19 | 苏州奇可思信息科技有限公司 | Enterprise income viewing system |
CN103955483A (en) * | 2014-04-08 | 2014-07-30 | 方芳 | Multi-dimensional analysis method of data in RFID (Radio Frequency Identification) supply chain |
CN104298779A (en) * | 2014-11-04 | 2015-01-21 | 中国银行股份有限公司 | Processing method and system for massive data processing |
CN105243480A (en) * | 2015-09-28 | 2016-01-13 | 国网浙江宁海县供电公司 | Data information management method, server and system |
CN108876581A (en) * | 2018-07-19 | 2018-11-23 | 武汉杰威鑫创软件技术有限公司 | A kind of financial management system |
Also Published As
Publication number | Publication date |
---|---|
CN100370458C (en) | 2008-02-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6691101B2 (en) | Database system providing optimization of group by operator over a union all | |
US7266775B2 (en) | Method for retrieving information from an information repository | |
US6934687B1 (en) | Computer architecture and method for supporting and analyzing electronic commerce over the world wide web for commerce service providers and/or internet service providers | |
US20060004615A1 (en) | System and method for filtering exceptions generated by forecasting and replenishment engine | |
US20070038641A1 (en) | Systems and methods for automated application updating | |
US20020169777A1 (en) | Database architecture and method | |
CN112364223B (en) | Digital archive system | |
EP1687744A1 (en) | Systems and methods for retrieving data | |
CN100370458C (en) | Data integration and analysis system and method | |
CN1534526A (en) | EDI apply custom management declare system and method | |
Baumgartner et al. | Web data extraction for business intelligence: the lixto approach | |
CN100498780C (en) | Data inquire system and method | |
CN1459747A (en) | Patent information excavating and analyzing system and method | |
CN1661606A (en) | Product pricing system and method | |
US10922328B2 (en) | Method and system for implementing an on-demand data warehouse | |
CN100412858C (en) | Report generating system and method | |
CN100377140C (en) | Global stock inquiry system and method | |
US20040249728A1 (en) | System and method for global inventory querying | |
CN115689463A (en) | Enterprise standing book database management system in rare earth industry | |
CN113886465A (en) | Big data analysis platform for automobile logistics | |
CN102056349A (en) | Data acquisition system and method and application server | |
US20070226085A1 (en) | System and method for automated mapping of data in a multi-valued data structure | |
CN1641665A (en) | Multi-strong-point inventory analysing system and method | |
CN1632799A (en) | Hyperlink automatic redirecting and management system and method | |
US20070214139A1 (en) | System and method for mapping data in a multi-valued data structure |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080220 Termination date: 20141112 |
|
EXPY | Termination of patent right or utility model |