Employee information updating method, device, computer equipment and storage medium

Abstract

The present application relates to an employee information update method, device, computer equipment and storage medium. The method includes: obtaining a first information file from an information server, and storing a first employee information set in the first information file to a local cache space; obtaining a second information file from a domain control server, and storing the second information file to a local memory space; based on the employee identifier corresponding to each object in the second employee information set, integrating the first employee information set and the second employee information set in the local memory space to obtain a target employee information set; storing the target employee information set to the local memory space; determining a historical employee information set in the local memory space; in the local memory space, comparing the target employee information set with the historical employee information set, and updating the corresponding employee information in the database according to the comparison result. The use of this method can achieve efficient management of scattered employee information.

Description

Technical Field

[0001] The present application relates to the field of database technology, and in particular to an employee information updating method, device, computer equipment and storage medium. Background Art

[0002] At present, the personnel management of large enterprises generally adopts Active Directory domain to manage departments and personnel rights, or uses human resource management system to record employee information, approval relationship between superiors and subordinates, etc. However, such decentralized management method makes the employee information data of large enterprises scattered and unreasonable, making it difficult to achieve unified management of employee information. Summary of the invention

[0003] Based on this, it is necessary to provide an employee information updating method, device, computer equipment and storage medium that can realize unified management and updating of employee information in response to the above technical problems.

[0004] A method for updating employee information, the method comprising:

[0005] Acquire a first information file from an information server, and store a first employee information set in the first information file into a local cache space;

[0006] Acquire a second information file from a domain control server, and store the second information file in a local memory space; the second information file includes a second employee information set;

[0007] Based on the employee identifier corresponding to each object in the second employee information set, the first employee information set and the second employee information set are integrated in the local memory space to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object;

[0008] Storing the target employee information set in a local memory space;

[0009] Determine a historical employee information set in a local memory space, where the historical employee information set is imported into the local memory space from a database in advance;

[0010] In the local memory space, the target employee information set is compared with the historical employee information set, and the corresponding employee information in the database is updated according to the comparison result.

[0011] In one embodiment, obtaining the second information file from the domain control server includes:

[0012] Determine a target domain to be processed currently in at least one domain managed by the domain control server;

[0013] Reading the second information file from the target domain in parallel by using multiple threads;

[0014] After the corresponding employee information in the database is updated according to the comparison result, the following is further included:

[0015] The next domain is taken as the current target domain to be processed, and the step of reading the second information file from the target domain in parallel by using multiple threads is returned to and continued to be executed until all the domains managed by the domain control server are traversed.

[0016] In one embodiment, based on the employee identifier corresponding to each object in the second employee information set, integrating the first employee information set and the second employee information set in the local memory space to obtain the target employee information set includes:

[0017] Based on the employee identifier corresponding to each object in the second employee information set, determining in the local cache space the object corresponding to the employee identifier in the first employee information set;

[0018] Based on the first group identifier related to the object in the first employee information set, the second group identifier corresponding to each object in the second employee information set is updated to obtain a target group identifier;

[0019] Determining the upper-level domain account corresponding to each object in the second employee information set based on the upper-level identifier corresponding to each upper-level of the object in the first employee information set;

[0020] In the local memory space, the upper-level domain account corresponding to each object is added to the second employee information set respectively;

[0021] The updated second employee information set is used as the target employee information set.

[0022] In one embodiment, the updating of the second group identifier corresponding to each object in the second employee information set based on the first group identifier related to the object in the first employee information set to obtain the target group identifier includes:

[0023] If an object corresponding to the employee identifier is found in the first employee information set, a first group identifier corresponding to the object is determined from the first employee information set, and a third group identifier corresponding to the first group identifier is determined in the database, and in the local memory space, the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier to obtain a target group identifier;

[0024] If no object corresponding to the employee identifier is found in the first employee information set, obtaining a second group identifier corresponding to each object in the second employee information set, and searching the local cache space for the first group identifier corresponding to the corresponding object according to the second group identifier;

[0025] If a corresponding first group identifier is found, a third group identifier corresponding to the first group identifier is searched in the database, and the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier in the database to obtain a target group identifier;

[0026] If no corresponding first group identifier is found, the second group identifier corresponding to each object in the second employee information set is updated to an ungrouped identifier in the local memory space, and the ungrouped identifier is used as the corresponding target group identifier.

[0027] In one embodiment, determining the upper-level domain account corresponding to each object in the second employee information set based on the upper-level identifier corresponding to each upper-level of the object in the first employee information set includes:

[0028] Based on the employee identifiers corresponding to the objects in the second employee information set, searching the local cache space for the superior identifiers corresponding to the superiors corresponding to the objects in the first employee information set;

[0029] According to the superior identifier, the superior domain account corresponding to each object is searched in the database; wherein the database pre-stores the association relationship between the superior identifier and the superior domain account.

[0030] In one embodiment, comparing the target employee information set with the historical employee information set in the local memory space, and updating the corresponding employee information in the database according to the comparison result, includes:

[0031] In the local memory space, determining whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier;

[0032] If it is an ungrouped identifier, query the corresponding group in the database according to the ungrouped identifier, and add the target employee information corresponding to each object corresponding to the ungrouped identifier in the target employee information set to the group;

[0033] If it is not an ungrouped mark, comparing the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see whether they match;

[0034] If there is no match, an update operation is performed on the historical employee information of the corresponding object in the historical employee information set in the database based on the target employee information corresponding to each object in the target employee information set; wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

[0035] In one embodiment, comparing the target employee information set with the historical employee information set in the local memory space, and updating the corresponding employee information in the database according to the comparison result, includes:

[0036] Comparing the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set to see whether they match;

[0037] If there is no match, the group identifier corresponding to the corresponding object in the database is updated according to the target group identifier.

[0038] An employee information updating device, comprising:

[0039] An acquisition module, used for acquiring a first information file from an information server, and storing a first employee information set in the first information file into a local cache space;

[0040] The acquisition module is further used to acquire a second information file from the domain control server and store the second information file in the local memory space; the second information file includes a second employee information set;

[0041] an integration module, configured to integrate the first employee information set and the second employee information set in a local memory space based on the employee identifier corresponding to each object in the second employee information set, to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object;

[0042] A storage module, used for storing the target employee information set in a local memory space;

[0043] A determination module, used to determine a historical employee information set in a local memory space, wherein the historical employee information set is imported into the local memory space from a database in advance;

[0044] The updating module is used to compare the target employee information set with the historical employee information set in the local memory space, and update the corresponding employee information in the database according to the comparison result.

[0045] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above method when executing the computer program.

[0046] A computer-readable storage medium stores a computer program, which implements the steps of the above method when executed by a processor.

[0047] The employee information updating method, device, computer equipment and storage medium respectively obtain information files from the information server and the domain control server, and integrate the employee information sets therein in the local memory space according to the information files of the two, thereby avoiding multiple interactions with the database and improving processing efficiency; then the integrated target employee information set is compared with the historical employee information set in the database extracted to the local memory space, and the corresponding employee information in the database is updated according to the comparison result. In this way, the scattered employee information can be efficiently integrated together, which is convenient for adding, deleting, modifying, and searching the employee information. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] Figure 1 This is an application environment diagram of an employee information updating method according to an embodiment;

[0049] Figure 2 A flowchart of an employee information updating method according to an embodiment of the present invention;

[0050] Figure 3 is a flow chart of the integration steps of an embodiment;

[0051] Figure 4 is a flow chart of the integration steps of another embodiment;

[0052] Figure 5 is a flow chart of the integration steps of another embodiment;

[0053] Figure 6 is a flow chart of the integration steps of yet another embodiment;

[0054] Figure 7 A schematic diagram of a flow chart of the steps of updating a database according to an embodiment;

[0055] Figure 8 A schematic flow chart of the steps of updating a database according to another embodiment;

[0056] Fig. 9 An interactive schematic diagram of an employee information updating method according to an embodiment;

[0057] Fig.10 It is a structural block diagram of an employee information updating device according to an embodiment;

[0058] Fig.11 The figure is a diagram of the internal structure of a computer device according to an embodiment. DETAILED DESCRIPTION

[0059] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0060] The employee information updating method provided in this application can be applied to Figure 1 In the application environment shown. Among them, the information server 110 is connected to the management server 130 through a network, and the domain control server 120 is connected to the third-party server 130 through a network. The third-party server 130 is provided with a storage space, including a cache space and a memory space, etc. At the same time, the third-party server 130 is also provided with a database, and the third-party server 130 can perform operations such as query, read, call, and modify the information in the database. Exemplarily, the information server 110 is a human resources management server, which is usually used to manage information such as the organizational structure of the enterprise. Exemplarily, the domain control server 120 is an AD domain control server, which is usually used to manage information such as employee information of the employees of the enterprise.

[0061] The network may be the Internet, a mobile network, a local area network (LAN), a wide area network (WLAN), a storage area network (SAN), one or more intranets, or a suitable combination thereof. The embodiment of the present application does not limit the type or protocol of the communication network between the server device and the electronic device on the user side in the present application. The network connection includes one or more of a wired network connection (e.g., via a network cable) and a wireless network connection (e.g., via Bluetooth, 4G / 5G / 6G, and Wi-Fi, etc.).

[0062] The above-mentioned servers can be arranged on one or more physical servers according to various factors such as function and load. Among them, when distributed on multiple physical servers, the server can be composed of servers based on cloud architecture. For example, the server based on cloud architecture includes a public cloud (Public Cloud) server and a private cloud (Private Cloud) server, wherein the public or private cloud server includes Software-as-a-Service (Software as a Service, SaaS), Platform-as-a-Service (Platform as a Service, PaaS) and Infrastructure-as-a-Service (Infrastructure as a Service, IaaS), etc. The server can also be composed of distributed or centralized server clusters. For example, a server cluster is composed of at least one physical server. Multiple virtual servers are configured in each physical server, and each virtual server runs at least one functional module to implement the above-mentioned employee information update method, and each virtual server communicates through the network.

[0063] It should be noted that the enterprise organizational structure information and employee information involved in this application are all information authorized by employees or fully authorized by all parties, and the above information is only used for employee information management within the enterprise organization.

[0064] In one embodiment, Figure 2 As shown, a method for updating employee information is provided, which is applied to Figure 1 The third-party server in the example is used as an example to illustrate the process, including the following steps:

[0065] Step S202: Acquire a first information file from an information server, and store a first employee information set in the first information file into a local cache space.

[0066] Among them, the first information file includes organizational structure information and a first employee information set. The organizational structure information includes but is not limited to one or more of a group name, a group identifier, a parent group identifier, and a status. The first employee information set includes but is not limited to one or more employee information such as the employee's work number, the group identifier of the group to which the employee belongs, and the employee's direct superior's work number. For example, the group name can be the name of a task team or group within the enterprise, and the parent group of the group to which the task team belongs is the enterprise department to which it belongs. Among them, the third-party server obtains an information file from the information server through a network connection. For example, the information server can push an information file to the third-party server at a preset frequency (for example, every week, every day, every hour, etc.). For another example, the third-party server can send a read request to the information server at a preset frequency or when an update is required, and the information server sends an information file to the third-party server according to the read request.

[0067] It should be noted that in the embodiments of the present application, in order to distinguish, the information / data from the information server is represented by the term "first", the information / data from the domain control server is represented by the term "second", and the information / data from the third-party server is represented by the term "third". For example, the first information file is used to represent the information file from the information server, and the second information file is used to represent the information file from the domain control server. Similar situations also include the first employee information set and the second employee information set.

[0068] Specifically, after the third-party server obtains the first information file from the information server, it updates the corresponding information in the database according to the organizational structure information in the first information file. Exemplarily, the third-party server inserts new information or updates existing information according to the group identifier in the first information file. At the same time, the third-party server stores the first employee information set in the first information file in the local cache space for subsequent update operations. Exemplarily, the local cache space is, for example, a Redis cache space.

[0069] Step S204, obtaining a second information file from the domain control server, and storing the second information file in the local memory space; the second information file includes a second employee information set.

[0070] The second information file includes a second employee information set. The second employee information set includes, but is not limited to, one or more employee information such as employee ID, employee name, employee account, and work email address. Specifically, the third-party server obtains the second information file from the domain control server and stores the second information file in the local memory space for subsequent update operations.

[0071] In some embodiments, Figure 3 As shown, the step of the third-party server obtaining the second information file from the domain control server includes:

[0072] Step S302: determining a target domain to be processed currently in at least one domain managed by the domain control server.

[0073] Step S304: read the second information file from the target domain in parallel by using multiple threads.

[0074] Among them, the domain control server usually manages at least one domain, such as the office domain HDQ.spdb.com and the village bank domain OVS.spdb.com. Specifically, the third-party server initializes the domain connection according to the configuration information. Among them, the configuration information includes but is not limited to one or more of the domain administrator account, password, root domain name, IP address of the server where the domain is located, and port. The third-party server determines one of the domains in at least one domain as the target domain that needs to be updated currently. After determining the target domain, the third-party server can use the domain administrator account, password and other parameters to connect to the target domain, thereby obtaining the second information file under the target domain in the domain control server. The third-party server uses multi-threading to read the second information file in parallel from the target domain, which significantly improves the processing efficiency compared to the circular reading operation in the prior art.

[0075] In order to reduce the pressure on the server, the domain synchronization function is processed by domain in the embodiment of the present application, and each update of employee information is based on the domain hierarchy, that is, each update only synchronizes the data of the current domain. After the subsequent update operation is completed on the current target domain, in some embodiments, the following steps are also included: Step S306, taking the next domain as the current target domain to be processed, returning to the step of reading the second information file in parallel from the target domain using multiple threads and continuing to execute until all domains managed by the domain control server are traversed. Specifically, the third-party server selects the next domain to be updated in at least one domain, and takes the next domain as the current target domain to be processed, and returns to step S304 to continue execution, thereby updating the next domain. In this way, all domains managed by the domain control server are traversed until all domains managed by the domain control server are traversed, thereby completing the data update of all domains.

[0076] In the above embodiment, domain synchronization function is processed by domain, data of only one domain is processed each time, and multi-threading is used to read in parallel from the target domain, thereby improving processing efficiency.

[0077] Step S206, based on the employee identification corresponding to each object in the second employee information set, the first employee information set and the second employee information set are integrated in the local memory space to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object.

[0078] Specifically, after obtaining the first employee information set and the second employee information set, the third-party server stores them in the local memory space for integrated processing. Compared with the prior art in which each query requires interaction with the database, the method provided in the embodiment of the present application can reduce the interaction with the database, alleviate the pressure on the database, and improve processing efficiency.

[0079] Step S208, storing the target employee information set in the local memory space. Specifically, after the third-party server integrates the first employee information set and the second employee information set to obtain the target employee information set, it stores the target employee information set in the local memory space, so that the third-party server can subsequently update the database in the local memory space based on the integrated target employee information set. In this way, direct interaction with the database is avoided, the pressure on the database is reduced, and the processing efficiency is improved.

[0080] Step S210, determining a historical employee information set in the local memory space, where the historical employee information set is pre-imported from a database into the local memory space.

[0081] The historical employee information set is a set of employee information stored in the database. For example, the historical employee information set may be the target employee information set obtained after the last update, and in this update, it is the historical employee information set. Specifically, the third-party server imports the historical employee information set in the database into the local memory space for subsequent comparison with the target employee information set in the local memory space.

[0082] It should be noted that the third-party server may import the historical employee information set from the database into the local memory space after integrating the first employee information set and the second employee information set to obtain the target employee information set, that is, after step S206; or the third-party server may import the historical employee information set from the database into the local memory space before step S206, for example, before step S202, or after step S204 and before step S206, etc. In the embodiment of the present application, the execution order of the steps of the third-party server importing the historical employee information set from the database into the memory space is not limited.

[0083] Step S212, in the local memory space, the target employee information set is compared with the historical employee information set, and the corresponding employee information in the database is updated according to the comparison result.

[0084] Specifically, the third-party server compares the integrated target employee information set with the historical employee information set extracted from the database in the local memory space, and performs corresponding update operations on the database according to the comparison results, thereby updating the corresponding employee information in the database. For example, for a certain employee, the employee account in the target employee information set is inconsistent with the employee account in the historical employee information set, then the third-party server modifies the employee account corresponding to the employee in the database according to the new employee account in the target employee information set, thereby completing the update of the employee information. For another example, for a resigned employee, the third-party server deletes the employee information corresponding to the employee in the database, and so on.

[0085] Thus, the third-party server completes the integration of scattered employee information and updates the database based on the integrated target employee information.

[0086] The above employee information updating method obtains information files from the information server and the domain control server respectively, and integrates the employee information sets therein in the local memory space according to the information files of the two, thereby avoiding multiple interactions with the database and improving processing efficiency; then the integrated target employee information set is compared with the historical employee information set in the database extracted to the local memory space, and the corresponding employee information in the database is updated according to the comparison result. In this way, the scattered employee information can be efficiently integrated together, which is convenient for adding, deleting, modifying, and searching the employee information.

[0087] In some embodiments, Figure 4 As shown, the third-party server integrates the first employee information set and the second employee information set in the local memory space based on the employee identifier corresponding to each object in the second employee information set to obtain the target employee information set, including:

[0088] Step S402: Based on the employee identification corresponding to each object in the second employee information set, determine the object corresponding to the employee identification in the first employee information set in the local cache space.

[0089] Step S404: based on the first group identifier related to the object in the first employee information set, the second group identifier corresponding to each object in the second employee information set is updated to obtain a target group identifier.

[0090] Step S406: determining the superior domain account corresponding to each object in the second employee information set based on the superior identifier corresponding to each superior of the object in the first employee information set.

[0091] Step S408: In the local memory space, the upper-level domain account corresponding to each object is added to the second employee information set respectively.

[0092] Step S410: Using the updated second employee information set as the target employee information set.

[0093] Among them, the object in the employee information set refers to the employee. The employee identifier corresponding to the object refers to the employee's work number. The superior identifier refers to the work number of the employee's direct superior. Similar to the above embodiment, in order to distinguish, the group identifier in the first employee information set is called the first group identifier, and the group identifier in the second employee information set is called the second group identifier. At the same time, the group identifier in the database of the third-party server is called the third group identifier. Exemplarily, the first group identifier is represented by GUID, the second group identifier is represented by DomainGUID, and the third group identifier is represented by GroupID. Among them, in the database of the third-party server, the mapping relationship between the first group identifier and the second group identifier, and the mapping relationship between the first group identifier and the third group identifier are pre-stored. For example, in the database, in the form of a table, the first group identifier GUID is associated with the second group identifier DomainGUID and stored, and the first group identifier GUID is associated with the third group identifier GroupID and stored. The database of the third-party server also pre-stores

[0094] Specifically, the third-party server extracts the employee identification corresponding to each object in the second employee information set, and determines the object corresponding to the employee identification in the first employee information set stored in the local cache space based on the employee identification. If the value is not empty, it means that there is an object corresponding to the employee identification in the first employee information set stored in the local cache space. Therefore, on the one hand, the third-party server updates the second group identification corresponding to each object in the second employee information set based on the first group identification related to the object in the first employee information set to obtain the target group identification. On the other hand, since the first employee information set contains the employee's direct superior work number, the third-party server can determine the superior domain account corresponding to each object in the second employee information set based on the superior identification corresponding to each superior of the object in the first employee information set, and add the superior domain account corresponding to each object to the second employee information set in the local memory space. Therefore, after updating the group identification and the superior domain account, the third-party server uses the updated second employee information set as the target employee information set.

[0095] In the above embodiment, the first employee information and the second employee information are integrated to obtain complete employee information, which can integrate scattered employee information together, and is conducive to efficient management of employee information.

[0096] In some embodiments, Figure 5 As shown, the third-party server updates the second group identifier corresponding to each object in the second employee information set based on the first group identifier related to the object in the first employee information set, and the step of obtaining the target group identifier includes:

[0097] Step S502: If an object corresponding to the employee identifier is found in the first employee information set, a first group identifier corresponding to the object is determined from the first employee information set, and a third group identifier corresponding to the first group identifier is determined in the database. In the local memory space, the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier to obtain the target group identifier.

[0098] Step S504: if no object corresponding to the employee identifier is found in the first employee information set, obtain the second group identifiers corresponding to each object in the second employee information set, and search the local cache space for the first group identifier corresponding to the corresponding object according to the second group identifiers.

[0099] Step S506, if a corresponding first group identifier is found, a third group identifier corresponding to the first group identifier is searched in the database, and the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier in the database to obtain a target group identifier.

[0100] Step S508, if no corresponding first group identifier is found, then in the local memory space, the second group identifier corresponding to each object in the second employee information set is updated to an ungrouped identifier, and the ungrouped identifier is used as the corresponding target group identifier.

[0101] Specifically, the third-party server searches the local cache space by taking values ​​according to the employee identifier, thereby determining whether there is an object corresponding to the employee identifier in the first employee information set stored in the local cache space.

[0102] If the value is empty, then there is no object corresponding to the employee ID in the first employee information set; conversely, if the value is not empty, then there is an object corresponding to the employee ID in the first employee information set. Specifically, if the value is not empty, that is, the third-party server finds the object corresponding to the employee ID from the first employee information set, then the first group of identifiers corresponding to the object is determined from the first employee information set, and then the third group of identifiers corresponding to the first group of identifiers is determined in the database based on the first group of identifiers. Finally, the third-party server updates the second group of identifiers corresponding to the object in the second employee information set in the local memory space based on the third group of identifiers, and the updated second group of identifiers is the target group identifier.

[0103] Exemplarily, the third-party server retrieves a value from the local cache based on the employee ID in the second employee information set. If the value is not empty, the GUID corresponding to the employee ID is extracted from the first employee information set. Then, the third-party server determines the GroupID corresponding to the GUID in the database based on the GUID, and updates the DomainGUID in the second employee information set with the GroupID. The updated DomainGUID is the target group identifier. If the value is empty, that is, the third-party server does not find an object corresponding to the employee ID from the first employee information set, the third-party server obtains the second group identifier corresponding to each object in the second employee information set, and searches the local cache space for the first group identifier corresponding to the corresponding object based on the second group identifier. Exemplarily, the third-party server extracts the second group identifier DomainGUID corresponding to each object in the second employee information set, and then searches the local cache space for the first group identifier GUID corresponding to the corresponding object based on the DomainGUID.

[0104] If a corresponding first group identifier is found, the third-party server searches the database for a third group identifier corresponding to the first group identifier, and updates the second group identifier corresponding to each object in the second employee information set based on the third group identifier in the database to obtain a target group identifier. That is, the third-party server searches the database for a third group identifier GroupID corresponding to the first group identifier GUID based on the first group identifier GUID, and updates the second group identifier DomainGUID based on the third group identifier GroupID to obtain the target group identifier.

[0105] If no corresponding first group identifier is found, the third-party server updates the second group identifier corresponding to each object in the second employee information set to an ungrouped identifier in the local memory space, and uses the ungrouped identifier as the corresponding target group identifier. That is, the third-party server updates the second group identifier DomainGUID to an ungrouped identifier in the local memory space. Exemplarily, the ungrouped identifier can be represented by a specific value, such as 0, -1, or null.

[0106] In the above embodiment, the first employee information and the second employee information are integrated to obtain complete employee information, which can integrate scattered employee information together, and is conducive to efficient management of employee information.

[0107] In some embodiments, Figure 6 As shown, the step of the third-party server determining the upper-level domain account corresponding to each object in the second employee information set based on the upper-level identifier corresponding to each upper-level of the object in the first employee information set includes:

[0108] Step S602: Based on the employee identifier corresponding to each object in the second employee information set, the superior identifier corresponding to each superior corresponding to each object in the first employee information set is searched in the local cache space.

[0109] Step S604: searching the database for the upper-level domain account corresponding to each object according to the upper-level identifier; wherein the database pre-stores the association relationship between the upper-level identifier and the upper-level domain account.

[0110] As mentioned above, the association relationship between the superior identifier and the superior domain account is pre-stored in the database of the third-party server. For example, the associated superior identifier and superior domain account are stored in the form of a table. Specifically, based on the employee identifier (i.e., employee work number) corresponding to each object in the second employee information set, the third-party server searches the local cache space for the superior identifier (i.e., employee's direct superior work number) corresponding to each superior corresponding to each object in the first employee information set. According to the superior identifier, the superior domain account corresponding to each object is searched in the database. In this way, the third-party server can add the superior domain account to the second employee information set in the local memory space.

[0111] Therefore, after the group identifier and the upper-level domain account are updated, the third-party server can obtain the information obtained by integrating the first employee information set and the second employee information set.

[0112] In the above embodiment, the first employee information and the second employee information are integrated to obtain complete employee information, which can integrate scattered employee information together, and is conducive to efficient management of employee information.

[0113] In some embodiments, Figure 7 As shown, the third-party server compares the target employee information set with the historical employee information set in the local memory space, and updates the corresponding employee information in the database according to the comparison result, including:

[0114] Step S702: In the local memory space, it is determined whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier.

[0115] Step S704: if it is an ungrouped mark, then according to the ungrouped mark, the corresponding group is searched in the database, and the target employee information corresponding to each object corresponding to the ungrouped mark in the target employee information set is added to the group.

[0116] Step S706: if there is no ungrouped mark, compare the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see if they match.

[0117] Step S708, if there is no match, then based on the target employee information corresponding to each object in the target employee information set, an update operation is performed on the historical employee information of the corresponding object in the historical employee information set in the database; wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

[0118] Specifically, the third-party server determines in the local memory space whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier. Taking the ungrouped identifier as a value of "-1" as an example, if the value of the target group identifier is "-1", the third-party server queries the database to see whether the corresponding group exists. If the group exists, the third-party server adds the target employee information corresponding to each object corresponding to the ungrouped identifier in the target employee information set to the group; if the group does not exist, the third-party server creates a corresponding group in the database and then adds the corresponding target employee information to the group. If it is not an ungrouped identifier, that is, if the value of the target group identifier is not "-1", the third-party server compares the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see if they match. For example, whether the employee account in the target employee information is consistent with the employee account in the historical employee information, etc. If they are completely consistent, no operation is performed, and the third-party server compares the next object and traverses all objects in the target employee information set in sequence. If there is any unmatched employee information, the third-party server performs an update operation on the corresponding employee information in the database according to the target employee information, wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

[0119] In the above embodiment, the historical employee information in the database is updated according to the integrated employee information, which effectively avoids the situation where each employee information needs to interact with the database, reduces the pressure on the database, and integrates first and then updates the database, thereby improving the update efficiency.

[0120] In some embodiments, Figure 8 As shown, the third-party server compares the target employee information set with the historical employee information set in the local memory space, and updates the corresponding employee information in the database according to the comparison result, including the following steps:

[0121] Step S802: compare the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set to see if they match.

[0122] Step S804: If there is no match, the group identifier corresponding to the corresponding object in the database is updated according to the target group identifier.

[0123] Specifically, the third-party server compares the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set in the local memory space to see if they match. If they match, no operation needs to be performed. If they do not match, the third-party server performs a group-level move operation, that is, moves the corresponding employee information from a group in the database to the group corresponding to the target group identifier, thereby updating the group identifier in the database. Thus, the update of the corresponding employee information in the database is completed.

[0124] In the above embodiment, the historical employee information in the database is updated according to the integrated employee information, which effectively avoids the situation where each employee information needs to interact with the database, reduces the pressure on the database, and integrates first and then updates the database, thereby improving the update efficiency.

[0125] In a specific example, the three-party interaction process of the employee information update method provided in the embodiment of the present application is as follows: Fig. 9As shown, the third-party server background configures scheduled user (i.e., employee) synchronization, and its console can configure the time for automatic synchronization, etc., or the operator can manually trigger the synchronization operation. When synchronization is started, the third-party server obtains the first information file from the information server, for example, the HR system (corresponding to the information server) regularly pushes the user information file at 9:30 pm every day. The third-party server first synchronizes the HR user information, that is, reads the HR user information file, and stores the HR user information (i.e., the first employee information set) in the HR user information to the Redis cache (i.e., the local cache space) for subsequent use of the employee work number to divide the AD user affiliation (i.e., the employee belonging group in the domain control server). At the same time, the third-party server updates the organizational information in the database according to the HR organizational information in the HR user information file. In addition, the third-party server uses multi-threaded traversal to obtain the AD user information (i.e., the second employee information set) from the AD domain control server (i.e., the domain control server), uses multiple processing threads to process multiple user groups at the same time, and assigns each user to multiple threads for processing, that is, it is processed by multiple user processing threads. Then, the third-party server determines whether the user exists in the third-party system database. There are three possible states: one is that the domain account is disabled, and the third-party server updates the locked state; the second is that if it does not exist in the database, a new operation is performed; the third is that if it exists in the database, an update operation is performed. The third-party server compares the integrated HR user data in the cache (i.e., the target employee information set), performs corresponding operations on the database (such as adding, deleting, and changing, etc.), and then removes the processed users from the memory and deletes the data that has not been updated and synchronized. Thus, the third-party server completes the update processing of the current domain and loops to process the next domain; or, when all domains that need to be processed are processed, the synchronization ends. Thus, the third-party server updates the corresponding employee information in the database based on the integrated employee information set, thereby achieving efficient management of scattered employee information.

[0126] It should be understood that although Figure 2-8 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 2-8 At least part of the steps may include multiple steps or multiple stages. These steps or stages are not necessarily performed at the same time, but can be performed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed in turn or alternately with other steps or at least part of the steps or stages in other steps.

[0127] In one embodiment, Fig.10 As shown, an employee information updating device 1000 is provided, comprising an acquisition module 1001, an integration module 1002, a storage module 1003, a determination module 1004, and an update module 1005, wherein:

[0128] The acquisition module 1001 is used to acquire a first information file from an information server, and store a first employee information set in the first information file into a local cache space.

[0129] The acquisition module 1001 is further used to acquire a second information file from the domain control server and store the second information file in the local memory space; the second information file includes a second employee information set.

[0130] The integration module 1002 is used to integrate the first employee information set and the second employee information set in the local memory space based on the employee identification corresponding to each object in the second employee information set to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object.

[0131] The storage module 1003 is used to store the target employee information set in the local memory space.

[0132] The determination module 1004 is used to determine the historical employee information set in the local memory space. The historical employee information set is imported into the local memory space from the database in advance.

[0133] The updating module 1005 is used to compare the target employee information set with the historical employee information set in the local memory space, and update the corresponding employee information in the database according to the comparison result.

[0134] In one embodiment, the acquisition module is also used to determine the current target domain to be processed in at least one domain managed by the domain control server; use multiple threads to read the second information file in parallel from the target domain; and use the next domain as the current target domain to be processed, return to the step of reading the second information file in parallel from the target domain using multiple threads and continue to execute until all domains managed by the domain control server are traversed.

[0135] In one embodiment, the integration module is also used to determine, in the local cache space, the objects corresponding to the employee identifiers in the first employee information set based on the employee identifiers corresponding to the objects in the second employee information set; update the second group of identifiers corresponding to the objects in the second employee information set based on the first group of identifiers related to the objects in the first employee information set to obtain the target group identifier; determine the upper-level domain account corresponding to each object in the second employee information set based on the superior identifiers corresponding to each superior of the object in the first employee information set; add the superior domain account corresponding to each object to the second employee information set in the local memory space; and use the updated second employee information set as the target employee information set.

[0136] In one embodiment, the integration module is also used to determine the first group identifier corresponding to the object from the first employee information set if an object corresponding to the employee identifier is found from the first employee information set, and determine the third group identifier corresponding to the first group identifier in the database, and update the second group identifier corresponding to each object in the second employee information set in the local memory space based on the third group identifier to obtain a target group identifier; if the object corresponding to the employee identifier is not found from the first employee information set, obtain the second group identifier corresponding to each object in the second employee information set, and search the local cache space for the first group identifier corresponding to the corresponding object based on the second group identifier; if the corresponding first group identifier is found, search the database for the third group identifier corresponding to the first group identifier, and update the second group identifier corresponding to each object in the second employee information set based on the third group identifier in the database to obtain the target group identifier; if the corresponding first group identifier is not found, update the second group identifier corresponding to each object in the second employee information set to an ungrouped identifier in the local memory space, and use the ungrouped identifier as the corresponding target group identifier.

[0137] In one embodiment, the integration module is also used to search the superior identifier corresponding to each superior corresponding to each object in the first employee information set in the local cache space based on the employee identifier corresponding to each object in the second employee information set; and search the database for the superior domain account corresponding to each object according to the superior identifier; wherein the database pre-stores the association relationship between the superior identifier and the superior domain account.

[0138] In one embodiment, the update module is also used to determine in the local memory space whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier; if it is an ungrouped identifier, then query the corresponding group in the database according to the ungrouped identifier, and add the target employee information corresponding to each object corresponding to the ungrouped identifier in the target employee information set to the group; if it is not an ungrouped identifier, compare the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see if it matches; if not, then based on the target employee information corresponding to each object in the target employee information set, perform an update operation on the historical employee information of the corresponding object in the historical employee information set in the database; wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

[0139] In one embodiment, the update module is also used to compare the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set to see if they match; if not, the group identifier corresponding to the corresponding object in the database is updated according to the target group identifier.

[0140] For the specific definition of the employee information updating device, please refer to the definition of the employee information updating method above, which will not be repeated here. Each module in the above employee information updating device can be implemented in whole or in part by software, hardware and their combination. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0141] In one embodiment, a computer device is provided. The computer device may be a server, and its internal structure diagram may be as follows: Fig.11 As shown. The computer device includes a processor, a memory and a network interface connected through a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data such as employee information. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for updating employee information is implemented.

