A method and system for querying inventory quantity of inventory items

Abstract

The present application provides a method and system for querying the inventory quantity of inventory accounts. After starting the inventory quantity query, the product identification information in the inventory account is obtained; the query control list of the query role when accessing the inventory account is determined by querying the session set; the query constraint amount during multi-role query control is extracted according to the query control list, and the permission allocation set during inventory query is determined by the query constraint amount and the query role for querying the product in the inventory account, and then the static query permission is determined; the query permission level corresponding to the dynamic inventory information is determined according to the query rules and the product identification characteristics when the inventory product changes, and the dynamic query permission is determined by the query permission level; then the trusted query metric is determined, and the inventory quantity of the inventory account is queried based on the trusted query metric. The above scheme queries the inventory quantity of the inventory account based on the trusted query metric, which can improve the directed interactive matching between the query role and the inventory information in the inventory quantity query of the inventory account.

Description

Technical Field

[0001] The present application relates to the technical field of query authority allocation, and more specifically, to a method and system for querying inventory quantity of inventory items. Background Art

[0002] Query permission allocation is designed and implemented based on user role and permission control system. The access rights of different user roles are managed to control their query and operation of inventory data. First, the user roles (such as warehouse managers, purchasing staff, sales staff, financial staff, etc.) and their responsibilities are clarified. Then, the specific permission types of each role are defined, such as read, write and delete. The role access control model is used to associate permissions with roles, so that users can obtain corresponding permissions by assigning roles. Permission allocation is reviewed and updated regularly to ensure that it matches the user's actual responsibilities. Through this technology, it is ensured that users can only operate inventory data within their authorized scope to comply with standard accounting rules and improve system security and data accuracy.

[0003] Inventory quantity query of inventory account refers to obtaining and analyzing enterprise inventory data through information system to ensure the accuracy and timeliness of inventory quantity. This query method first determines the specific query requirements, such as the current quantity of a certain inventory or the total inventory of a certain warehouse. Then, the query conditions are input through the enterprise resource planning system or inventory management system. The system generates and executes query statements, retrieves relevant data from the database, and displays the results to the user. This query method ensures that only authorized users can access and operate inventory data through role authority control; however, in the existing inventory quantity query method of inventory account, there is an imperfect authority allocation mechanism in the inventory quantity query of inventory account, which fails to accurately match the user role and its responsibility requirements, resulting in incorrect authority allocation. Users cannot access the required inventory information because they are not correctly granted query permissions, and dynamic cross-validation cannot be achieved when querying the inventory quantity, which leads to a decrease in the directed interactive matching between the query role and the inventory information in the inventory quantity query of inventory account. Therefore, how to achieve dynamic cross-validation of inventory quantity query of inventory account and improve the directed interactive matching between the query role and the inventory information in the inventory quantity query of inventory account is a problem faced by the industry. Summary of the invention

[0004] The present application provides a method and system for inventory quantity query of inventory accounts, which can realize dynamic cross-validation of inventory quantity query of inventory accounts, and effectively improve the directed interactive matching between query roles and inventory information in inventory quantity query of inventory accounts.

[0005] In a first aspect, the present application provides a method for querying the inventory quantity of an inventory account, comprising the following steps:

[0006] Start inventory quantity query to obtain product identification information in inventory accounts;

[0007] Matching the product identification information with the query role when querying the inventory quantity to obtain an inventory query session set, and then determining a query control list of the query role when accessing the inventory account through the query session set;

[0008] Extracting query constraints of query control for different query roles when accessing inventory accounts according to the query control list, determining a permission allocation set for inventory query based on all query constraints and the query role for querying products in the inventory account, and then determining static query permissions through the permission allocation set;

[0009] Obtaining the query rules corresponding to the query roles of the products in the inventory account, determining the query authority level corresponding to the dynamic inventory information according to the query rules and the product identification characteristics when the inventory products in the inventory account are changed, and determining the dynamic query authority according to the query authority level;

[0010] The static query authority and the dynamic query authority are credit cross-verified to obtain a trusted query metric, and the inventory quantity of the inventory account is queried based on the trusted query metric.

[0011] In some embodiments, matching the product identification information with the query role when querying the inventory quantity to obtain the inventory query session set specifically includes:

[0012] Setting query characteristics of inventory products according to the product identification information;

[0013] Classify the permissions of the query roles when querying the inventory quantity to obtain the query role permissions;

[0014] The query characteristics and the query role permissions are matched to obtain an inventory query session set.

[0015] In some embodiments, determining the query control list of the query role when accessing the inventory account through the query session set specifically includes:

[0016] Extracting authentication features of the query role according to the query session set;

[0017] Get the historical access records of the inventory account;

[0018] Generate a query control list for the query role when accessing inventory accounts based on the authentication characteristics of the query role and the historical access records of the inventory accounts.

[0019] In some embodiments, extracting the query constraint amounts of query control for different query roles when accessing inventory accounts according to the query control list specifically includes:

[0020] Determining low-dimensional representations of different query roles according to the query control list;

[0021] By comparing the low-dimensional representations of different query roles in the query control list, the query constraints of query control for different query roles when accessing inventory accounts are obtained.

[0022] In some embodiments, the permission allocation set for inventory query is determined by all query constraints and the query role for querying products in inventory items, specifically including:

[0023] Get the inventory query history data corresponding to the query role for querying products in the inventory account;

[0024] Associating the inventory query history data with the current inventory query behavior to obtain a query behavior correlation amount;

[0025] Aggregation is performed according to the query constraint amount and the query behavior association amount to obtain a permission allocation set for inventory query.

[0026] In some embodiments, the query rules corresponding to the query roles for obtaining products in inventory items specifically include:

[0027] Determine the query permissions for inventory query of inventory accounts;

[0028] Generate query role information according to the query authority;

[0029] The query rule corresponding to the query role is determined by the query authority and the query role information.

[0030] In some embodiments, product identification information in the inventory account is read by the inventory management system.

[0031] In a second aspect, the present application provides an inventory quantity query system for inventory items, including:

