CN108959560B - Information processing method and device based on data table and electronic equipment - Google Patents
Information processing method and device based on data table and electronic equipment Download PDFInfo
- Publication number
- CN108959560B CN108959560B CN201810719411.4A CN201810719411A CN108959560B CN 108959560 B CN108959560 B CN 108959560B CN 201810719411 A CN201810719411 A CN 201810719411A CN 108959560 B CN108959560 B CN 108959560B
- Authority
- CN
- China
- Prior art keywords
- organization
- information
- personnel
- information table
- updating
- 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.)
- Active
Links
Images
Classifications
-
- 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
Abstract
The invention provides an information processing method and device based on a data table, wherein the method comprises the following steps: by obtaining organization change data; updating an organization information table according to the organization change data; acquiring a preset associated external key between a record in the organization information table and a record in the personnel information table; and updating the associated records in the personnel information table according to the associated external keys and the updated organization information table. According to the method, the change data is organized, the personnel information is correspondingly updated, the information management efficiency is improved, and the technical problem that centralized processing and centralized analysis of organization and personnel information are difficult to realize in the prior art is solved.
Description
Technical Field
The present invention relates to the field of information processing technologies, and in particular, to an information processing method and apparatus based on a data table, and an electronic device.
Background
With the continuous development of internet technology, many group enterprises develop towards multi-state and multi-diversification, and the group enterprises can include sub-companies and even multi-level sub-companies, which provides great challenges for unified management and unified resource allocation of human resources on a group level.
In the existing Human Resource management system, the related information of Human resources is difficult to be processed or analyzed in a centralized manner, data of Human Resource data analysis platforms of many group enterprises are directly obtained from a Human Resource management electronic system (HER), the dependency of theme analysis and customized reports on data such as organization architecture is large, and once the underlying data is changed or the system is upgraded, the cost for the transformation of the analysis and reports is huge.
Disclosure of Invention
The present invention is directed to solving, at least to some extent, one of the technical problems in the related art.
Therefore, the invention provides an information processing method based on a data table, which is used for realizing the unified management of organization and personnel information data, and when a background system is changed or upgraded, the report and analysis can be maintained only by modifying the mapping relation of the data, so that the corresponding cost is reduced, and the management efficiency is improved.
The invention provides an information processing device based on a data table.
The invention provides an electronic device.
The invention provides a computer readable storage medium.
An embodiment of a first aspect of the present invention provides an information processing method based on a data table, including:
acquiring organization change data;
updating an organization information table according to the organization change data;
acquiring a preset associated foreign key between a record in the organization information table and a record in the personnel information table;
and updating the associated records in the personnel information table according to the associated external keys and the updated organization information table.
According to the information processing method based on the data table, the organization change data are obtained; updating an organization information table according to the organization change data; acquiring a preset associated foreign key between a record in the organization information table and a record in the personnel information table; and updating the associated records in the personnel information table according to the associated external keys and the updated organization information table. According to the method, the change data is organized, the personnel information is correspondingly updated, the information management efficiency is improved, and the technical problem that centralized processing and centralized analysis of organization and personnel information are difficult to realize in the prior art is solved.
The second aspect of the present invention provides an information processing apparatus based on a data table, including:
the first acquisition module is used for acquiring organization change data;
the first updating module is used for updating the organization information table according to the organization change data;
the second acquisition module is used for acquiring a preset associated external key between the record in the organization information table and the record in the personnel information table;
and the second updating module is used for updating the associated records in the personnel information table according to the associated external keys and the updated organization information table.
The information processing device based on the data table of the embodiment of the invention acquires organization change data; updating an organization information table according to the organization change data; acquiring a preset associated external key between a record in the organization information table and a record in the personnel information table; and updating the associated records in the personnel information table according to the associated external keys and the updated organization information table. According to the method, the change data is organized, the personnel information is correspondingly updated, the information management efficiency is improved, and the technical problem that centralized processing and centralized analysis of organization and personnel information are difficult to realize in the prior art is solved.
An embodiment of a third aspect of the present invention provides an electronic device, including: the information processing method comprises the following steps of storing a program, storing the program in a memory, and executing the program by a processor, wherein the processor realizes the information processing method based on the data table according to the embodiment of the first aspect.
A third embodiment of the present invention provides a computer-readable storage medium, on which a computer program is stored, wherein the program, when executed by a processor, implements a method for processing information based on a data table as set forth in the foregoing embodiments of the present invention.
Additional aspects and advantages of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
The foregoing and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
fig. 1 is a schematic flowchart of an information processing method based on a data table according to an embodiment of the present invention;
FIG. 2 is a block diagram of a core module of the human resource system according to an embodiment of the present invention;
FIG. 3 is a flowchart illustrating a method for processing information based on a data table according to a second embodiment of the present invention;
fig. 4 is a schematic flowchart of an information processing method based on a data table according to a third embodiment of the present invention;
fig. 5 is a schematic structural diagram of an information processing apparatus based on a data table according to a fourth embodiment of the present invention;
FIG. 6 is a schematic structural diagram of another information processing apparatus based on a data table according to a fourth embodiment of the present invention; and
fig. 7 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative and intended to be illustrative of the invention and are not to be construed as limiting the invention.
A data table-based information processing method and apparatus according to an embodiment of the present invention will be described below with reference to the accompanying drawings.
Example one
Fig. 1 is a flowchart illustrating an information processing method based on a data table according to an embodiment of the present invention.
Before processing data information of organizations and personnel in the human resource system, first, a core module of the system is known, referring to fig. 2, and fig. 2 is a schematic structural diagram of the core module of the human resource system in the embodiment of the present invention.
As shown in fig. 2, the human resource system in this embodiment includes an organization information change fact recording module 21 and a staff information change fact recording module 11, and performs association through an association foreign key, so as to realize that the organization information change drives staff information change, thereby ensuring that the system responds to the personal information change of an organization or staff in time.
The core module records the most core contents of organizations and personnel in the field of human resources, wherein the organization information change fact recording module records the merging, splitting, renaming and other related facts of the organizations in the development process of the whole enterprise, so that the enterprise can inquire the organization change in the development process; the employee information change fact recording module records all relevant information of the employees such as selection, use, breeding, leaving, going in, going out, rising, falling, transferring and the like in the enterprise, and can inquire the whole occupation life cycle of the employees in the enterprise.
Specifically, the employee basic information module 111 records all relevant basic information of the employee, such as name, gender, and the like.
The employee salary information module 112 records information related to employee salaries.
The employee education information module 113 records all the education background information of the employees.
The employee performance information module 114 records information relating to the performance of the employee.
Staff reward and punishment information module 115 records staff relevant reward and punishment information.
The employee training information module 116 records all relevant training that employees have participated in before and after the enterprise of enrollment.
The employee attendance information module 117 records all attendance record information of the employee after the employee enters the enterprise.
The employee past work experience module 118 records all past work experiences of the employee before and after entering the business.
The organization basic information module 211 records the information of the organization architecture currently used by the whole enterprise.
The organization unit position information module 212 records the relevant position information set by the enterprise under the existing organization architecture.
The organization unit hierarchy information module 213 records the related information of each hierarchy of the organization unit.
The organization unit position information module 214 records the basic information of all positions under the position setting.
Finally, the personnel and the organization are related through a related external key, the organization is firstly followed by the personnel, the personnel depend on the organization, and after the organization information is updated, the personnel information is correspondingly updated.
As shown in fig. 1, the information processing method based on the data table includes the following steps:
The organization is one of the most central parts in human resource management, and as the business field of a group-level enterprise expands, the corresponding organization also adjusts, and the organization records the path of the change of the organization of the whole enterprise, so that the change data of the organization is acquired first.
The organization change data includes one or more combinations of new creation, merger, and revocation adjustments for the organization.
And 102, updating the organization information table according to the organization change data.
See table 1 below, where the organization information table is a plurality of tables, including one or more combinations of an organization unit change table, an organization unit hierarchy table, an organization unit membership table, and an organization unit basic information table.
The organization unit change table is used for recording organization change data of the organization unit, wherein the organization change data is used for indicating one or more combinations of combination, renaming and hierarchy adjustment of the organization unit; the organization unit level table is used for recording the report level relation of the organization units; the organization unit membership table is used for recording the administrative membership hierarchical relationship of the organization units; and the organization unit basic information table is used for recording the functions and/or the posts of the organization units.
Specifically, the organization unit change table is updated first according to organization change data, that is, one or more combinations of merging, renaming, and hierarchical adjustment of the organization units; and further, correspondingly updating the organization unit hierarchy table, the organization unit membership table and the organization unit basic information table according to the updated organization unit change table.
TABLE 1
And 103, acquiring a preset associated foreign key between the record in the organization information table and the record in the personnel information table.
See table 1 above, wherein the staff information table includes information such as basic information, job information, performance information, education experience, reward and punishment information, work experience, and photos of the staff.
Therefore, the preset association foreign key between the record in the organization information table and the record in the personnel information table is acquired first. And correspondingly updating the personnel information table according to the associated foreign key and the updated organization information table. The related external key refers to a mapping relation between records in the organization information table and records in the personnel information table. Taking the structured table as an example, the organization information table includes a cell for recording an organization identifier, and the person information table includes a cell for recording a person identifier, and the associated external key may indicate a mapping relationship between a record in the organization information table and a record in the person information table by recording a mapping relationship between a cell in the organization information table and a cell in the person information table.
In a possible scenario, when the records in the organization information table change, that is, one or more combinations of merging, renaming and hierarchy adjustment of the organization units change, the records in the personnel information table are updated correspondingly according to the mapping relationship between the records in the organization information table and the records in the personnel information table.
And 104, updating the associated records in the personnel information table according to the associated external keys and the updated organization information table.
Specifically, the specific process of updating the personnel information table according to the associated foreign key and the organization information table is as follows: firstly, according to the obtained associated external key, determining the mapping relation between the organization mechanism identifier in the organization information table and the personnel identifier in the personnel information table, and then according to the changed organization mechanism identifier, inquiring the records related to the personnel identifier with the mapping relation in the personnel information table. And reading the updated organization mechanism identification from the updated organization information table aiming at the changed organization mechanism identification, and finally updating the record inquired in the personnel information table by adopting the updated organization mechanism identification.
As an example, for a certain organization information table and a person information table, first, a mapping relationship between a cell of an organization identifier in the organization information table and a cell of a person identifier in the person information table is determined as shown in table 2 according to the acquired associated foreign key. When the organizational structure identifier in the first row and the first column (for example, a1) in the organization information table changes, the person information identifier in the person information table having a mapping relationship with the organization information table is queried by associating a foreign key, and if the person information identifier is located in the fourth column (for example, D8) in the eighth row, the organizational structure identifier corresponding to the person information identifier (for example, D5) in the person information table is found (for example, located in the fourth column in the fifth row), the organizational structure identifier in D5 is updated, and finally, the record in D8 in the person information table is updated according to the updated organizational structure identifier.
| Cell for organizing organization identification in organization information table | Cell corresponding to personnel identification in personnel information table |
| A1 | D8 |
| B2 | D4 |
| C3 | D7 |
TABLE 2
It should be noted that, in table 2, all cells corresponding to the person identifier in the person information table are the fourth column, which is D column, because in the structured table, generally the same column corresponds to the same attribute, in this example, the fourth column attribute is the person identifier. The organization mechanism identifier in the organization information table may be recorded in different row and column positions due to different corresponding organization hierarchies.
Furthermore, the organization information table after each update corresponds to the updated personnel information table, and personnel change records are generated according to the difference between the updated personnel information table and the personnel information table before update, so that the personnel change data are written into the fact table corresponding to the information type according to the information type related to the personnel change data. Wherein the information category includes one or more combinations of enrollment information, trial information, vitality information, training information, and departure information. In this embodiment, referring to table 1 above, the fact table is used to record relevant information such as employee enrollment information, trial period information, transaction information, training information, and leave information. Through the combination of the organization information table, the employee information table and the fact table, a data table of the employee detailed information shown in table 3 is obtained, and table 3 includes all information of the employee.
TABLE 3
And finally, respectively generating personnel information linked lists of different personnel according to personnel change records generated by updating in the past. The personnel information zipper table is used for recording personnel change records updated by corresponding personnel in the past, namely a historical record table, and is used for recording all change information of events from the initial state to the current state.
As an example, the zipper table of the personnel key information can be processed through the embodiment, when the personnel key information is changed, the condition of personnel information updating can be accurately positioned according to the starting time and the ending time, and a record is updated in the zipper table. See table 4 for example marital changes for employee zhang:
TABLE 4
In the information processing method based on the data sheet in this embodiment, after the organization change data is acquired, the organization information sheet is updated according to the organization change data, and the preset associated external key between the record in the organization information sheet and the record in the personnel information sheet is acquired; and updating the associated records in the personnel information table according to the associated external keys and the updated organization information table. According to the method, the change data is organized, the personnel information is correspondingly updated, the information management efficiency is improved, and the technical problem that centralized processing and centralized analysis of organization and personnel information are difficult to realize in the prior art is solved.
Example two
On the basis of the above embodiments, the information processing method based on the data table of the present embodiment further includes an information processing procedure as shown in fig. 3.
Fig. 3 is a flowchart illustrating an information processing method based on a data table according to a second embodiment of the present invention.
As shown in fig. 3, the data table-based information processing method may include the steps of:
The organization information table may be periodically acquired at intervals, such as one week, two weeks, one month, and the like. The merging, renaming, hierarchical adjustment and the like of the organization units cannot be changed in real time, so that only the organization information table needs to be acquired periodically.
Specifically, by comparing the organization information tables of two adjacent cycles, the organization information difference between the two organization information tables is obtained, for example, two organization units are merged, or the organization information difference occurring in a certain organization unit is deleted.
Wherein each row in the periodic snapshot table summarizes a plurality of metric events occurring in a certain period, such as a certain day, a certain week, a certain month.
Specifically, according to the organization information tables of two adjacent cycles, a cycle snapshot table of the organization information is generated through the obtained organization information difference.
As an example, when data of personnel transfer between organization units is counted, a monthly snapshot table may be used, and by comparing two monthly basic information tables of the organization units to obtain a difference between the two basic information tables of the organization units, the flow condition of employees in an enterprise may be counted according to different levels.
According to the information processing method based on the data table, the organization information table is obtained periodically, organization information difference between the organization information tables of two adjacent periods is compared, and then the period snapshot table of the organization information is generated according to the organization information difference. The method can accelerate the speed of inquiring the change of the organization information and improve the analysis efficiency of the data by periodically tracking the change of the organization information.
EXAMPLE III
On the basis of the above embodiments, the information processing method based on the data table of the present embodiment further includes an information processing procedure as shown in fig. 4.
Fig. 4 is a flowchart illustrating an information processing method based on a data table according to a third embodiment of the present invention.
As shown in fig. 4, the data table-based information processing method may include the steps of:
Specifically, the staff information table may be periodically acquired at intervals, such as one week, two weeks, one month, and the like. Since the personnel information cannot be changed in real time, only the organization information table needs to be acquired periodically.
And step 302, comparing the personnel information difference between the personnel information tables of two adjacent periods.
Specifically, by comparing the personal information tables of two adjacent periods, the personal information difference between the two personal information tables is obtained, for example, the marital status of zhangsan is changed from ungainly to married within a certain month; or, the change of personnel information from the technical department to the training department.
And 303, generating a periodic snapshot table of the personnel information according to the personnel information difference.
Wherein each row in the periodic snapshot table summarizes a plurality of metric events occurring in a certain period, such as a certain day, a certain week, a certain month.
Specifically, according to the personnel information tables of two adjacent periods, a period snapshot table of the personnel information is generated through the obtained personnel information difference.
As an example, when the marital status of a person is counted, the change of the marital status of the person may be counted by comparing two monthly personnel unit basic information tables to obtain the difference between the two personnel unit basic information tables using a monthly snapshot table.
According to the information processing method based on the data sheet, the personnel information sheets are obtained periodically, personnel information differences between the personnel information sheets in two adjacent periods are compared, and then the periodic snapshot sheet of the personnel information is generated according to the personnel information differences. The method can accelerate the speed of inquiring the change of the personnel information and improve the analysis efficiency of the data by periodically tracking the change of the personnel information.
Example four
In order to implement the above embodiments, the present invention further provides an information processing apparatus based on a data table.
Fig. 5 is a schematic structural diagram of an information processing apparatus based on a data table according to a fourth embodiment of the present invention.
As shown in fig. 5, the data table-based information processing apparatus includes: a first obtaining module 110, a first updating module 120, a second obtaining module 130, and a second updating module 140.
The first obtaining module 110 is configured to obtain organization change data.
The first updating module 120 is configured to update the organization information table according to the organization change data.
A second obtaining module 130, configured to obtain a preset associated foreign key between a record in the organization information table and a record in the personnel information table.
And the second updating module 140 is configured to update the associated record in the person information table according to the associated foreign key and the updated organization information table.
In one possible implementation manner of this embodiment, the information processing apparatus based on a data table further includes:
and the third acquisition module is used for periodically acquiring the organization information table.
And the first comparison module is used for comparing the organization information difference between the organization information tables of two adjacent periods.
And the first generation module is used for generating a periodic snapshot table of the organization information according to the organization information difference.
In one possible implementation manner of this embodiment, the information processing apparatus based on a data table further includes:
and the fourth acquisition module is used for periodically acquiring the personnel information table.
And the second comparison module is used for comparing the personnel information difference between the personnel information tables of two adjacent periods.
And the second generation module is used for generating a periodic snapshot table of the personnel information according to the personnel information difference.
In one possible implementation manner of this embodiment, the information processing apparatus based on a data table further includes:
the third generation module is used for generating personnel change records according to the difference between the updated personnel information table and the personnel information table before updating aiming at the previous updating;
respectively generating personnel information pull-chain tables of different personnel according to personnel change records generated by updating in the past; the personnel information zipper table is used for recording personnel change records updated by corresponding personnel in each time.
In one possible implementation manner of this embodiment, the information processing apparatus based on a data table further includes:
the writing module is used for writing the personnel change data into a fact table corresponding to the information type according to the information type related to the personnel change data; wherein the information category includes one or more combinations of enrollment information, trial information, vitality information, training information, and departure information.
The first updating module 120 is further configured to update the organization unit change table according to the organization change data; and correspondingly updating the organization unit hierarchy table, the organization unit membership table and the organization unit basic information table according to the updated organization unit change table.
Based on the foregoing embodiment, an embodiment of the present invention further provides another possible implementation manner of an information processing apparatus based on a data table, fig. 6 is a schematic structural diagram of another information processing apparatus based on a data table according to a fourth embodiment of the present invention, and based on the foregoing embodiment, the information processing apparatus based on a data table further includes: the cycle processing module 150, or the cycle processing module 160, or both the cycle processing module 150 and the cycle processing module 160. In the present embodiment, the above three cases are not limited, and the cycle processing module 150 and the cycle processing module 160 are described as an example. The method comprises the following specific steps:
a period processing module 150, configured to periodically obtain an organization information table; comparing the organization information difference between the organization information tables of two adjacent periods; and generating a periodic snapshot table of the organization information according to the organization information difference.
A periodic processing module 160, configured to periodically obtain a staff information table; comparing personnel information differences between the personnel information tables of two adjacent periods; and generating a periodic snapshot table of the personnel information according to the personnel information difference.
The information processing device based on the data table of the embodiment of the invention acquires organization change data; updating an organization information table according to the organization change data; and updating the associated records in the personnel information table according to the updated organization information table. According to the method, the change data is organized, the personnel information is correspondingly updated, the information management efficiency is improved, and the technical problem that centralized processing and centralized analysis of organization and personnel information are difficult to realize in the prior art is solved.
It should be noted that the foregoing explanation of the embodiment of the method for processing information based on a data table also applies to the apparatus for processing information based on a data table of this embodiment, and is not repeated here.
EXAMPLE five
In order to implement the above embodiments, the present invention further provides an electronic device.
Fig. 7 is a schematic structural diagram of an electronic device according to a fifth embodiment of the present invention.
As shown in fig. 7, the electronic device 700 includes: the information processing method includes a memory 701, a processor 702 and a computer program stored in the memory 701 and executable on the processor 702, and when the processor 701 executes the program, the information processing method based on the data table as proposed in the foregoing embodiments is implemented.
In order to implement the foregoing embodiments, an embodiment of the present invention further proposes a computer-readable storage medium on which a computer program is stored, wherein the program, when executed by a processor, implements the method for processing information based on a data table as proposed in the foregoing embodiments.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present invention, "a plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present invention in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present invention.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present invention may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present invention have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present invention, and that variations, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present invention.
Claims (10)
1. An information processing method based on a data table, characterized in that the method comprises the following steps:
acquiring organization change data;
updating an organization information table according to the organization change data;
acquiring a preset associated foreign key between a record in the organization information table and a record in the personnel information table; the related external key refers to a mapping relation between records in the organization information table and records in the personnel information table;
updating the associated records in the personnel information table according to the associated external keys and the updated organization information table; determining a mapping relation between an organization mechanism identifier in an organization information table and a personnel identifier in a personnel information table according to the associated foreign key; according to the changed organization mechanism identification, inquiring records related to the personnel identification with mapping relation in a personnel information table; reading the updated organization mechanism identifier from the updated organization information table aiming at the changed organization mechanism identifier; and updating the records inquired in the personnel information table by adopting the updated organization mechanism identification.
2. The method of claim 1, further comprising:
periodically acquiring the organization information table;
comparing the organization information difference between the organization information tables of two adjacent periods;
and generating a periodic snapshot table of the organization information according to the organization information difference.
3. The method of claim 1, further comprising:
periodically acquiring the personnel information table;
comparing personnel information differences between the personnel information tables of two adjacent periods;
and generating a periodic snapshot table of the personnel information according to the personnel information difference.
4. The method according to any one of claims 1 to 3, further comprising, after updating the records associated in the person information table according to the associated foreign key and the updated organization information table:
aiming at the update of the previous time, generating a personnel change record according to the difference between the updated personnel information table and the personnel information table before the update;
respectively generating personnel information pull-chain tables of different personnel according to personnel change records generated by updating in the past; the personnel information zipper table is used for recording personnel change records updated by corresponding personnel in each time.
5. The method of claim 4, further comprising, after generating a staff change record based on a difference between the updated staff information table and the staff information table before updating,:
writing the personnel change data into a fact table corresponding to the information type according to the information type related to the personnel change data; wherein the information categories include one or more combinations of enrollment information, trial information, vitality information, training information, and departure information.
6. The information processing method based on the data table according to any one of claims 1 to 3, wherein the organization information table is a plurality of tables, including one or more combinations of an organization unit change table, an organization unit hierarchy table, an organization unit membership table and an organization unit basic information table;
the organization unit change table is used for recording organization change data of the organization unit; the organizational change data is to indicate one or more combinations of mergers, renames, and hierarchy adjustments of organizational units;
the organization unit level table is used for recording the report level relation of the organization units;
the organization unit membership table is used for recording the administrative membership hierarchical relationship of the organization units;
and the organization unit basic information table is used for recording the functions and/or the posts of the organization units.
7. The method of claim 6, wherein the updating the organization information table according to the organization change data comprises:
updating the organization unit change table according to the organization change data;
and correspondingly updating the organization unit hierarchy table, the organization unit membership table and the organization unit basic information table according to the updated organization unit change table.
8. An information processing apparatus based on a data table, the apparatus comprising:
the first acquisition module is used for acquiring organization change data;
the first updating module is used for updating the organization information table according to the organization change data;
the second acquisition module is used for acquiring a preset associated external key between the record in the organization information table and the record in the personnel information table; the related external key refers to a mapping relation between records in the organization information table and records in the personnel information table;
the second updating module is used for updating the associated records in the personnel information table according to the associated external keys and the updated organization information table; determining a mapping relation between an organization mechanism identifier in an organization information table and a personnel identifier in a personnel information table according to the associated foreign key; according to the changed organization mechanism identification, inquiring records related to the personnel identification with mapping relation in a personnel information table; reading the updated organization mechanism identifier from the updated organization information table aiming at the changed organization mechanism identifier; and updating the records inquired in the personnel information table by adopting the updated organization mechanism identification.
9. An electronic device, comprising: memory, processor and computer program stored on the memory and executable on the processor, which when executing the program implements a method of data table based information processing according to any of claims 1-7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out a method of processing information based on a data table according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810719411.4A CN108959560B (en) | 2018-07-03 | 2018-07-03 | Information processing method and device based on data table and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810719411.4A CN108959560B (en) | 2018-07-03 | 2018-07-03 | Information processing method and device based on data table and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108959560A CN108959560A (en) | 2018-12-07 |
| CN108959560B true CN108959560B (en) | 2021-02-12 |
Family
ID=64485274
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810719411.4A Active CN108959560B (en) | 2018-07-03 | 2018-07-03 | Information processing method and device based on data table and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108959560B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111382992A (en) * | 2018-12-29 | 2020-07-07 | 达丰(上海)电脑有限公司 | Information change management method, device, equipment and storage medium |
| CN109726996A (en) * | 2019-01-03 | 2019-05-07 | 深圳壹账通智能科技有限公司 | Human input management method, device, computer equipment and storage medium |
| CN110335004A (en) * | 2019-05-08 | 2019-10-15 | 重庆天蓬网络有限公司 | A kind of product and engineering relationships solution based on responsibility system |
| CN111177398B (en) * | 2019-11-29 | 2023-07-07 | 广东轩辕网络科技股份有限公司 | Method and device for updating organization architecture |
| CN111427894A (en) * | 2020-03-26 | 2020-07-17 | 山东浪潮通软信息科技有限公司 | Method for realizing data increment summarization in comprehensive budget based on document |
| CN113780967A (en) * | 2020-11-16 | 2021-12-10 | 北京沃东天骏信息技术有限公司 | Information tracing method and device |
| CN113037844B (en) * | 2021-03-12 | 2023-01-31 | 北京京东振世信息技术有限公司 | Identification updating method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101131743A (en) * | 2006-08-23 | 2008-02-27 | 中国共产主义青年团贵州省委员会 | Method and system for managing organization information of parties and social groups |
| CN101931525A (en) * | 2009-11-23 | 2010-12-29 | 深圳市易聆科信息技术有限公司 | Information security management resource positioning method and system |
| CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
| CN102622436A (en) * | 2012-02-29 | 2012-08-01 | 浙江吉利汽车研究院有限公司 | Data table establishing method of human resource management system |
| CN105787737A (en) * | 2014-12-26 | 2016-07-20 | 阿里巴巴集团控股有限公司 | Business object information processing publishing method and business object information processing publishing device |
| CN107808005A (en) * | 2017-11-14 | 2018-03-16 | 广州品唯软件有限公司 | Processing method, device and the storage medium of human resource data |
-
2018
- 2018-07-03 CN CN201810719411.4A patent/CN108959560B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101131743A (en) * | 2006-08-23 | 2008-02-27 | 中国共产主义青年团贵州省委员会 | Method and system for managing organization information of parties and social groups |
| CN101931525A (en) * | 2009-11-23 | 2010-12-29 | 深圳市易聆科信息技术有限公司 | Information security management resource positioning method and system |
| CN102110142A (en) * | 2011-02-09 | 2011-06-29 | 浪潮集团山东通用软件有限公司 | Method for dynamically expanding personnel transaction in human resource management information system |
| CN102622436A (en) * | 2012-02-29 | 2012-08-01 | 浙江吉利汽车研究院有限公司 | Data table establishing method of human resource management system |
| CN105787737A (en) * | 2014-12-26 | 2016-07-20 | 阿里巴巴集团控股有限公司 | Business object information processing publishing method and business object information processing publishing device |
| CN107808005A (en) * | 2017-11-14 | 2018-03-16 | 广州品唯软件有限公司 | Processing method, device and the storage medium of human resource data |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108959560A (en) | 2018-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108959560B (en) | Information processing method and device based on data table and electronic equipment | |
| US7937416B2 (en) | Business intelligence data repository and data management system and method | |
| Andresen et al. | A taxonomy of internationally mobile managers | |
| List et al. | A comparison of data warehouse development methodologies case study of the process warehouse | |
| EP1681634A1 (en) | Method and system for tracking changes in a document | |
| US20020178036A1 (en) | Project management method and project management system | |
| US20190311042A1 (en) | Intelligent incentive distribution | |
| US20210279690A1 (en) | Pathfinder | |
| Balabanov et al. | Implementation of ISO 9001, ISO 14001, ISO 45001 requirements with the systems of electronic document turnover | |
| CN114676316A (en) | Method and system for constructing enterprise employee portrait based on big data | |
| Peng et al. | Establishment of business intelligence and big data analysis for higher education | |
| CN111784385A (en) | Manufacturing industry-oriented client portrait construction method and device and computer storage medium | |
| KR101725142B1 (en) | Strategy map management method and device, and storage media storing the same | |
| Ahmed et al. | Improvement of Vehicle Management System (IVMS) | |
| US20050080820A1 (en) | Method and system for generating, associating and employing user-defined fields in a relational database within an information technology system | |
| Mans et al. | Data quality issues | |
| Mathieu et al. | Data quality in the database systems course | |
| US20090030760A1 (en) | Computer-implemented management system, method and computer program product | |
| Halpin | Temporal modeling and ORM | |
| Djedović et al. | A combined process mining for improving business process | |
| Jain | Data Science and Analytics (with Python, R and SPSS Programming) | |
| CN111078680B (en) | Table information processing method, apparatus, electronic device and readable storage medium | |
| Banerjee et al. | Review of Current Practices for Implementing Organization-Wide Knowledge Repositories | |
| Hawk | Implementing standardized statistical measures and metrics for public services in archival repositories and special collections libraries | |
| Mathieu et al. | Teaching Data Quality in the Undergraduate Database Course. |
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 |