[0142] Those skilled in the art will understand that Fig.11The structure shown in the figure is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0143] In one embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the following steps when executing the computer program: obtaining a first information file from an information server, and storing a first employee information set in the first information file in a local cache space; obtaining a second information file from a domain control server, and storing the second information file in a local memory space; the second information file includes a second employee information set; based on an employee identifier corresponding to each object in the second employee information set, integrating the first employee information set and the second employee information set in a local memory space to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object; storing the target employee information set in a local memory space; determining a historical employee information set in the local memory space, the historical employee information set being pre-imported from a database into the local memory space; comparing the target employee information set with the historical employee information set in the local memory space, and updating the corresponding employee information in the database according to the comparison result.

[0144] In one embodiment, when the processor executes the computer program, the following steps are also implemented: in at least one domain managed by the domain control server, determining the current target domain to be processed; using multiple threads to read the second information file in parallel from the target domain; after updating the corresponding employee information in the database according to the comparison result, it also includes: taking the next domain as the current target domain to be processed, returning to the step of reading the second information file in parallel from the target domain using multiple threads and continuing to execute until all domains managed by the domain control server are traversed.

[0145] In one embodiment, when the processor executes the computer program, the following steps are also implemented: based on the employee identification corresponding to each object in the second employee information set, the object corresponding to the employee identification in the first employee information set is determined in the local cache space; based on the first group identification related to the object in the first employee information set, the second group identification corresponding to each object in the second employee information set is updated to obtain the target group identification; based on the superior identification corresponding to each superior of the object in the first employee information set, the superior domain account corresponding to each object in the second employee information set is determined; in the local memory space, the superior domain account corresponding to each object is respectively added to the second employee information set; and the updated second employee information set is used as the target employee information set.

[0146] In one embodiment, when the processor executes the computer program, the following steps are further implemented: if an object corresponding to the employee identifier is found from the first employee information set, a first group identifier corresponding to the object is determined from the first employee information set, and a third group identifier corresponding to the first group identifier is determined in a database, and in a local memory space, the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier to obtain a target group identifier; if an object corresponding to the employee identifier is not found from the first employee information set, the second group identifier corresponding to each object in the second employee information set is obtained, and according to the second group identifier, the first group identifier corresponding to the corresponding object is searched in a local cache space; if a corresponding first group identifier is found, a third group identifier corresponding to the first group identifier is searched in a database, and the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier in the database to obtain a target group identifier; if a corresponding first group identifier is not found, the second group identifier corresponding to each object in the second employee information set is updated to an ungrouped identifier in the local memory space, and the ungrouped identifier is used as the corresponding target group identifier.

[0147] In one embodiment, when the processor executes the computer program, the following steps are also implemented: based on the employee identifier corresponding to each object in the second employee information set, searching the local cache space for the superior identifier corresponding to each superior corresponding to each object in the first employee information set; based on the superior identifier, searching the database for the superior domain account corresponding to each object; wherein the database pre-stores the association relationship between the superior identifier and the superior domain account.

[0148] In one embodiment, when the processor executes the computer program, the following steps are also implemented: in the local memory space, determining whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier; if it is an ungrouped identifier, querying the corresponding group in the database according to the ungrouped identifier, and adding the target employee information corresponding to each object corresponding to the ungrouped identifier in the target employee information set to the group; if it is not an ungrouped identifier, comparing the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see if it matches; if it does not match, performing an update operation on the historical employee information of the corresponding object in the historical employee information set in the database based on the target employee information corresponding to each object in the target employee information set; wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

[0149] In one embodiment, when the processor executes the computer program, the following steps are also implemented: comparing the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set to see if they match; if not, updating the group identifier corresponding to the corresponding object in the database according to the target group identifier.

[0150] The above-mentioned computer device obtains information files from the information server and the domain control server respectively, and integrates the employee information sets therein in the local memory space according to the information files of the two, thereby avoiding multiple interactions with the database and improving processing efficiency; then the integrated target employee information set is compared with the historical employee information set in the database extracted to the local memory space, and the corresponding employee information in the database is updated according to the comparison result. In this way, the scattered employee information can be efficiently integrated together, which is convenient for adding, deleting, modifying, and searching the employee information.

[0151] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0152] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).

[0153] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0154] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.

Claims

1. A method for updating employee information, characterized in that: The method comprises: Acquire a first information file from an information server, and store a first employee information set in the first information file into a local cache space; In at least one domain managed by the domain control server, determine a target domain to be processed currently; read a second information file from the target domain in parallel using multiple threads; and store the second information file in a local memory space; the second information file includes a second employee information set; Based on the employee identifier corresponding to each object in the second employee information set, the first employee information set and the second employee information set are integrated in the local memory space to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object; Storing the target employee information set in a local memory space; Determine a historical employee information set in a local memory space, where the historical employee information set is imported into the local memory space from a database in advance; In the local memory space, the target employee information set is compared with the historical employee information set, and the corresponding employee information in the database is updated according to the comparison result; the next domain is used as the current target domain to be processed, and the step of using multiple threads to read the second information file in parallel from the target domain is returned and continued to be executed until all domains managed by the domain control server are traversed.