[0032] The acquisition module is used to start the inventory quantity query and obtain the product identification information in the inventory account;

[0033] A processing module, used for matching the product identification information with the query role when querying the inventory quantity to obtain an inventory query session set, and then determining a query control list of the query role when accessing the inventory account through the query session set;

[0034] The processing module is further used to extract the query constraint quantities of query control of different query roles when accessing inventory accounts according to the query control list, determine the permission allocation set for inventory query based on all query constraint quantities and the query role for querying products in the inventory account, and further determine the static query permission through the permission allocation set;

[0035] The processing module is further used to obtain a query rule corresponding to a query role of a product in an inventory account, determine a query authority level corresponding to the dynamic inventory information according to the query rule and a product identification feature when an inventory product in an inventory account is changed, and determine the dynamic query authority according to the query authority level;

[0036] The execution module is used to perform credit cross-verification on the static query authority and the dynamic query authority to obtain a trusted query metric, and query the inventory quantity of the inventory account based on the trusted query metric.

[0037] In a third aspect, the present application provides a computer device, comprising a memory and a processor, wherein the memory stores codes, and the processor is configured to obtain the codes and execute the above-mentioned inventory account stock quantity query method.

[0038] In a fourth aspect, the present application provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above-mentioned inventory account stock quantity query method is implemented.

[0039] The technical solution provided by the embodiments disclosed in this application has the following beneficial effects:

[0040] The present application provides a method and system for querying inventory quantity of inventory accounts. First, after starting the inventory quantity query, product identification information in the inventory account is obtained; secondly, the product identification information is matched with the query role when querying the inventory quantity to obtain the inventory query session set, and then the query control list of the query role when accessing the inventory account is determined through the query session set; then, the query constraint amount of the query control of different query roles when accessing the inventory account is extracted according to the query control list, and the permission allocation set when querying the inventory account is determined according to all the query constraints and the query role of the product in the inventory account, and then the static query permission is determined through the permission allocation set; then, the query rule corresponding to the query role of the product in the inventory account is obtained, and the query permission level corresponding to the dynamic inventory information is determined according to the query rule and the product identification feature when the inventory product in the inventory account changes, and the dynamic query permission is determined according to the query permission level; finally, the static query permission and the dynamic query permission are credit cross-validated to obtain a trusted query metric, and the inventory quantity of the inventory account is queried according to the trusted query metric.

[0041] It can be seen that this application cross-validates the credit of static query permissions and dynamic query permissions, and then queries the inventory quantity of inventory accounts based on trusted query metrics. First, the permission allocation set for inventory query is determined by the query constraint amount and the query role of the product in the inventory account, and then the static query permission is determined by the permission allocation set. Among them, the multi-role query control in the inventory quantity query of inventory accounts represents a mechanism set according to the responsibilities and permissions of different user roles, which is used to control their access to and query of inventory data to ensure data security and the standardization of operations. Static query permissions represent the rules and restrictions that must be followed by the query role when performing query operations in inventory quantity queries; secondly, according to the query rules and the product when the inventory products in the inventory account change, The product identification feature determines the query permission level corresponding to the dynamic inventory information, and then the dynamic query permission is determined by the query permission level. Among them, inventory product change refers to the change in the quantity, status or attributes of the inventory product. In order to realize the dynamic cross-validation of inventory quantity query of inventory account, it is necessary to determine the dynamic permission according to the query rules and the dynamic behavior when the inventory product changes, so as to improve the directed interactive matching between the query role and the inventory information in the inventory quantity query of inventory account. Then, the static query permission and the dynamic query permission are credit cross-validated to ensure the similarity of the permission matching of the authorized query in the inventory data query. Finally, the inventory quantity of the inventory account is queried based on the trusted query measurement. In summary, the present application can realize the dynamic cross-validation of inventory quantity query of inventory account. BRIEF DESCRIPTION OF THE DRAWINGS

[0042] Figure 1 is an exemplary flow chart of a method for querying inventory quantity of inventory items according to some embodiments of the present application;

[0043] Figure 2 is an exemplary schematic diagram of a multi-role query control process according to some embodiments of the present application;

[0044] Figure 3 is a schematic diagram of an exemplary process of determining static query permissions according to some embodiments of the present application;

[0045] Figure 4 is a schematic diagram of exemplary hardware and / or software of an inventory account inventory quantity query system according to some embodiments of the present application;

[0046] Figure 5 It is a structural diagram of a computer device for implementing a method for querying inventory quantity of inventory items according to some embodiments of the present application. DETAILED DESCRIPTION

[0047] The core of this application is to obtain the product identification information in the inventory account after starting the inventory quantity query; match the product identification information with the query role when querying the inventory quantity to obtain the inventory query session set, and then determine the query control list of the query role when accessing the inventory account through the query session set; extract the query constraint quantity of the query control of different query roles when accessing the inventory account according to the query control list, determine the permission allocation set when querying the inventory account by all the query constraints and the query role of the product in the inventory account, and then determine the static query permission through the permission allocation set; obtain the query rule corresponding to the query role of the product in the inventory account, determine the query permission level corresponding to the dynamic inventory information according to the query rule and the product identification characteristics when the inventory product in the inventory account changes, and determine the dynamic query permission by the query permission level; perform credit cross-validation on the static query permission and the dynamic query permission to obtain a trusted query metric, and query the inventory quantity of the inventory account according to the trusted query metric. The above scheme queries the inventory quantity of the inventory account based on the trusted query metric, which can realize the dynamic cross-validation of the inventory quantity query, and thus improve the directed interactive matching between the query role and the inventory information in the inventory quantity query of the inventory account.

[0048] In order to better understand the above technical solution, the above technical solution will be described in detail below in conjunction with the accompanying drawings and specific implementation methods. Figure 1 , which is an exemplary flow chart of a method for querying inventory quantity of inventory items according to some embodiments of the present application. The method 100 for querying inventory quantity of inventory items mainly includes the following steps:

[0049] In step 101, an inventory quantity query is initiated to obtain product identification information in the inventory account.

[0050] In specific implementation, the product identification information in the inventory account can be read through the inventory management system. When reading the product identification information, it is necessary to clarify the specific query requirements at the beginning of the inventory query, such as querying the current quantity of a specific inventory, querying all inventory in a warehouse, etc. In other embodiments, the product identification information in the inventory account can also be obtained through accounting software or an enterprise resource planning system. The enterprise resource planning system integrates finance, procurement, production, sales and other modules to provide real-time updated inventory data.

[0051] It should be noted that the product identification information in the inventory account in this application is key information used to identify and describe inventory items to ensure the accuracy and efficiency of inventory management; the product identification information may include: inventory code, product serial code, product name, barcode / QR code, etc. In this application, the product serial code can be used as product identification information in the inventory account. The product serial code refers to a unique number used to uniquely identify a single product. Each product has a unique serial code to ensure that no two products have the same serial code, which will not be repeated here.

[0052] In addition, it should be noted that the inventory account is a type of accounting account used to record the value and quantity of various inventories held by an enterprise during the production and sales process. Inventory is one of the important assets of an enterprise and is reflected in the balance sheet. It mainly includes raw materials, work-in-progress, semi-finished products, finished products and commodities. The management and recording of inventory accounts is crucial to the accuracy of a company's financial statements and operational efficiency.

[0053] In step 102, the product identification information is matched with the query role when querying the inventory quantity to obtain an inventory query session set, and then the query control list of the query role when accessing the inventory account is determined through the query session set.

[0054] In some embodiments, reference Figure 2 As shown, according to the exemplary schematic diagram of the multi-role query control process shown in some embodiments of the present application, the specific content of the multi-role query control process in this embodiment includes:

[0055] In the inventory quantity query of the inventory account, according to different inventory query permissions and inventory quantity information security requirements, the roles in the inventory query are defined, and corresponding permissions are assigned to each role. These permissions can be security verified according to the attributes of the query role, and flexibly query constraints can be performed to match the corresponding query permissions. In addition, when the inventory products of the inventory account change (for example, increase or decrease), or the access role changes (for example, after the low-level query role is upgraded, the query permission needs to be reassigned), the query role, inventory quantity and query permission form dynamic changes, and the query control of multiple roles (that is, different types of query roles) plays an important role in protecting the inventory information of the inventory account, especially when the permissions are assigned when querying multiple roles, effectively reducing the query role's inability to query the inventory information of the inventory account or the leakage of specific price inventory information caused by permission assignment errors; in other embodiments, when multiple roles query the inventory quantity of the inventory account, role-based query control, inventory attribute-based query control, query time-based query control, etc. will also be adopted. For example, a restriction that only specific roles can query the inventory quantity information of certain sensitive inventory products can be set, which will not be repeated here.

[0056] In some embodiments, matching the product identification information with the query role when querying the inventory quantity to obtain the inventory query session set can be achieved by using the following steps:

[0057] Setting query characteristics of inventory products according to the product identification information;

[0058] Classify the permissions of the query roles when querying the inventory quantity to obtain the query role permissions;

[0059] Matching the query features with the query role permissions to obtain an inventory query session set;

[0060] In specific implementation, first, the product serial code in the product identification information is used as the query feature of the inventory product. In other embodiments, the SKU code, batch number, etc. of the product can also be used as the query feature of the inventory product, which will not be repeated here; then, the roles when querying the inventory quantity are classified, such as: administrators and ordinary employees, etc., and permissions are granted to each role, that is, query role permissions are obtained, wherein granting permissions to each role includes: assigning corresponding permissions to each role, and the permissions can be flexibly assigned and managed according to the security requirements of the inventory information, for example: assigning read and write permissions to all inventory data to the administrator role, while ordinary employees are only assigned read permissions to part of the inventory data; finally, the query features of the inventory products corresponding to all query roles in querying the inventory quantity are traversed, and the query features corresponding to the roles with the same access rights are classified to obtain multiple inventory query session classes, and all inventory query session classes are combined into an inventory query session set.

[0061] It should be noted that the query features of inventory products in this application represent the key information and attributes used to identify, classify and retrieve inventory products; query role permissions mean that when querying inventory quantities, specific operation permissions are granted according to the query role, and this permission determines the data that users of different roles can view and operate in the inventory account; the inventory query session set represents a collection of query operations generated in the data query system of the inventory account according to specific query requests and query permissions. Each inventory query session class represents a type of query operation, including the user's identity, query conditions, and query results. This collection can be used to track and manage user access to and operations on inventory data.

[0062] In some embodiments, determining the query control list of the query role when accessing the inventory account through the query session set can be implemented by the following steps:

[0063] Extracting authentication features of the query role according to the query session set;

[0064] Get the historical access records of the inventory account;

[0065] Generate a query control list for the query role when accessing inventory accounts based on the authentication characteristics of the query role and the historical access records of the inventory accounts.

[0066] In the specific implementation, first, the authentication characteristics of the query role are determined according to the query scope of the query role in the query session set, that is, the query scope of the query role in the query session set is used as the authentication characteristics of the query role. In other embodiments, other methods can also be used to determine the authentication characteristics of the query role, such as password authentication, two-factor authentication, feature recognition authentication, etc., which will not be repeated here; then, the historical records of accessing the inventory account can be obtained by reading the data management system of the inventory account; finally, a rule-based query control mechanism can be used to correspond and filter the historical access records and the authentication characteristics of the query role, and by setting rules, for example, the authentication characteristics of the same query role are classified into one category in the historical access records to generate a query control list for the query role when accessing the inventory account.

[0067] It should be noted that the authentication feature of the query role in this application is information used to identify and verify the user's identity and authority. In the inventory account inventory quantity query system, this authentication feature ensures that the user can only access inventory data within his or her authority. The historical access record for accessing the inventory account represents all queries and operation logs related to the inventory account recorded by the inventory account query system. The record describes in detail the time of each access to the inventory account, the user's identity, the operations performed, the query conditions and results, etc. The query control list is a rule-based query control mechanism (query rule), which allows the administrator to set the scope of query allowed and the roles allowed to query when querying the inventory quantity. When querying the inventory quantity of the inventory account, the query control list is usually integrated with the database management system to ensure security.

