Property management work order processing method based on data processing

Abstract

The invention discloses a property management work order processing method based on data processing, and relates to the technical field of work order processing, and the method comprises the following steps: S1, obtaining an access log of a user in a cloud server, and generating an access anti-leakage value according to the access log; s2, acquiring a property management work order to be accessed by a user on the cloud server; s3, calculating a transition coefficient between the property management work order to be accessed and the user according to the memory parameters of the property management work order to be accessed and the access authority of the user; and S4, generating a dynamic access password for the user according to the access anti-leakage value and a transition coefficient between the property management work order to be accessed and the user. In the whole processing process, the access control strategy is adjusted according to the actual access requirement of the user, so that more flexible and more personalized access management is realized, the physical work order management efficiency is improved, and the possibility of human errors and negligence is reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of work order processing, and in particular to a property management work order processing method based on data processing. Background Art

[0002] With the development of cloud computing technology, more and more property management services are being migrated to the cloud. As the core data in property management, property work orders contain sensitive content such as the owner's personal information, housing information, and maintenance requirements. Although cloud storage improves the convenience and scalability of data storage, it also brings the risk of data leakage. For example, data can be easily obtained by users without access rights, which seriously threatens the privacy security of owners. Therefore, it is particularly important to develop an efficient and secure method for processing property work order data. Summary of the invention

[0003] In order to solve the above problems, the present invention proposes a property management work order processing method based on data processing.

[0004] The technical solution of the present invention is: a property management work order processing method based on data processing comprises the following steps:

[0005] S1. Obtain the user's access log on the cloud server and generate an access anti-leakage value based on the access log;

[0006] S2. Obtain the property management work order that the user wants to access on the cloud server;

[0007] S3, calculating the transition coefficient between the property management work order to be accessed and the user according to the memory parameters of the property management work order to be accessed and the user's access rights;

[0008] S4. Generate a dynamic access password for the user based on the access anti-leakage value and the transition coefficient between the property management work order to be accessed and the user.

[0009] The user registers an account through the interface of the cloud server and submits personal information for verification. After successful verification, the system assigns a unique user ID (UID) to the user. When a user tries to access a property management work order, the system generates a dynamic access password based on the user's UID and current timestamp TS and other parameters, transmits the generated dynamic access password to the user through a secure channel, and prompts the user to enter the password for access. After receiving the dynamic access password, the user submits it to the cloud server, which verifies the received dynamic access password and allows the user to access the corresponding property management work order after confirming its validity.

[0010] Furthermore, in S1, the user's access log on the cloud server includes the user's UID and the user's access timestamp;

[0011] In S1, the user's access anti-leakage value The calculation formula is:

[0012] ;

[0013] In the formula, Indicates the hash value corresponding to the user UID. A hash value representing the user's access timestamp. Indicates the hash value of the concatenation of the user UID and the user's access timestamp.

[0014] The beneficial effect of the above further solution is: in the present invention, the user UID and the access timestamp are respectively used as hash function inputs to generate corresponding hash values, which can ensure that each user and each access has a unique identification. User UIDs of different digits can be concatenated with the access timestamp and then hashed, which further enhances the uniqueness of the access value and ensures that even if the same user accesses at different times, the generated access values ​​are different.

[0015] Furthermore, S3 includes the following sub-steps:

[0016] S31. Calculate memory parameters for the property management work order to be accessed according to the table space of the property management work order to be accessed in the Oracle database;

[0017] S32, using the access control list of the Oracle database to determine the user's access rights;

[0018] S33. Determine the transition coefficient between the property management work order to be accessed and the user based on the source IP address and memory parameters of the property management work order to be accessed and the user's access rights.

[0019] The beneficial effect of the above further scheme is: in the present invention, the access control list is mainly used in the cloud platform to control the access rights of data. The access control list can limit or allow specific users to access data resources based on conditions such as the source IP address, the destination IP address, the protocol type (such as TCP, UDP) and the port number. By calculating the memory parameters for a specific table space, it can be ensured that the database has sufficient memory resources when processing these work orders; by limiting the user's access rights through the access control list and setting different access rights for different users, it can prevent unauthorized users from accessing sensitive data, thereby enhancing the security of the database. By combining the source IP address, memory parameters and user's access rights to determine the transition coefficient, the user's access parameters to the property management work order can be controlled more accurately.

[0020] Furthermore, in S31, the memory parameters The calculation formula is:

[0021] ;

[0022] In the formula, Indicates the maximum size of the system global area of ​​the Oracle database. Indicates the weight corresponding to the tablespace type. Indicates the block size of the tablespace.

[0023] In Oracle database, tablespace is a logical structure used to manage the storage of database objects. Each tablespace can contain one or more data files. When work order data is stored in the database, it will be assigned to a tablespace and then stored in the data file corresponding to the tablespace. Therefore, to understand which data file the work order data is stored in, you need to first determine which tablespace it belongs to. Tablespace types include system tablespace, temporary tablespace, rollback segment tablespace, user tablespace, data tablespace, and LOB tablespace. The weight of each type of tablespace can be set manually.

[0024] The System Global Area (SGA) is a shared memory area required by an Oracle database instance, including data buffers and shared pools. Proper configuration of the maximum size of the System Global Area can ensure that the database has enough memory to handle a large number of concurrent requests.

[0025] A block is the smallest storage unit in a tablespace and is used to store data.

[0026] Further, S33 includes the following sub-steps:

[0027] S331. Obtain the wildcard mask corresponding to the source IP address of the property management work order to be accessed;

[0028] S332, calculating source coefficients according to the wildcard mask;

[0029] S333. Calculate the transition coefficient between the property management work order to be accessed and the user based on the source coefficient, memory parameters and the user's access rights.

[0030] The beneficial effect of the above further solution is that in the present invention, by calculating the source coefficient, the IP address range represented by the wildcard mask can be quantified into a specific value, thereby facilitating subsequent calculations. By comprehensively considering the source coefficient, memory parameters and user access rights, the user's access request can be comprehensively evaluated.

[0031] Furthermore, in S332, the source coefficient The calculation formula is:

[0032] ;

[0033] In the formula, Indicates the number of bits that are 0 in the wildcard mask. Indicates the number of 1 bits in the wildcard mask.

[0034] The wildcard mask is represented by a 32-bit binary number, where each bit can be either 0 or 1.

[0035] Furthermore, in S333, the calculation formula for the transition coefficient between the property management work order to be accessed and the user is:

[0036] ;

[0037] In the formula, represents the source coefficient, Indicates the weight of the user's access rights. Indicates memory parameters.

[0038] The weight of a user's access rights can be set manually, for example, the administrator's weight can be set higher than the visitor's weight.

[0039] Further, S4 includes the following sub-steps:

[0040] S41, generating a standard access anti-leakage value according to the user's access anti-leakage value;

[0041] S42: Combine the transition coefficient with the standard access anti-leakage value to obtain a dynamic access password.

[0042] The beneficial effect of the above further solution is that in the present invention, by combining the transition coefficient with the standard access anti-leakage value, a unique dynamic access password can be generated. This password is different for each access, thus greatly enhancing security and preventing the password from being guessed or stolen.

[0043] Furthermore, in S41, the access anti-leakage value is processed by using the ROUD function and converted into a binary form as a standard access anti-leakage value.

[0044] The ROUD function rounds the access anti-leakage value to an integer, and then converts it to binary form.

[0045] The beneficial effects of the present invention are: the present invention generates dynamic access passwords by integrating multiple factors (such as access logs, memory parameters and user access rights, etc.), which can greatly improve the security of property management work order management and prevent unauthorized access and data leakage; and the entire processing process adjusts the access control policy according to the user's actual access needs, thereby achieving more flexible and personalized access management, improving the efficiency of physical work order management, and reducing the possibility of human errors and negligence. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] Figure 1 The present invention is a flowchart of a property management work order processing method based on data processing. DETAILED DESCRIPTION

[0047] The embodiments of the present invention will be further described below in conjunction with the accompanying drawings.

[0048] like Figure 1 As shown, the present invention provides a property management work order processing method based on data processing, comprising the following steps:

[0049] S1. Obtain the user's access log on the cloud server and generate an access anti-leakage value based on the access log;

[0050] S2. Obtain the property management work order that the user wants to access on the cloud server;

[0051] S3, calculating the transition coefficient between the property management work order to be accessed and the user according to the memory parameters of the property management work order to be accessed and the user's access rights;

[0052] S4. Generate a dynamic access password for the user based on the access anti-leakage value and the transition coefficient between the property management work order to be accessed and the user.

