CN103488693A - Data processing device and data processing method - Google Patents
Data processing device and data processing method Download PDFInfo
- Publication number
- CN103488693A CN103488693A CN201310392597.4A CN201310392597A CN103488693A CN 103488693 A CN103488693 A CN 103488693A CN 201310392597 A CN201310392597 A CN 201310392597A CN 103488693 A CN103488693 A CN 103488693A
- Authority
- CN
- China
- Prior art keywords
- data
- temporary table
- detailed data
- detailed
- data temporary
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR 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/2455—Query execution
- G06F16/24552—Database cache management
Abstract
The invention provides a data processing device and a data processing method, wherein the data processing device comprises an acquiring unit; a caching unit, a processing unit and a data converting unit; the acquiring unit is used for acquiring detailed data of bill information according to a first query condition of a user; the caching unit is used for caching the detailed data into a temporary detailed data table and caching the analyzing data generated by the processing unit into a temporary analyzing data table; the processing unit is used for performing grouped crossing processing on the detailed data according to a second query condition of the user and generating analyzing data; the data converting unit is used for switching and displaying the temporary detailed data table and the temporary analyzing data table. By the technical scheme disclosed by the invention, accessing times from a database can be reduced, service repeating is avoided and the data processing efficiency can be improved.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of data processing equipment and a kind of data processing method.
Background technology
In the ERP management system, often use two kinds of forms of list and form to client's display data.Generally can represent detailed data with tableau format form, document list; represent the analysis data with the cross-packet form, and often have the situation of from analyzing data, checking detailed data or checking the analysis data from detailed data between these Report Lists.Realize that this general fashion of mutually checking is, first do a form that show to analyze data, then do form or a list of showing detailed data, then by a joint investigation device between these two forms or carry out picture between form and list and check.
In this implementation, need at least get twice identical data from database, and need the developer to safeguard two similar functions.This implementation makes the ERP management system more too fat to move on business, and executing efficiency is lower, has wasted again exploitation, test, the personnel cost of maintenance.
Use the method for present analysis data and the mutual joint investigation of detailed data to have the problem of several aspects:
1, need in the ERP management system at least to realize that an analytical statement and detailed form or list represent the data in same source, repetition is arranged like this on business.
2, analyze the data that data and detailed data derive from same data source, but will at least access twice database peek, reduced like this execution efficiency of program.
3, need to realize that an analytical statement and detailed form or at least two function points of list just can complete joint investigation in the ERP management system, this need to spend at least exploitation of many a times, test, the time of maintenance.
Summary of the invention
The present invention just is being based on above-mentioned technical matters, has proposed a kind of new data processing technique, can reduce the number of times of peeking from database, improves executing efficiency.
In view of this, according to an aspect of the present invention, provide a kind of data processing equipment, having comprised: acquiring unit, for obtain the detailed data of document information according to the first querying condition of user; Buffer unit, for by described detailed data buffer memory to the detailed data temporary table, and the analysis data buffer storage that processing unit is generated is to analyzing in the data temporary table; Described processing unit, to the cross processing of being divided into groups of described detailed data, generate described analysis data for the second querying condition according to described user; Described Date Conversion Unit, represent described detailed data temporary table and described analysis data temporary table for switching.
In this technical scheme, at first obtain the detailed data of document according to the first querying condition, and this detailed data is kept in the detailed data temporary table, for the user, check, if the user needs the query analysis data simultaneously, according to the detailed data found out, carry out analyzing and processing, and analysis result is kept at and analyzes in the data temporary table, like this, just can switch back and forth these two temporary tables for user's inquiry, owing to directly according to the detailed data inquired, carrying out data analysis, therefore, identical data have been avoided obtaining again from database, reduced database peek number of times, therefore can improve the execution efficiency of program, and also reduced database pressure.Secondly, only need to realize the joint investigation that just can complete detailed data and analysis data of the function point of a detailed form, reduce development time and cost of development.
In technique scheme, preferred, described buffer unit is also for being kept at the detailed data temporary table by described detailed data according to the field classification.
In above-mentioned arbitrary technical scheme, preferred, described processing unit also, for described the second querying condition is resolved to SQL statement, is carried out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.When the user need to check the analysis data, directly adopt the SQL mode obtain corresponding data and analyzed from the detailed data temporary table, avoid getting from database the process of identical data, also improved existing ERP management system in the joint investigation efficiency of analyzing between data and detailed data.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: the first delete cells, for example, when described data processing equipment cuts out (ERP system is closed), delete described detailed data temporary table and described analysis data temporary table.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: the second delete cells, when query page is closed, delete described detailed data temporary table and described analysis data temporary table.
In order to reduce taking of cache resources, when stop or current page while closing, delete this two temporary tables, further to improve the operational efficiency of system.
According to a further aspect in the invention, also provide a kind of data processing method, having comprised: the detailed data that obtains document information according to the first querying condition of user; By described detailed data buffer memory to the detailed data temporary table; , generate and analyze data the cross processing of being divided into groups of described detailed data according to the second querying condition of described user, by described analysis data buffer storage to analyzing in the data temporary table; Switching represents described detailed data temporary table and described analysis data temporary table.
In this technical scheme, at first obtain the detailed data of document according to the first querying condition, and this detailed data is kept in the detailed data temporary table, for the user, check, if the user needs the query analysis data simultaneously, according to the detailed data found out, carry out analyzing and processing, and analysis result is kept at and analyzes in the data temporary table, like this, just can switch back and forth these two temporary tables for user's inquiry, owing to directly according to the detailed data inquired, carrying out data analysis, therefore, identical data have been avoided obtaining again from database, reduced database peek number of times, therefore can improve the execution efficiency of program, and also reduced database pressure.Secondly, only need to realize the joint investigation that just can complete detailed data and analysis data of the function point of a detailed form, reduce development time and cost of development.
In technique scheme, preferred, described detailed data is kept in the detailed data temporary table according to the field classification.
In above-mentioned arbitrary technical scheme, preferred, the above second querying condition according to described user, to the cross processing of being divided into groups of described detailed data, generates the step of analyzing data and specifically comprises:
Described the second querying condition is resolved to SQL statement, carry out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.
When the user need to check the analysis data, directly adopt the SQL mode obtain corresponding data and analyzed from the detailed data temporary table, avoid getting from database the process of identical data, also improved existing ERP management system in the joint investigation efficiency of analyzing between data and detailed data.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: when management system is closed, delete described detailed data temporary table and described analysis data temporary table.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: when query page is closed, delete described detailed data temporary table and described analysis data temporary table.
In order to reduce taking of cache resources, when stop or current page while closing, delete this two temporary tables, further to improve the operational efficiency of system.
Data processing method of the present invention arranges two buffer memory temporary tables, store respectively detailed data and analyze data, analyzing data directly obtains according to detailed data, reduced the number of times of getting identical data from database, and can switch and show detail and analyze data by easy mode, improved existing ERP management system in the efficiency of analyzing joint investigation between data and detailed data, also make form or the list business of ERP management system more succinct, promoted customer experience, and ERP management system form and list exploitation, test have been saved, maintenance cost.
The accompanying drawing explanation
Fig. 1 shows the block diagram of data processing equipment according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of data processing method according to an embodiment of the invention;
Fig. 3 shows the process flow diagram of data processing method according to another embodiment of the present invention.
Embodiment
In order more clearly to understand above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that, in the situation that do not conflict, the application's embodiment and the feature in embodiment can combine mutually.
A lot of details have been set forth in the following description so that fully understand the present invention; but; the present invention can also adopt other to be different from other modes described here and implement, and therefore, protection scope of the present invention is not subject to the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of data processing equipment according to an embodiment of the invention.
As shown in Figure 1, data processing equipment 100 comprises according to an embodiment of the invention: acquiring unit 102, for obtain the detailed data of document information according to the first querying condition of user; Buffer unit 104, for by described detailed data buffer memory to the detailed data temporary table, and the analysis data buffer storage that processing unit 106 is generated is to analyzing in the data temporary table; Described processing unit 106, to the cross processing of being divided into groups of described detailed data, generate described analysis data for the second querying condition according to described user; Described Date Conversion Unit 108, represent described detailed data temporary table and described analysis data temporary table for switching.
In this technical scheme, at first obtain the detailed data of document according to the first querying condition, and this detailed data is kept in the detailed data temporary table, for the user, check, if the user needs the query analysis data simultaneously, according to the detailed data found out, carry out analyzing and processing, and analysis result is kept at and analyzes in the data temporary table, like this, just can switch back and forth these two temporary tables for user's inquiry, owing to directly according to the detailed data inquired, carrying out data analysis, therefore, identical data have been avoided obtaining again from database, reduced database peek number of times, therefore can improve the execution efficiency of program, and also reduced database pressure.Secondly, only need to realize the joint investigation that just can complete detailed data and analysis data of the function point of a detailed form, reduce development time and cost of development.
In technique scheme, preferred, described buffer unit is also for being kept at the detailed data temporary table by described detailed data according to the field classification.
In above-mentioned arbitrary technical scheme, preferred, described processing unit 106 also, for described the second querying condition is resolved to SQL statement, is carried out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.When the user need to check the analysis data, directly adopt the SQL mode obtain corresponding data and analyzed from the detailed data temporary table, avoid getting from database the process of identical data, also improved existing ERP management system in the joint investigation efficiency of analyzing between data and detailed data.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: the first delete cells 110, when ERP system is closed, delete described detailed data temporary table and described analysis data temporary table.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: the second delete cells 112, when query page is closed, delete described detailed data temporary table and described analysis data temporary table.
In order to reduce taking of cache resources, when stop or current page while closing, delete this two temporary tables, further to improve the operational efficiency of system.
Effectively improved the search efficiency of mutual joint investigation between ERP management system analysis data and detailed data according to data processing equipment of the present invention, effectively saved personnel cost in exploitation and maintenance process, and make form and list business in the ERP management system simpler, bring good customer experience.
Adopt analysis data and detailed data mutually to transform at least and can bring following beneficial effect:
The ERP management system realizes detailed data and analyzes representing of data with a function point, more brief on business; The ERP management system realizes detailed data and analyzes representing of data with a function point, only needs a set of code of development and maintenance, has saved exploitation, test, the personnel cost of maintenance; Just can realize detailed data and analyze checking of data with a database access in the ERP management system, having improved the execution efficiency of program.
Fig. 2 shows the process flow diagram of data processing method according to an embodiment of the invention.
As shown in Figure 2, data processing method can comprise the following steps according to an embodiment of the invention:
When stop or page close, the analysis data and the detailed data that are stored in buffer memory are deleted.
Below with concrete example, above-mentioned data handling procedure is described.
Suppose to check personnel's debt situation and department's debt situation in each department.
One. first each departmental staff's debt situation is deposited in temporary table tempTab, and this information is shown to the client, as shown in the table:
Department name | Personnel's name | Amount owed |
Finance Department | Zhang San | 100 |
Finance Department | Li Si | 800 |
Administration department | The king five | 400 |
Administration department | Look for six | 600 |
Two buttons (detailed button, analysis button) are arranged on report interface, click analysis button and check the analysis data.
Specifically can process above-mentioned temporary table by the method for SQL grouping, concrete SQL statement is as follows.
The Select department name, sum (amount owed) as amount owed from tempTab Group by department name, thus obtain analysis data as shown in the table.
Department name | Amount owed |
Finance Department | 900 |
Administration department | 1000 |
If click detailed button, the data of directly getting in the detailed data temporary table are just passable.
Effectively improved the search efficiency of mutual joint investigation between ERP management system analysis data and detailed data according to data processing method of the present invention, effectively saved personnel cost in exploitation and maintenance process, and make form and list business in the ERP management system simpler, bring good customer experience.
Fig. 3 shows the process flow diagram of data processing method according to another embodiment of the present invention.
As shown in Figure 3, data processing method can comprise the following steps according to an embodiment of the invention: step 302, obtain the detailed data of document information according to the first querying condition of user; By the detailed data buffer memory to the detailed data temporary table; Step 304,, generate and analyze data the detailed data cross processing of being divided into groups according to the second querying condition of user, will analyze data buffer storage to analyzing in the data temporary table; Step 306, switching represents the detailed data temporary table and analyzes the data temporary table.
In this technical scheme, at first obtain the detailed data of document according to the first querying condition, and this detailed data is kept in the detailed data temporary table, for the user, check, if the user needs the query analysis data simultaneously, according to the detailed data found out, carry out analyzing and processing, and analysis result is kept at and analyzes in the data temporary table, like this, just can switch back and forth these two temporary tables for user's inquiry, owing to directly according to the detailed data inquired, carrying out data analysis, therefore, identical data have been avoided obtaining again from database, reduced database peek number of times, therefore can improve the execution efficiency of program, and also reduced database pressure.Secondly, only need to realize the joint investigation that just can complete detailed data and analysis data of the function point of a detailed form, reduce development time and cost of development.
In technique scheme, preferred, described detailed data is kept in the detailed data temporary table according to the field classification.
In above-mentioned arbitrary technical scheme, preferred, the above second querying condition according to described user, to the cross processing of being divided into groups of described detailed data, generates the step of analyzing data and specifically comprises:
Described the second querying condition is resolved to SQL statement, carry out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.
When the user need to check the analysis data, directly adopt the SQL mode obtain corresponding data and analyzed from the detailed data temporary table, avoid getting from database the process of identical data, also improved existing ERP management system in the joint investigation efficiency of analyzing between data and detailed data.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: when system closing, delete described detailed data temporary table and described analysis data temporary table.
In above-mentioned arbitrary technical scheme, preferred, can also comprise: when query page is closed, delete described detailed data temporary table and described analysis data temporary table.
In order to reduce taking of cache resources, when stop or current page while closing, delete this two temporary tables, further to improve the operational efficiency of system.
Data processing method of the present invention, two buffer memory temporary tables are set, store respectively detailed data and analyze data, analyzing data directly obtains according to detailed data, reduced the number of times of getting identical data from database, and can switch and show detail and analyze data by easy mode, improved existing ERP management system in the efficiency of analyzing joint investigation between data and detailed data, also make form or the list business of ERP management system more succinct, promoted customer experience, and ERP management system form and list exploitation have been saved, test, maintenance cost.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.Within the spirit and principles in the present invention all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (10)
1. a data processing equipment, is characterized in that, comprising:
Acquiring unit, for obtaining the detailed data of document information according to the first querying condition of user;
Buffer unit, for by described detailed data buffer memory to the detailed data temporary table, and the analysis data buffer storage that processing unit is generated is to analyzing in the data temporary table;
Described processing unit, to the cross processing of being divided into groups of described detailed data, generate described analysis data for the second querying condition according to described user;
Described Date Conversion Unit, represent described detailed data temporary table and described analysis data temporary table for switching.
2. data processing equipment according to claim 1, is characterized in that, described buffer unit is also for being kept at the detailed data temporary table by described detailed data according to the field classification.
3. data processing equipment according to claim 2, it is characterized in that, described processing unit also, for described the second querying condition is resolved to SQL statement, is carried out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.
4. according to the described data processing equipment of any one in claims 1 to 3, it is characterized in that, also comprise:
The first delete cells, when described data processing equipment cuts out, delete described detailed data temporary table and described analysis data temporary table.
5. according to the described data processing equipment of any one in claims 1 to 3, it is characterized in that, also comprise:
The second delete cells, when query page is closed, delete described detailed data temporary table and described analysis data temporary table.
6. a data processing method, is characterized in that, comprising:
Obtain the detailed data of document information according to the first querying condition of user;
By described detailed data buffer memory to the detailed data temporary table;
, generate and analyze data the cross processing of being divided into groups of described detailed data according to the second querying condition of described user, by described analysis data buffer storage to analyzing in the data temporary table;
Switching represents described detailed data temporary table and described analysis data temporary table.
7. data processing method according to claim 6, is characterized in that, described detailed data is kept in the detailed data temporary table according to the field classification.
8. data processing method according to claim 7, is characterized in that, the above second querying condition according to described user, to the cross processing of being divided into groups of described detailed data, generates the step of analyzing data and specifically comprises:
Described the second querying condition is resolved to SQL statement, carry out described SQL statement, described detailed data temporary table is processed, to obtain described analysis data.
9. according to the described data processing method of any one in claim 6 to 8, it is characterized in that, also comprise:
When management system is closed, delete described detailed data temporary table and described analysis data temporary table.
10. according to the described data processing method of any one in claim 6 to 8, it is characterized in that, also comprise:
When query page is closed, delete described detailed data temporary table and described analysis data temporary table.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310392597.4A CN103488693A (en) | 2013-09-02 | 2013-09-02 | Data processing device and data processing method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310392597.4A CN103488693A (en) | 2013-09-02 | 2013-09-02 | Data processing device and data processing method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN103488693A true CN103488693A (en) | 2014-01-01 |
Family
ID=49828919
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310392597.4A Pending CN103488693A (en) | 2013-09-02 | 2013-09-02 | Data processing device and data processing method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN103488693A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105653436A (en) * | 2015-12-31 | 2016-06-08 | 山东中创软件商用中间件股份有限公司 | Data displaying method and system |
CN106502672A (en) * | 2016-10-21 | 2017-03-15 | 用友网络科技股份有限公司 | A kind of method that document information is shown with different grain size |
CN109086279A (en) * | 2017-06-13 | 2018-12-25 | 北京京东尚科信息技术有限公司 | Caching report method and apparatus |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5864842A (en) * | 1995-10-23 | 1999-01-26 | Ncr Corporation | Optimization of SQL queries using hash star join operations |
CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
CN101593203A (en) * | 2009-05-12 | 2009-12-02 | 用友软件股份有限公司 | The database compound query system and method that has pre-treatment and aftertreatment |
CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
CN103207919A (en) * | 2013-04-26 | 2013-07-17 | 北京亿赞普网络技术有限公司 | Method and device for quickly inquiring and calculating MangoDB cluster |
-
2013
- 2013-09-02 CN CN201310392597.4A patent/CN103488693A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5864842A (en) * | 1995-10-23 | 1999-01-26 | Ncr Corporation | Optimization of SQL queries using hash star join operations |
CN1482766A (en) * | 2002-09-13 | 2004-03-17 | 华为技术有限公司 | Method for automatic generating of net management report form |
CN101860449A (en) * | 2009-04-09 | 2010-10-13 | 华为技术有限公司 | Data query method, device and system |
CN101593203A (en) * | 2009-05-12 | 2009-12-02 | 用友软件股份有限公司 | The database compound query system and method that has pre-treatment and aftertreatment |
CN103207919A (en) * | 2013-04-26 | 2013-07-17 | 北京亿赞普网络技术有限公司 | Method and device for quickly inquiring and calculating MangoDB cluster |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105653436A (en) * | 2015-12-31 | 2016-06-08 | 山东中创软件商用中间件股份有限公司 | Data displaying method and system |
CN106502672A (en) * | 2016-10-21 | 2017-03-15 | 用友网络科技股份有限公司 | A kind of method that document information is shown with different grain size |
CN109086279A (en) * | 2017-06-13 | 2018-12-25 | 北京京东尚科信息技术有限公司 | Caching report method and apparatus |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN109034993B (en) | Account checking method, account checking equipment, account checking system and computer readable storage medium | |
CN107918600B (en) | Report development system and method, storage medium and electronic equipment | |
CN106021260B (en) | The method and system of at least one relation schema is searched in product in multiple operations | |
JP2019532370A (en) | User authority data search method and electronic device | |
CN103678446B (en) | Improved mode map based on Data View and database table | |
CN110990390B (en) | Data cooperative processing method, device, computer equipment and storage medium | |
CN107273369B (en) | Table data modification method and device | |
CN106503274A (en) | A kind of Data Integration and searching method and server | |
CN112711581A (en) | Medical data verification method and device, electronic equipment and storage medium | |
US20140325405A1 (en) | Auto-completion of partial line pattern | |
Wainer et al. | How productivity and impact differ across computer science subareas | |
CN109408502A (en) | A kind of data standard processing method, device and its storage medium | |
US10628421B2 (en) | Managing a single database management system | |
CN111737364A (en) | Safe multi-party data fusion and federal sharing method, device, equipment and medium | |
CN103488693A (en) | Data processing device and data processing method | |
US20140122163A1 (en) | External operational risk analysis | |
US9141686B2 (en) | Risk analysis using unstructured data | |
US20180046669A1 (en) | Eliminating many-to-many joins between database tables | |
Ni et al. | Hadoop-based distributed computing algorithms for healthcare and clinic data processing | |
Peng | Statistical analysis of employee retention | |
CN110062112A (en) | Data processing method, device, equipment and computer readable storage medium | |
CN116244387A (en) | Entity relationship construction method, device, electronic equipment and storage medium | |
CN115357656A (en) | Information processing method and device based on big data and storage medium | |
US20140156339A1 (en) | Operational risk and control analysis of an organization | |
CN115543428A (en) | Simulated data generation method and device based on strategy template |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C41 | Transfer of patent application or patent right or utility model | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20160203 Address after: 100094 Beijing City, North Road, Haidian District, No. 68, building 2, floor 2 Applicant after: You Pu Information Technology Co., Ltd of UFSOFT Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Applicant before: UFIDA Software Co., Ltd. |
|
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140101 |
|
RJ01 | Rejection of invention patent application after publication |