[0068] In step 103, the query constraints of query control for different query roles when accessing inventory accounts are extracted according to the query control list, and the permission allocation set for inventory query is determined by all query constraints and the query role for querying products in the inventory account, and then the static query permission is determined by the permission allocation set.

[0069] It should be noted that the multi-role query control in the inventory quantity query of inventory accounts refers to a mechanism set according to the responsibilities and permissions of different user roles, which is used to control their access to and query of inventory data. This mechanism ensures that each user can only perform query operations within the scope of their authorization, thereby ensuring data security and the standardization of operations. The specific implementation includes: first, define different user roles within the enterprise, such as warehouse managers, purchasing personnel, sales personnel, and financial personnel; second, assign specific query permissions to each role, such as reading, modifying, and deleting inventory data; then, use the role-based access control (RBAC) model to associate permissions with roles, so that users can obtain corresponding permissions by assigning roles; finally, construct query conditions, generate query sessions based on user roles and their permissions, and regularly review and update permission configurations to ensure that permission settings match user responsibilities. Through multi-role query control, the security of the system and the accuracy of data queries are improved to prevent unauthorized access and data leakage.

[0070] In some embodiments, extracting the query constraint amounts of query control for different query roles when accessing inventory items according to the query control list can be implemented by the following steps:

[0071] Determining low-dimensional representations of different query roles according to the query control list;

[0072] By comparing the low-dimensional representations of different query roles in the query control list, the query constraints of query control for different query roles when accessing inventory accounts are obtained.

[0073] In the specific implementation, first, the authentication features of all query roles in the query control list and the historical behaviors of all query roles in the inventory data query of the inventory account are learned through the deep neural network, and then the learning results of the deep neural network are used as the low-dimensional representation of different query roles. In the deep learning of the deep neural network, the feature authentication affine transformation of the query role is carried out to the query role, and then the last hidden layer feature is used as the low-dimensional representation of each query role, so as to obtain the low-dimensional representation of different query roles. Other methods can also be used, for example, using principal component analysis (PCA, Principal Component Analysis) reduces the high-dimensional query role features to a two-dimensional representation, which can improve the efficiency of data processing and analysis and help discover the similarities and differences between roles; then, by comparing the similarities of the authentication features of each query role in the query control list, the similarities of the authentication features of each query role are aggregated from large to small through the moving exponential average method to obtain the authentication feature aggregation amount, which represents the concentration of inventory quantity queries in inventory account inventory queries, and uses the entropy weight method to obtain the feature weight of the query role query. Finally, the feature weight of the query role is multiplied by the authentication feature aggregation amount, and the product is used as the query constraint amount of query control for different query roles when accessing inventory accounts.

[0074] It should be noted that the low-dimensional representation of all query roles refers to the conversion of high-dimensional query role feature information (such as user identity, role, authority, access record, etc.) into a low-dimensional representation through dimensionality reduction technology; the query constraints during multi-role query control represent the query restrictions and conditions set for different query roles in the inventory quantity query. The restrictions and conditions are used to control and manage the authority scope and operation behavior of each role when querying inventory data. The query constraints are intended to ensure that the query roles can only perform query operations within their authority scope, thereby ensuring data security and system stability.

[0075] In some embodiments, determining the permission allocation set for inventory query based on all query constraints and the query role for querying products in inventory items can be implemented by the following steps:

[0076] Get the inventory query history data corresponding to the query role for querying products in the inventory account;

[0077] Associating the inventory query history data with the current inventory query behavior to obtain a query behavior correlation amount;

[0078] Aggregation is performed according to the query constraint amount and the query behavior association amount to obtain a permission allocation set for inventory query.

[0079] In specific implementation, first, the inventory query history data corresponding to the query role for querying products in the inventory account can be read through the log file of the inventory account, and then the query behavior association amount is determined according to the cosine distance between the query behavior of the query role in the inventory query history data and the inventory query behavior when the current query is performed, that is, the cosine distance between the query behavior of the query role in the inventory query history data and the inventory query behavior when the current query is performed is used as the query behavior association amount. In other embodiments, a machine learning model can also be used to identify the query pattern in the historical data, and compare it with the current query behavior, and then define the query behavior association amount according to the results of matching and association analysis, for example, the query behavior association amount can be defined as the number of matching records or the similarity score, which will not be repeated here; finally, a deep neural network is used to matrix the query constraint amount and the query behavior association amount between the self and neighbor nodes, and then the query behavior of the query role is introduced, and the output of the last hidden layer is used as the permission allocation amount during inventory query, which indicates the matching degree between the current inventory query behavior and the inventory query history data, and all the permission allocation amounts during inventory query are combined to obtain the permission allocation set during inventory query.

[0080] It should be noted that the inventory query history data corresponding to the query role of the product in the inventory account represents the detailed information in the inventory quantity query of the inventory account, showing the behavior of different query roles in performing query operations on the products in the inventory account at different times. These data include the user's identity, role, queried product information, query time, query conditions, etc.; the query behavior correlation quantity represents an indicator that measures the correlation between the current inventory query behavior and the historical query behavior. This indicator is used to quantify the similarity between the current query operation and the past query records in terms of characteristics, patterns and frequency, so as to identify the regularity, anomalies and trends of the query behavior; the permission allocation set during inventory query represents the permission set defined in the inventory query that the query role has when performing the inventory quantity query operation. These permissions determine what inventory information the user can query, the depth and breadth of the query, and the related operations that can be performed in the inventory quantity query.

[0081] In some embodiments, reference Figure 3 As shown, this figure is an exemplary flow chart of determining static query authority according to some embodiments of the present application. In this embodiment, determining static query authority can be implemented by the following steps:

[0082] In step 1031, a plurality of query authority source nodes are extracted from the authority allocation set;

[0083] In step 1032, a query authority aggregation node is determined based on all query authority source nodes;

