CN102446172A - Data service processing method and device adopting same - Google Patents

Data service processing method and device adopting same Download PDF

Info

Publication number
CN102446172A
CN102446172A CN2010102999905A CN201010299990A CN102446172A CN 102446172 A CN102446172 A CN 102446172A CN 2010102999905 A CN2010102999905 A CN 2010102999905A CN 201010299990 A CN201010299990 A CN 201010299990A CN 102446172 A CN102446172 A CN 102446172A
Authority
CN
China
Prior art keywords
data
dynamic
dimension
statistical form
row
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
Application number
CN2010102999905A
Other languages
Chinese (zh)
Other versions
CN102446172B (en
Inventor
王云
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Kingdee Software China Co Ltd
Original Assignee
Kingdee Software China Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Kingdee Software China Co Ltd filed Critical Kingdee Software China Co Ltd
Priority to CN201010299990.5A priority Critical patent/CN102446172B/en
Publication of CN102446172A publication Critical patent/CN102446172A/en
Application granted granted Critical
Publication of CN102446172B publication Critical patent/CN102446172B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention relates to a data service processing method and a device adopting the same. The method comprises the following steps: whether the attribute of a statistical chart is a static data sheet or a dynamic data sheet is judged; if the statistical chart is a dynamic data sheet, line dimensionality and row dimensionality for dynamic modification are generated in the statistical chart; when data is added into or acquired from the line dimensionality and the row dimensionality, the line dimensionality and the row dimensionality in the statistical chart are combined to form a dynamic item formula; and the data is processed according to the dynamic item formula. By adopting the method and the device both provided by the invention, the complexity during data processing is reduced, the data processing quantity is reduced, the operation performance of a computer and other systems is promoted, the data processing is accurate, the data processing speed is accelerated, and dynamic modification and expansion of data services can be realized.

Description

The disposal route of data service and device
Technical field
The present invention relates to field of computer technology, specifically is to utilize computing machine to carry out the method that data service is handled.
Background technology
Be employed in the permission row of dynamic area section or the dynamic data table of row change and work out all kinds of statistical report forms of group in ERP system.Because this table is on the basis of the project data preserving type that adopts two-dimentional fixed table, to increase to preserve the tables of data that the dynamic area is enumerated; And each project formula has been preserved one group of similar data; Cause to gather automatically by area segments group's statistical report form and calculate, can't and merge adjustment, payment and calculate automatically, and finally cause the user of conglomerate to accomplish the joint account data complicacy of all kinds of statistical report forms; Data processing amount is big, and the time that need carry out data processing is long.
Capable fixing dead, row change of the dynamic data table of the permission row of section or row changes or row change in the dynamic area, row are fixing dead.In table three layers of characteristic of page structure (project formula layer, figure selection formula layer, data Layer), the project of project formula layer is fixed extremely, can not be expanded;
The association of dynamically enumerating of data Layer is only divided into groups by similarity, and preservation can't be accomplished to preserve by uniqueness.
Therefore in the prior art; To the complex disposal process of above-mentioned various data services, the treatment capacity of data service is bigger, causes the treatment capacity of data of systems such as computing machine bigger; Influence the runnability of systems such as computing machine, and can not revise or handle above-mentioned data service dynamically.
Summary of the invention
Fundamental purpose of the present invention provides that a kind of data procedures is simple, data processing amount is little, promotes system performance such as computing machine and can on-the-fly modify and disposal route and device that expanded data is professional.
The technical solution adopted for the present invention to solve the technical problems is:
A kind of disposal route of data service, it comprises:
The attribute of judging statistical form is that static list of data still is the dynamic data table;
If the dynamic data table, then in said statistical form, generate and to supply the capable dimension and the row dimension that on-the-fly modify;
When in said capable dimension and row dimension, adding data or obtaining data, capable dimension in the said statistical form and the combination of row dimension are generated the dynamic item formula;
Said data are handled according to said dynamic item formula.
Preferably, shown in judge that the attribute of statistical form is that static list of data still is the dynamic data table, specifically comprise: judge that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
Preferably, said processing comprises: calculate and preserve.
The present invention also provides a kind of deal with data professional device, and it comprises:
Judging unit is used to judge that the attribute of statistical form is that static list of data still is the dynamic data table;
The dimension table generation unit is used for: if the result of said judging unit is the dynamic data table, then in said statistical form, generates and can supply the capable dimension and the row dimension that on-the-fly modify;
The combination generation unit is used for when adding data in said capable dimension and row dimension or obtaining data, and capable dimension in the said statistical form and row dimension are made up generation dynamic item formula;
Data processing unit is used for said data are handled according to said dynamic item formula.
Preferably, said judging unit is used for judging that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
Preferably, said processing comprises: calculate and preserve.
The technical scheme of embodiment of the present invention; Has following beneficial effect: method and apparatus provided by the invention; Reduce the complexity of data handling procedure, reduced data processing amount, promoted the runnability of systems such as computing machine; And data processing accurately with speed up, and above-mentioned data service can be revised and expand dynamically.
Description of drawings
The method flow diagram that Fig. 1 provides for the embodiment of the invention;
The apparatus structure synoptic diagram that Fig. 2 provides for the embodiment of the invention.
The realization of the object of the invention, functional characteristics and advantage will combine embodiment, further specify with reference to accompanying drawing.
Embodiment
In order to make the object of the invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with accompanying drawing and embodiment.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
The embodiment of the invention provides a kind of method of real time data processing, and is as shown in Figure 1, and the method comprising the steps of:
The attribute of S110, judgement statistical form is that static list of data still is the dynamic data table;
Among the concrete embodiment, judge that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
S120, according to the judged result of step S110, if the dynamic data table, then in said statistical form, generate and can supply the capable dimension and the row dimension that on-the-fly modify;
S130, when in said capable dimension and row dimension, adding data or obtaining data, capable dimension in the said statistical form and row dimension are made up generation dynamic item formula;
S140, said data are handled according to said dynamic item formula.
The method that the foregoing description provides; Reduce the complexity of data handling procedure, reduced data processing amount, promoted the runnability of systems such as computing machine; And data processing accurately with speed up, and above-mentioned data service can be revised and expand dynamically.
Enumerate the application implementation example of a said method below; Below the application implementation example be that said method is to be applied in the user's of conglomerate in ERP (Enterprise Resourse Planning, the Enterprise Resources Planning) management system the process of establishment of statistical report form.
The first step: customer analysis group of general headquarters of group statistical form (this statistical form is: form statistical report form), content, and the form attribute of decision statistic table is a static list of data, or the dynamic data table; In static list of data, capable dimension parameter of project formula and row dimension parameter; In the dynamic data table, the project formula has capable dimension parameter and row maintenance parameters.
Second step: for the form attribute is the dynamic data table, and computing machine provides capable dimension (as: defining classification standard row) through ERP system in statistical form the permission user of subordinate unit selects from this ERP system basic data through computing machine or the user of subordinate unit inserts by hand with row dimension (as: the detailed item of criteria for classification).
The 3rd step: for dynamic table, the user of subordinate unit of group of enterprises fills out number or gets when several through figure selection formula at statistical form, computing machine through ERP system in the list data automatically with capable dimension of statistical form table page or leaf (as: criteria for classification detailed) and row dimension (as: data item formula) combination generation dynamic item formula; Like DItem (" 102001 ", " plumbous 1 ", 0; 0, " TEXT03 ", " TXT "); Parameter in this dynamic item formula " plumbous 1 " is detailed (a row dimension) of criteria for classification, and the other guide in this dynamic item formula is data item formula DItem (" 102001 ", " plumbous 1 "; 0,0, " TEXT03 "; " TXT ") (row dimension), both dynamic combined then are the dynamic item formula.
The 3rd step: computing machine through ERP system with the above-mentioned data of dynamic table by the parameter with unique above-mentioned property dynamic item formula preserve, calculate, adjust, payment and joint account.
Said method is applied in this application implementation example; The user will work out the form of the form of all kinds of business statistics detailed datas, detailed content is uncertain; Work out through dynamic table, the user of general headquarters of group is as long as the sign row clause name and the project formula thereof of definition list are fixed or changed the detailed clause name of going and dynamically added by subordinate unit; But its detailed clauses and subclauses project formula is generated by the system backstage automatically, can reduce the workload of user definition report form template project and project formula thereof widely;
Because the uniqueness of moving project project formula sign dynamic item data; Allow adjustment, the payment of user to dynamic data; These handle record system log (SYSLOG); Automatically the dynamic item record data are carried out identification, classification, adjustment, payment and joint account, thereby reduce every month each workload of user, increase work efficiency dynamic item data identification, classification, adjustment, payment and joint account etc.;
The data collection of all kinds of statistical report forms of group, the form and the contents of a project are free, any, need not carry out special processing by the requirement of all subordinate units again, reduce and formulate and submit difficulty;
Owing to dynamically preserve data by dynamic project formula, thereby can a plurality of joint accounts of dynamically enumerating a dimension be provided, for the analysis decision of conglomerate various data supports are provided fast for group.
The embodiment of the invention also provides a kind of deal with data professional device, and as shown in Figure 2, this device comprises:
Judging unit 210 is used to judge that the attribute of statistical form is that static list of data still is the dynamic data table;
Dimension table generation unit 220 is used for: if the judged result of said judging unit 210 is dynamic data tables, then in said statistical form, generates and can supply the capable dimension and the row dimension that on-the-fly modify;
Combination generation unit 230 is used for when adding data in said capable dimension and row dimension or obtaining data, and capable dimension in the said statistical form and row dimension are made up generation dynamic item formula;
Data processing unit 240 is used for said data are handled according to said dynamic item formula.
Among other the embodiment, concrete, said judging unit 210 is used for judging that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
Wherein, among the embodiment of said apparatus, said processing comprises: calculate and preserve.
The device that the foregoing description provides; Reduce the complexity of data handling procedure, reduced data processing amount, promoted the runnability of systems such as computing machine; And data processing accurately with speed up, and above-mentioned data service can be revised and expand dynamically.
More than above-mentionedly be merely preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of within spirit of the present invention and principle, being done, be equal to and replace and improvement etc., all should be included within protection scope of the present invention.

Claims (6)

1. the disposal route of a data service is characterized in that, comprising:
The attribute of judging statistical form is that static list of data still is the dynamic data table;
If the dynamic data table, then in said statistical form, generate and to supply the capable dimension and the row dimension that on-the-fly modify;
When in said capable dimension and row dimension, adding data or obtaining data, capable dimension in the said statistical form and the combination of row dimension are generated the dynamic item formula;
Said data are handled according to said dynamic item formula.
2. method according to claim 1; It is characterized in that; The attribute of judging statistical form is that static list of data still is the dynamic data table, specifically comprises: judge that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
3. method according to claim 1 is characterized in that said processing comprises: calculate and preserve.
4. the device that deal with data is professional is characterized in that, comprising:
Judging unit is used to judge that the attribute of statistical form is that static list of data still is the dynamic data table;
The dimension table generation unit is used for: if the result of said judging unit is the dynamic data table, then in said statistical form, generates and can supply the capable dimension and the row dimension that on-the-fly modify;
The combination generation unit is used for when adding data in said capable dimension and row dimension or obtaining data, and capable dimension in the said statistical form and row dimension are made up generation dynamic item formula;
Data processing unit is used for said data are handled according to said dynamic item formula.
5. like the professional device of the said deal with data of claim 4, it is characterized in that said judging unit is used for judging that according to said statistics tableau format, content the attribute of said statistical form is that static list of data still is the dynamic data table.
6. like the professional device of the said deal with data of claim 4, it is characterized in that said processing comprises: calculate and preserve.
CN201010299990.5A 2010-10-08 2010-10-08 Data service processing method and device adopting same Active CN102446172B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201010299990.5A CN102446172B (en) 2010-10-08 2010-10-08 Data service processing method and device adopting same

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010299990.5A CN102446172B (en) 2010-10-08 2010-10-08 Data service processing method and device adopting same

Publications (2)

Publication Number Publication Date
CN102446172A true CN102446172A (en) 2012-05-09
CN102446172B CN102446172B (en) 2014-10-01

Family

ID=46008676

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010299990.5A Active CN102446172B (en) 2010-10-08 2010-10-08 Data service processing method and device adopting same

Country Status (1)

Country Link
CN (1) CN102446172B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880597A (en) * 2012-09-28 2013-01-16 用友软件股份有限公司 Multidimensional data generation device and multidimensional data generation method used for computer system
CN103745301A (en) * 2013-12-16 2014-04-23 远光软件股份有限公司 Statement figure acquisition setting method and device based on statement dimension
CN104462254A (en) * 2014-11-21 2015-03-25 用友软件股份有限公司 Complex region number taking device and method
CN104679819A (en) * 2014-12-22 2015-06-03 上海钢富电子商务有限公司 Data analysis method and system of spot resources for steel trading industry
CN105389346A (en) * 2015-10-22 2016-03-09 江苏国泰新点软件有限公司 Bidding clearing method and apparatus in electronic bidding evaluation system

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093472A (en) * 2007-06-18 2007-12-26 北京润乾信息系统技术有限公司 Method for calculating expression in WEB dynamic line type report forms
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101093472A (en) * 2007-06-18 2007-12-26 北京润乾信息系统技术有限公司 Method for calculating expression in WEB dynamic line type report forms
CN101556579A (en) * 2009-05-08 2009-10-14 用友软件股份有限公司 Formula processing system used for dynamic report areas and method thereof

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102880597A (en) * 2012-09-28 2013-01-16 用友软件股份有限公司 Multidimensional data generation device and multidimensional data generation method used for computer system
CN103745301A (en) * 2013-12-16 2014-04-23 远光软件股份有限公司 Statement figure acquisition setting method and device based on statement dimension
CN103745301B (en) * 2013-12-16 2017-05-24 远光软件股份有限公司 Statement figure acquisition setting method and device based on statement dimension
CN104462254A (en) * 2014-11-21 2015-03-25 用友软件股份有限公司 Complex region number taking device and method
CN104462254B (en) * 2014-11-21 2018-08-28 用友网络科技股份有限公司 Complex region access device and method
CN104679819A (en) * 2014-12-22 2015-06-03 上海钢富电子商务有限公司 Data analysis method and system of spot resources for steel trading industry
CN104679819B (en) * 2014-12-22 2018-03-23 上海找钢网信息科技股份有限公司 The data analysis method and system of steel trade industry stock resource
CN105389346A (en) * 2015-10-22 2016-03-09 江苏国泰新点软件有限公司 Bidding clearing method and apparatus in electronic bidding evaluation system

Also Published As

Publication number Publication date
CN102446172B (en) 2014-10-01

Similar Documents

Publication Publication Date Title
US8417732B2 (en) Methods, systems, and software applications for event based data processing
US10671671B2 (en) Supporting tuples in log-based representations of graph databases
CN104536965B (en) A kind of data query display systems under the conditions of big data and method
WO2019024496A1 (en) Enterprise recommendation method and application server
US20110270850A1 (en) Prioritization of Resources based on User Activities
US20120265720A1 (en) Infrastructure and architecture for development and execution of predictive models
CN102446172A (en) Data service processing method and device adopting same
CN102725753A (en) Method and apparatus for optimizing data access, method and apparatus for optimizing data storage
US10547525B2 (en) Determining events by analyzing stored electronic communications
CN107622068A (en) A kind of blog management method and device based on JSON forms
US20180357278A1 (en) Processing aggregate queries in a graph database
US20210397601A1 (en) Enforcing path consistency in graph database path query evaluation
CN107203529A (en) Multi-service correlation analysis method and device based on metadata graph structural similarity
Ranjan The 10 Vs of Big Data framework in the Context of 5 Industry Verticals.
US20110154376A1 (en) Use of Web Services API to Identify Responsive Content Items
Li et al. Bohr: similarity aware geo-distributed data analytics
US20180357328A1 (en) Functional equivalence of tuples and edges in graph databases
US8392406B1 (en) Determining a height-balanced histogram incrementally
US9053177B1 (en) Sitelinks based on visual location
US20200201853A1 (en) Collecting query metadata for application tracing
CN105574027A (en) On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system
CN106326400A (en) Multi-dimension data set-based data processing system
CN111078905A (en) Data processing method, device, medium and equipment
CN102117324B (en) File management method and management system applying fuzzy matrice
Nambiar et al. Industry standards for the analytics era: TPC roadmap

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