CN110471912A - A kind of employee's attribute information method of calibration, device and terminal device - Google Patents
A kind of employee's attribute information method of calibration, device and terminal device Download PDFInfo
- Publication number
- CN110471912A CN110471912A CN201910667523.4A CN201910667523A CN110471912A CN 110471912 A CN110471912 A CN 110471912A CN 201910667523 A CN201910667523 A CN 201910667523A CN 110471912 A CN110471912 A CN 110471912A
- Authority
- CN
- China
- Prior art keywords
- employee
- attribute
- information
- attribute information
- headcount
- 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.)
- Granted
Links
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- 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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of employee's attribute information method of calibration, device and terminal devices, are suitable for technical field of data processing, this method comprises: obtaining the attribute information and position level of every employee in database to be verified;Judge whether the corresponding headcount of every kind of job information is in corresponding default headcount range, and judges whether the ratio between the corresponding headcount of every kind of position level meets preset distributed number ratio;The first kind attribute tags that every employee of type identification based on information each in attribute information has, and the corresponding second generic attribute label of every employee is inquired according to attribute mapping table;Judge in the attribute information of every employee whether include corresponding second generic attribute label information;If three judging results are to meet, determine that data of attribute information is completely errorless.The embodiment of the present invention realizes the rapid verification to employee's data of attribute information integrality after migration merging.
Description
Technical field
The invention belongs to technical field of data processing more particularly to employee's attribute information method of calibration and terminal devices.
Background technique
In practical application, the different attribute information of employee is often arrived among each different database by a point storage, example
As the basic personal information of employee, tenure record, attendance information and performance information may be stored to 4 different numbers
Among library, when carrying out aggregation process to employee's all properties information, need the user that will be stored in each database each
Attribute information carries out migration merging.
It is final to need to migrate combined employee since headcount is more and employee's attribute information is more in actual conditions
The data volume of attribute information is larger, so that being extremely easy to appear data loss problem in migration merging process, loses main
Loss including the entire attribute information of some employees should such as have the attribute information of 1000 employees, but be lost 10 after merging
The attribute information of name employee, so that the attribute information of final only remaining 990 employees and some employee's attribute informations
Partial loss, as the attendance information in employee's A attribute information is lost, it is therefore desirable to believe employee's attribute in database after merging
Breath carries out completeness check, to have found that it is likely that existing data loss problem in time.
It is all that raw data base and data after merging are being compared by technical staff manually after migration merges in the prior art
The data in library judge that whether complete employee's data of attribute information is errorless, and efficiency is very low.
Summary of the invention
In view of this, the embodiment of the invention provides a kind of employee's attribute information method of calibration and terminal device, to solve
In the prior art to employee's data of attribute information integrity checking method inefficiency after migration merging the problem of.
The first aspect of the embodiment of the present invention provides a kind of employee's attribute information method of calibration, comprising:
The attribute information of every employee in database to be verified is obtained, and is looked into according to the job information in the attribute information
Ask the position level of employee;
Judge whether the corresponding headcount of every kind of job information is in corresponding default headcount range, and sentences
Whether the ratio between the corresponding headcount of every kind of position level of breaking meets preset distributed number ratio;
Preset attribute mapping table is obtained, there are many first generic attribute marks for record in the attribute mapping table
Label and the interdependent one or more second generic attribute labels of every kind of first kind attribute tags;Based in the attribute information
The first kind attribute tags that every employee of type identification of each information has, and inquired often according to the attribute mapping table
The corresponding second generic attribute label of position employee;
Judge in the attribute information of every employee whether include the corresponding second generic attribute label information;
If the corresponding headcount of every kind of job information is in corresponding default headcount range, every kind of position layer
The corresponding headcount of grade meets preset distributed number ratio, and includes corresponding institute in the attribute information of every employee
The information for stating the second generic attribute label determines that the data of attribute information is completely errorless.
The second aspect of the embodiment of the present invention provides a kind of employee's attribute information calibration equipment, comprising:
Data obtaining module, for obtaining the attribute information of every employee in database to be verified, and according to the attribute
The position level of job information inquiry employee in information;
Quantity discrimination module, for judging whether the corresponding headcount of every kind of job information is in corresponding default
Headcount range, and judge whether the ratio between the corresponding headcount of every kind of position level meets preset distributed number
Ratio;
Tag queries module, for obtaining preset attribute mapping table, recording in the attribute mapping table has
A variety of first kind attribute tags and the interdependent one or more second generic attribute labels of every kind of first kind attribute tags;Base
The first kind attribute tags that every employee of the type identification of each information has in the attribute information, and according to the attribute
Mapping table inquires the corresponding second generic attribute label of every employee;
Whether information detecting module includes corresponding second class in the attribute information for judging every employee
The information of attribute tags;
First complete detection module, if being in corresponding default member for the corresponding headcount of every kind of job information
Work quantitative range, the corresponding headcount of every kind of position level meet preset distributed number ratio, and every employee's is described
Include the information of the corresponding second generic attribute label in attribute information, determines that the data of attribute information is completely errorless.
The third aspect of the embodiment of the present invention provides a kind of terminal device, and the terminal device includes memory, processing
Device, the computer program that can be run on the processor is stored on the memory, and the processor executes the calculating
The step of employee's attribute information method of calibration as described above is realized when machine program.
The fourth aspect of the embodiment of the present invention provides a kind of computer readable storage medium, comprising: is stored with computer
Program, which is characterized in that the computer program realizes employee's attribute information as described above verification side when being executed by processor
The step of method.
Existing beneficial effect is the embodiment of the present invention compared with prior art: the embodiment of the present invention is from whole level and carefully
Two aspect of ganglionic layer face carries out completeness check to the attribute information of employee in database after merging, specifically, being based on position group
The headcount ratio of the headcount range of each position and each position level in stretching frame structure, to the attribute of all employees
Information carries out whole verification, so that when the attribute information for employee occur all is lost, without carrying out a large amount of data analysis, only
Quantity statistics need to simply be carried out can find all the case where losing in time, and level of detail, it is contemplated that different attribute letters
There is certain logic dependence between breath, based on the dependence between attribute information, first determine to need it is interdependent its
First kind attribute tags existing for his attribute information ability, then whether search in database in the attribute information of employee comprising first
The information of the second interdependent generic attribute label of generic attribute label, then illustrates that these attribute informations are normal presences if it exists,
To realize to the whether complete rapid verification of the attribute information of every employee, without carrying out complicated data processing operation,
It finally verifies in whole level and level of detail without mistaking, determines that attribute information is completely errorless in database, to realize
The rapid verification of employee's data of attribute information integrality after merging to migration.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to embodiment or description of the prior art
Needed in attached drawing be briefly described, it should be apparent that, the accompanying drawings in the following description is only of the invention some
Embodiment for those of ordinary skill in the art without any creative labor, can also be according to these
Attached drawing obtains other attached drawings.
Fig. 1 is the implementation process schematic diagram for employee's attribute information method of calibration that the embodiment of the present invention one provides;
Fig. 2 is the implementation process schematic diagram of employee's attribute information method of calibration provided by Embodiment 2 of the present invention;
Fig. 3 is the implementation process schematic diagram for employee's attribute information method of calibration that the embodiment of the present invention three provides;
Fig. 4 is the implementation process schematic diagram for employee's attribute information method of calibration that the embodiment of the present invention four provides;
Fig. 5 is the structural schematic diagram for employee's attribute information calibration equipment that the embodiment of the present invention five provides;
Fig. 6 is the schematic diagram for the terminal device that the embodiment of the present invention six provides.
Specific embodiment
In being described below, for illustration and not for limitation, the tool of such as particular system structure, technology etc is proposed
Body details, to understand thoroughly the embodiment of the present invention.However, it will be clear to one skilled in the art that there is no these specific
The present invention also may be implemented in the other embodiments of details.In other situations, it omits to well-known system, device, electricity
The detailed description of road and method, in case unnecessary details interferes description of the invention.
In order to illustrate technical solutions according to the invention, the following is a description of specific embodiments.
To facilitate the understanding of the present invention, first the embodiment of the present invention is briefly described herein, due to right in actual conditions
Merge in employee's attribute information migration of big data quantity and loss of data easily occur, regardless of being that the entire attribute information of employee is lost
Or part attribute is lost, and can all cause the employee's data of attribute information finally merged imperfect, in order to carry out to merging data
Completeness check is all the data for comparing original database and merging data library manually by technical staff in the prior art, to judge
Whether employee's data of attribute information is complete, but faces employee's attribute information of big data quantity, and manual comparison efficiency is low and easily goes out
It is wrong.
In view of in actual conditions, on the one hand, for each company, the headcount of each professional level in organizational structure
It is that can know in advance and relatively-stationary, on the other hand, employee's attribute information itself has certain particularity, different categories
Property information between there is certain logic dependence, such as employee must have basic personal information could illustrate that it is tangible
The normal employee of company could have subsequent tenure record, attendance information and performance information etc., be based on these practical feelings
Condition, in the embodiment of the present invention from terms of whole level and level of detail two to merging after in database the attribute information of employee carry out
Completeness check, specifically, the embodiment of the present invention passes through category since attribute information itself includes the job information of employee
Property information counts each position headcount, headcount range and each duty based on each position in position organizational structure
The headcount ratio of position level carries out whole verification to the attribute data of all employees, so that when the attribute letter for employee occur
When breath is all lost, without carrying out a large amount of data analysis, only need to simply carry out quantity statistics can find all to lose in time
The case where mistake, and level of detail, it is contemplated that there is certain logic dependence between different attribute informations, be based on attribute
Dependence between information is first determined to need first kind attribute tags existing for other interdependent attribute information ability, then is looked into
Look in database in the attribute information of employee whether the information comprising the second interdependent generic attribute label of first kind attribute tags,
Then illustrate that these attribute informations are normal presences if it exists, to realize whether complete to the attribute information of every employee fast
Speed verification finally verifies without mistaking in whole level and level of detail, determines without carrying out complicated data processing operation
Attribute information is completely errorless in database, to realize the quick school to employee's data of attribute information integrality after migration merging
It tests.Details are as follows:
Fig. 1 shows the implementation flow chart of employee's attribute information method of calibration of the offer of the embodiment of the present invention one, is described in detail such as
Under:
S101 obtains the attribute information of every employee in database to be verified, and according to the job information in attribute information
Inquire the position level of employee.
S102, judges whether the corresponding headcount of every kind of job information is in corresponding default headcount model
It encloses, and judges whether the ratio between the corresponding headcount of every kind of position level meets preset distributed number ratio.
Wherein, database to be verified is to obtain after carrying out migration merging to employee's data of attribute information in raw data base
The database arrived.
Since for each company, company's total staff number amount and the corresponding headcount of each position all may be used
It can change in real time, therefore the practical headcount for including and position situation when merging can not be predicted in advance, it is difficult in advance
Set employee's position and corresponding list, but for company its employee's position organizational structure be generally it is constant, that is, set up
Hierarchical relationship and each position level headcount distribution proportion between how many kinds of position, position etc. be it is relatively-stationary,
For example, president, general manager's grade, Zong Jianji, supervisor's grade and common employee can be set up, totally 5 position levels, and it is set
A length of 1 people of middle director, 1~5 people of general manager's grade, chief inspector's grade 10~15, supervisor's grade 20~30 and common 100 or more employee, together
When each level headcount distribution proportion is arranged is president: general manager's grade be 1:3~5, general manager's grade: chief inspector's grade for 1:3~
5, Zong Jianji: supervisor's grade is 1:2~3, Zhu Guanji: common employee is 1:5~10.Therefore in embodiments of the present invention, preparatory meeting
Corresponding organizational structure data are set for company actual situation to be verified, or based on raw data base to company to be verified
Organizational structure data analyzed, obtain belonging to the corresponding headcount range of every kind of job information, every kind of job information
Position level and the corresponding headcount of every kind of position level.On the basis of getting required organizational structure data, this
Inventive embodiments can count the corresponding headcount of every kind of job information according to the job information in attribute information first, and unite
The corresponding headcount of every kind of position level is counted, then the data in the real data counted and organizational structure data are compared
It is right, judge whether the corresponding headcount of every kind of job information meets corresponding headcount area requirement, while judging reality
Headcount ratio in data between position level, if meet distributed number ratio in organizational structure data, if satisfied, then
Illustrate that the case where all losing does not occur in whole level employee attribute information in database to be verified.Wherein, if some position
Level exists simultaneously in multiple proportionate relationships two-by-two in distributed number ratio, such as in examples detailed above, and general manager's grade is simultaneously
It is present among " president: general manager's grade is 1:3~5 " and " general manager's grade: chief inspector's grade is 1:3~5 ", needs the position at this time
The headcount of level meets corresponding all proportionate relationships two-by-two simultaneously, just judges as the corresponding staff number of position level
Ratio two-by-two between amount and other position level headcounts meets distributed number ratio.
S103 obtains preset attribute mapping table, and there are many first generic attribute marks for record in attribute mapping table
Label and the interdependent one or more second generic attribute labels of every kind of first kind attribute tags.Based on each in attribute information
The first kind attribute tags that every employee of type identification of information has, and every employee point is inquired according to attribute mapping table
Not corresponding second generic attribute label.
On the other hand, there is certain logic dependence as shown in the above description, as employee must between attribute information
There need be tenure to record, there could be performance information, therefore, even if can not know in advance what attribute each employee may have
Information (because the position of each employee is different, even and identical position, it is poor that the different practical personal considerations of employee can also exist
It is different, so that being difficult to predict the one-to-one attribute information situation of all employees), but according to employee in the data after merging
The some attribute informations having, theoretically can be according to the interdependent logical relation between attribute information, and being inferred to it must also
In database with what a little information, such as after merging, employee A has performance information, then it is substantially a to illustrate that it must have
People's information, tenure record and attendance information judge whether it meets this at this point it is possible to verify to the attribute information of employee A
Condition, if satisfied, then illustrating that the attribute information of the employee A is errorless, if not satisfied, then illustrating that the attribute information of employee A is necessarily deposited
In problem, i.e. migration merging process data must there is a problem.Therefore, existing attribute logic is depended on to this kind in order to realize
The record of relationship can be the corresponding interdependent attribute information of each attribute information setting, such as above-mentioned performance information in this programme
Depend on basic personal information, tenure record and attendance information, attribute mapping table needed for obtaining the embodiment of the present invention.Its
In should explanatorily, since dependence itself is that a relative concept was both likely to be for single attribute information
Need to depend on the first attribute tags of other attribute informations, it is also possible to be that can also be by the second interdependent attribute tags
Belong to the first attribute tags and the second attribute tags simultaneously, such as performance fee, depends on above-mentioned achievement letter
Breath, performance information is exactly the second attribute tags at this time, therefore performance information had both belonged to the first attribute tags and also belonged to the second attribute
Label, therefore when setting a property mapping table is needed actually interdependent according to performance information and is carried out by interdependent situation
Corresponding first attribute tags and the second attribute tags sort out and setting.
After getting attribute mapping table, the embodiment of the present invention can be according to recorded in attribute mapping table
One attribute tags and the practical attribute information having of employee, to inquire the corresponding one or more first attribute marks of every employee
Label, and filter out corresponding second attribute tags of each first attribute tags.Such as in examples detailed above, it is assumed that the person of inquiring
Work A includes the performance information in the first attribute tags, then can filter out its corresponding multiple second attribute tags: basic personal letter
Breath, tenure record and attendance information.
S104, judge in the attribute information of every employee whether include corresponding second generic attribute label information.
It is determining corresponding second attribute tags of every employee and then employee's attribute information is being carried out in turn
It searches, if the attribute information comprising corresponding second attribute tags, such as assume to inquire employee A in examples detailed above corresponding more
A second attribute tags are as follows: basic personal information, tenure record and attendance information herein can carry out the attribute information of employee A
Inquiry judges whether comprising specific basic personal information, tenure record and attendance information data content.If comprising the person of explanation
The attribute information of work A is complete.
S105, if the corresponding headcount of every kind of job information is in corresponding default headcount range, every kind
The corresponding headcount of position level meets preset distributed number ratio, and comprising corresponding in the attribute information of every employee
The information of second generic attribute label determines that data of attribute information is completely errorless.
The embodiment of the present invention from terms of whole level and level of detail two to merging after in database employee attribute information
Completeness check is carried out, specifically, headcount range and each position based on each position in position organizational structure
The headcount ratio of level carries out whole verification to the attribute information of all employees, so that when there is the attribute information of employee
When all losing, without carrying out a large amount of data analysis, only need to simply carry out quantity statistics can find whole loss in time
The case where, and level of detail, it is contemplated that there is certain logic dependence between different attribute informations, believed based on attribute
Dependence between breath is first determined to need first kind attribute tags existing for other interdependent attribute information ability, then is searched
In database in the attribute information of employee whether the information comprising interdependent the second generic attribute label of first kind attribute tags, if
In the presence of then illustrating that these attribute informations are normal presences, to realize whether complete to the attribute information of every employee quick
Verification finally verifies nothing in whole level and level of detail and mistakes without carrying out complicated data processing operation, resulting number
It is completely errorless according to attribute information in library.Due to finding in actual conditions, loss of data tends not to only lose one liang of data
So simple, the amount for usually losing data all can at least more than ten to tens, therefore when carrying out completeness check, the present invention
Embodiment is not necessarily limited to the verification of the specific data content of single attribute information, but single employee's attribute is that unit progress is whole
Sports school tests, while carrying out details verification to single employee's attribute with the corresponding dependence of every attribute information, due to the present invention
Embodiment does not need original database and carries out data processing, do not need database data comparison while not needing to data after merging yet
The specific object message data content in library is analyzed, but is formed to attribute information and carried out logic analysis, relatively specific data
Processing task amount is greatly reduced for content analysis compares, significant increase processing speed efficiency, so that the embodiment of the present invention can
Completed in a very short period of time to employee's data of attribute information completeness check.
As a kind of specific implementation for obtaining organizational structure data in the embodiment of the present invention one, as shown in Fig. 2, this hair
Bright embodiment two, comprising:
S201 obtains the organizational structure data for being counted and being sent respectively by one or more raw data bases, organizational structure
Include the corresponding headcount of every kind of job information and the corresponding staff number of every kind of position level in raw data base in data
Amount.
S202 carries out Macro or mass analysis to one or more organizational structure data, and based on the organizational structure data after summarizing
Determine that the corresponding default headcount range of every kind of job information and every kind of position level correspond between headcount
Distributed number ratio.
It in embodiments of the present invention, can be to each original number in order to ensure the accurate and effective of the organizational structure data used
It is counted, that is, is counted in each raw data base according to the actual tissue framework data in library, the corresponding member of every kind of job information
Corresponding employee's data under number amount and every kind of position level, and employee's data of attribute information is being carried out by raw data base
While migration, the organizational structure data of its own are sent to together among database to be verified.
Database to be verified after receiving the multiple organizational structure data that all raw data bases are sent (due to
Can all there be the job information of employee in not necessarily all raw data base, therefore can specifically carry out organizational structure statistics original number
Need to be determined by actual conditions according to library quantity), the organizational structure data received can be summarized, to obtain final practical merging
Preceding organizational structure data.Should explanatorily, preset organizational structure data with technical staff the difference is that, the present invention
Embodiment is the organizational structure data counted to raw data base truth, thus for the embodiment of the present invention and
It says, the corresponding headcount range of every kind of job information for including in organizational structure data should be a specific numerical value, and
Non- one include a variety of numerical value value range, such as chief inspector 3 people of grade rather than 1~3 people, similarly, the corresponding number of each position level
Measure distribution proportion, it should also it is a specific ratio value, rather than the proportional region illustrated in the embodiment of the present invention one.
In embodiments of the present invention, by carrying out the statistics of organizational structure data to raw data base and summarizing, to make
The organizational structure data for obtaining progress headcount verification in the embodiment of the present invention are extremely accurate and reliable, simultaneously because organizational structure number
According to it is interior be only merely to have recorded some quantity informations, the data volume for being included is minimum, thus to data transmission etc. hardly make
It influences at what, so that being greatly improved to the accuracy of the completeness check of employee's attribute data, ensure that
Verification is safely and fast.
As an embodiment of the present invention, it in order to realize the rapid integrity verification to employee's attribute information, is carrying out
Before method of calibration in the embodiment of the present invention one, further includes:
Whether the job information for verifying every employee in database to be verified complete, if check results be it is complete, execute
Obtain the operation of the attribute information of every employee in database to be verified.
Since for every employee, job information is all the data certainly existed, therefore the embodiment of the present invention can be straight
It connects and is verified to whether the job information of every employee completely exists, if it does not exist or data are imperfect, then directly can be with
Determine that employee's attribute data is incomplete, conversely, the method for then executing the embodiment of the present invention one is verified.Wherein, position
The whether complete method of calibration of information can preset all positions that intra-company to be verified includes, and set correspondence
Position coexist rule, such as management level position and common office worker cannot coexist among the job information of an employee,
It recycles the job information prestored and position that rule coexists to verify the job information of every employee, judges whether to meet and want
It asks.
This hair is being carried out as the embodiment of the present invention three in order to realize the rapid integrity verification to employee's attribute information
Before method of calibration in bright embodiment one, as shown in Figure 3, further includes:
S301, the type for the information for including in recognition property information, and search the corresponding data format of each type.
S302 carries out format check to attribute information based on data format, if format check is errorless, executes acquisition to school
Test the operation of the attribute information of every employee in database.
In embodiments of the present invention, it is contemplated that the data format of different type attribute information can there is some difference, such as
Job information is usually Chinese or the characters such as English, and attendance record is usually number+punctuation character, therefore meeting of the embodiment of the present invention
Its practical corresponding data format is set for every attribute information in advance, and in the integrality for carrying out the embodiment of the present invention one
Before verification, first the data format of every employee's attribute information is verified, the attribute information of format error, then say if it exists
There are mistakes for bright attribute information, are directly determined as that employee's attribute information is imperfect at this time.Since the embodiment of the present invention only carries out
The data format of attribute information verifies, and is not related to the processing such as specific data content identification analysis, therefore at reality
It is also relatively small to manage workload, realizes on the basis of additionally not increasing verifying work amount, to the preliminary of employee's attribute information
Rapid verification.
As the embodiment of the present invention four, it is contemplated that complete in actual conditions when employee's data of attribute information amount is larger
The workload of whole property verification is also larger, at this time verifying work inherently may there is a certain error possibility, therefore, in order to
The error of verifying work itself is avoided to cause to interfere completeness check result, the embodiment of the present invention will not be in check results
When not being whole level and level of detail while meeting the requirements, directly it is determined as that employee's data of attribute information is imperfect, but meeting
Duplication check is further carried out, as shown in Figure 4, comprising:
S401, if the corresponding headcount of any job information is not at corresponding default headcount range, any
The corresponding headcount of kind position level is unsatisfactory for preset distributed number ratio, or, in the attribute information of any bit employee not
It is abnormal then to determine verification, and updates verification frequency of abnormity for information comprising corresponding second generic attribute label.
When in three aspect verifications in the presence of being unsatisfactory for requiring, illustrate that this check results can not prove that employee's attribute is believed
The integrality of data is ceased, but on the one hand this result may be that employee's data of attribute information itself is really imperfect, on the other hand
It is also likely to be that verifying work some errors occurs in the process, such as statistical data is that error etc. occur, it is therefore, of the invention at this time
Embodiment will not directly determine that employee's attribute information is imperfect, but can be judged to verifying exception, and it is different to count corresponding verification
Normal number.
S402, if verification frequency of abnormity is less than default frequency of abnormity threshold value, return execution obtains every in database to be verified
The operation of the attribute information of position employee, until determining that result is completely errorless for data of attribute information.
S403 determines that there are data to lose for attribute information if verification frequency of abnormity is greater than or equal to default frequency of abnormity threshold value
It loses.
In embodiments of the present invention, a frequency of abnormity threshold value can be preset by technical staff first, and can be complete
Property verification it is abnormal when, update and judge whether frequency of abnormity exceeds frequency of abnormity threshold value, if without departing from that can return and execute sheet
The completeness check of inventive embodiments one, to reduce the error that verifying work itself may cause, when verification is repeatedly abnormal, this
When verifying work error itself a possibility that it is minimum, therefore the embodiment of the present invention can directly determine attribute information there are data to lose
Lose, and if within frequency of abnormity threshold value, identify that data of attribute information is completely errorless, then illustrate that verification before this is abnormal
It is particularly likely that the error of verifying work itself, therefore then can directly determine that data of attribute information is completely errorless at this time.
Corresponding to the method for foregoing embodiments, Fig. 5 shows employee's attribute information verification dress provided in an embodiment of the present invention
The structural block diagram set, for ease of description, only parts related to embodiments of the present invention are shown.The exemplary employee's attribute of Fig. 5
Information checking device can be the executing subject of employee's attribute information method of calibration of the offer of previous embodiment one.
Referring to Fig. 5, which includes:
Data obtaining module 51, for obtaining the attribute information of every employee in database to be verified, and according to the category
Property information in job information inquiry employee position level.
Quantity discrimination module 52, for judging whether the corresponding headcount of every kind of job information is in corresponding pre-
If headcount range, and judge whether the ratio between the corresponding headcount of every kind of position level meets preset quantity point
Cloth ratio.
Tag queries module 53 records in the attribute mapping table for obtaining preset attribute mapping table
There are many interdependent one or more second generic attribute labels of first kind attribute tags and every kind of first kind attribute tags.
The first kind attribute tags that every employee of type identification based on each information in the attribute information has, and according to the category
Property mapping table inquires the corresponding second generic attribute label of every employee.
Whether information detecting module 54 includes corresponding described second in the attribute information for judging every employee
The information of generic attribute label.
First complete detection module 55, if being in corresponding default for the corresponding headcount of every kind of job information
Headcount range, the corresponding headcount of every kind of position level meet preset distributed number ratio, and the institute of every employee
The information in attribute information comprising the corresponding second generic attribute label is stated, determines that the data of attribute information is completely errorless.
Further, employee's attribute information calibration equipment, further includes:
Data acquisition module, for obtaining the organizational structure number for being counted and being sent respectively by one or more raw data bases
According to including the corresponding headcount of every kind of job information and every kind of duty in the raw data base in the organizational structure data
The corresponding headcount of position level.
Data analysis module for carrying out Macro or mass analysis to one or more organizational structure data, and is based on summarizing
The organizational structure data afterwards determine the corresponding default headcount range of every kind of job information and every kind of duty
Position level corresponds to the distributed number ratio between headcount.
Further, employee's attribute information calibration equipment, further includes:
Whether the job information for verifying every employee in the database to be verified complete, if check results be it is complete,
Execute the operation for obtaining the attribute information of every employee in database to be verified.
Further, employee's attribute information calibration equipment, further includes:
It identifies the type for the information for including in the attribute information, and searches the corresponding data format of each type.
Format carries out format check to the attribute information based on the data, if format check is errorless, described in execution
Obtain the operation of the attribute information of every employee in database to be verified.
Further, employee's attribute information calibration equipment, further includes:
Second complete detection module, if not to be that the corresponding headcount of every kind of job information is not at right respectively for any
The default headcount range answered, the corresponding headcount of any every kind of position level are unsatisfactory for preset distributed number ratio,
Or, not including the information of the corresponding second generic attribute label in any and every employee attribute information, then determine
Verification is abnormal, and updates verification frequency of abnormity.
Detection module again is returned and is obtained described in executing if being less than default frequency of abnormity threshold value for the verification frequency of abnormity
The operation of the attribute information of every employee in database to be verified is taken, until determining that result is the complete nothing of the data of attribute information
Accidentally.
Determination module determines institute if being greater than or equal to the default frequency of abnormity threshold value for the verification frequency of abnormity
Stating attribute information, there are loss of data.
Each module realizes the process of respective function in employee's attribute information calibration equipment provided in an embodiment of the present invention, specifically
It can refer to the description of aforementioned embodiment illustrated in fig. 1 one, details are not described herein again.
It should be understood that the size of the serial number of each step is not meant that the order of the execution order in above-described embodiment, each process
Execution sequence should be determined by its function and internal logic, the implementation process without coping with the embodiment of the present invention constitutes any limit
It is fixed.
Although will also be appreciated that term " first ", " second " etc. are used in some embodiment of the present invention in the text
Various elements are described, but these elements should not be limited by these terms.These terms are used only to an element
It is distinguished with another element.For example, the first table can be named as the second table, and similarly, the second table can be by
It is named as the first table, without departing from the range of various described embodiments.First table and the second table are all tables, but
It is them is not same table.
Fig. 6 is the schematic diagram for the terminal device that one embodiment of the invention provides.As shown in fig. 6, the terminal of the embodiment is set
Standby 6 include: processor 60, memory 61, and the computer that can be run on the processor 60 is stored in the memory 61
Program 62.The processor 60 realizes that above-mentioned each employee's attribute information method of calibration is implemented when executing the computer program 62
Step in example, such as step 101 shown in FIG. 1 is to 105.Alternatively, when the processor 60 executes the computer program 62
Realize the function of each module/unit in above-mentioned each Installation practice, such as the function of module 51 to 55 shown in Fig. 5.
The terminal device 6 can be the calculating such as desktop PC, notebook, palm PC and cloud server and set
It is standby.The terminal device may include, but be not limited only to, processor 60, memory 61.It will be understood by those skilled in the art that Fig. 6
The only example of terminal device 6 does not constitute the restriction to terminal device 6, may include than illustrating more or fewer portions
Part perhaps combines certain components or different components, such as the terminal device can also include input sending device, net
Network access device, bus etc..
Alleged processor 60 can be central processing unit (Central Processing Unit, CPU), can also be
Other general processors, digital signal processor (Digital Signal Processor, DSP), specific integrated circuit
(Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-
Programmable Gate Array, FPGA) either other programmable logic device, discrete gate or transistor logic,
Discrete hardware components etc..General processor can be microprocessor or the processor is also possible to any conventional processor
Deng.
The memory 61 can be the internal storage unit of the terminal device 6, such as the hard disk or interior of terminal device 6
It deposits.The memory 61 is also possible to the External memory equipment of the terminal device 6, such as be equipped on the terminal device 6
Plug-in type hard disk, intelligent memory card (Smart Media Card, SMC), secure digital (Secure Digital, SD) card dodge
Deposit card (Flash Card) etc..Further, the memory 61 can also both include the storage inside list of the terminal device 6
Member also includes External memory equipment.The memory 61 is for storing needed for the computer program and the terminal device
Other programs and data.The memory 61, which can be also used for temporarily storing, have been sent or data to be sent.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated module/unit be realized in the form of SFU software functional unit and as independent product sale or
In use, can store in a computer readable storage medium.Based on this understanding, the present invention realizes above-mentioned implementation
All or part of the process in example method, can also instruct relevant hardware to complete, the meter by computer program
Calculation machine program can be stored in a computer readable storage medium, the computer program when being executed by processor, it can be achieved that on
The step of stating each embodiment of the method.Wherein, the computer program includes computer program code, the computer program generation
Code can be source code form, object identification code form, executable file or certain intermediate forms etc..The computer-readable medium
It may include: any entity or device, recording medium, USB flash disk, mobile hard disk, magnetic that can carry the computer program code
Dish, CD, computer storage, read-only memory (Read-Only Memory, ROM), random access memory (Random
Access Memory, RAM), electric carrier signal, telecommunication signal and software distribution medium etc..
Embodiment described above is merely illustrative of the technical solution of the present invention, rather than its limitations;Although referring to aforementioned reality
Applying example, invention is explained in detail, those skilled in the art should understand that: it still can be to aforementioned each
Technical solution documented by embodiment is modified or equivalent replacement of some of the technical features;And these are modified
Or replacement, the essence of corresponding technical solution is departed from the spirit and scope of the technical scheme of various embodiments of the present invention, it should all
It is included within protection scope of the present invention.
Claims (10)
1. a kind of employee's attribute information method of calibration characterized by comprising
The attribute information of every employee in database to be verified is obtained, and according to the job information inquiry person in the attribute information
The position level of work;
Judge whether the corresponding headcount of every kind of job information is in corresponding default headcount range, and judges every
Whether the ratio between the corresponding headcount of kind position level meets preset distributed number ratio;
Preset attribute mapping table is obtained, first kind attribute tags there are many records in the attribute mapping table, with
And one or more second generic attribute labels that every kind of first kind attribute tags are interdependent;Based on each letter in the attribute information
The first kind attribute tags that every employee of type identification of breath has, and every employee is inquired according to the attribute mapping table
Corresponding second generic attribute label;
Judge in the attribute information of every employee whether include the corresponding second generic attribute label information;
If the corresponding headcount of every kind of job information is in corresponding default headcount range, every kind of position level pair
The headcount answered meets preset distributed number ratio, and includes corresponding described the in the attribute information of every employee
The information of two generic attribute labels determines that the data of attribute information is completely errorless.
2. employee's attribute information method of calibration as described in claim 1, which is characterized in that obtain database to be verified described
In every employee attribute information before, comprising:
The organizational structure data that are counted and sent respectively by one or more raw data bases are obtained, in the organizational structure data
Include the corresponding headcount of every kind of job information in the raw data base and the corresponding headcount of every kind of position level;
Macro or mass analysis is carried out to one or more organizational structure data, and true based on the organizational structure data after summarizing
The fixed corresponding default headcount range of every kind of job information and every kind of position level correspond between headcount
The distributed number ratio.
3. employee's attribute information method of calibration as described in claim 1, which is characterized in that obtain database to be verified described
In every employee attribute information before, further includes:
Whether the job information for verifying every employee in the database to be verified complete, if check results be it is complete, execute
The operation for obtaining the attribute information of every employee in database to be verified.
4. employee's attribute information method of calibration as described in claim 1, which is characterized in that obtain database to be verified described
In every employee attribute information before, further includes:
It identifies the type for the information for including in the attribute information, and searches the corresponding data format of each type;
Format carries out format check to the attribute information and executes the acquisition if format check is errorless based on the data
The operation of the attribute information of every employee in database to be verified.
5. employee's attribute information method of calibration as described in claim 1, which is characterized in that further include:
If the corresponding headcount of any job information is not at corresponding default headcount range, any position level
Corresponding headcount is unsatisfactory for preset distributed number ratio, or, in the attribute information of any bit employee do not include pair
It is abnormal then to determine verification, and updates verification frequency of abnormity for the information for the second generic attribute label answered;
If the verification frequency of abnormity is less than default frequency of abnormity threshold value, returns and execute in the acquisition database to be verified every
The operation of the attribute information of employee, until determining that result is that the data of attribute information is completely errorless;
If the verification frequency of abnormity is greater than or equal to the default frequency of abnormity threshold value, determine that there are data for the attribute information
It loses.
6. a kind of employee's attribute information calibration equipment characterized by comprising
Data obtaining module, for obtaining the attribute information of every employee in database to be verified, and according to the attribute information
In job information inquiry employee position level;
Quantity discrimination module, for judging whether the corresponding headcount of every kind of job information is in corresponding default employee
Quantitative range, and judge whether the ratio between the corresponding headcount of every kind of position level meets preset distributed number ratio
Example;
Tag queries module, for obtaining preset attribute mapping table, in the attribute mapping table there are many records
First kind attribute tags and the interdependent one or more second generic attribute labels of every kind of first kind attribute tags;Based on institute
The first kind attribute tags that every employee of type identification of each information in attribute information has are stated, and corresponding according to the attribute
Relation table inquires the corresponding second generic attribute label of every employee;
Whether information detecting module includes corresponding second generic attribute in the attribute information for judging every employee
The information of label;
First complete detection module, if being in corresponding default staff number for the corresponding headcount of every kind of job information
Amount range, the corresponding headcount of every kind of position level meet preset distributed number ratio, and the attribute of every employee
Include the information of the corresponding second generic attribute label in information, determines that the data of attribute information is completely errorless.
7. employee's attribute information calibration equipment as claimed in claim 6, which is characterized in that further include:
Data acquisition module, for obtaining the organizational structure data for being counted and being sent respectively by one or more raw data bases,
Include the corresponding headcount of every kind of job information and every kind of position in the raw data base in the organizational structure data
The corresponding headcount of level;
Data analysis module, for carrying out Macro or mass analysis to one or more organizational structure data, and based on summarizing after
The organizational structure data determine the corresponding default headcount range of every kind of job information and every kind of position layer
The distributed number ratio between the corresponding headcount of grade.
8. employee's attribute information calibration equipment as claimed in claim 6, which is characterized in that further include:
Second complete detection module, if being not at corresponding default staff number for the corresponding headcount of any job information
Amount range, the corresponding headcount of any position level are unsatisfactory for preset distributed number ratio, or, the institute of any bit employee
The information for not including the corresponding second generic attribute label in attribute information is stated, then it is abnormal to determine verification, and it is different to update verification
Normal number;
Detection module again, if being less than default frequency of abnormity threshold value for the verification frequency of abnormity, return execute the acquisition to
The operation of the attribute information of every employee in calibration database, until determining that result is that the data of attribute information is completely errorless;
Determination module determines the category if being greater than or equal to the default frequency of abnormity threshold value for the verification frequency of abnormity
There are loss of data for property information.
9. a kind of terminal device, which is characterized in that the terminal device includes memory, processor, is stored on the memory
There is the computer program that can be run on the processor, is realized when the processor executes the computer program as right is wanted
The step of seeking any one of 1 to 5 the method.
10. a kind of computer readable storage medium, the computer-readable recording medium storage has computer program, and feature exists
In when the computer program is executed by processor the step of any one of such as claim 1 to 5 of realization the method.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910667523.4A CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910667523.4A CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110471912A true CN110471912A (en) | 2019-11-19 |
CN110471912B CN110471912B (en) | 2023-07-25 |
Family
ID=68509169
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910667523.4A Active CN110471912B (en) | 2019-07-23 | 2019-07-23 | Employee attribute information verification method and device and terminal equipment |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110471912B (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112488729A (en) * | 2020-11-30 | 2021-03-12 | 上海中商网络股份有限公司 | Data verification method and device, computer equipment and readable storage medium |
CN112732755A (en) * | 2020-12-30 | 2021-04-30 | 招商局金融科技有限公司 | Client grouping-based label value matching joint verification method and device and computer equipment |
CN114048744A (en) * | 2021-10-28 | 2022-02-15 | 盐城金堤科技有限公司 | Entity extraction-based job record generation method, device and equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020133459A1 (en) * | 2001-01-12 | 2002-09-19 | Polk John D. | Apparatus and methods for providing a payment system over a network |
WO2015062767A1 (en) * | 2013-11-01 | 2015-05-07 | Peter Fink | System and method for visualizing and simulating personal knowledge structures in a company |
WO2018120457A1 (en) * | 2016-12-29 | 2018-07-05 | 平安科技(深圳)有限公司 | Data processing method, apparatus, device, and computer readable storage medium |
CN108510239A (en) * | 2018-03-13 | 2018-09-07 | 平安普惠企业管理有限公司 | Employee information management method, device, computer equipment and storage medium |
-
2019
- 2019-07-23 CN CN201910667523.4A patent/CN110471912B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20020133459A1 (en) * | 2001-01-12 | 2002-09-19 | Polk John D. | Apparatus and methods for providing a payment system over a network |
WO2015062767A1 (en) * | 2013-11-01 | 2015-05-07 | Peter Fink | System and method for visualizing and simulating personal knowledge structures in a company |
WO2018120457A1 (en) * | 2016-12-29 | 2018-07-05 | 平安科技(深圳)有限公司 | Data processing method, apparatus, device, and computer readable storage medium |
CN108510239A (en) * | 2018-03-13 | 2018-09-07 | 平安普惠企业管理有限公司 | Employee information management method, device, computer equipment and storage medium |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112488729A (en) * | 2020-11-30 | 2021-03-12 | 上海中商网络股份有限公司 | Data verification method and device, computer equipment and readable storage medium |
CN112732755A (en) * | 2020-12-30 | 2021-04-30 | 招商局金融科技有限公司 | Client grouping-based label value matching joint verification method and device and computer equipment |
CN112732755B (en) * | 2020-12-30 | 2024-03-22 | 招商局金融科技有限公司 | Label value matching joint verification method and device based on customer grouping and computer equipment |
CN114048744A (en) * | 2021-10-28 | 2022-02-15 | 盐城金堤科技有限公司 | Entity extraction-based job record generation method, device and equipment |
Also Published As
Publication number | Publication date |
---|---|
CN110471912B (en) | 2023-07-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110471912A (en) | A kind of employee's attribute information method of calibration, device and terminal device | |
CN105868373B (en) | Method and device for processing key data of power business information system | |
Caballero et al. | A Data Quality Measurement Information Model Based On ISO/IEC 15939. | |
CN108614895B (en) | Abnormal data access behavior identification method and data processing device | |
CN110909129B (en) | Abnormal complaint event identification method and device | |
CN111177139A (en) | Data quality verification monitoring and early warning method and system based on data quality system | |
CN114116801A (en) | Data list checking method and device | |
CN109947797B (en) | Data inspection device and method | |
CN112882956A (en) | Method and device for automatically generating full-scene automatic test case through data combination calculation, storage medium and electronic equipment | |
CN115577983B (en) | Enterprise task matching method based on block chain, server and storage medium | |
CN111724079A (en) | Industry economic data management system based on big data | |
CN111177311A (en) | Data analysis model and analysis method of event processing result | |
CN112100183B (en) | Report query system, device and method based on label management | |
CN110489329A (en) | A kind of output method of test report, device and terminal device | |
CN109377391A (en) | A kind of tracking of information method, storage medium and server | |
CN112328752B (en) | Course recommendation method and device based on search content, computer equipment and medium | |
CN108537654B (en) | Rendering method and device of customer relationship network graph, terminal equipment and medium | |
CN114490406A (en) | Test coverage item management method, device, equipment and medium | |
CN114840519A (en) | Data labeling method, equipment and storage medium | |
CN111427936B (en) | Report generation method and device, computer equipment and storage medium | |
CN110569435B (en) | Intelligent dual-ended recommendation engine system and method | |
CN113094241A (en) | Method, device and equipment for determining accuracy of real-time program and storage medium | |
CN113297053A (en) | Method and device for determining test coverage rate and storage medium | |
CN111475657A (en) | Display device, display system and entity alignment method | |
CN109165518A (en) | Data authority division management method and device |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |