A property management work order processing method based on data processing

Abstract

The present invention discloses a method for processing property management work orders based on data processing, which relates to the technical field of work order processing and includes the following steps: S1, obtaining a user's access log on a cloud server and generating an access anti-leakage value based on the access log; S2, obtaining the property management work order that the user wishes to access on the cloud server; S3, calculating a transition coefficient between the property management work order that wishes to access and the user based on the memory parameters of the property management work order that wishes to access and the user's access rights; S4, generating a dynamic access password for the user based on the access anti-leakage value and the transition coefficient between the property management work order that wishes to access and the user. The entire processing process of the present invention 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 error and negligence.

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 migrating to the cloud. Property work orders, as core data in property management, contain sensitive information such as owners' personal information, property information, and maintenance requests. While cloud-based storage improves the convenience and scalability of data storage, it also introduces the risk of data leakage. For example, data can be easily accessed by users without permission, seriously threatening owners' privacy. Therefore, developing an efficient and secure method for processing property work order data is crucial. 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 includes 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. Calculate the transition coefficient between the property management work order to be accessed and the user based on 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] Users register an account through the cloud server's interface and submit personal information for verification. Upon successful verification, the system assigns the user a unique user identifier (UID). When a user attempts to access a property management work order, the system generates a dynamic access password based on parameters such as the user's UID and the current timestamp (TS). This dynamic access password is transmitted to the user via a secure channel and prompted 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, upon confirming its validity, allows the user to access the corresponding property management work order.

[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] Where, 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 this further solution is that, in this invention, the user UID and access timestamp are each input into a hash function to generate a corresponding hash value, ensuring that each user and each access is uniquely identified. User UIDs of different digits can be concatenated with the access timestamp and then hashed, further enhancing the uniqueness of the access value, ensuring that even if the same user accesses at different times, the generated access value is different.

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

[0016] S31. Calculate memory parameters for the property management work order to be accessed based on the tablespace of the property management work order to be accessed in the Oracle database;

[0017] S32. Determine the user's access rights using the Oracle database's access control list;

[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-mentioned further solution is that, in the present invention, access control lists are primarily used in the cloud platform to control data access rights. Access control lists can restrict or allow specific users' access to data resources based on conditions such as the source IP address, destination IP address, protocol type (such as TCP, UDP), and port number. By calculating memory parameters for specific table spaces, the database can ensure that it has sufficient memory resources to process these work orders. By limiting user access rights through access control lists and setting different access rights for different users, unauthorized users can be prevented from accessing sensitive data, thereby enhancing database security. By combining the source IP address, memory parameters, and user access rights to determine the transition coefficient, user access parameters for property management work orders can be more precisely controlled.

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

[0021] ;

[0022] Where, Indicates the maximum size of the system global area of the Oracle database. Indicates the weight corresponding to the table space type, Indicates the block size of the tablespace.

[0023] In Oracle Database, a 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 is assigned to a tablespace and then stored in the data file corresponding to that tablespace. Therefore, to understand which data file the work order data is stored in, you must 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 manually configured.

[0024] The System Global Area (SGA) is a shared memory area required by Oracle database instances. It includes data buffers and shared pools. Properly configuring the maximum size of the SGA ensures that the database has sufficient 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] Furthermore, 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 the source coefficient 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 above further solution has the beneficial effect of: 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, a user's access request can be comprehensively evaluated.

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

[0032] ;

[0033] Where, 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 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] Where, represents the source coefficient, Indicates the weight of the user's access rights. Indicates memory parameters.

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

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

[0040] S41. Generate a standard access anti-leakage value based on 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, thereby greatly enhancing security and preventing the password from being guessed or misused.

