CN106022896A - Transaction statistics report generation method and system - Google Patents
Transaction statistics report generation method and system Download PDFInfo
- Publication number
- CN106022896A CN106022896A CN201610397491.7A CN201610397491A CN106022896A CN 106022896 A CN106022896 A CN 106022896A CN 201610397491 A CN201610397491 A CN 201610397491A CN 106022896 A CN106022896 A CN 106022896A
- Authority
- CN
- China
- Prior art keywords
- input domain
- data
- statistics
- transaction data
- repetition
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
- G06Q30/0633—Managing shopping lists, e.g. compiling or processing purchase lists
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/183—Tabulation, i.e. one-dimensional positioning
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Accounting & Taxation (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Finance (AREA)
- Probability & Statistics with Applications (AREA)
- Development Economics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a transaction statistics report generation method and system. A plurality of generated reports have repeated input fields. The method comprises the following steps: transaction data is received; the transaction data for one of the repeated input fields is subjected to statistics operation, statistics result data is added into the repeated input fields, and corresponding statistics result data are added into input fields, beyond the repeated input fields, of the plurality of reports based on the received transaction data. Via implementation of the transaction statistics report generation method and system, the repeated input fields are subjected to only one time of data statistics operation, repeated execution of statistics processing can be prevented, and report generation efficiency can be improved.
Description
Technical field
The present invention relates to the communications field, specifically for, relate to transaction statistics report generation side
Method and system.
Background technology
Along with the development of informationized society, big data technique is applied the most at large in enterprise.Report
Table is the effective way of exhibiting data information, and therefore, generating form the most efficiently becomes big data industry
The emphasis of research.
But, for the situation of multiple forms of generation, the mode generally used in the middle of prior art is,
Respectively transaction data is added up for every form, and if multiple forms to be generated existing weight
Multiple input domain (such as row index is balance of points, and row index is Pekinese's input domain), then can be for
Described input domain repeatedly adds up transaction data, significantly reduces the formation efficiency of form.
Summary of the invention
For solve above-mentioned technical problem, the present invention provide a kind of for conclude the business statistics report form generation method and
System.
On the one hand, embodiments of the present invention provide a kind of report form generation method for statistics of concluding the business,
Wherein, having the input domain of repetition in multiple forms of generation, described method includes:
Receive transaction data；
For an input domain in the input domain of described repetition, the transaction data that statistics receives；
The result data of described statistics is added to the input domain of described repetition；
Based on the transaction data received, remaining in addition to the input domain of described repetition at the plurality of form
Input domain in add corresponding statistical result data.
On the other hand, embodiment of the present invention provides a kind of report generating system for statistics of concluding the business,
Wherein, having the input domain of repetition in multiple forms of generation, described system includes:
Receiver module, is used for receiving transaction data.
Statistical module, for for an input domain in the input domain of described repetition, adds up described reception
The transaction data that module receives；
First adds module, for adding the result data of described statistical module counts to described repetition
In input domain；
Second adds module, for the transaction data received based on described receiver module, at the plurality of report
Table remaining input domain adds in addition to the input domain of described repetition corresponding statistical result data.
Implement the report form generation method for statistics of concluding the business and system that the present invention provides, defeated for repeat
Enter territory, only carry out a data statistics, it is to avoid repeating of statistical disposition, improve the life of form
Become efficiency.
Accompanying drawing explanation
Fig. 1 is the flow process of a kind of report form generation method for statistics of concluding the business according to embodiment of the present invention
Figure；
Fig. 2 is the structure of a kind of report generating system for statistics of concluding the business according to embodiment of the present invention
Schematic diagram.
Detailed description of the invention
For making the purpose of embodiments of the invention, technical scheme and advantage clearer, below in conjunction with attached
The present invention is described in further detail for figure.
Fig. 1 is the flow process of a kind of report form generation method for statistics of concluding the business according to embodiment of the present invention
Figure.The multiple forms wherein generated have the input domain of repetition.Seeing Fig. 1, described method includes:
S100: receive transaction data.
S200: for an input domain in the input domain of described repetition, the transaction data that statistics receives.
In embodiments of the present invention, form includes row index, row index and input domain.Wherein,
The input domain repeated refers to multiple input domains that row index is the most identical with row index.
S300: the result data of described statistics is added to the input domain of described repetition.
In certain embodiments of the present invention, for the ease of directly obtaining the result data of described statistics,
Before execution processes S300, the result data of described statistics can be stored to middleware (in such as,
Between table etc.) in.
S400: based on receive transaction data, the plurality of form except described repetition input domain with
Outer remaining input domain adds corresponding statistical result data.Certainly embodiments of the present invention are not limited to
This, those skilled in the art can also first carry out process S400 before execution processes S200.
When the transaction data received is multiple, processing S200 can be accomplished by:
The multiple transaction data received are stored in multiple data capsule, such as can be according to user in transaction data
The cryptographic Hash of identifier carries out the distribution of data capsule；For an input in the input domain of described repetition
Territory, adds up the transaction data in each data capsule respectively；Collect the statistical result data of each data capsule.
Owing to multiple transaction data are dispersed in different data capsules, therefore, if some or many
Individual data capsule occurs in that the situation of mistake of statistics, only data capsule mistake occur need to be re-started number
According to statistics, and without again adding up whole transaction data, to improve the formation efficiency of form further.
Below as a example by generating multiple monthly forms, embodiments of the present invention are specifically described, its
In, the multiple monthly form of generation has one or more groups input domain repeated, wherein, repetition defeated
Enter multiple input domains that territory refers to that in multiple forms to be generated, row index is the most identical with row index.
Step 1: receive multiple transaction data of transaction system generation in this month.
Step 2: according to the cryptographic Hash of user identifier in transaction data, multiple transaction data are stored respectively
In the most individual data capsule.
Step 3: perform following process respectively for each group of input domain repeated:
A, for repeat input domain in an input domain, add up the number of deals in each data capsule respectively
According to；
B, the statistical result data of each data capsule are stored respectively to corresponding middle table；
C, collect in each middle table the statistical result data of storage, and the result data collected is added to phase
In the input domain answered.
Step 4: based on receive transaction data, multiple monthly form to be generated except described one group or
Beyond the input domain that many groups repeat in remaining input domain, add corresponding statistical result data.
Wherein, in order to reduce the statistics pressure at the end of month, knot is per diem added up in the statistics employing for transaction data
Close the mode monthly added up to carry out, such as, for carrying out the data acquisition side per diem added up of increment every day
Formula, and the mode monthly can only added up in the data acquisition use that the end of month carries out adding up for extreme value etc..
Certainly embodiments of the present invention are not limited to this, and those skilled in the art can also be according to actual need
Use and combine, by Zhou Tongji, the mode monthly added up.
Fig. 2 is the structure of a kind of report generating system for statistics of concluding the business according to embodiment of the present invention
Schematic diagram.The multiple forms wherein generated have the input domain of repetition.See Fig. 2, described system 1000
Including: receiver module 100, statistical module 200, first add module 300 and second and add module 400,
Specifically:
Receiver module 100 is used for receiving transaction data.
Statistical module 200 is for for an input domain in the input domain of described repetition, and statistics receives mould
The transaction data that block 100 receives.
First adds module 300 adds to described repetition for the result data added up by statistical module 200
Input domain in.
Second adds the transaction data that module 400 is used for receiving based on receiver module 100, at the plurality of report
Table remaining input domain adds in addition to the input domain of described repetition corresponding statistical result data.
In certain embodiments of the present invention, for the ease of directly obtaining the knot of statistical module 200 statistics
Really data, this system 100 can also include memory module, for the result added up by statistical module 200
Data store to middleware (such as, middle table etc.).
Receive transaction data be multiple when, statistical module 200 may include that memory element,
Statistic unit and collection unit, specifically, memory element is for depositing the multiple transaction data received
Enter in multiple data capsule；Statistic unit is used for for an input domain in the input domain of described repetition,
Add up the transaction data in each data capsule respectively；Collection unit is for collecting the statistics knot of each data capsule
Really data.
Implement the report form generation method for statistics of concluding the business and system that the present invention provides, defeated for repeat
Enter territory, only carry out a data statistics, it is to avoid repeating of statistical disposition, improve the life of form
Become efficiency.
Through the above description of the embodiments, those skilled in the art is it can be understood that arrive this
Bright can realize by the mode of software combined with hardware platform.Based on such understanding, the technology of the present invention
What background technology was contributed by scheme can embody with the form of software product in whole or in part,
This computer software product can be stored in storage medium, such as ROM/RAM, magnetic disc, CD etc.,
Including some instructions with so that computer equipment (can be personal computer, server, intelligent
Mobile phone or the network equipment etc.) perform described in some part of each embodiment of the present invention or embodiment
Method.
The term used in description of the invention and wording, just to illustrating, are not intended to constitute limit
Fixed.It will be appreciated by those skilled in the art that before the ultimate principle without departing from disclosed embodiment
Put, each details in above-mentioned embodiment can be carried out various change.Therefore, the scope of the present invention is only
Being determined by claim, in the claims, except as otherwise noted, all of term should be by broadest conjunction
The meaning of reason understands.
Claims (6)
1., for a report form generation method for statistics of concluding the business, multiple forms of generation have the defeated of repetition
Enter territory, it is characterised in that described method includes:
Receive transaction data；
For an input domain in the input domain of described repetition, the transaction data that statistics receives；
The result data of described statistics is added to the input domain of described repetition；
Based on the transaction data received, remaining in addition to the input domain of described repetition at the plurality of form
Input domain in add corresponding statistical result data.
2. the method for claim 1, it is characterised in that described method also includes:
Process in performing the described input domain that the result data of described statistics is added extremely described repetition
Before, the result data of described statistics is stored to middleware.
3. method as claimed in claim 1 or 2, it is characterised in that the transaction data in reception is many
When individual, for an input domain in the input domain of described repetition, the transaction data that statistics receives
Including:
The multiple transaction data received are stored in multiple data capsule；
For an input domain in the input domain of described repetition, add up the transaction in each data capsule respectively
Data；
Collect the statistical result data of each data capsule.
4., for a report generating system for statistics of concluding the business, multiple forms of generation have the defeated of repetition
Enter territory, it is characterised in that described system includes:
Receiver module, is used for receiving transaction data；
Statistical module, for for an input domain in the input domain of described repetition, adds up described reception
The transaction data that module receives；
First adds module, for adding the result data of described statistical module counts to described repetition
In input domain；
Second adds module, for the transaction data received based on described receiver module, at the plurality of report
Table remaining input domain adds in addition to the input domain of described repetition corresponding statistical result data.
5. system as claimed in claim 4, it is characterised in that described system also includes:
Memory module, for storing the result data of described statistical module counts to middleware.
6. the system as described in claim 4 or 5, it is characterised in that the transaction data in reception is many
When individual, described statistical module includes:
Memory element, for being stored in the multiple transaction data received in multiple data capsule；
Statistic unit, for for an input domain in the input domain of described repetition, adds up each number respectively
According to the transaction data in container；
Collection unit, for collecting the statistical result data of each data capsule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610397491.7A CN106022896A (en) | 2016-06-07 | 2016-06-07 | Transaction statistics report generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610397491.7A CN106022896A (en) | 2016-06-07 | 2016-06-07 | Transaction statistics report generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106022896A true CN106022896A (en) | 2016-10-12 |
Family
ID=57089780
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610397491.7A Pending CN106022896A (en) | 2016-06-07 | 2016-06-07 | Transaction statistics report generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106022896A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1696937A (en) * | 2004-05-12 | 2005-11-16 | 微软公司 | Smart Autofill |
| CN102479180A (en) * | 2010-11-22 | 2012-05-30 | 金蝶软件（中国）有限公司 | Data filling method and device |
| CN103548019A (en) * | 2011-02-21 | 2014-01-29 | 阿玛得斯两合公司 | Method and system for providing statistical from a data warehouse |
| CN103581212A (en) * | 2012-07-18 | 2014-02-12 | 百度在线网络技术（北京）有限公司 | Automatic form filling method, system and device based on cloud analysis |
| CN104318425A (en) * | 2014-10-08 | 2015-01-28 | 广州市海珠区电子政务技术信息中心 | Service information logging method and system |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
-
2016
- 2016-06-07 CN CN201610397491.7A patent/CN106022896A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1696937A (en) * | 2004-05-12 | 2005-11-16 | 微软公司 | Smart Autofill |
| CN102479180A (en) * | 2010-11-22 | 2012-05-30 | 金蝶软件（中国）有限公司 | Data filling method and device |
| CN103548019A (en) * | 2011-02-21 | 2014-01-29 | 阿玛得斯两合公司 | Method and system for providing statistical from a data warehouse |
| CN103581212A (en) * | 2012-07-18 | 2014-02-12 | 百度在线网络技术（北京）有限公司 | Automatic form filling method, system and device based on cloud analysis |
| CN104318425A (en) * | 2014-10-08 | 2015-01-28 | 广州市海珠区电子政务技术信息中心 | Service information logging method and system |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104283975B (en) | Document distribution method and device | |
| CN104737157A (en) | A federated database system | |
| CN106155812A (en) | Method, device, system and the electronic equipment of a kind of resource management to fictitious host computer | |
| CN101556678A (en) | Processing method of batch processing services, system and service processing control equipment | |
| CN1459184A (en) | Method, system and device for monitoring activity of wireless communcation device | |
| US8886791B2 (en) | Generating alerts based on managed and unmanaged data | |
| CN107562809A (en) | Business data statistical method, device and system and readable storage medium | |
| US7698312B2 (en) | Performing recursive database operations | |
| US20180109641A1 (en) | Data Processing Method and Apparatus, Server, and Controller | |
| CN102890714A (en) | Method and device for indexing data | |
| CN108491255B (en) | Self-service MapReduce data optimal distribution method and system | |
| CN110008173A (en) | A kind of method and device of data storage | |
| CN112035531A (en) | Sensitive data processing method, device, equipment and medium | |
| CN107203532A (en) | Construction method, the implementation method of search and the device of directory system | |
| CN107656955A (en) | Refund data are offerred method and apparatus in batches | |
| CN115714692B (en) | A model training method for monitoring network card and its application, system and electronic device | |
| CN103473106B (en) | Method and system for generating page | |
| CN110519782A (en) | A kind of communication network multi-center selection method and device | |
| CN106815718A (en) | A kind of pcb board defect statistics method and system | |
| CN106022896A (en) | Transaction statistics report generation method and system | |
| CN102348186A (en) | Account and asset loader tool | |
| CN103795788B (en) | The load-balancing method and load-balanced server of instant communication server | |
| CN117235773B (en) | Intelligent data classification management method, system and storage medium for big data center | |
| CN105740278A (en) | Data processing method and apparatus | |
| EP2919504B1 (en) | Method and device for judging user repeatedly accessing network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20161012 |