CN102722568B - Data processing method for improving authority set and query efficiency of office management system - Google Patents

Abstract

The invention discloses a data processing method for improving authority set and query efficiency of an office management system. The data processing method comprises the following steps: establishing a form page, establishing three dimensionalities of a user, an authority function and an authority data scope on the form page, and carrying out interlinking on the three dimensionalities through selection; modifying the interlinking relation of the user, the authority function and authority data scope in batches, storing modified result data in batches, storing batches of data stored with the modified result data in a database according to a time sequence; and extracting the latest batches of data of the user to be modified or queried when the authority is modified or queried. The data processing method disclosed by the invention improves the authority set and the query efficiency of the office management system, so that a manager applying the system can easily distribute the authority, efficiently and rapidly search the existing authority of the user, manage the authority of the user in real time, and ensure the data safety of the system.

Description

Data processing method to improve authority setting and query efficiency in office management system

technical field

The invention relates to the field of computer technology, and more specifically, to a method for setting authority and optimizing authority query in an office management system.

Background technique

Currently in all application systems, data security management is the core function of each system. The traditional design method can configure and use different functional modules for different roles through permission settings, but the entire permission configuration process is complicated and cumbersome, and a large number of permission data storage seriously occupies database resources. Query a user's data permission range for a certain module The efficiency is also relatively low. In traditional application systems, the complexity of permission settings is mainly reflected in the fact that you can only select a single user, select a function module, and then select the corresponding data range to submit. If there is more data in any dimension of the user or function module, it will cause A large number of system administrators repeat the same tedious operations.

Contents of the invention

The purpose of the present invention is to overcome the defects of the prior art and provide a data processing method that improves the efficiency of authority setting and authority query in an office management system.

The technical problem mainly solved by the invention is to solve the problem of low efficiency of authority setting and authority query in the office management system.

In order to solve the above problems, the present invention discloses a data processing method for improving authority setting and query efficiency in an office management system. The method includes the following steps:

Step 1, constructing a form page, setting up three dimensions of user, authority function and authority data range on the form page, and the three dimensions are related to each other through selection;

Step 2, modifying the association relationship between users, authority functions and authority data ranges in batches, and storing the modification result data in batches, and storing the batch data with the modification result data in the database in time series;

Step 3. When modifying or querying permissions again, the data of the latest batch of the user to be modified or queried is retrieved.

Preferably, in the data processing method for improving authority setting and query efficiency in the office management system, modifying user authority setting includes adding and deleting.

Preferably, in the data processing method for improving authority setting and query efficiency in the office management system, when modifying user authority only includes adding but not deleting, in the latest batch of data retrieved, Add new permissions.

Preferably, in the data processing method for improving authority setting and query efficiency in the office management system, when modifying user authority includes deletion, all authority of the user is first cleared to generate deletion batch data, and then Assign a new permission value to the user through batch setting.

Preferably, in the data processing method for improving authority setting and query efficiency in the office management system, when inquiring about user authority, the user's latest deleted batch data is first retrieved, and then the latest deleted batch data is retrieved. The batch data are superimposed.

Preferably, in the data processing method for improving authority setting and query efficiency in the office management system, the users include association relationships set according to predetermined rules, and users are selected as a whole according to the association relationships.

The beneficial effects of the present invention are: the efficiency of authority setting and query in the office management system is improved, so that the administrator of the application system can easily allocate user authority, efficiently and quickly query the existing authority of the user, manage the user authority in real time, and ensure System data security. The involvement of the database structure can greatly reduce the storage of permission data, save resource costs by multiples, and improve efficiency. The permission data is stored in batches, which can completely record the change process of a user's permission, which is convenient for tracking and management. When adding and deleting permissions for users, because they are stored in batches, the permissions are set conveniently and quickly. When querying the permissions owned by the user, the overall selection operation is directly performed on the user according to the association relationship, which improves the query efficiency.

Description of drawings

Accompanying drawing 1 is the flow chart of this method permission setting.

Accompanying drawing 2 is the flow chart of this method permission inquiry.

Detailed ways

The present invention will be further described below in conjunction with the accompanying drawings, so that those of ordinary skill in the art can implement it after referring to this specification.

As shown in Figure 1, the data processing method of improving authority setting in the office management system described in the present invention, comprises the following steps:

Step 1: Build a form page, and set up three dimensions on the form page: user, authority function and authority data range, and the three dimensions are related to each other through selection.

For example, the users set on the form page include all users in the organizational structure of the unit, and these users are displayed in a structured list. Authority functions can include various functions under the authority, such as approval right, reimbursement right, modification right, review right, procurement project browsing right, technical project reference right, declaration right, etc. People in different departments may have different powers. For example, people in the purchasing department may have the right to browse the purchasing items, but only the manager of the purchasing department can have the right to approve the purchasing items, and at the same time have the right to browse the purchasing items. The manager of the marketing department will not have the right to browse the procurement items, and the manager of the financial department may have the right to browse the procurement items, but it is impossible to have the right to approve the procurement items.

In use, the user can establish an association between the user and the permission function by clicking to select the user and the permission function. The authority data range includes department information, such as purchasing department, marketing department, legal department, secretariat and other departments. By associating users, authority functions and authority data ranges, the relationship between users and authority functions, the relationship between users and departments, and the relationship between departments and authority functions can be determined. For example, for the procurement project browsing right, it can be assigned to everyone in the purchasing department, and some people in the finance department and some people in the secretariat can also have this right, but it is impossible for people in the marketing department to have this right. In this way, the relationship between authority functions and departments is established.

When using traditional methods to store permission data, the storage capacity is extremely large. For example, there are 10 users, 10 permission functions and 10 permission data ranges. According to the traditional method, each user needs to save a total of 10x10x10=1000 pieces of data for each authority function and each authority data range. However, by only saving the associated data in the present invention, it is only necessary to save three kinds of data, namely the user, the relationship between the user and the authority function, and the relationship between the user and the department. Then if there are 10 users in total, the total is 10x3=30 pieces of data. If there are 100 users, that is 300 pieces of data. Greatly reduces the amount of data storage.

Step 2: Select target users in batches, and modify their permission settings, including adding and deleting permissions. If modifying the permission setting only includes adding, add a new permission to the data of the latest batch retrieved; if modifying the permission setting includes deleting, first clear all the permissions of the user, so as to avoid It saves time by eliminating the cumbersome operation of deleting permissions multiple times for users with multiple permissions. After clearing, the system will automatically generate a batch of cleared data storage, and then assign new permission values to the user through batch settings. By using the present invention, batch modification can be performed on multiple users with the same modifying permission setting method at the same time, which improves efficiency and facilitates subsequent permission data storage and query operations.

In the prior art, modification of each authority of each user is performed and saved separately. If there are a lot of people, or there are many people who need to change permissions, for example, a new batch of employees is hired by the company, the workload of permission modification will be very large. The present invention adopts the method of batch modification and batch saving, and stores batch modification records in the system instead of storing each modification record of a single employee, which greatly saves storage space. With batch storage, there is at least one employee modification record in each batch, and there may be dozens, hundreds or even thousands of modification records at most, which naturally saves the amount of stored data, and also reduces query or download. When modifying for the first time, the workload when calling the stored data.

Step 3. The newly modified permission data is stored in batches in the historical permission data table and sorted in time series. The purpose of batch storage is to minimize the space occupied by database resources on the one hand, and to record users completely on the other hand. The entire process of permission changes.

For example, when modifying permission data in batches for the first time, five users A, B, C, D, and E are given permission settings. Assuming that these five people are all new recruits and there is no record before, then the system generates a batch data file I at this time, which records the modification authority data of these five users in the first batch. And because there is no data before, the latest batch records retrieved by the system for each user are all empty, so it is only necessary to assign values to these five users at one time. When modifying the authority data in the second batch, the authority setting of the four users A, B, C, F, and G shall be performed. Then, for users A, B, and C, it is to call the above-mentioned batch data file I, and for user F, it is to call its own latest batch data, and modify it on this basis. If the modification of these four users is to add a permission, then it is only necessary to add and assign these four users at one time, which is the simplest case. If two of the users F and G have departmental transfers and some permissions need to be deleted, the permissions clearing operation must be performed on the users F and G first, and a deletion batch data P will be generated. Then, the newly added permissions are assigned with users A, B, and C in batches. End users A, B, C, F, and G are all granted the same permission to add. And in the data of users F and G, there is a new batch of deleted data P. In the future, when querying the permissions of users F and G, it is to query the batch data after deleting the batch data P, and superimpose them.

That is to say, if you only add permissions, you don’t need to clear the permissions. If you want to delete permissions, you can use the clear operation for the convenience of assignment. Of course, you can also manually delete individual items. If a single item is deleted, deletion batch data will also be generated.

Since simply adding permissions does not generate deletion batch data, the current permission status of the user can be obtained by accumulating all batch data after deleting batch data.