[0043] Furthermore, in S41, the access anti-leakage value is processed 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 with reference to 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. Calculate the transition coefficient between the property management work order to be accessed and the user based on 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] Users register an account through the cloud server's interface and submit personal information for verification. Upon successful verification, the system assigns the user a unique user identifier (UID). When a user attempts to access a property management work order, the system generates a dynamic access password based on parameters such as the user's UID and the current timestamp (TS). This dynamic access password is transmitted to the user via a secure channel and prompted 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, upon confirming its validity, allows the user to access the corresponding property management work order.

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

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

[0056] ;

[0057] Where, 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 this method, the user UID and access timestamp are input into a hash function to generate a corresponding hash value, ensuring that each user and each access is uniquely identified. User UIDs with different digits can be concatenated with the access timestamp and then hashed, further enhancing the uniqueness of the access value. This ensures that even if the same user accesses at different times, the generated access value is 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 based on the tablespace of the property management work order to be accessed in the Oracle database;

[0061] S32. Determine the user's access rights using the Oracle database's access control list;

[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 this invention, access control lists (ACLs) are primarily used in cloud platforms to control data access rights. ACLs can restrict or allow specific users' access to data resources based on conditions such as the source IP address, destination IP address, protocol type (e.g., TCP, UDP), and port number. By calculating memory parameters for specific tablespaces, the database can ensure sufficient memory resources to process these work orders. Limiting user access rights through ACLs and setting different access rights for different users can prevent unauthorized users from accessing sensitive data, thereby enhancing database security. By combining the source IP address, memory parameters, and user access rights to determine the transition coefficient, user access parameters for property management work orders can be more precisely controlled.

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

[0065] ;

[0066] Where, Indicates the maximum size of the system global area of the Oracle database. Indicates the weight corresponding to the table space type, Indicates the block size of the tablespace.

[0067] In Oracle Database, a 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 is assigned to a tablespace and then stored in the data file corresponding to that tablespace. Therefore, to understand which data file the work order data is stored in, you must 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 manually configured.

[0068] The System Global Area (SGA) is a shared memory area required by Oracle database instances. It includes data buffers and shared pools. Properly configuring the maximum size of the SGA ensures that the database has sufficient 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 the source coefficient 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, a user's access request can be comprehensively evaluated.

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

[0076] ;

[0077] Where, 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 0 or 1.

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

[0080]

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

[0082] The weight of the 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. Generate a standard access anti-leakage value based on 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 misused.

[0087] In the embodiment of the present invention, in S41, the access anti-leakage value is processed using the ROUD function and converted into a binary form as the 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 it should be understood that the scope of protection of the present invention is not limited to such specific descriptions and embodiments. Those skilled in the art can make various other specific variations and combinations based on the technical teachings disclosed in the present invention without departing from the essence of the present invention, and such variations and combinations are still within the scope of protection 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. Calculate the transition coefficient between the property management work order to be accessed and the user based on 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; 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: ； Where, Indicates the hash value corresponding to the user UID, A hash value representing the user's access timestamp. Indicates the hash value obtained by concatenating the user UID and the user's access timestamp; The S3 includes the following sub-steps: S31. Calculate memory parameters for the property management work order to be accessed based on the tablespace of the property management work order to be accessed in the Oracle database; S32. Determine the user's access rights using the Oracle database's access control list; S33. Determine a 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; In S31, the memory parameters The calculation formula is: ； Where, Indicates the maximum size of the system global area of the Oracle database. Indicates the weight corresponding to the table space type, Indicates the block size of the tablespace; The S33 includes 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 the source coefficient 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; In the S332, the source coefficient The calculation formula is: ； Where, Indicates the number of bits that are 0 in the wildcard mask. Indicates the number of bits that are 1 in the wildcard mask; In S333, the calculation formula for the transition coefficient between the property management work order to be accessed and the user is: ； Where, represents the source coefficient, Indicates the weight of the user's access rights. Indicates memory parameters.

2. The method for processing property management work orders based on data processing according to claim 1, characterized in that: The S4 includes the following sub-steps: S41. Generate a standard access anti-leakage value based on 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.

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

Images