CN102446172B - Data service processing method and device adopting same - Google Patents
Data service processing method and device adopting same Download PDFInfo
- Publication number
- CN102446172B CN102446172B CN201010299990.5A CN201010299990A CN102446172B CN 102446172 B CN102446172 B CN 102446172B CN 201010299990 A CN201010299990 A CN 201010299990A CN 102446172 B CN102446172 B CN 102446172B
- Authority
- CN
- China
- Prior art keywords
- data
- dynamic
- row 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.)
- Active
Links
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
Technical field
The present invention relates to field of computer technology, specifically utilize computing machine to carry out the method for data processing.
Background technology
Adopt the dynamic data tables changing in the permission row or column of dynamic area section at all kinds of statistical report forms of ERP system establishment group.Because this table is to increase and preserve the tables of data that dynamic area is enumerated on the basis of project data preserving type that adopts two-dimentional fixed table, and each project formula has been preserved one group of similar data, cause can only group's statistical report form being gathered automatically and being calculated by area segments, cannot automatically calculate adjusting, offset and merging, and finally cause the user of conglomerate to complete the joint account data complexity of all kinds of statistical report forms, data processing amount is large, and the time that need to carry out data processing is long.
Fixing dead at capable fixing dead, the row variation of the dynamic data tables of the permission row or column variation of dynamic area section or row variation, row.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 item number certificate of dynamically enumerating of data Layer is only divided into groups by similarity, and preservation cannot be accomplished to preserve by uniqueness.
Therefore in prior art, to the complex disposal process of above-mentioned various data services, the treatment capacity of data service is larger, causes the treatment capacity of data of the systems such as computing machine larger, affect the runnability of the systems such as computing machine, and can not revise dynamically or process above-mentioned data service.
Summary of the invention
Fundamental purpose of the present invention is to provide that a kind of data procedures is simple, data processing amount is little, promotes the system performance such as computing machine and disposal route and the device of the data service that can on-the-fly modify and expand.
The technical solution adopted for the present invention to solve the technical problems is:
A disposal route for data service, it comprises:
The attribute that judges statistical form is static list of data or dynamic data tables;
If dynamic data tables generates row dimension and the row dimension that can Gong on-the-fly modify in described statistical form;
In the time adding data or obtain data in described row dimension and row dimension, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
Described data are processed according to described dynamic item formula.
Preferably, shown in judge that the attribute of statistical form is static list of data or dynamic data tables, specifically comprise: judge that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
Preferably, described processing comprises: calculate and preserve.
The present invention also provides a kind of device of deal with data business, and it comprises:
Judging unit, for judging that the attribute of statistical form is static list of data or dynamic data tables;
Dimension table generation unit, for: if the result of described judging unit is dynamic data tables, in described statistical form, generate row dimension and the row dimension that can Gong on-the-fly modify;
Combination producing unit, for when in the time that described row dimension and row dimension are added data or obtain data, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
Data processing unit, for processing described data according to described dynamic item formula.
Preferably, described judging unit, for judging that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
Preferably, described processing comprises: calculate and preserve.
Implement technical scheme of the present invention, there is following beneficial effect: method and apparatus provided by the invention, reduce the complexity of data handling procedure, reduce data processing amount, promote the runnability of the systems such as computing machine, and data processing is accurate and speed is accelerated, and make above-mentioned data service be revised dynamically and to expand.
Brief description of the drawings
The method flow diagram that Fig. 1 provides for the embodiment of the present invention;
The apparatus structure schematic diagram that Fig. 2 provides for the embodiment of the present invention.
Realization, functional characteristics and the advantage of the object of the invention, in connection with embodiment, are described further with reference to accompanying drawing.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearer, below in conjunction with drawings and Examples, the present invention is further elaborated.Should be appreciated that specific embodiment described herein, only in order to explain the present invention, is not intended to limit the present invention.
The embodiment of the present invention provides a kind of method of real time data processing, and as shown in Figure 1, the method comprising the steps of:
S110, judge that the attribute of statistical form is static list of data or dynamic data tables;
In specific embodiment, judge that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
S120, according to the judged result of step S110, if dynamic data tables, in described statistical form, generate row dimension and the row dimension that can Gong on-the-fly modify;
S130, in the time adding data or obtain data in described row dimension and row dimension, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
S140, described data are processed according to described dynamic item formula.
The method that above-described embodiment provides, the complexity that has reduced data handling procedure, has reduced data processing amount, has promoted the runnability of the systems such as computing machine, and data processing is accurate and speed is accelerated, and make above-mentioned data service be revised dynamically and to expand.
Enumerate the Application Example of a said method below, Application Example is below that said method is to be applied in the process of establishment of the statistical report form of the user of conglomerate in ERP (Enterprise Resourse Planning, Enterprise Resources Planning) management system.
The first step: form, the content of customer analysis group of general headquarters of group statistical form (this statistical form is: statistical report form), the form attribute of decision statistic table is static list of data, or dynamic data tables; In static list of data, project formula is row dimension parameter and row dimension parameter not; In dynamic data tables, project formula has row dimension parameter and row maintenance parameters.
Second step: be dynamic data tables for form attribute, row dimension (as: defining classification standard row) is provided in statistical form by ERP system computing machine and row dimension (as: detailed of criteria for classification) allows the user of subordinate unit to select from this ERP system basic data by computing machine or the user of subordinate unit inserts by hand.
The 3rd step: for dynamic table, the user of subordinate unit of group of enterprises gets when several in statistical form number completion or by figure selection formula, computing machine by ERP system in list data automatically by the row dimension of statistical form table page (as: criteria for classification detailed) and row dimension (as: data item formula) combination producing dynamic item formula, as DItem (" 102001 ", " plumbous 1 ", 0, 0, " TEXT03 ", " TXT "), parameter " plumbous 1 " in this dynamic item formula is detailed (the row dimension) of criteria for classification, other guide in this dynamic item formula is data item formula DItem (" 102001 ", " plumbous 1 ", 0, 0, " TEXT03 ", " TXT ") (row dimension), both dynamic combined are dynamic item formula.
The 3rd step: computing machine by ERP system by 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 Example, user will work out the report tableau format of all kinds of business statistics detailed datas, detailed content is uncertain, work out by dynamic table, as long as the user of general headquarters of group is mark row clause name and the project formula thereof of definition list, the detailed clause name of fixing or change row is by subordinate unit's dynamic appending, but its detailed entry project formula is generated automatically by system backstage, user can be reduced widely define the workload of report form template project and project formula thereof;
Because the uniqueness of moving project project formula mark dynamic item data, allow adjustment, the payment of user to dynamic data, these process record system log (SYSLOG), automatically dynamic item record data are carried out to identification, classification, adjustment, payment and joint account, thereby reduce monthly each workload to dynamic item data identification, classification, adjustment, payment and joint account etc. of user, increase work efficiency;
The data collection of all kinds of statistical report forms of group, form and the contents of a project freely, arbitrarily, need not be carried out special processing by the requirement of all subordinate units again, reduce and formulate and submit difficulty;
Owing to pressing dynamic item formula dynamical save data, thereby can provide multiple joint accounts of dynamically enumerating a dimension for group, fast for the analysis decision of conglomerate provides various Data supports.
The embodiment of the present invention also provides a kind of device of deal with data business, and as shown in Figure 2, this device comprises:
Judging unit 210, for judging that the attribute of statistical form is static list of data or dynamic data tables;
Dimension table generation unit 220, for: if the judged result of described judging unit 210 is dynamic data tables, in described statistical form, generate row dimension and the row dimension that can Gong on-the-fly modify;
Combination producing unit 230, for when in the time that described row dimension and row dimension are added data or obtain data, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
Data processing unit 240, for processing described data according to described dynamic item formula.
In other embodiment, concrete, described judging unit 210, for judging that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
Wherein, in the embodiment of said apparatus, described processing comprises: calculate and preserve.
The device that above-described embodiment provides, the complexity that has reduced data handling procedure, has reduced data processing amount, has promoted the runnability of the systems such as computing machine, and data processing is accurate and speed is accelerated, and make above-mentioned data service be revised dynamically and to expand.
More than above are only preferred embodiment of the present invention, not in order to limit the present invention, all any amendments of doing within the spirit and principles in the present invention, be equal to and replace and improvement etc., within all should being included in protection scope of the present invention.
Claims (6)
1. a disposal route for data service, is characterized in that, comprising:
Judge that according to statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables;
If dynamic data tables generates row dimension and the row dimension that can Gong on-the-fly modify in described statistical form;
In the time adding data or obtain data in described row dimension and row dimension, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
Described data are processed according to described dynamic item formula.
2. method as claimed in claim 1, it is characterized in that, the attribute that judges statistical form is static list of data or dynamic data tables, specifically comprises: judge that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
3. method as claimed in claim 1, is characterized in that, described processing comprises: calculate and preserve.
4. a treating apparatus for data service, is characterized in that, comprising:
Judging unit, for judging that according to statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables;
Dimension table generation unit, for: if the result of described judging unit is dynamic data tables, in described statistical form, generate row dimension and the row dimension that can Gong on-the-fly modify;
Combination producing unit, for when in the time that described row dimension and row dimension are added data or obtain data, by the row dimension in described statistical form and row dimension combination producing dynamic item formula;
Data processing unit, for processing described data according to described dynamic item formula.
5. the treating apparatus of data service as claimed in claim 4, is characterized in that, described judging unit, for judging that according to described statistics tableau format, content the attribute of described statistical form is static list of data or dynamic data tables.
6. the treating apparatus of data service as claimed in claim 4, is characterized in that, described processing comprises: calculate and preserve.
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 CN102446172A (en) | 2012-05-09 |
| CN102446172B true 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) |
Families Citing this family (5)
| 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 |
| CN103745301B (en) * | 2013-12-16 | 2017-05-24 | 远光软件股份有限公司 | Statement figure acquisition setting method and device based on statement dimension |
| CN104462254B (en) * | 2014-11-21 | 2018-08-28 | 用友网络科技股份有限公司 | Complex region access device and method |
| 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 |
Citations (2)
| 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 |
-
2010
- 2010-10-08 CN CN201010299990.5A patent/CN102446172B/en active Active
Patent Citations (2)
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102446172A (en) | 2012-05-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102446172B (en) | Data service processing method and device adopting same | |
| Tan et al. | A maturity model of enterprise business intelligence | |
| CN104536965B (en) | A kind of data query display systems under the conditions of big data and method | |
| CN107870981A (en) | Electronic installation, the method and storage medium of tables of data filing processing | |
| CN111143286B (en) | Cloud platform log management method and system | |
| CA2795202A1 (en) | Prioritization of resources based on user activities | |
| CN104102636B (en) | A kind of statistics of page data, rendering method and device | |
| US9998450B2 (en) | Automatically generating certification documents | |
| CN102722533A (en) | Method and system for displaying and filling report | |
| CN107622068A (en) | A kind of blog management method and device based on JSON forms | |
| CN105550270B (en) | Data base query method and device | |
| CN106095546A (en) | The task management method of cloud computing platform and device | |
| CN107729137A (en) | Server, the method and storage medium of the decryption of block chain sign test | |
| CN102708466A (en) | Project management system | |
| MX2022008932A (en) | Method and apparatus for managing and controlling resource, device and storage medium. | |
| CN110674152A (en) | Data synchronization method and device, storage medium and electronic equipment | |
| WO2021258934A1 (en) | Typesetting and layout method and system | |
| CN101789023A (en) | Food material information release management system based on Web and release management method thereof | |
| CN104699788A (en) | Database query method and device | |
| CN105824279A (en) | Method for establishing flexible and effective CMDB (Configuration Management Database) of machine room monitoring system | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| CN109978513A (en) | Obtain method and apparatus, project task management equipment and the medium of technical standard | |
| CN103856969A (en) | Method, device and system for counting network element characteristic parameters | |
| KR101830504B1 (en) | In-Memory DB Connection Support Type Scheduling Method and System for Real-Time Big Data Analysis in Distributed Computing Environment | |
| CN105574027A (en) | On-line transaction processing/on-line analytical processing (OLTP/OLAP) hybrid application based multi-dimensional performance data storage method, device and system |
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 |