As shown in Figure 2, the data processing method for improving authority inquiry in the office management system described in the present invention comprises the following steps:

Step 1: Determine the target user, and retrieve the latest deletion batch data of the user.

Step 2, superimposing the batch data after the latest deleted batch data.

Because user permissions need to be cleared when deleting permissions to generate a cleared data store, and when adding user permissions, it only needs to be added to the latest batch of data retrieved, so when querying permissions , as long as the latest deletion batch data of the user is retrieved, the batch data after this batch data are the permissions added by the user later, and the superposition of them is all the permissions currently owned by the user.

For example, if there are five new employees A, B, C, D, and E in the purchasing department, you need to grant them the right to browse the purchasing items, because their previous permission records are empty, so just select A on the form page at the same time , B, C, D, E five users, and increase the purchase item browsing right to them, and the authority data will generate a batch data file I. One year later, these five users were transferred to the marketing department, so their permissions must be modified. This revision includes the deletion and addition of permissions. First, check the historical permissions, that is, batch data file I, and check their permissions. Clear processing, generate and delete batch data file Q, and then increase market project browsing rights for them, generate batch data file II, after three years, two users A and E are respectively promoted to district managers, then they need to Increase the authority of the person, after selecting users A and E, increase their market item approval rights, and generate batch data file III.

Now to view the five users A, B, C, D, and E, you only need to retrieve their latest deleted batch data file Q, and superimposing the batch data files after this date is their respective user permissions. For example, users B, C, and D, after the latest deletion of batch data file Q, only have batch data file II, so the browsing rights of market items in this data file are the final permissions of users B, C, and D; After the latest deletion of batch data file Q, users A and E have two batch data files II and III, and the permissions in the two data files are superimposed, that is, the market item browsing right and the market item approval right are The final authority of two users A and E.

In addition, in the method of the present invention, the users include an association relationship set according to predetermined rules, and an overall selection operation is performed on users according to the association relationship, which simplifies the work of the system administrator.

Establish a personnel tree organization chart for all employees of the company according to their departments and functions, and set up association relationships. For example, the company includes the board of directors, which is the first-level organizational relationship; its lower level includes the second-level organizational relationship such as the marketing department, finance department, and technical department; each department in the second-level organizational relationship, such as the lower level of the marketing department also includes Region A The third-level organizational relationship is manager, area manager B, and area manager C; the lower level of the area manager includes all employees under its jurisdiction, which is the fourth-level organizational relationship.

When selecting users, users can be selected as a whole according to the association relationship. For example, if the board of directors is selected, everyone in the second, third, and fourth-level organizational relationships under it can be selected at the same time; if the third-level organizational relationship is selected If the manager of area A is the manager of area A, then all sales employees in area A in the fourth-level organizational relationship under his jurisdiction will also be selected at the same time. The overall operation can be performed on selected users, which facilitates the operation of the system administrator and saves time.

Although the embodiment of the present invention has been disclosed as above, it is not limited to the use listed in the specification and implementation, it can be applied to various fields suitable for the present invention, and it can be easily understood by those skilled in the art Therefore, the invention is not limited to the specific details and examples shown and described herein without departing from the general concept defined by the claims and their equivalents.

Claims (3)

1. the data processing method of authority setting and search efficiency in raising office management system, is characterized in that, comprises the following steps:

Step 1, construction forms pages are set up user, privilege feature and three dimensions of permissions data scope in forms pages, and described three dimensions are interrelated by selecting each other;

Step 2, by batch revising the incidence relation between user, privilege feature and permissions data scope, and by batch memory modify result data, store each lot data of revising result data and be stored in database by time series,

Revise user authority setting and comprise increase and delete,

When revising user right, only comprise and increase and do not comprise while deleting, in the data at transferred a up-to-date place batch, increase new authority,

When modification user right comprises deletion, first all authorities of this user are carried out to zero clearing processing, generate and delete lot data, then to this user, give new authority credentials by the mode of batch setting;

Step 3, again revise or during search access right, transfer the user's of to be modified or inquiry the data at a up-to-date place batch.

2. the data processing method of authority setting and search efficiency in raising office management system as claimed in claim 1, it is characterized in that, when carrying out user right inquiry, first transfer the up-to-date deletion lot data of this user, then the lot data after this up-to-date deletion lot data is superposeed.

3. the data processing method of authority setting and search efficiency in raising office management system as claimed in claim 1, it is characterized in that, between described user, comprise the incidence relation arranging according to pre-defined rule, according to incidence relation, user is carried out to whole selection operation.