[0084] In step 1033, a static query factor of the query role during inventory query is determined;

[0085] In step 1034, the static query authority is determined according to the query authority aggregation node and the static query factor.

[0086] In specific implementation, after obtaining the permission allocation set, the permission allocation set is parsed. The parsing process can use a programming language to read and parse the permission configuration. For example, the permission allocation set may contain detailed permission items for each role. Then, the permission items related to the query operation are retrieved from the parsed permission allocation set. The retrieval process can be completed by extracting relevant nodes from the data structure using programming logic or query language, which will not be repeated here. According to the extracted query permission source nodes, the node sets with similar or related query permissions are identified and aggregated. This can be achieved in the following way: First, the roles with the same or similar query permissions are classified, and then a aggregation node is defined for each type of query permission, representing the total set of this type of permissions, thereby obtaining a query permission aggregation node.

[0087] It should be noted that the query permission source node in the present application represents a specific permission unit related to the query operation in the inventory quantity query. Each query permission source node represents an independent permission item, which defines the scope and specific content of the query operation that the query role can perform; the query permission source node represents a specific permission unit related to the query operation in the inventory quantity query. The specific permission unit defines the scope and specific content of the query operation that the query role can perform. By centrally managing these permission source nodes, fine-grained permission control can be achieved to improve the security and management efficiency of the system.

[0088] In addition, in a specific implementation, the static query factor of the query role during inventory query can be determined in the following manner, namely: the static query factor of the query role during inventory query can be determined by the average value of the communication distance between two different query authority source nodes during inventory query, wherein the communication distance between two different query authority source nodes can be determined using the Euclidean distance. In other embodiments, other methods can also be used to determine the distance, which will not be described here. Finally, the average value of all communication distances is calculated, the average value of the communication distance is used as the static query factor, and the range of the static query factor is set between 0 and 1.

[0089] It should be noted that the static query factor in the present application represents a fixed parameter or condition that does not change with time, state or context in the query operation. The static query factor is used to define and control the basic rules and restrictions of the query operation to ensure that the query operation remains consistent and stable under various circumstances. The static query factor is usually set in the design phase of the query. The query restriction conditions set may be field value restrictions, data table restrictions, etc. In the present application, a data table restriction is set, and its function is to only query specific data tables, for example, only the data in the products table can be queried, and it will not change dynamically during the query execution process.

[0090] In specific implementation, the static query authority can be determined according to the query authority aggregation node and the static query factor in the following manner: identify the applicable query roles in each query authority aggregation node, and match them with the role authority defined in the static query factor. If the role in a certain aggregation node does not meet the role conditions of the static factor, the role will be excluded; integrate the fixed query conditions (such as time range, data range, field value, etc.) defined in the static query factor into the corresponding query authority aggregation node to ensure that the authority in each aggregation node must follow these fixed conditions when executing the query. After combining the conditions of the static query factor and the authority of the aggregation node, a complete static query authority definition is formed. This definition clarifies the specific authority of each role when executing the query and the fixed conditions that must be followed. For example: a permission aggregation node allows "warehouse manager" and "sales representative" to query the inventory information of all products and salable products. One of the static query factors stipulates that the query operation must be performed throughout 2023, and only the "administrator" and "manager" roles can execute these queries.

[0091] It should be noted that the static query permission in this application refers to the pre-defined and fixed query permission in the inventory quantity query, which determines the rules and restrictions that the user or role must abide by when performing the query operation; the query permission aggregation node and the static query factor are effectively combined to ensure that the permissions and conditions of the query operation are clear and fixed, and finally form a reliable static query permission. This process ensures that all query operations are performed within the set security and compliance framework.

[0092] In step 104, the query rules corresponding to the query role of the products in the inventory account are obtained, and the query authority level corresponding to the dynamic inventory information is determined based on the query rules and the product identification characteristics when the inventory products in the inventory account are changed, and the dynamic query authority is determined by the query authority level.

[0093] It should be noted that in the inventory quantity query of inventory accounts, inventory product changes refer to changes in the quantity, status or attributes of inventory products, such as warehousing, outbound, transfer and inventory counting operations; when inventory products change, in order to achieve dynamic cross-validation of inventory quantity queries of inventory accounts, it is necessary to determine dynamic permissions based on query rules and dynamic behaviors when inventory products change. The purpose is to ensure that users have appropriate access and operation permissions in different operation scenarios, thereby improving the directed interactive matching between query roles and inventory information in inventory quantity queries of inventory accounts; specifically, the dynamic permission mechanism automatically adjusts the user's permission scope based on real-time inventory change behaviors and predefined query rules. For example, when the inventory product status changes to inventory counting, only authorized warehouse managers can modify the data, while other users can only view it. This dynamic permission control ensures the flexibility and security of the system, prevents unauthorized operations, and improves the accuracy and efficiency of inventory management.

[0094] In some embodiments, obtaining the query rules corresponding to the query roles of products in the inventory account may be implemented by the following steps:

[0095] Determine the query permissions for inventory query of inventory accounts;

[0096] Generate query role information according to the query authority;

[0097] The query rule corresponding to the query role is determined by the query authority and the query role information.

[0098] In specific implementation, the query authority for inventory query of inventory account can be determined in the following way, namely: determine the role of the current query, for example, the current user is a "warehouse manager", and then extract the authority of the "warehouse manager" from the authority management system to determine that he can read the inventory data of the warehouse assigned to him, then load the query rules corresponding to the "warehouse manager", limit the query time range and data status, integrate and verify the extracted authority and loaded rules to ensure the legality of the query operation, and finally assign authority and perform authority check when the user queries, thus completing the determination of the query authority for inventory query of inventory account.

[0099] It should be noted that the query permissions for inventory queries of inventory accounts in this application refer to permissions pre-defined in inventory queries and assigned to user roles. These permissions determine the scope and type of data that users can access when performing inventory query operations, as well as the types of operations that can be performed (such as reading, modifying, etc.). Query permissions are intended to ensure the security and compliance of data access, and to prevent unauthorized users from accessing sensitive information or performing illegal operations.