[0053] The user registers an account through the interface of the cloud server and submits personal information for verification. After successful verification, the system assigns a unique user ID (UID) to the user. When a user tries to access a property management work order, the system generates a dynamic access password based on the user's UID and current timestamp TS and other parameters, transmits the generated dynamic access password to the user through a secure channel, and prompts the user to enter the password for access. After receiving the dynamic access password, the user submits it to the cloud server, which verifies the received dynamic access password and allows the user to access the corresponding property management work order after confirming its validity.

[0054] In the embodiment of the present invention, in S1, the user's access log on the cloud server includes the user UID and the user's access timestamp;

[0055] In S1, the user's access anti-leakage value The calculation formula is:

[0056] ;

[0057] In the formula, Indicates the hash value corresponding to the user UID. A hash value representing the user's access timestamp. Indicates the hash value of the concatenation of the user UID and the user's access timestamp.

[0058] In the present invention, the user UID and the access timestamp are respectively used as inputs of the hash function to generate the corresponding hash value, which can ensure that each user and each access has a unique identification. User UIDs with different digits can be concatenated with the access timestamp and then hashed, which further enhances the uniqueness of the access value and ensures that even if the same user accesses at different times, the generated access values ​​are different.

[0059] In this embodiment of the present invention, S3 includes the following sub-steps:

[0060] S31. Calculate memory parameters for the property management work order to be accessed according to the table space of the property management work order to be accessed in the Oracle database;

[0061] S32, using the access control list of the Oracle database to determine the user's access rights;

[0062] S33. Determine the transition coefficient between the property management work order to be accessed and the user based on the source IP address and memory parameters of the property management work order to be accessed and the user's access rights.

[0063] In the present invention, the access control list is mainly used to control the access rights of data in the cloud platform. The access control list can limit or allow specific users to access data resources based on conditions such as the source IP address, the destination IP address, the protocol type (such as TCP, UDP) and the port number. By calculating the memory parameters for specific table spaces, it can be ensured that the database has sufficient memory resources when processing these work orders; by limiting the user's access rights through the access control list and setting different access rights for different users, it can prevent unauthorized users from accessing sensitive data, thereby enhancing the security of the database. By combining the source IP address, memory parameters and user's access rights to determine the transition coefficient, the user's access parameters to the property management work order can be controlled more accurately.

[0064] In the embodiment of the present invention, in S31, the memory parameter The calculation formula is:

[0065] ;

[0066] In the formula, Indicates the maximum size of the system global area of ​​the Oracle database. Indicates the weight corresponding to the tablespace type. Indicates the block size of the tablespace.

[0067] In Oracle database, tablespace is a logical structure used to manage the storage of database objects. Each tablespace can contain one or more data files. When work order data is stored in the database, it will be assigned to a tablespace and then stored in the data file corresponding to the tablespace. Therefore, to understand which data file the work order data is stored in, you need to first determine which tablespace it belongs to. Tablespace types include system tablespace, temporary tablespace, rollback segment tablespace, user tablespace, data tablespace, and LOB tablespace. The weight of each type of tablespace can be set manually.

[0068] The System Global Area (SGA) is a shared memory area required by an Oracle database instance, including data buffers and shared pools. Proper configuration of the maximum size of the System Global Area can ensure that the database has enough memory to handle a large number of concurrent requests.

[0069] A block is the smallest storage unit in a tablespace and is used to store data.

[0070] In this embodiment of the present invention, S33 includes the following sub-steps:

[0071] S331. Obtain the wildcard mask corresponding to the source IP address of the property management work order to be accessed;

[0072] S332, calculating source coefficients according to the wildcard mask;

[0073] S333. Calculate the transition coefficient between the property management work order to be accessed and the user based on the source coefficient, memory parameters and the user's access rights.

[0074] In the present invention, by calculating the source coefficient, the IP address range represented by the wildcard mask can be quantified into a specific value, thereby facilitating subsequent calculations. By comprehensively considering the source coefficient, memory parameters and user access rights, the user's access request can be fully evaluated.

[0075] In the embodiment of the present invention, in S332, the source coefficient The calculation formula is:

[0076] ;

[0077] In the formula, Indicates the number of bits that are 0 in the wildcard mask. Indicates the number of 1 bits in the wildcard mask.

[0078] The wildcard mask is represented by a 32-bit binary number, where each bit can be either 0 or 1.

[0079] In the embodiment of the present invention, in S333, the calculation formula of the transition coefficient between the property management work order to be accessed and the user is:

[0080]

[0081] In the formula, represents the source coefficient, Indicates the weight of the user's access rights. Indicates memory parameters.

[0082] The weight of a user's access rights can be set manually, for example, the administrator's weight can be set higher than the visitor's weight.

[0083] In this embodiment of the present invention, S4 includes the following sub-steps:

[0084] S41, generating a standard access anti-leakage value according to the user's access anti-leakage value;

[0085] S42: Combine the transition coefficient with the standard access anti-leakage value to obtain a dynamic access password.

[0086] In the present invention, by combining the transition coefficient with the standard access anti-leakage value, a unique dynamic access password can be generated. This password is different for each access, thus greatly enhancing security and preventing the password from being guessed or stolen.

[0087] In the embodiment of the present invention, in S41, the access anti-leakage value is processed by using the ROUD function and converted into a binary form as a standard access anti-leakage value.

[0088] The ROUD function rounds the access anti-leakage value to an integer, and then converts it to binary form.

[0089] Those skilled in the art will appreciate that the embodiments described herein are intended to help readers understand the principles of the present invention, and should be understood that the protection scope of the present invention is not limited to such specific statements and embodiments. Those skilled in the art can make various other specific variations and combinations that do not deviate from the essence of the present invention based on the technical revelations disclosed by the present invention, and these variations and combinations are still within the protection scope of the present invention.

Claims

1. A property management work order processing method based on data processing, characterized in that: The following steps are involved: S1. Obtain the user's access log on the cloud server and generate an access anti-leakage value based on the access log; S2. Obtain the property management work order that the user wants to access on the cloud server; S3, calculating the transition coefficient between the property management work order to be accessed and the user according to the memory parameters of the property management work order to be accessed and the user's access rights; S4. Generate a dynamic access password for the user based on the access anti-leakage value and the transition coefficient between the property management work order to be accessed and the user.

2. The method for processing property management work orders based on data processing according to claim 1, characterized in that: In S1, the user's access log on the cloud server includes the user's UID and the user's access timestamp; In S1, the user's access anti-leakage value The calculation formula is: ； In the formula, Indicates the hash value corresponding to the user UID. A hash value representing the user's access timestamp. Indicates the hash value of the concatenation of the user UID and the user's access timestamp.

3. The method for processing property management work orders based on data processing according to claim 1, characterized in that: The S3 comprises the following sub-steps: S31. Calculate memory parameters for the property management work order to be accessed according to the table space of the property management work order to be accessed in the Oracle database; S32, using the access control list of the Oracle database to determine the user's access rights; S33. Determine the transition coefficient between the property management work order to be accessed and the user based on the source IP address and memory parameters of the property management work order to be accessed and the user's access rights.

4. The method for processing property management work orders based on data processing according to claim 3 is characterized in that: In S31, memory parameters The calculation formula is: ； In the formula, Indicates the maximum size of the system global area of ​​the Oracle database. Indicates the weight corresponding to the tablespace type. Indicates the block size of the tablespace.

5. The method for processing property management work orders based on data processing according to claim 3 is characterized in that: The S33 comprises the following sub-steps: S331. Obtain the wildcard mask corresponding to the source IP address of the property management work order to be accessed; S332, calculating source coefficients according to the wildcard mask; S333. Calculate the transition coefficient between the property management work order to be accessed and the user based on the source coefficient, memory parameters and the user's access rights.

6. The method for processing property management work orders based on data processing according to claim 5, characterized in that: In S332, the source coefficient The calculation formula is: ； In the formula, Indicates the number of bits that are 0 in the wildcard mask. Indicates the number of 1 bits in the wildcard mask.

7. The method for processing property management work orders based on data processing according to claim 5, characterized in that: In S333, the calculation formula of the transition coefficient between the property management work order to be accessed and the user is: ； In the formula, represents the source coefficient, Indicates the weight of the user's access rights. Indicates memory parameters.

8. The method for processing property management work orders based on data processing according to claim 1, characterized in that: The S4 comprises the following sub-steps: S41, generating a standard access anti-leakage value according to the user's access anti-leakage value; S42. Combine the transition coefficient with the standard access anti-leakage value to obtain a dynamic access password.

9. The method for processing property management work orders based on data processing according to claim 8, characterized in that: In S41, the access anti-leakage value is processed by using the ROUD function and converted into a binary form as a standard access anti-leakage value.

Images