CN102354317A - Data generation device and method - Google Patents
Data generation device and method Download PDFInfo
- Publication number
- CN102354317A CN102354317A CN2011102845155A CN201110284515A CN102354317A CN 102354317 A CN102354317 A CN 102354317A CN 2011102845155 A CN2011102845155 A CN 2011102845155A CN 201110284515 A CN201110284515 A CN 201110284515A CN 102354317 A CN102354317 A CN 102354317A
- Authority
- CN
- China
- Prior art keywords
- data
- wage
- middle table
- user
- employee
- 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
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a data generation device which comprises a query condition setup module, an acquisition module, a processing module and a generation module, wherein the query condition setup module is used for setting query conditions; the acquisition module is used for acquiring employee information and auxiliary information from a database according to the set query conditions; the processing module is used for storing the employee information and the auxiliary information into an intermediate table, wherein the intermediate table is stored in the database; and the generation module is used for generating the numerical value of data according to the intermediate table. Accordingly, the invention also provides a data generation method. Through the technical scheme provided by the invention, the data processing process can be improved, the data processing efficiency can be increased, and the complexity of a data computing system can be reduced.
Description
Technical field
The present invention relates to the data generation technique, in particular to data generating device and method.
Background technology
Original payroll; Natural language need be converted into the payroll language; Be Structured Query Language (SQL) (Structure Query Language according to the payroll language conversion then; Be called for short sql like language); At last sql like language to be carried out in database. not enough below this account form exists: (1) payroll language conversion is a Structured Query Language (SQL); This transfer process more complicated causes payroll calculation system too fat to move, is difficult to safeguard; (2) will consider wage assistant director's data permission and the related personnel's scope of business rule, it is not high that the SQL statement after causing changing is carried out efficient, and the client is difficult to accept.
Therefore, need a kind of new data generation technique, can improve data handling procedure, improve data-handling efficiency, reduce the complicacy of data computation system.
Summary of the invention
The present invention just is being based on the problems referred to above, has proposed a kind of new data generation technique, can improve data handling procedure, improves data-handling efficiency, reduces the complicacy of data computation system.
In view of this, the present invention proposes a kind of data generating device, comprising: querying condition is provided with module, and querying condition is provided with; Acquisition module, the said querying condition according to set obtains employee information and supplementary from database; Processing module is stored to middle table with said employee information and said supplementary, and said middle table is stored in the said database; Generation module generates the numerical value of said data according to said middle table.In this technical scheme; The process of the numerical value through will generating the data that need obtain is divided into a plurality of steps; At first the information that possibly use in the generative process is generated a middle table; When then finally generating the numerical value of desired data; Needn't obtain in real time or the bulk information in database in inquire about; But directly utilize data volume to be significantly less than the middle table of database, thus improved generative process, improve formation efficiency.
In technique scheme, preferably, said supplementary comprises taxing information, and said taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And said data comprise: employee's wage.In this technical scheme, said apparatus can be used to generate employee's wage, and the information of required employee information of using and tax aspect etc. can generate middle table in advance in the generative process here, so that optimize generative process.Certainly, be construed as the numerical value that is not limited in generation " employee's wage ", every needs use the data generating procedure of intermediate information, all should adopt technical scheme provided by the invention.
In technique scheme, preferably, said supplementary also comprises: professional variable, said professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage; Said data generating device also comprises: setting module, and setting data create-rule, said generation module generate the numerical value of said data according to said data create-rule; The numerical value acquisition module when in said data create-rule, comprising said professional variable, utilizes preset professional variable to obtain the numerical value that rule is obtained said professional variable, and is stored in the said middle table.In this technical scheme; Can set corresponding rule to the generation of the numerical value of data; The rule here possibly be the language that generates this numerical value, condition etc.; Such as " length of service less than the employee in 5 years subsidy be wage 5% "; And in this rule; " length of service " possibly be a professional variable; Then need obtain the numerical value in corresponding " length of service "; Such as being " 8 "; At this moment do not satisfy above-mentioned rule, and should belong to Else Rule as " length of service greater than 5 years and less than the employee in 10 years subsidy be wage 10% ".
In technique scheme; Preferably; Also comprise: Registering modules; Be used for said user's registration; Generate and the unique corresponding user ID of said user; When making said user utilize said user ID to login said data generating device, obtain the data permission corresponding, and under said data permission, operate with said user ID.In this technical scheme; Each operation user needs registration in advance; And obtain with it corresponding unique ID; This ID is used for before operation, logining; And obtain with it corresponding operating right in login; Can only operate " the formal employee of Finance Department " such as employee A, rather than the employee of " Finance Department " and " the interim employee of Finance Department " etc. then do not have operating right.The setting of authority, it is managerial convenient to help.
In technique scheme, preferably, also comprise: removing module, behind the numerical value that generates said data, delete said employee information and said supplementary in the said middle table.In this technical scheme, after the generation of the numerical value of accomplishing data, can be with the data deletion in the middle table, because middle table is an intermediate data, be not that people hope the data paid close attention to; Simultaneously,, but do not delete for middle table with the deletion of intermediate data, but with the list storage of blank in database, save the space on the one hand, be convenient to later utilization once more on the other hand.
According to another aspect of the invention; A kind of data creation method has also been proposed; Comprise: step 202; Querying condition is set; To be stored to middle table according to employee information and the supplementary that said querying condition obtains from database; Said middle table is stored in the said database, and generates the numerical value of said data according to said middle table.In this technical scheme; Be divided into a plurality of steps through the process that will generate the data that need obtain; At first the information that possibly use in the generative process is generated a middle table; When then finally generating the numerical value of desired data; Needn't obtain in real time or the bulk information in database in inquire about; But directly utilize data volume to be significantly less than the middle table of database, thus improved generative process, improve formation efficiency.
In technique scheme, preferably, said supplementary comprises taxing information, and said taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And said data comprise: employee's wage.In this technical scheme, said apparatus can be used to generate employee's wage, and the information of required employee information of using and tax aspect etc. can generate middle table in advance in the generative process here, so that optimize generative process.Certainly, be construed as the numerical value that is not limited in generation " employee's wage ", every needs use the data generating procedure of intermediate information, all should adopt technical scheme provided by the invention.
In technique scheme, preferably, said supplementary also comprises: professional variable, said professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage; Also comprise before the said step 202: the setting data create-rule, when in said data create-rule, comprising said professional variable, utilize preset professional variable to obtain rule, obtain the numerical value of said professional variable, and be stored in the said middle table; And said step 202 specifically comprises: according to said middle table, and generate the numerical value of said data through said data create-rule.In this technical scheme; Can set corresponding rule to the generation of data; The condition here possibly be the language that generates data, condition etc.; Such as " length of service less than the employee in 5 years subsidy be wage 5% ", and in this rule, " length of service " possibly be a professional variable; Then need obtain the numerical value in corresponding " length of service "; Such as being " 8 ", at this moment do not satisfy above-mentioned rule, and should belong to Else Rule as " length of service greater than 5 years and less than the employee in 10 years subsidy be wage 10% ".
In technique scheme; Preferably, before said step 202, also comprise: use and login with the unique corresponding user ID of said user; Obtain the data permission corresponding, and under said data permission, carry out the operation of said step 202 with said user ID.In this technical scheme; Each operation user needs registration in advance; And obtain with it corresponding unique ID; This ID is used for before operation, logining; And obtain with it corresponding operating right in login; Can only operate " the formal employee of Finance Department " such as employee A, rather than the employee of " Finance Department " and " the interim employee of Finance Department " etc. then do not have operating right.The setting of authority, it is managerial convenient to help.
In technique scheme, preferably, after said step 202, also comprise said employee information and said supplementary in the said middle table of deletion.In this technical scheme, after the generation of the numerical value of accomplishing data, can be with the data deletion in the middle table, because middle table is an intermediate data, be not that people hope the data paid close attention to; Simultaneously,, but do not delete for middle table with the deletion of intermediate data, but with the list storage of blank in database, save the space on the one hand, be convenient to later utilization once more on the other hand.
Through above technical scheme, can improve data handling procedure, improve data-handling efficiency, reduce the complicacy of data computation system.
Description of drawings
Fig. 1 shows the block diagram of data generating device according to an embodiment of the invention;
Fig. 2 shows the process flow diagram of data creation method according to an embodiment of the invention;
Fig. 3 shows the schematic flow diagram that generates data according to an embodiment of the invention; And
Fig. 4 shows the particular flow sheet that generates data according to an embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with accompanying drawing and embodiment.
Set forth a lot of details in the following description so that make much of the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following disclosed specific embodiment.
Fig. 1 shows the block diagram of data generating device according to an embodiment of the invention.
As shown in Figure 1, data generating device 100 comprises according to an embodiment of the invention: querying condition is provided with module 102, and querying condition is provided with; Acquisition module 104 according to set querying condition, obtains employee information and supplementary from database; Processing module 106 is stored to middle table with employee information and supplementary, and middle table is stored in the database; Generation module 108 is according to the numerical value of middle table generation data; Setting module 110, setting data create-rule, generation module 108 generate the numerical value of data according to the data create-rule; Numerical value acquisition module 112 when in the data create-rule, comprising professional variable, utilizes preset professional variable to obtain the numerical value that rule is obtained professional variable, and is stored in the middle table; Registering modules 114 is used for user's registration, generates and the unique corresponding user ID of user, when making the user utilize user ID logon data generating apparatus 100, obtains the data permission corresponding with user ID, and under data permission, operates; Removing module 116, behind the numerical value that generates data, employee information and supplementary in the deletion middle table.In this technical scheme; The process of the numerical value through will generating the data that need obtain is divided into a plurality of steps; At first the information that possibly use in the generative process is generated a middle table; When then finally generating the numerical value of desired data; Needn't obtain in real time or the bulk information in database in inquire about; But directly utilize data volume to be significantly less than the middle table of database, thus improved generative process, improve formation efficiency.
In technique scheme, supplementary comprises taxing information, and taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And data comprise: employee's wage.In this technical scheme, said apparatus 100 can be used to generate employee's wage, and the information of required employee information of using and tax aspect etc. can generate middle table in advance in the generative process here, so that optimize generative process.Certainly, be construed as the numerical value that is not limited in generation " employee's wage ", every needs use the data generating procedure of intermediate information, all should adopt technical scheme provided by the invention.
In technique scheme, supplementary also comprises: professional variable, professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage.In this technical scheme; Can set corresponding rule to the generation of the numerical value of data; The rule here possibly be the language that generates this numerical value, condition etc.; Such as " length of service less than the employee in 5 years subsidy be wage 5% "; And in this rule; " length of service " possibly be a professional variable; Then need obtain the numerical value in corresponding " length of service "; Such as being " 8 "; At this moment do not satisfy above-mentioned rule, and should belong to Else Rule as " length of service greater than 5 years and less than the employee in 10 years subsidy be wage 10% ".
In this technical scheme; Each operation user needs registration in advance; And obtain with it corresponding unique ID; This ID is used for before operation, logining; And obtain with it corresponding operating right in login; Can only operate " the formal employee of Finance Department " such as employee A, rather than the employee of " Finance Department " and " the interim employee of Finance Department " etc. then do not have operating right.The setting of authority, it is managerial convenient to help.
In this technical scheme, after the generation of the numerical value of accomplishing data, can be with the data deletion in the middle table, because middle table is an intermediate data, be not that people hope the data paid close attention to; Simultaneously,, but do not delete for middle table with the deletion of intermediate data, but with the list storage of blank in database, save the space on the one hand, be convenient to later utilization once more on the other hand.
Fig. 2 shows the process flow diagram of data creation method according to an embodiment of the invention.
As shown in Figure 2; Data creation method comprises according to an embodiment of the invention: step 202; Querying condition is set; To be stored to middle table according to employee information and the supplementary that querying condition obtains from database; Middle table is stored in the said database, and generates the numerical value of data according to middle table.In this technical scheme; Be divided into a plurality of steps through the process that will generate the data that need obtain; At first the information that possibly use in the generative process is generated a middle table; When then finally generating the numerical value of desired data; Needn't obtain in real time or the bulk information in database in inquire about; But directly utilize data volume to be significantly less than the middle table of database, thus improved generative process, improve formation efficiency.
In technique scheme, supplementary comprises taxing information, and said taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And data comprise: employee's wage.In this technical scheme, said apparatus can be used to generate employee's wage, and the information of required employee information of using and tax aspect etc. can generate middle table in advance in the generative process here, so that optimize generative process.Certainly, be construed as the numerical value that is not limited in generation " employee's wage ", every needs use the data generating procedure of intermediate information, all should adopt technical scheme provided by the invention.
In technique scheme, supplementary also comprises: professional variable, professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage; Before step 202, also comprise: the setting data create-rule, when in the data create-rule, comprising professional variable, utilize preset professional variable to obtain rule, obtain the numerical value of professional variable, and be stored in the middle table; And step 202 specifically comprises: according to middle table, and pass through the numerical value that the data create-rule generates data.In this technical scheme; Can set corresponding rule to the generation of data; The rule here possibly be the language that generates data, condition etc.; Such as " length of service less than the employee in 5 years subsidy be wage 5% ", and in this rule, " length of service " possibly be a professional variable; Then need obtain the numerical value in corresponding " length of service "; Such as being " 8 ", at this moment do not satisfy above-mentioned rule, and should belong to Else Rule as " length of service greater than 5 years and less than the employee in 10 years subsidy be wage 10% ".
In technique scheme, before step 202, also comprise: use and login, obtain the data permission corresponding, and under data permission, carry out the operation of step 202 with user ID with the unique corresponding user ID of user.In this technical scheme; Each operation user needs registration in advance; And obtain with it corresponding unique ID; This ID is used for before operation, logining; And obtain with it corresponding operating right in login; Can only operate " the formal employee of Finance Department " such as employee A, rather than the employee of " Finance Department " and " the interim employee of Finance Department " etc. then do not have operating right.The setting of authority, it is managerial convenient to help.
In technique scheme, after step 202, also comprise employee information and supplementary in the deletion middle table.In this technical scheme, after the generation of the numerical value of accomplishing data, can be with the data deletion in the middle table, because middle table is an intermediate data, be not that people hope the data paid close attention to; Simultaneously,, but do not delete for middle table with the deletion of intermediate data, but with the list storage of blank in database, save the space on the one hand, be convenient to later utilization once more on the other hand.
Fig. 3 shows the schematic flow diagram that generates data according to an embodiment of the invention.
As shown in Figure 3, be to utilize technique scheme to carry out the process of employee's payroll, step is following:
For the step among Fig. 3, carry out bright specifically below in conjunction with Fig. 4.
Fig. 4 shows the particular flow sheet that generates data according to an embodiment of the invention.
As shown in Figure 4, concrete steps are following:
Department privilege: the employee that can only calculate " Finance Department " and " Human Resource Department ";
Employee's classification authority: the wage that can only calculate " formal employee ".
If " subsidize so the length of service＞=10 is basic wage * 15%;
If the length of service＞=5 and the length of service＜10, subsidy is basic wage * 10% so;
If subsidize so the length of service＜5 is basic wage * 5%.”
Need change according to table 1:
| Business description | Machine language |
| The length of service | workage |
| Subsidy | wage.allowance |
| Basic wage | wage.basesalary |
| If | if |
| So | then |
| And | && |
| Be | ＝ |
Table 1
According to table 1, just can obtain corresponding payroll language so:
if?workage＞＝10，then?wage.allowance＝wage.basesalary*15％；
if?workage＞＝5?&&?workage＜10?then?wage.allowance＝wage.basesalary*10％；
if?workage＜5，then?wage.allowance＝wage.basesalary*5％，
Judge whether comprise professional variable in the above-mentioned language,, then directly get into step 412, as comprise, then get into step 410 as not comprising;
Step 412 is resolved the wage language and is carried out, and obtains the data that the user wants to obtain such as the numerical value of wage, i.e. each employee wage number that should obtain.
For in the above-mentioned steps for the utilization of middle table, can through between the following data language to recently describing:
At first be the sql like language when not using middle table:
The employee of // the length of service＞=10
update?wage?set?wage.allowance＝wage.basesalary*15％
Where/* add the restriction * of the length of service＞=10/(extract (year from to_date (' current system data ', ' yyyy-mm-dd '))-extract (year from to_date (' work the date ', ' yyyy-mm-dd ')))＞=10
/ * adds department privilege restriction */and wage.deptid in (select distinct power.resource_data_id from sm_power_deptdoc power where power.pk_role in (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk '))
/ * adds personnel's classification authority restriction */and wage.psnclid in ((select distinct power.resource_data_id from sm_power_psncl power where power.pk_role in (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk ')))
The employee of // 10＞length of service＞=5
update?wage?set?wage.allowance＝wage.basesalary*10％
Where/* add the restriction * of 10＞length of service＞=5/(extract (year from to_date (' current system data ', ' yyyy-mm-dd '))-extract (year from to_date (' work the date ', ' yyyy-mm-dd ')))＞=5
And (extract (year from to_date (' current system data ', ' yyyy-mm-dd '))-extract (year from to_date (' work the date ', ' yyyy-mm-dd ')))＜10
/ * adds department privilege restriction */and wage.deptid in ((select distinct power.resource_data_id from sm_power_deptdoc power where power.pk_rolein (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk '))
/ * adds personnel's classification authority restriction */and wage.psnclid in ((select distinct power.resource_data_id from sm_power_psncl power where power.pk_role in (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk ')))
The employee of // the length of service＜5
update?wage?set?wage.allowance＝wage.basesalary*5％
The restriction * of the where/* length of service＜5/(extract (year from to_date (' current system data ', ' yyyy-mm-dd '))-extract (year from to_date (' work the date ', ' yyyy-mm-dd ')))＜5
/ * adds department privilege restriction */and wage.deptid in ((select distinct power.resource_data_id from sm_power_deptdoc power where power.pk_role in (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk '))
/ * adds personnel's classification authority restriction */and wage.psnclid in ((select distinct power.resource_data_id from sm_power_psncl power where power.pk_role in (select pk_role from sm_user_role where sm_user_role.cuserid=' active user pk ')))
Annotate: wage---wage deposit data table
Sm_user---subscriber's meter
Sm_user_role---user role relation table
Sm_power_deptdoc---department privilege table
Sm_power_psncl---personnel's classification authority list
And after having used middle table, corresponding sql like language has then been simplified much relatively:
The employee of // the length of service＞=10
update?wage?set?wage.allowance＝wage.basesalary*15％
where?wage.pk_psn?in(select?midname.pk_psn?from?midname?where?midname.workage＞＝10)
The employee of // 10＞length of service＞=5
update?wage?set?wage.allowance＝wage.basesalary*10％
where?wage.pk_psn?in(select?midname.pk_psn?from?midname?where?midname.workage＞＝5?and?midname.workage＜10)
The employee of // the length of service＜5
update?wage?set?wage.allowance＝wage.basesalary*5％
where?wage.pk_psn?in(select?midname.pk_psn?from?midname?where?midname.workage＜5)
Through the contrast of above-mentioned sql like language, middle table has been used in visible this conversion, has following advantage:
All calculate in advance each employee's the length of service, can directly use.Needn't repeat to add the SQL fragment in the length of service;
Middle table has been stored this and has been calculated all employees of firewood, has just confined this and has calculated the data permission of firewood, so no longer add the restriction of data permission;
SQL after the conversion just uses 2 tables (table 1 and middle table), so transfer process is simple, the SQL statement after the conversion is also very simple;
Data volume is little in the middle table, only writes down this and calculates employee's record of being concerned about.So it is high especially that SQL carries out efficient.
Therefore, arranged the computational data preparatory stage, payroll process is significantly optimized, and is mainly reflected in the following aspects:
The data permission constraint of SQL statement has been simplified: system only needs related middle table just can the expression data authority to retrain, if there is not middle table, then need spell responsible SQL statement, related a plurality of tables of data (generally comprising authority list, subscriber's meter etc.);
Improve counting yield: at first SQL statement is simplified, and contingency table reduces, and has directly improved the counting yield of SQL statement; In addition, middle table also write down many can reusable results of intermediate calculations, such as: age, the length of service, department age, taxing mode etc.; Data volume is little in the most important middle table, only writes down this and calculates employee's record of being concerned about, so it is high to carry out efficient;
Reduce the parsing difficulty of payroll formula, reduced the complexity of payroll calculation system: for example: be payroll item of information commonly used the length of service.If there is not middle table, show as the SQL fragment of a complicacy length of service, if middle table is arranged, just show as a field in the middle table length of service, thereby reduced the difficulty of Formula Parsing.
In addition, can also pass through in the following table 2, be practical test result, can be for reference:
Table 2
Visible by table 2, after having used numerical procedure provided by the invention, on the efficient that data generate, promoted more than 80%, effectively shortened the rise time.
More than be described with reference to the accompanying drawings technical scheme of the present invention; Consider in the data such as wage generative process under the prior art; The Structured Query Language (SQL) transfer process is complicated, causes payroll calculation system too fat to move, is difficult to safeguard; And it is not high that the SQL statement after the conversion is carried out efficient; Therefore, through technical scheme provided by the invention, can improve data handling procedure; Improve data-handling efficiency, reduce the complicacy of data computation system.
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.All within spirit of the present invention and principle, 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 data generating device is characterized in that, comprising:
Querying condition is provided with module, and querying condition is provided with;
Acquisition module, the said querying condition according to set obtains employee information and supplementary from database;
Processing module is stored to middle table with said employee information and said supplementary, and said middle table is stored in the said database;
Generation module generates the numerical value of said data according to said middle table.
2. data generating device according to claim 1 is characterized in that said supplementary comprises taxing information, and said taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And
Said data comprise: employee's wage.
3. data generating device according to claim 2 is characterized in that, said supplementary also comprises: professional variable, said professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage;
Said data generating device also comprises: setting module, and setting data create-rule, said generation module generate the numerical value of said data according to said data create-rule;
The numerical value acquisition module when in said data create-rule, comprising said professional variable, utilizes preset professional variable to obtain the numerical value that rule is obtained said professional variable, and is stored in the said middle table.
4. according to each described data generating device in the claim 1 to 3; It is characterized in that; Also comprise: Registering modules; Be used for said user's registration; Generate and the unique corresponding user ID of said user; When making said user utilize said user ID to login said data generating device, obtain the data permission corresponding, and under said data permission, operate with said user ID.
5. according to each described data generating device in the claim 1 to 3, it is characterized in that, also comprise: removing module, behind the numerical value that generates said data, delete said employee information and said supplementary in the said middle table.
6. a data creation method is characterized in that, comprising:
Step 202 is provided with querying condition, will be stored to middle table according to employee information and the supplementary that said querying condition obtains from database, and said middle table is stored in the said database, and generates the numerical value of said data according to said middle table.
7. data creation method according to claim 6 is characterized in that said supplementary comprises taxing information, and said taxing information comprises taxing mode, tax rate schedule, detains tax base number and/or detained tax; And
Said data comprise: employee's wage.
8. data creation method according to claim 7 is characterized in that, said supplementary also comprises: professional variable, said professional variable comprise during age, the length of service, department age, the wage fate of working during calendar fate and/or the wage;
Also comprise before the said step 202: the setting data create-rule, when in said data create-rule, comprising said professional variable, utilize preset professional variable to obtain rule, obtain the numerical value of said professional variable, and be stored in the said middle table; And
Said step 202 specifically comprises: according to said middle table, and generate the numerical value of said data through said data create-rule.
9. according to claim 6 or 8 described data creation methods; It is characterized in that; Before said step 202; Also comprise: use and login with the unique corresponding user ID of said user; Obtain the data permission corresponding, and under said data permission, carry out the operation of said step 202 with said user ID.
10. data creation method according to claim 6 is characterized in that, after said step 202, also comprises said employee information and said supplementary in the said middle table of deletion.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102845155A CN102354317A (en) | 2011-09-22 | 2011-09-22 | Data generation device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102845155A CN102354317A (en) | 2011-09-22 | 2011-09-22 | Data generation device and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102354317A true CN102354317A (en) | 2012-02-15 |
Family
ID=45577882
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011102845155A Pending CN102354317A (en) | 2011-09-22 | 2011-09-22 | Data generation device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102354317A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105786956A (en) * | 2016-01-08 | 2016-07-20 | 国家电网公司 | Power business data mining method based on business application system |
| CN106897139A (en) * | 2015-12-21 | 2017-06-27 | 北京奇虎科技有限公司 | A kind for the treatment of method and apparatus of business datum |
| CN108428104A (en) * | 2018-01-03 | 2018-08-21 | 平安科技（深圳）有限公司 | Wages computational methods, application server and computer readable storage medium |
| CN108984547A (en) * | 2017-05-31 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of data processing |
| CN109408576A (en) * | 2018-10-24 | 2019-03-01 | 江苏税软软件科技有限公司 | A kind of method that general wage data import and count calculating |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101694661A (en) * | 2009-10-22 | 2010-04-14 | 中兴通讯股份有限公司 | Method and device for generating statistical form and statistical server |
-
2011
- 2011-09-22 CN CN2011102845155A patent/CN102354317A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101694661A (en) * | 2009-10-22 | 2010-04-14 | 中兴通讯股份有限公司 | Method and device for generating statistical form and statistical server |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897139A (en) * | 2015-12-21 | 2017-06-27 | 北京奇虎科技有限公司 | A kind for the treatment of method and apparatus of business datum |
| CN105786956A (en) * | 2016-01-08 | 2016-07-20 | 国家电网公司 | Power business data mining method based on business application system |
| CN108984547A (en) * | 2017-05-31 | 2018-12-11 | 北京京东尚科信息技术有限公司 | The method and apparatus of data processing |
| CN108428104A (en) * | 2018-01-03 | 2018-08-21 | 平安科技（深圳）有限公司 | Wages computational methods, application server and computer readable storage medium |
| CN109408576A (en) * | 2018-10-24 | 2019-03-01 | 江苏税软软件科技有限公司 | A kind of method that general wage data import and count calculating |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107544984A (en) | A kind of method and apparatus of data processing | |
| CN102354317A (en) | Data generation device and method | |
| JP5624674B2 (en) | How to improve queries for searching databases | |
| CN109784689B (en) | Power grid infrastructure project report data processing method | |
| CN105989076A (en) | Data statistical method and device | |
| CN101859303A (en) | Metadata management method and management system | |
| CN110851667A (en) | Integrated analysis method and tool for multi-source large data | |
| US20120158714A1 (en) | Storage and searching of temporal entity information | |
| WO2019095670A1 (en) | Sales performance tracking method, application server and computer-readable storage medium | |
| CN103235811A (en) | Data storage method and device | |
| CN111126809A (en) | Guard duty scheduling method and system | |
| CN103944964A (en) | Distributed system and method carrying out expansion step by step through same | |
| CN113626527A (en) | Financial data processing method and system | |
| CN104182826A (en) | A method and an apparatus for processing allocation data | |
| CN102208061A (en) | Data cancel after verification processing device and method | |
| CN112214536B (en) | Enterprise account data real-time import management system | |
| US20230079825A1 (en) | Systems, methods, and user interfaces in a patent management system | |
| CN114997109A (en) | Receipt conversion method and device, computer equipment and storage medium | |
| CN104572739A (en) | Stock query method | |
| CN103336865A (en) | Dynamic communication network construction method and device | |
| CN106933784A (en) | Entity conversion method and system based on ECP | |
| CN106651559A (en) | Method for automatically generating financial data through terminal submission | |
| CN111399838A (en) | Data modeling method and device based on spark SQ L and materialized view | |
| CN110597899B (en) | Project expense management method and system | |
| CN117273720B (en) | High-performance extensible metering and charging service platform |
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: 20120215 |