[0100] In the specific implementation, first, determine all user roles defined in the system, such as administrator, warehouse manager, sales representative, etc., and then extract the query permissions of each role from the permission management system or configuration file, such as data access scope, the specific data scope that the query role can access, and then generate the query role information of each role based on the extracted query permissions. The information should include the role name, permission description, and the specific conditions and restrictions of the role when performing query operations; then, based on the extracted query permissions and query role information, generate specific query rules for each role. The rules include the conditions and restrictions that the role must comply with when performing query operations. The query permissions and role information can be integrated into a set of rules to clearly define the specific requirements of the query operation; finally, verify the generated query rules to ensure their accuracy and effectiveness. The verification can be carried out by simulating query operations to check whether the role has the correct permissions and access scope. If errors are found or the permissions are improperly set, they should be updated and adjusted in a timely manner. After verification, the query rules are applied to the inventory query system of the inventory account.

[0101] It should be noted that the query role information in this application represents a detailed description of the permissions and restrictions that each query role has when performing query operations; the query rules represent the specific conditions and restrictions that need to be followed when performing query operations. The rules are used to limit the user's behavior when accessing data, including the scope of data accessed, operation type, query conditions, etc.

[0102] In some embodiments, determining the query authority level corresponding to the dynamic inventory information according to the query rules and the product identification characteristics when the inventory products in the inventory account are changed can be implemented by the following steps:

[0103] Get product identification characteristics when inventory products in inventory accounts are changed;

[0104] Determine the query expansion authority entropy when the inventory product is changed according to the product identification feature;

[0105] Generate a query authority joint probability of a query message sequence according to the query rule;

[0106] The query authority level is determined according to the query expansion authority entropy and the query authority joint probability.

[0107] In the specific implementation, first, query the change records or logs in the inventory management system to find all the records involving the changes of inventory products, extract the product identification information involved in each change from the change records, parse or filter the records to extract the required product identification information, and organize the extracted product identification information into structured data for subsequent analysis and processing, including associating the product identification information with the change type, change time and other related information, and then obtain the product identification characteristics when the inventory products in the inventory account are changed; then, confirm the product identification characteristics to be used to determine the change, such as product name, number, classification, production batch number, etc., collect the records of inventory product changes from the inventory management system, such as: the time and type of change (such as addition, modification, deletion), product identification information before and after the change, etc., and then analyze the change records, for example: calculate the frequency of different product identification characteristics in the change, and calculate the query extension entropy of each characteristic according to the change mode and change frequency of the product identification characteristics. The query extension entropy can be expressed by the change frequency, and the value range of the query extension entropy is between 0 and 1.

[0108] It should be noted that the product identification feature when the inventory product changes represents the attribute or information used to uniquely identify and distinguish different products in the inventory account; the query extension permission entropy represents the measurement of the change in query permissions caused by the change in product identification features in the inventory query of the inventory account. It measures the extent to which the query permissions need to be adjusted or expanded when the product identification features of the inventory product change.

[0109] In addition, in a specific implementation, the joint probability of query authority for generating a query message sequence according to the query rule can be implemented in the following manner: each query operation in the query rule is sorted in chronological order and then the query message sequence is determined, that is, the result of sorting each query operation in the query rule in chronological order is used as the query message sequence, and the query message sequence includes the specific conditions and content of each query operation; then, for the query message sequence that meets the rule, the joint probability of its query authority is calculated, and Bayes' theorem or other probability calculation methods can be used to aggregate the probability of each query operation to obtain the joint probability of query authority.

[0110] It should be noted that the query authority joint probability in the present application represents the probability that the authorities of all query operations are satisfied at the same time in a query message sequence.

[0111] In addition, in specific implementation, the following steps can be adopted to determine the query authority level according to the query expansion authority entropy and the query authority joint probability: the query authority is graded according to the calculation results of the query expansion authority entropy and the query authority joint probability, and the division rules can be formulated according to the specific situation, for example: the division is made according to the degree of change of the authority and the size of the probability, and then the specific standards and classification methods of the query authority level are formulated, including determining the authority scope of different levels, the authority allocation method, etc., and the corresponding query authority level is allocated to each query operation according to the formulated grade standards. According to the degree of change of the query operation and the authority requirements, the authority level to which it belongs is determined. The query authority level can be determined according to the degree of change of the authority caused by the query operation. If the authority change caused by the query operation is small, a lower authority level can be assigned; if the change is large, a higher authority level may need to be assigned.

[0112] It should be noted that the query permission level indicates the permission level set for different query operations in inventory quantity query. Usually, the query permission level includes multiple levels, which represent the access scope of data and the degree of restriction on operation permissions from low to high. For example, the query permission level can be divided into different levels such as read-only, read-write, and management to meet the different needs of query roles for data query and operation in the system.

[0113] In some embodiments, determining the dynamic query permission from the query permission level may be implemented by the following steps:

[0114] The query authority level is divided into autonomous query authority and mandatory query authority;

[0115] Determining a query matching amount according to the autonomous query authority and the mandatory query authority;

[0116] Determine dynamic permission access parameters when querying inventory quantities;

[0117] Dynamic query permissions are determined according to the query matching amount and the dynamic access parameters.