2. The method according to claim 1, characterized in that The step of integrating the first employee information set and the second employee information set in the local memory space based on the employee identifier corresponding to each object in the second employee information set to obtain a target employee information set includes: Based on the employee identifier corresponding to each object in the second employee information set, determining in the local cache space the object corresponding to the employee identifier in the first employee information set; Based on the first group identifier related to the object in the first employee information set, the second group identifier corresponding to each object in the second employee information set is updated to obtain a target group identifier; Determining the upper-level domain account corresponding to each object in the second employee information set based on the upper-level identifier corresponding to each upper-level of the object in the first employee information set; In the local memory space, the upper-level domain account corresponding to each object is added to the second employee information set respectively; The updated second employee information set is used as the target employee information set.

3. The method according to claim 2, characterized in that The updating of the second group identifier corresponding to each object in the second employee information set based on the first group identifier related to the object in the first employee information set to obtain the target group identifier includes: If an object corresponding to the employee identifier is found in the first employee information set, a first group identifier corresponding to the object is determined from the first employee information set, and a third group identifier corresponding to the first group identifier is determined in the database, and in the local memory space, the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier to obtain a target group identifier; If no object corresponding to the employee identifier is found in the first employee information set, obtaining a second group identifier corresponding to each object in the second employee information set, and searching the local cache space for the first group identifier corresponding to the corresponding object according to the second group identifier; If a corresponding first group identifier is found, a third group identifier corresponding to the first group identifier is searched in the database, and the second group identifier corresponding to each object in the second employee information set is updated based on the third group identifier in the database to obtain a target group identifier; If no corresponding first group identifier is found, the second group identifier corresponding to each object in the second employee information set is updated to an ungrouped identifier in the local memory space, and the ungrouped identifier is used as the corresponding target group identifier.

4. The method according to claim 2, characterized in that: The determining, based on the superior identifiers corresponding to the superiors of the objects in the first employee information set, the superior domain account corresponding to each object in the second employee information set includes: Based on the employee identifiers corresponding to the objects in the second employee information set, searching the local cache space for the superior identifiers corresponding to the superiors corresponding to the objects in the first employee information set; According to the superior identifier, the superior domain account corresponding to each object is searched in the database; wherein the database pre-stores the association relationship between the superior identifier and the superior domain account.

5. The method according to claim 1, characterized in that: The step of comparing the target employee information set with the historical employee information set in the local memory space and updating the corresponding employee information in the database according to the comparison result includes: In the local memory space, determining whether the target group identifier corresponding to each object in the target employee information set is an ungrouped identifier; If it is an ungrouped identifier, query the corresponding group in the database according to the ungrouped identifier, and add the target employee information corresponding to each object corresponding to the ungrouped identifier in the target employee information set to the group; If it is not an ungrouped mark, comparing the target employee information corresponding to each object in the target employee information set with the historical employee information corresponding to the corresponding object in the historical employee information set to see whether they match; If there is no match, an update operation is performed on the historical employee information of the corresponding object in the historical employee information set in the database based on the target employee information corresponding to each object in the target employee information set; wherein the update operation includes at least one of an add operation, a delete operation, and a modify operation.

6. The method according to claim 1, characterized in that The step of comparing the target employee information set with the historical employee information set in the local memory space and updating the corresponding employee information in the database according to the comparison result includes: Comparing the target group identifier corresponding to each object in the target employee information set with the historical group identifier corresponding to the corresponding object in the historical employee information set to see whether they match; If there is no match, the group identifier corresponding to the corresponding object in the database is updated according to the target group identifier.

7. An employee information updating device, characterized in that: The device comprises: An acquisition module, used for acquiring a first information file from an information server, and storing a first employee information set in the first information file into a local cache space; The acquisition module is further used to determine the target domain to be processed in the at least one domain managed by the domain control server; read the second information file from the target domain in parallel by using multiple threads; and store the second information file in the local memory space; the second information file includes the second employee information set; an integration module, configured to integrate the first employee information set and the second employee information set in a local memory space based on the employee identifier corresponding to each object in the second employee information set, to obtain a target employee information set; the target employee information set includes target employee information corresponding to each object; A storage module, used for storing the target employee information set in a local memory space; A determination module, used to determine a historical employee information set in a local memory space, wherein the historical employee information set is imported into the local memory space from a database in advance; An update module is used to compare the target employee information set with the historical employee information set in the local memory space, and update the corresponding employee information in the database according to the comparison result; take the next domain as the current target domain to be processed, return to the step of reading the second information file in parallel from the target domain using multiple threads and continue to execute until all domains managed by the domain control server are traversed.

8. The device according to claim 7, characterized in that The integration module is also used for: Based on the employee identifier corresponding to each object in the second employee information set, determining in the local cache space the object corresponding to the employee identifier in the first employee information set; Based on the first group identifier related to the object in the first employee information set, the second group identifier corresponding to each object in the second employee information set is updated to obtain a target group identifier; Determining the upper-level domain account corresponding to each object in the second employee information set based on the upper-level identifier corresponding to each upper-level of the object in the first employee information set; In the local memory space, the upper-level domain account corresponding to each object is added to the second employee information set respectively; The updated second employee information set is used as the target employee information set.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 7 are implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images