CN101582138A - Dynamic business processing system and method - Google Patents
Dynamic business processing system and method Download PDFInfo
- Publication number
- CN101582138A CN101582138A CNA2009100873346A CN200910087334A CN101582138A CN 101582138 A CN101582138 A CN 101582138A CN A2009100873346 A CNA2009100873346 A CN A2009100873346A CN 200910087334 A CN200910087334 A CN 200910087334A CN 101582138 A CN101582138 A CN 101582138A
- Authority
- CN
- China
- Prior art keywords
- business
- database
- dynamic
- item
- business processing
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a dynamic business processing method, comprising: step 202, analyzing the attribute of business items which are needed to be added according to the need of the business; step 204, setting up the corresponding relation between the business items and table fields in a database; step 206, setting computing formulas and operation relations of the business items; step 208, resolving the computing formulas and the operation relations into SQL sentences in the operation of the database; and step 210, executing the SQL sentences and working out the result. By utilizing efficient SQL executive capability provided by the database, the logical relationship occurring in a business system is resolved, the problem that the number of information items in an information system is uncertain is solved, and the efficient operation of logical or arithmetic relation between the information items is realized.
Description
Technical field
The present invention relates to transaction processing system and method, relate more specifically to be applied to dynamic business processing system and method in wage system, the welfare system etc.
Background technology
Common dynamic service is used wage system, welfare system, attendance checking system, performance appraisal system etc. is arranged in the actual life.For example: uncertain (common wage project has the number of wage project: basic wage in the wage system of different enterprises, performance pay, travel allowance, income tax, the real total etc. of sending out), computation rule between the wage project is uncertain, and this is because the number that enterprise's size and participation wage calculate is uncertain.In general infosystem with dynamic service, be to adopt in the database physics table fixing processing mode such as reserved field mostly, cause system to expand dynamically.In addition, it also is by sequential operation that common dynamic service calculates, and perhaps part employing program is calculated, and part is calculated by the database SQL statement, and then is updated in the data Kuku of infosystem, and this way efficient under big data quantity can't guarantee.Calculate for dynamic service, the efficient of its calculating is guaranteed in expectation.
Summary of the invention
In order to solve the problems of the technologies described above, the invention provides a kind of dynamic business processing system, comprising: the business diagnosis module, be used for demand according to business, analyze the attribute of the business item that needs increase; Corresponding relation building module is used for setting up the corresponding relation between described business item and the database literary name section; Formula and operation relation are provided with module, are used to be provided with the computing formula and the operation relation of described business item; Formula and operation relation parsing module are used for described computing formula and described operation relation are resolved to the SQL statement of database operation; Computing module is used to carry out described SQL statement, calculates the result.
Wherein, dynamic business processing system is: wage system, welfare system, attendance checking system or performance appraisal system; And the attribute of business item comprises: data type, data length, precision.
Preferably, formula and operation relation are provided with the dependence that module also is used to be provided with described business item, and described dependence is used to judge the sequencing of described business item calculating; And computing module also is used for upgrading described SQL statement on described database.
According to a further aspect in the invention, also provide a kind of dynamic business processing method, having comprised: step 202, according to the demand of business, analyze the attribute of the business item that needs increase; Step 204 is set up the corresponding relation between the literary name section in described business item and the database; Step 206 is provided with the computing formula and the operation relation of described business item; Step 208 resolves to described computing formula and described operation relation the SQL statement of database operation; And step 210, carry out described SQL statement, calculate the result.
Wherein, dynamic business processing method is used for: wage system, welfare system, attendance checking system or performance appraisal system; And the attribute of business item comprises: data type, data length, precision.
Preferably, in described step 206, the dependence of described business item is set, described dependence is used to judge the sequencing of described business item calculating; And in described step 210, on described database, upgrade described SQL statement.
The method according to this invention and system, the efficient SQL executive capability of utilizing database to provide, solve the logical relation that occurs in the operation system, solved the uncertainty of item of information number in the infosystem, and realized the efficient computing of logical OR arithmetic relation between item of information and the item of information.
Description of drawings
Fig. 1 shows the block diagram according to dynamic business processing system of the present invention;
Fig. 2 shows the process flow diagram according to dynamic business processing method of the present invention;
Fig. 3 shows business item and database physics literary name section corresponding diagram according to an embodiment of the invention;
Fig. 4 shows the synoptic diagram of setting up operation relation according to an embodiment of the invention;
Fig. 5 shows the synoptic diagram that operation relation is set according to an embodiment of the invention; And
Fig. 6 shows the synoptic diagram of professional formula according to an embodiment of the invention.
Embodiment
Below in conjunction with description of drawings according to the specific embodiment of the present invention.
Fig. 1 shows according to dynamic business processing system of the present invention.As shown in Figure 1, dynamic business processing system 100 according to the present invention comprises: business diagnosis module 102, be used for demand according to business, and analyze the attribute of the business item that needs increase; Corresponding relation building module 104 is used for setting up the corresponding relation between described business item and the database literary name section; Formula and operation relation are provided with module 106, are used to be provided with the computing formula and the operation relation of described business item; Formula and operation relation parsing module 108 are used for described computing formula and described operation relation are resolved to the SQL statement of database operation; Computing module 110 is used to carry out described SQL statement, calculates the result.
Wherein, dynamic business processing system is: wage system, welfare system, attendance checking system or performance appraisal system; And the attribute of business item comprises: data type, data length, precision.
Preferably, formula and operation relation are provided with the dependence that module 108 also is used to be provided with described business item, and dependence is used to judge the sequencing of described business item calculating; And computing module 110 also is used for upgrading described SQL statement on described database.
Fig. 2 shows the process flow diagram according to dynamic business processing method of the present invention.As shown in Figure 2, in step 202,, analyze the attribute of the business item that needs increase according to the demand of business.Business item is exactly the item of information that participates in service logic in the infosystem, and as the basic wage in the wage system, performance pay etc., unit pays ratio in the welfare system, the individual pays ratio etc., the fate absent from duty in the attendance checking system, late number of times etc.The professional business item of calculating is uncertain in infosystem, that is to say dynamically to expand.In this step, analyze the attribute of the business item that needs increase, as: the data type of project, data length, information such as precision.Analyze business item, need to determine the business item of increase.
Proceed to step 204 then, set up the corresponding relation between the literary name section in described business item and the database.As shown in Figure 3, in this step, set up the dynamic one-to-one relationship of business item with field in the information system database physics table, promptly the data storage of which business item is to the field of database physics table.
In step 206, the computing formula and the operation relation of described business item is set.The sequencing of setting up the operation relation between each project in the system and determining according to the dependence between project to calculate according to professional implication analysis.Dependence is used for judging the precedence relationship that business item is calculated.Dependence is arranged by Automatic Program, the preferential calculating that is cited at first.Operation relation is exactly to obtain according to the formula that is provided with.As sending out total=basic wage+performance pay+bonus+subsidy in the wage system, dependence should be sent out exactly to add up to and rely on basic wage, performance pay, bonus and subsidy, the precedence relationship of calculating is exactly will calculate basic wage, performance pay, bonus and subsidy earlier to finish, and then calculates and should send out total.Fig. 4 and Fig. 5 show business item and database physics literary name section corresponding diagram according to an embodiment of the invention respectively; And the synoptic diagram of setting up operation relation according to an embodiment of the invention.
In step 208, described computing formula and described operation relation are resolved to the SQL statement of database operation.In this step, the professional formula as shown in Figure 6 of infosystem (for example the professional formula in the step 206: should send out total=basic wage+performance pay+bonus+subsidy) is resolved, by the corresponding relation of business item with Database field, the update SQL statement of the database update that foundation can be carried out by database.
In step 210, the SQL statement that obtains in the execution in step 208 calculates the result.In infosystem, calculating for business item generally all has subsidiary condition, also just say according to business scenario, as: the operator (promptly carries out the people of business operation, for example: be the user of wage system) data permission (that is: which business item is that the operator can carry out calculating) etc. in the wage system.These restrictive conditions are appended in the database update statement that forms in the step 208, what the user may calculate is not total data, but it is wherein a part of, the SQL statement that user's filtercondition and Formula Parsing need be come out is spliced into complete SQL statement, carries out SQL and calculate correct result in database.
To sum up, according to dynamic business processing method of the present invention and system, make business item become and to expand according to client's actual needs by the fixed qty in past.Business item organically can be combined with database by technical scheme of the present invention, make the mutual logical relation between project become the sql like language that database can be discerned.The efficient SQL executive capability of utilizing database to provide solves the logical relation that occurs in the operation system, has solved the uncertainty of item of information number in the infosystem, and has realized the efficient computing of logical OR arithmetic relation between item of information and the item of information.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a dynamic business processing system is characterized in that, comprising:
The business diagnosis module is used for the demand according to business, analyzes the attribute of the business item that needs increase;
Corresponding relation building module is used for setting up the corresponding relation between described business item and the database literary name section;
Formula and operation relation are provided with module, are used to be provided with the computing formula and the operation relation of described business item;
Formula and operation relation parsing module are used for described computing formula and described operation relation are resolved to the SQL statement of database operation;
Computing module is used to carry out described SQL statement, calculates the result.
2. dynamic business processing system according to claim 1 is characterized in that, the attribute of described business item comprises: data type, data length, precision.
3. dynamic business processing system according to claim 1 and 2 is characterized in that described formula and operation relation are provided with the dependence that module also is used to be provided with described business item, and described dependence is used to judge the sequencing of described business item calculating.
4. dynamic business processing system according to claim 1 and 2 is characterized in that, described computing module also is used for upgrading described SQL statement on described database.
5. dynamic business processing system according to claim 1 and 2 is characterized in that, described dynamic business processing system is: wage system, welfare system, attendance checking system or performance appraisal system.
6. a dynamic business processing method is characterized in that, comprising:
Step 202 according to the demand of business, is analyzed the attribute of the business item that needs increase;
Step 204 is set up the corresponding relation between the literary name section in described business item and the database;
Step 206 is provided with the computing formula and the operation relation of described business item;
Step 208 resolves to described computing formula and described operation relation the SQL statement of database operation;
Step 210 is carried out described SQL statement, calculates the result.
7. dynamic business processing method according to claim 6 is characterized in that, the attribute of described business item comprises: data type, data length, precision.
8. according to claim 6 or 7 described dynamic business processing method, it is characterized in that, in described step 206, the dependence of described business item is set, described dependence is used to judge the sequencing of described business item calculating.
9. according to claim 6 or 7 described dynamic business processing method, it is characterized in that, in described step 210, on described database, upgrade described SQL statement.
10. according to claim 6 or 7 described dynamic business processing method, it is characterized in that described dynamic business processing method is used for: wage system, welfare system, attendance checking system or performance appraisal system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100873346A CN101582138A (en) | 2009-06-23 | 2009-06-23 | Dynamic business processing system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100873346A CN101582138A (en) | 2009-06-23 | 2009-06-23 | Dynamic business processing system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101582138A true CN101582138A (en) | 2009-11-18 |
Family
ID=41364275
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2009100873346A Pending CN101582138A (en) | 2009-06-23 | 2009-06-23 | Dynamic business processing system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101582138A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102054232A (en) * | 2010-12-30 | 2011-05-11 | 用友软件股份有限公司 | Method and device for project management |
| CN104965923A (en) * | 2015-07-08 | 2015-10-07 | 安徽兆尹信息科技有限责任公司 | Cloud computing application platform building method for generating cash flow statement |
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN106886557A (en) * | 2016-12-28 | 2017-06-23 | 北京元心科技有限公司 | Patrol and examine assessment models adaptive approach and system |
| CN107103453A (en) * | 2017-04-28 | 2017-08-29 | 上海易路软件有限公司 | Public emolument computational methods and system |
| CN107480953A (en) * | 2017-08-17 | 2017-12-15 | 苏州浦瑞融网络科技有限公司 | A kind of wage settlement system |
| CN109299913A (en) * | 2018-08-27 | 2019-02-01 | 天津字节跳动科技有限公司 | Employee's wages scheme generation method and device |
| CN110362585A (en) * | 2019-06-19 | 2019-10-22 | 东软集团股份有限公司 | Data analysing method, device, storage medium and electronic equipment |
| CN112948400A (en) * | 2020-09-17 | 2021-06-11 | 深圳市明源云科技有限公司 | Database management method, database management device and terminal equipment |
-
2009
- 2009-06-23 CN CNA2009100873346A patent/CN101582138A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102054232A (en) * | 2010-12-30 | 2011-05-11 | 用友软件股份有限公司 | Method and device for project management |
| CN104965923A (en) * | 2015-07-08 | 2015-10-07 | 安徽兆尹信息科技有限责任公司 | Cloud computing application platform building method for generating cash flow statement |
| CN106201539A (en) * | 2016-07-18 | 2016-12-07 | 浪潮通用软件有限公司 | A kind of method realizing accounting item dynamic calculation in Star Model |
| CN106886557A (en) * | 2016-12-28 | 2017-06-23 | 北京元心科技有限公司 | Patrol and examine assessment models adaptive approach and system |
| CN107103453A (en) * | 2017-04-28 | 2017-08-29 | 上海易路软件有限公司 | Public emolument computational methods and system |
| CN107480953A (en) * | 2017-08-17 | 2017-12-15 | 苏州浦瑞融网络科技有限公司 | A kind of wage settlement system |
| CN109299913A (en) * | 2018-08-27 | 2019-02-01 | 天津字节跳动科技有限公司 | Employee's wages scheme generation method and device |
| CN110362585A (en) * | 2019-06-19 | 2019-10-22 | 东软集团股份有限公司 | Data analysing method, device, storage medium and electronic equipment |
| CN110362585B (en) * | 2019-06-19 | 2021-11-26 | 东软集团股份有限公司 | Data analysis method and device, storage medium and electronic equipment |
| CN112948400A (en) * | 2020-09-17 | 2021-06-11 | 深圳市明源云科技有限公司 | Database management method, database management device and terminal equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101582138A (en) | Dynamic business processing system and method | |
| US8886654B2 (en) | Infrastructure and architecture for development and execution of predictive models | |
| US10115058B2 (en) | Predictive modeling | |
| US8160913B2 (en) | Methods and tools to support strategic decision making by specifying, relating and analyzing requirements, solutions, and deployments | |
| EP2199905A1 (en) | Lifecycle management and consistency checking of object models using application platform tools | |
| Hu et al. | A model driven service engineering approach to system of systems | |
| Lin et al. | Empirical Evidence on Developer's Commit Activity for Open-Source Software Projects. | |
| CN117036062A (en) | Accounting resource calculation method and device | |
| Shen et al. | Vehicle scheduling based on variable trip times with expected on‐time performance | |
| CN115618825A (en) | Financial statement merging method and device, computer readable medium and terminal equipment | |
| CN112465363B (en) | Task management platform and method | |
| US20120317081A1 (en) | Detecting wasteful data collection | |
| de Barros Paes et al. | RUP extension for the software performance | |
| Ahsan et al. | Mining effort data from the oss repository of developer's bug fix activity | |
| Nilsson et al. | How to manage technical debt in a lean startup | |
| CN108764607A (en) | User month data reinspection method, apparatus, equipment and storage medium | |
| CN111680858B (en) | Method and device for managing service promotion policy and electronic equipment | |
| Godbout | Modernizing Statistics Canada’s Transportation Surveys | |
| CN114297184A (en) | State trade data processing method, device, equipment and medium | |
| Datla | Software Performance Workload Modelling | |
| Ivan et al. | Estimating the Complexity of IT Projects. | |
| Bernroider | Internal IT Control Systems and Global Regulation of Organizations: The Rise of Control Assemblages | |
| Shrestha et al. | A tool for IT service management process assessment for process improvement | |
| CN113947424A (en) | Intelligent bidding and quotation system | |
| Waheed et al. | Performance analysis of instrumentation system management policies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20091118 |