[0118] In the specific implementation, first, set the level standards of autonomous query permissions and mandatory query permissions, including determining each type of permission level, permission scope, permission control method, etc. The permission scope can be used to set the level standards of autonomous query permissions and mandatory query permissions. The actions of querying within the permission scope are set as autonomous query permissions, and the actions beyond the permission query scope are set as mandatory query permissions; secondly, for autonomous query permissions, check whether the query operation of the query role meets the corresponding permission requirements, including permission level, permission scope, etc. For mandatory query permissions, the system will automatically check whether the user's query operation meets the pre-set permission conditions, and calculate the query matching amount based on the matching degree between the query operation and the permission requirements. Quantitative methods (such as scores, percentages, etc.) or qualitative methods (such as descriptions of matching degrees) can be used to represent query matching. quantity, which will not be elaborated here; then, the dynamic permission access parameters can be determined through the inventory quantity query management experience or expert experience of the inventory account and computer simulation, and the dynamic permission access parameters can include time period restrictions, location restrictions, user identity authentication requirements, etc. In this application, user identity authentication requirements are selected as dynamic permission access parameters; finally, using the deep machine learning method, a function is set, which receives the query matching quantity and the dynamic access parameters as input, and calculates the dynamic query permission. Inside the function, a permission threshold is set. If the query matching quantity reaches the threshold, the permission level is adjusted according to the dynamic parameters; otherwise, the permission level is lowered, wherein lowering the permission level includes lowering the permission level to read-only permission; otherwise, the original permission level is maintained as read-write permission, and then the output result is used as the dynamic query permission, which will not be elaborated here.

[0119] It should be noted that in this application, autonomous query authority means that the query role decides by itself when to execute the inventory quantity query; mandatory query authority means that the inventory quantity query system strictly limits and constrains the query operation of the query role, and the query role must meet the system preset conditions or obtain specific authorization to perform the query operation; the query match quantity means the degree of match between the query operation initiated by the query role and the query authority defined in the inventory query system; the dynamic permission access parameter means the variable factors taken into account in the query permission management to determine the user's access rights to the inventory quantity; the dynamic query authority means the query operation authority determined according to dynamic factors such as specific query scenarios, user identities and environmental conditions. Unlike static authorities, dynamic query authorities can be adjusted according to real-time conditions to adapt to different query needs and environmental changes.

[0120] In step 105, the static query authority and the dynamic query authority are credit cross-verified to obtain a trusted query metric, and the inventory quantity of the inventory account is queried based on the trusted query metric.

[0121] In some embodiments, the static query authority and the dynamic query authority are cross-validated to obtain a trusted query metric, which can be achieved by the following steps:

[0122] Compare the static query authority with the dynamic query authority to obtain credit cross-similar authority;

[0123] Set trusted query factors for different query behaviors when assigning permissions;

[0124] A trusted query metric is determined based on the credit cross-similarity authority and the trusted query factor.

[0125] In the specific implementation, first, the credit cross-similarity permission is determined according to the similarity between the static query permission and the dynamic query permission, that is, the similarity between the static query permission and the dynamic query permission is used as the credit cross-similarity permission, and the similarity refers to the similar part of the static query permission and the dynamic query permission, and it is identified as the credit cross-similarity permission; then, the trusted query factor of different query behaviors when allocating permissions can be set according to the query feature behavior, query role identity authentication and query history records. For example, different query behavior characteristics can set corresponding credibility factors. Users who frequently query the same type of data have higher credibility. The credibility factor can be represented by dimensionless data between 0 and 1, which is used to measure the degree of credibility when allocating permissions; finally, quantification is performed based on the credit cross-similarity permission and the trusted query factor, and the quantification result is used as the trusted query measurement. The quantification process can use matrix mapping or a deep machine learning model, which will not be repeated here.

[0126] It should be noted that the credit cross-similarity authority in this application represents the similarity of authority matching of authorized queries in inventory data queries; the trusted query factor is the degree of factors used to evaluate and ensure the credibility and security of inventory data queries; the trusted query metric is a metric or indicator used to measure the credibility and security in the data query process.

[0127] In specific implementation, querying the inventory quantity of inventory accounts based on the trusted query metric can be achieved in the following manner, namely: presetting an inventory account query trust threshold, comparing the trusted query metric with the query trust threshold, and when the trusted query metric is greater than or equal to the query trust threshold, generating and executing a query statement to query the inventory quantity of inventory accounts; when the trusted query metric is less than the query trust threshold, rejecting the inventory account inventory quantity query application.

[0128] In addition, in another aspect of the present application, in some embodiments, the present application provides an inventory item inventory quantity query system, referring to Figure 4, which is a schematic diagram of exemplary hardware and / or software of an inventory subject inventory quantity query system according to some embodiments of the present application, the inventory subject inventory quantity query system 400 includes: an acquisition module 401, a processing module 402 and an execution module 403, which are respectively described as follows:

[0129] Acquisition module 401, in this application, acquisition module 401 is mainly used to start inventory quantity query and obtain product identification information in inventory items;

[0130] Processing module 402, in this application, is mainly used to match the product identification information with the query role when querying the inventory quantity, obtain the inventory query session set, and then determine the query control list of the query role when accessing the inventory account through the query session set;

[0131] In addition, the processing module 402 is further used to extract the query constraints of query control of different query roles when accessing inventory accounts according to the query control list, determine the permission allocation set when querying inventory accounts according to all query constraints and the query role for querying products in the inventory accounts, and then determine the static query permission through the permission allocation set;

[0132] In addition, the processing module 402 is further used to obtain a query rule corresponding to a query role of a product in an inventory account, determine a query authority level corresponding to dynamic inventory information according to the query rule and a product identification feature when an inventory product in an inventory account is changed, and determine a dynamic query authority according to the query authority level;

[0133] The execution module 403 is mainly used in this application to perform credit cross-verification on the static query authority and the dynamic query authority to obtain a trusted query metric, and query the inventory quantity of the inventory account based on the trusted query metric.

[0134] In addition, the present application also provides a computer device, which includes a memory and a processor, the memory stores code, and the processor is configured to obtain the code and execute the above-mentioned inventory account inventory quantity query method.

[0135] In some embodiments, reference Figure 5 , which is a schematic diagram of the structure of a computer device for implementing a method for querying inventory quantity of inventory items according to some embodiments of the present application. The method for querying inventory quantity of inventory items in the above embodiments can be performed by Figure 5 The computer device 500 shown in the figure is implemented, and the computer device 500 includes at least one processor 501, a communication bus 502, a memory 503 and at least one communication interface 504.

[0136] Processor 501 can be a general-purpose central processing unit (CPU), or an application-specific integrated circuit (ASIC) or one or more for controlling the execution of the inventory item inventory quantity query method in the present application.

[0137] The communication bus 502 may be used to transmit information between the above-mentioned components.

[0138] The memory 503 may be a read-only memory (ROM) or other types of static storage devices that can store static information and instructions, a random access memory (RAM) or other types of dynamic storage devices that can store information and instructions, or an electrically erasable programmable read-only memory (EEPROM), a compact disc read-only memory (CD-ROM) or other optical disc storage, optical disc storage (including compressed optical disc, laser disc, optical disc, digital versatile disc, Blu-ray disc, etc.), a disk or other magnetic storage device, or any other medium that can be used to carry or store the desired program code in the form of instructions or data structures and can be accessed by a computer, but is not limited thereto. The memory 503 may exist independently and be connected to the processor 501 via the communication bus 502. The memory 503 may also be integrated with the processor 501.

[0139] The memory 503 is used to store the program code for executing the solution of the present application, and the execution is controlled by the processor 501. The processor 501 is used to execute the program code stored in the memory 503. The program code may include one or more software modules. The inventory account inventory quantity query method in the above embodiment can be implemented by the processor 501 and one or more software modules in the program code in the memory 503.

[0140] The communication interface 504 uses any transceiver or other device for communicating with other devices or communication networks, such as Ethernet, radio access network (RAN), wireless local area networks (WLAN), etc.

[0141] In a specific implementation, as an embodiment, a computer device may include multiple processors, each of which may be a single-CPU processor or a multi-CPU processor. The processor here may refer to one or more devices, circuits, and / or processing cores for processing data (e.g., computer program instructions).

[0142] The above-mentioned computer device can be a general-purpose computer device or a special-purpose computer device. In a specific implementation, the computer device can be a desktop computer, a portable computer, a network server, a personal digital assistant (PDA), a mobile phone, a tablet computer, a wireless terminal device, a communication device or an embedded device. The embodiment of the present application does not limit the type of computer device.

[0143] In addition, the present application also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the above-mentioned inventory account inventory quantity query method.

[0144] Although the preferred embodiments of the present application have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present application.

[0145] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A method for querying the inventory quantity of inventory items, characterized in that: The steps include: Start inventory quantity query to obtain product identification information in inventory accounts; Matching the product identification information with the query role when querying the inventory quantity to obtain an inventory query session set, and then determining a query control list of the query role when accessing the inventory account through the query session set; Extracting query constraints of query control for different query roles when accessing inventory accounts according to the query control list, determining a permission allocation set for inventory query based on all query constraints and the query role for querying products in the inventory account, and then determining static query permissions through the permission allocation set; Obtaining the query rules corresponding to the query roles of the products in the inventory account, determining the query authority level corresponding to the dynamic inventory information according to the query rules and the product identification characteristics when the inventory products in the inventory account are changed, and determining the dynamic query authority according to the query authority level; Perform credit cross-verification on the static query authority and the dynamic query authority to obtain a trusted query metric, and query the inventory quantity of the inventory account based on the trusted query metric; The product identification information is matched with the query role when querying the inventory quantity to obtain the inventory query session set, which specifically includes: Setting query characteristics of inventory products according to the product identification information; Classify the permissions of the query roles when querying the inventory quantity to obtain the query role permissions; Matching the query features with the query role permissions to obtain an inventory query session set; The query control list for the query role to access the inventory account through the query session set specifically includes: Extracting authentication features of the query role according to the query session set; Get the historical access records of the inventory account; Generate a query control list for the query role when accessing inventory accounts based on the authentication characteristics of the query role and the historical access records of the inventory accounts.

2. The method according to claim 1, characterized in that The query control list is used to extract query constraints of query control for different query roles when accessing inventory accounts, specifically including: Determining low-dimensional representations of different query roles according to the query control list; By comparing the low-dimensional representations of different query roles in the query control list, the query constraints of query control for different query roles when accessing inventory accounts are obtained.

3. The method according to claim 1, characterized in that The permission allocation set for inventory query is determined by all query constraints and the query role for querying products in inventory accounts. Specifically, it includes: Get the inventory query history data corresponding to the query role for querying products in the inventory account; Associating the inventory query history data with the current inventory query behavior to obtain a query behavior correlation amount; Aggregation is performed according to the query constraint amount and the query behavior association amount to obtain a permission allocation set for inventory query.

4. The method according to claim 1, characterized in that The query rules corresponding to the query role for obtaining products in inventory accounts include: Determine the query permissions for inventory query of inventory accounts; Generate query role information according to the query authority; The query rule corresponding to the query role is determined by the query authority and the query role information.

5. The method according to claim 1, characterized in that Read product identification information in the inventory account through the inventory management system.

6. A system for querying the inventory quantity of inventory items, which uses the method described in any one of claims 1 to 5 to query the inventory quantity of inventory items, characterized in that: The inventory quantity query system for inventory items includes: The acquisition module is used to start the inventory quantity query and obtain the product identification information in the inventory account; A processing module, used for matching the product identification information with the query role when querying the inventory quantity to obtain an inventory query session set, and then determining a query control list of the query role when accessing the inventory account through the query session set; The processing module is further used to extract the query constraint quantities of query control of different query roles when accessing inventory accounts according to the query control list, determine the permission allocation set for inventory query based on all query constraint quantities and the query role for querying products in the inventory account, and further determine the static query permission through the permission allocation set; The processing module is further used to obtain a query rule corresponding to a query role of a product in an inventory account, determine a query authority level corresponding to the dynamic inventory information according to the query rule and a product identification feature when an inventory product in an inventory account is changed, and determine the dynamic query authority according to the query authority level; The execution module is used to perform credit cross-verification on the static query authority and the dynamic query authority to obtain a trusted query metric, and query the inventory quantity of the inventory account based on the trusted query metric.

7. A computer device, characterized in that: The computer device includes a memory and a processor, the memory stores codes, and the processor is configured to obtain the codes and execute the inventory account stock quantity query method according to any one of claims 1 to 5.

8. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the inventory quantity query method for inventory items according to any one of claims 1 to 5 is implemented.

Images