Auxiliary balance query method, system and device and medium
By defining auxiliary query tables and optimizing query conditions, the problem that traditional query systems cannot scale and meet diversified needs is solved, efficient and accurate data query is achieved, and user experience and system performance are improved.
Patent Information
- Application Number
- CN202510485772.7
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-04-17
- Publication Date
- 2025-07-29
AI Technical Summary
Traditional query systems cannot support the expansion of auxiliary accounting projects, and the query scope is limited, which cannot meet the diverse query needs of users, resulting in inaccurate query results and poor convenience.
By defining auxiliary query tables, including auxiliary query main table, auxiliary list details table, help information table and filtering condition table, it supports flexible query condition configuration, and performs data preprocessing and cache optimization to achieve accurate and fuzzy matching, and optimize query performance using data partitioning and sharding strategies.
It improves the efficiency and accuracy of data query, improves user experience, supports complex query requirements, and enhances the scalability and maintainability of the system.
Smart Images
Figure CN120386799A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical fields of financial management and accounting, and particularly to an auxiliary balance query method, system, device and medium. Background Art
[0002] In the fields of financial management and accounting, auxiliary accounting items play a crucial role as an important tool for enterprises to carry out refined management. However, traditional query systems often fall short when dealing with these complex requirements.
[0003] Specifically, traditional query systems have many limitations. On the one hand, they usually do not support the expansion of auxiliary accounting items, resulting in limited query scope and inability to cover all relevant financial data of the enterprise. This may cause important information to be missed during financial analysis by the enterprise, affecting the accuracy of decision-making.
[0004] On the other hand, the query condition settings of traditional query systems are not flexible enough to meet the diverse query needs of users. Users often can only query according to the query conditions preset by the system and cannot customize according to their actual needs. This not only reduces the convenience of querying but also limits the accuracy of query results.
[0005] Therefore, in order to solve the problems existing in traditional query systems in the fields of financial management and accounting and improve query efficiency, accuracy and user experience, it is necessary to propose a new query system. Summary of the Invention
[0006] The purpose of the embodiments of the present invention is to provide an auxiliary balance query method, system, device and medium, which improve the efficiency and accuracy of data query and enhance the user experience by defining an auxiliary query table and configuring query conditions.
[0007] To achieve the above purpose, the embodiments of the present invention provide an auxiliary balance query method, including: Determine the types of auxiliary accounting items to be managed and define an auxiliary query table, where the auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filter condition table for constructing the logical relationship of query conditions; Identify detail fields, field descriptions, field types, field attributes, associated table requirements and help information in the auxiliary column detail table; Query vouchers or auxiliary balances according to the user's filter conditions and the accounting item information defined in the auxiliary query table.
[0008] Optionally, the filtering condition includes any field or a combination of multiple fields in the auxiliary query table.
[0009] Optionally, filtering the data in the auxiliary balance table to be queried includes exact matching and fuzzy matching. Among them, the exact matching is characterized as a retrieval method in which the retrieval term is exactly the same as the field in the database during the query process, and the fuzzy matching is characterized as a difference between the retrieval term and the database field during the query process.
[0010] Optionally, the auxiliary balance query method further includes: Based on the field information configured by the user, perceive the situation of the vouchers or auxiliary balances to be queried, and perform preprocessing and cache optimization to speed up the query speed.
[0011] Optionally, perceiving the situation of the vouchers or auxiliary balances to be queried includes: Data situation perception and preprocessing, including intelligent analysis of data volume, data partitioning and sharding, pre-aggregation and summarization; Optimization of common query conditions, including query condition recording and analysis, index optimization, query caching, and preprocessing intermediate tables.
[0012] Optionally, data situation perception and preprocessing include: Analyze the auxiliary query main table, auxiliary column detail table, help information table, or the data volume involved in the query through statistical information, index usage, or query execution plan; For the auxiliary query main table, auxiliary column detail table, and help information table whose data volume exceeds the preset threshold, use horizontal partitioning or vertical partitioning to disperse the data into different physical storage units. Among them, the horizontal partitioning is for the query requirements of the auxiliary balance, and the vertical partitioning is for the sending amount and balance key fields of specific accounting items; For the auxiliary item data that needs to be aggregated or summarized, pre-calculate and store the aggregation result when the data is written or when the processing task is executed regularly.
[0013] Optionally, the pre-aggregation or summarization includes pre-calculating and storing the aggregation result when the data is written or when the batch processing task is executed regularly to speed up the query speed.
[0014] In a second aspect, the present invention also provides an auxiliary balance query system, including: A definition module, used to determine the type of auxiliary accounting items to be managed and define an auxiliary query table. Among them, the auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filtering condition table for constructing the logical relationship of query conditions; An identification module, configured to identify detailed fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column breakdown list; A query module, configured to perform voucher or auxiliary balance query according to the accounting item information defined in the auxiliary query table based on user filtering conditions.
[0015] In a third aspect, the present invention further provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the steps of the above-mentioned auxiliary balance query method are implemented. In a fourth aspect, the present invention further provides a storage medium, on which a computer program is stored. When the computer program is executed by a processor, the steps of the above-mentioned auxiliary balance query method are implemented.
[0016] By the above technical solutions, by means of defining an auxiliary query table and configuring query conditions, the efficiency and accuracy of data query are improved, and the user experience is enhanced at the same time.
[0017] Other features and advantages of the embodiments of the present invention will be described in detail in the subsequent specific implementation part. BRIEF DESCRIPTION OF THE DRAWINGS
[0018] The drawings are used to provide a further understanding of the embodiments of the present invention, and constitute a part of the specification. Together with the following specific implementation manners, they are used to explain the embodiments of the present invention, but do not constitute a limitation to the embodiments of the present invention. In the drawings: Figure 1 is a flowchart of an auxiliary balance query method provided by an embodiment of the present invention; Figure 2 is a detailed implementation process of an auxiliary balance query method provided by an embodiment of the present invention; Figure 3 is a schematic structural diagram of an auxiliary balance query system provided by an embodiment of the present invention; Figure 4 is a schematic hardware structure diagram of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS
[0019] In the following detailed description, various embodiments of the present disclosure will be described more fully. The present disclosure may have various embodiments, and adjustments and changes may be made therein. However, it should be understood that there is no intention to limit the various embodiments of the present disclosure to the specific embodiments disclosed herein, but the present disclosure should be understood to cover all adjustments, equivalents, and / or alternative solutions falling within the spirit and scope of the various embodiments of the present disclosure.
[0020] In the following, the term "comprising" or "may comprise" that can be used in various embodiments of the present disclosure indicates the presence of the disclosed functions or operations, and does not limit the addition of one or more functions or operations. In addition, as used in various embodiments of the present disclosure, the terms "comprising", "having" and their cognates are only intended to indicate specific features, numbers, steps, operations or combinations of the foregoing items, and should not be construed as first excluding the existence of one or more other features, numbers, steps, operations or combinations of the foregoing items or the possibility of adding one or more features, numbers, steps, operations or combinations of the foregoing items.
[0021] In various embodiments of the present disclosure, the expression "or" or "at least one of A or / and B" includes any combination or all combinations of the recited words. For example, the expression "A or B" or "at least one of A or / and B" may include A, may include B, or may include both A and B.
[0022] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all of the embodiments. All other embodiments obtained by those of ordinary skill in the art based on the embodiments of the present invention without creative efforts shall fall within the protection scope of the present invention.
[0023] Refer to Figure 1 Shown is a flowchart of an auxiliary balance query method in a specific embodiment, including the following execution steps: Step 100: Determine the types of auxiliary accounting items to be managed and define an auxiliary query table.
[0024] Among them, the auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filter condition table for constructing the logical relationship of query conditions.
[0025] Exemplarily, determine common auxiliary accounting items (such as: department, customer, supplier, project, employee, etc.).
[0026] In some embodiments, after defining the auxiliary query main table, the auxiliary column detail table, and the help information table, a relationship between the auxiliary detail table and the auxiliary query main table (one-to-many, one item corresponding to multiple fields) is established through foreign key constraints, and a relationship between the auxiliary detail table and the help information table is established.
[0027] Step 101: Identify the detail fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column detail table.
[0028] Specifically, details fields: Each auxiliary accounting item will be equipped with specific details fields to ensure data integrity and accuracy. These fields will directly reflect the core characteristics of the item. Field description: Describe the content, usage, etc. of the details fields to facilitate user operation. Field type: Specify the data type (such as text, number, date, etc.) for each details field to ensure the standardization and consistency of data during storage and query. Field attributes: Set detailed attributes for each field, such as whether it allows null values, whether it contains default values, whether uniqueness is required, etc., to meet different data query requirements. Associated table requirements: For fields that need to establish connections with other data tables, clearly indicate their associated requirements, including the association method, association logic, etc., to support complex data analysis and query operations. Help information: To facilitate user understanding and operation, corresponding help can be specified for the fields, including the usage of the fields, data input rules, etc., to enhance the user experience and the accuracy of data entry.
[0029] Exemplarily, the table structure of the auxiliary query main table is shown in Table 1 below: Table 1 Auxiliary Query Main Table
[0030] Exemplarily, the auxiliary column details table (auxiliary accounting item), the table structure is shown in Table 2 below: Table 2 Auxiliary Column Details Table
[0031] By defining a unified auxiliary query table structure, it can be ensured that the information management and use of all auxiliary accounting items follow consistent standards and specifications. Standardized definitions of field names, field types, field attributes, etc. help reduce data redundancy and inconsistency. The auxiliary query table provides detailed field information, enabling users to quickly locate the required fields when querying data, improving query efficiency. The associated table requirement fields clarify the association relationships with other tables, helping to optimize query statements and reduce unnecessary table joins and data scans.
[0032] Step 102: According to the user filtering conditions, query vouchers or auxiliary balances based on the accounting item information defined in the auxiliary query table.
[0033] In response to the filtering conditions set by the user in the front-end interface, filtering the data in the auxiliary balance table to be queried can significantly improve the flexibility and efficiency of data query, optimize the user experience, enhance the accuracy and reliability of data, while supporting complex query requirements, promoting data analysis and decision support, and improving the scalability and maintainability of the system.
[0034] Exemplarily, the filtering condition includes any field or a combination of multiple fields in the auxiliary query table.
[0035] Exemplarily, the structure of the filtering condition table is shown in Table 3 below: Table 3 Filtering Condition Table
[0036] It should be understood that the magnitudes of the sequence numbers of the steps in the above embodiments do not imply the order of execution. The order of execution of each process should be determined according to its function and internal logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.
[0037] In a specific embodiment, the query includes exact match and fuzzy match. Among them, the exact match is characterized as a retrieval method in which the retrieval term is exactly the same as the field in the database during the query process, and the fuzzy match is characterized as a difference between the retrieval term and the database field during the query process.
[0038] Users can select a suitable matching method according to specific needs, thereby improving the query efficiency. For cases where exact results are required, exact match is used; for cases where broader results are required, fuzzy match is used. Providing multiple matching methods can meet the needs and preferences of different users. Users can select a suitable matching method according to their query habits and experience, thereby obtaining a better query experience. The combination of exact match and fuzzy match can support more complex query scenarios.
[0039] For example, in financial analysis, users may need to find both exact match and fuzzy match results simultaneously to obtain more comprehensive data and information.
[0040] In a specific embodiment, a highly configurable dictionary item information architecture is innovatively designed, that is, by publishing an auxiliary query definition form, allowing users to independently enter auxiliary item dictionary information, including auxiliary items and auxiliary item fields that need to be extended. This architecture allows users or system administrators to dynamically add, modify, or delete dictionary item information according to actual needs, without modifying the underlying code or database structure.
[0041] Designing a highly flexible and configurable dictionary item information architecture and allowing users to independently enter auxiliary item dictionary information by publishing an auxiliary query definition form has achieved multiple technical effects such as enhancing the scalability and flexibility of the system, improving user participation and satisfaction, optimizing data management and query efficiency, reducing system complexity and maintenance costs, supporting business innovation and quickly responding to market changes, and enhancing system security and stability. This innovative approach has laid a solid foundation for the long-term development and continuous optimization of the system.
[0042] Implementation of a multi-dimensional query engine. Based on the above configurable dictionary item information (auxiliary query definition form), the present invention further develops a powerful multi-dimensional query engine. This engine supports users to perform independent or combined queries based on any field in the dictionary. That is, during the process of configuring the filtering conditions, users can flexibly add single or multiple filtering fields, and can customize the relationships between these fields, choosing whether to adopt the logical relationship of "OR" or "AND", so as to achieve more accurate and detailed filtering of data. At the same time, it provides two query modes: exact match and fuzzy match (in the way of like). Exact match means the retrieval method where the retrieval term is exactly the same as the field in the database. Fuzzy match means that during the query process, it allows a certain degree of difference between the retrieval term and the content of the database field, as long as certain matching rules are met. In SQL queries, it is implemented using the LIKE operator combined with the wildcard percent sign to represent any number of characters. To meet the query requirements in different scenarios. The flexibility of this query mechanism not only improves the efficiency and accuracy of data retrieval, but also provides users with a more convenient and personalized query experience.
[0043] Based on the configured field information, the query page automatically displays the number and name fields for help fields and enumerated fields (usually the ID field. The help field is associated with the help dictionary to display the help number and name information. The enumerated field displays the name according to the configured enumeration items), optimizing the query experience.
[0044] Based on the configured field information, the design optimization of automatically displaying the number and name fields for help fields and enumerated fields on the query page can significantly improve data readability and understandability, optimize query efficiency and accuracy, enhance user experience and satisfaction, and support business requirements and changes. These technical effects jointly promote the overall improvement of the query experience.
[0045] To further improve the performance of the query page, especially when dealing with a large amount of data, we can, based on the configured field information, take a series of strategic measures (recording the query time consumption and the size of the data volume returned by the query) to perceive the situation of the data to be queried, and perform preprocessing and cache optimization to significantly speed up the query.
[0046] In some embodiments, the method flow of the auxiliary balance query further includes: Based on the field information configured by the user, perceive the situation of the vouchers or auxiliary balances to be queried, and perform preprocessing and cache optimization to speed up the query.
[0047] Specifically, the perception of the situation of the vouchers or auxiliary balances to be queried includes: 1) Perception and preprocessing of data situation, including intelligent analysis of data volume, data partitioning and sharding, pre-aggregation and summarization.
[0048] Specifically, intelligent analysis of data volume: The system should be able to automatically analyze the data volume involved in each table or query in the database, identify which queries may involve a large amount of data, and achieve this by recording the time taken for this query and the size of the returned data volume during the query. This can be accomplished through statistical information, index usage, or query execution plans.
[0049] Intelligently analyzing the data volume in the database and identifying queries that may involve a large amount of data through statistical information, index usage, or query execution plans can achieve multiple technical effects such as optimizing query performance, enhancing user experience, strengthening system stability, and promoting data governance. These effects work together at the enterprise's data management and application levels, providing strong support for the enterprise's digital transformation and intelligent development.
[0050] Specifically, data situation awareness and preprocessing include the following steps: S1: Analyze the data volume involved in the auxiliary query main table, auxiliary column detail table, help information table, or query through statistical information, index usage, or query execution plans.
[0051] S2: For the auxiliary query main table, auxiliary column detail table, and help information table whose data volume exceeds the preset threshold, use horizontal partitioning or vertical partitioning to disperse the data into different physical storage units. Among them, the horizontal partitioning is for the query requirements of the auxiliary balance, and the vertical partitioning is for the send amount and balance key fields of specific accounting items.
[0052] Exemplarily, data partitioning and sharding: For tables with a large amount of data, consider implementing a data partitioning or sharding strategy to disperse the data into different physical storage units. In this way, when querying, only the relevant partitions can be scanned, reducing the data scanning range and improving the query efficiency. For example, the query requirements for the auxiliary balance usually focus on specific months. In response to this characteristic, a horizontal partitioning method can be adopted to divide the data in detail according to months. This partitioning strategy not only helps to improve the query efficiency because the system can quickly locate and only scan the data of the required months, thus significantly reducing the data processing volume, but also makes the maintenance and management of the data more convenient. Through horizontal partitioning, the challenges of large data volumes can be more effectively addressed, ensuring the stable operation and high performance of the database system. Or, in certain specific scenarios, users may mainly focus on key fields such as the debit and credit amounts and balances of certain specific accounting items in the accounting organization. In response to this demand, consider adopting a vertical partitioning strategy. The advantage of doing this is that, on the one hand, it can significantly reduce the amount of data that needs to be scanned each time a query is made, thus accelerating the query speed; on the other hand, since these key fields are stored and managed separately, the update and maintenance of the data will also become more efficient and flexible. The vertical partitioning strategy can accurately meet the user's query requirements for specific fields while improving the overall performance and maintainability of the database.
[0053] S3: For the auxiliary item data that needs to be aggregated or summarized, pre-calculate and store the aggregation results when the data is written or periodically execute processing tasks.
[0054] The pre-aggregation or summarization includes pre-calculating and storing the aggregation results when the data is written or periodically executing batch processing tasks to speed up the query speed.
[0055] Exemplarily, the query of the auxiliary balance table needs to be associated with the corresponding accounting item dictionary and combined with filtering conditions for filtering and then real-time calculation and summarization. The table data involved is large, and generally the execution plan time is long. For statistical scenarios, for data that often needs to be aggregated or summarized, the aggregation results can be pre-calculated and stored when the data is written or periodically execute batch processing tasks. When querying, directly read these pre-calculated results, which can significantly reduce the processing time and resource consumption. For example, when a user needs to query the auxiliary accounting item - contract, first, according to the query conditions, filter out the qualified data from the original data source and store it separately in an intermediate table. Then, perform data aggregation on the contract data in the intermediate table, usually query the debit and credit amounts of the contract during the query period and store the data in the intermediate table to speed up the query speed.
[0056] 2) Optimization of common query conditions, including query condition recording and analysis, index optimization, query caching, and preprocessing intermediate tables.
[0057] Specifically, query condition recording and analysis: The system should record and analyze the user's query behavior, especially those frequently used query conditions. This helps identify which fields or combinations of conditions are query hotspots.
[0058] Index optimization: Based on common query conditions, optimize the index strategy. Ensure that these frequently used query conditions are all covered by effective indexes to reduce full table scans during queries.
[0059] Query caching: For exactly the same queries (including query conditions and parameters), implement query result caching. When the same query is received again, directly return the result from the cache to avoid repeating expensive database operations.
[0060] Preprocessing intermediate table: For complex aggregation queries, consider using a preprocessing intermediate table to store query results. The preprocessing intermediate table is refreshed regularly, and when querying, directly read the data in the preprocessing intermediate table to improve the response speed.
[0061] Query progress feedback: For long-running queries, provide feedback on the query progress to reduce the user's anxiety during waiting.
[0062] Result paging and lazy loading: For queries with a large number of results, implement result paging display and lazy loading functions. Users can gradually load more data as needed, reducing the consumption of system resources caused by loading a large amount of data at once. Based on the configured dictionary information, for abnormal states such as deactivated status, missing foreign keys, and duplicate main fields, perceive the data to be queried and push the abnormal data to the user to improve data quality.
[0063] In this embodiment, the user can not only perform independent queries on any field in the dictionary, but also freely combine multiple field conditions for advanced search, and at the same time support both exact match and fuzzy match modes, ensuring that the user can quickly and accurately find the required information, greatly improving the efficiency of data retrieval and the user experience.
[0064] Refer to Figure 2 As shown, the detailed implementation process of an auxiliary balance query method provided by an embodiment of the present invention includes, before performing voucher or auxiliary balance query, first performing auxiliary query definition: defining the dictionary of auxiliary items to be extended, configuring dictionary item fields, defining help association information, enumeration, etc., and then performing auxiliary balance query: selecting the auxiliary items for which the query conditions need to be extended, configuring the query conditions, and performing auxiliary balance query.
[0065] The technical effects achieved by this application are as follows: 1. By defining the auxiliary query table, the extension of auxiliary accounting items is realized, improving the flexibility of the query scope.
[0066] 2. The query configuration module allows users to independently set filtering conditions, meeting the diverse query needs of users.
[0067] 3. The display module allows users to select the auxiliary item fields they hope to present, achieving customized display of information.
[0068] 4. The query support module provides a highly configurable dictionary item information architecture and a multi-dimensional query engine, improving query efficiency and accuracy.
[0069] 5. The performance optimization module significantly improves the performance of the query page through strategies such as data situation awareness and preprocessing, and optimization of common query conditions.
[0070] As Figure 3 shown, the following is an embodiment of the auxiliary balance query system provided by the present disclosure. It belongs to the same inventive concept as the auxiliary balance query methods of the above embodiments. For the details not described in detail in the embodiment of the auxiliary balance query system, reference can be made to the embodiments of the above auxiliary balance query methods.
[0071] The auxiliary balance query system includes: A definition module, configured to determine the types of auxiliary accounting items to be managed and define an auxiliary query table. The auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filtering condition table for constructing the logical relationship of query conditions; An identification module, configured to identify detailed fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column detail table; A query module, configured to perform voucher or auxiliary balance query according to the user's filtering conditions and the accounting item information defined in the auxiliary query table.
[0072] Figure 4 It is a schematic hardware structure diagram of an electronic device for implementing various embodiments of the present invention.
[0073] The auxiliary balance query method provided by the embodiments of this application can be applied to an electronic device. Those skilled in the art can understand that the structure of the electronic device involved in the embodiments of the present invention does not constitute a limitation on the electronic device. The electronic device may include more or fewer components than shown in the figure, or combine certain components, or have different component arrangements. In the embodiments of the present invention, the electronic device includes, but is not limited to, a laptop computer, a desktop computer, a workbench, a personal digital assistant, a server, a blade server, a mainframe computer, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices, and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the embodiments of this application described and / or claimed herein.
[0074] The electronic device may include a processor, an external memory interface, an internal memory, a universal serial bus (USB) interface, a charging management module, a power management module, a battery, a wireless communication module, an audio module, a speaker, a microphone, a sensor module, a key, a camera, a display screen, and a SIM card interface, etc.
[0075] It can be understood that the structure schematically shown in the embodiments of this application does not constitute a specific limitation on the electronic device. In other embodiments of this application, the electronic device may include more or fewer components than shown in the figure, or combine certain components, or split certain components, or have different component arrangements. The components shown in the figure can be implemented in hardware, software, or a combination of software and hardware.
[0076] The processor may include one or more processing units. For example, the processor may include a central processing unit (CPU), etc., an application processor (AP), a modem processor, a graphics processing unit (GPU), an image signal processor (ISP), a controller, a memory, a video codec, a digital signal processor (DSP), a baseband processor, and / or a neural-network processing unit (NPU), etc. Among them, different processing units may be independent devices or integrated in one or more processors.
[0077] Among them, the processor can be the nerve center and command center of the electronic device. The controller can generate operation control signals according to the instruction operation code and timing signal to complete the control of fetching and executing instructions.
[0078] A memory can also be set in the processor for storing instructions and data. In some embodiments, the memory in the processor is a cache memory. This memory can save the instructions or data that the processor has just used or recycled. If the processor needs to use the instruction or data again, it can directly call it from this memory. This avoids repeated accesses, reduces the waiting time of the processor, and thus improves the system efficiency.
[0079] The external memory interface can be used to connect to an external memory card, such as a MicroSD card, to implement the storage capacity expansion of the electronic device. The external memory card communicates with the processor through the external memory interface to achieve the data storage function. For example, files such as music and videos are saved in the external memory card.
[0080] The internal memory can be used to store computer-executable program codes, and the computer-executable program codes include instructions. The processor executes various functional applications and data processing of the electronic device by running the instructions stored in the internal memory. The internal memory can include a program storage area and a data storage area. The internal memory can include a high-speed random access memory and can also include a non-volatile memory, such as at least one magnetic disk storage device, a flash memory device, a universal flash storage (UFS), etc.
[0081] The wireless communication function of the electronic device can be implemented through an antenna, a wireless communication module, a modem processor, a baseband processor, etc.
[0082] The wireless communication module can provide wireless communication solutions applied to the electronic device, including wireless local area networks (WLANs) (such as wireless fidelity (Wi-Fi) networks), Bluetooth (BT), global navigation satellite systems (GNSSs), frequency modulation (FM), near field communication (NFC), infrared technology (IR), etc.
[0083] The electronic device can implement audio functions, etc. through an audio module, a speaker, a receiver, a microphone, a headphone interface, an application processor, etc.
[0084] An electronic device can implement a shooting function through an ISP, a camera, a video codec, a GPU, a display screen, an application processor, etc.
[0085] An electronic device can implement a display function through a GPU, a display screen, an application processor, etc.
[0086] The GPU is a microprocessor for image processing, connecting the display screen and the application processor. The GPU is used to perform mathematical and geometric calculations for graphics rendering. The processor may include one or more GPUs, which execute program instructions to generate or change display information.
[0087] The display screen is used to display images, videos, etc. The display screen includes a display panel.
[0088] In the storage medium provided in this application, there is a program product that can implement an auxiliary balance query method.
[0089] The auxiliary balance query method includes: determining the type of auxiliary accounting item to be managed and defining an auxiliary query table, where the auxiliary query table includes an auxiliary query main table for managing the basic metadata of the auxiliary accounting item, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filter condition table for constructing the logical relationship of query conditions; identifying the detail fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column detail table; and performing voucher or auxiliary balance query according to the user's filter conditions and the accounting item information defined in the auxiliary query table.
[0090] In some possible implementation manners, the subject name auxiliary balance query method and system of the present disclosure can be implemented in the form of a program product, which includes program code. When the program product runs on a terminal device, the program code is used to cause the terminal device to execute the steps according to various exemplary embodiments of the present disclosure described in the "exemplary method" section of this specification.
[0091] The storage medium of the present disclosure can adopt any combination of one or more readable media. The readable medium can be a readable signal medium or a readable storage medium. The readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the above. More specific examples (non-exhaustive list) of the readable storage medium include: an electrical connection with one or more wires, a portable disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above.
[0092] The foregoing description of the disclosed embodiments enables those skilled in the art to practice or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. An auxiliary balance query method, characterized in that, including: Determine the types of auxiliary accounting items to be managed and define an auxiliary query table. The auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filter condition table for constructing the logical relationship of query conditions; Identify the detail fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column detail table; Query vouchers or auxiliary balances according to the user filter conditions and the accounting item information defined in the auxiliary query table.
2. The auxiliary balance query method according to claim 1, wherein The user filter conditions include any field or combination of multiple fields in the auxiliary query table.
3. The auxiliary balance query method according to claim 1, wherein Filtering the data in the auxiliary balance table to be queried includes exact matching and fuzzy matching. The exact matching is characterized by a retrieval method in which the retrieval term is exactly the same as the field in the database, and the fuzzy matching is characterized by a difference between the retrieval term and the database field during the query process.
4. The auxiliary balance query method according to claim 1, characterized in that The auxiliary balance query method further includes: Based on the field information configured by the user, sense the situation of the vouchers or auxiliary balances to be queried, and perform preprocessing and cache optimization to speed up the query.
5. The auxiliary balance query method according to claim 4, characterized in that The sensing of the situation of the vouchers or auxiliary balances to be queried includes: Data situation sensing and preprocessing, including intelligent analysis of data volume, data partitioning and sharding, pre-aggregation and summarization; Optimization of common query conditions, including recording and analysis of query conditions, index optimization, query caching, and preprocessing intermediate tables.
6. The auxiliary balance query method according to claim 5, wherein, The data situation sensing and preprocessing include: Analyze the data volume of the auxiliary query main table, auxiliary column detail table, help information table, or data involved in the query through statistical information, index usage, or query execution plan; For the auxiliary query main table, auxiliary column detail table, and help information table with data volume exceeding the preset threshold, use horizontal partitioning or vertical partitioning to disperse the data into different physical storage units. The horizontal partitioning is for the query requirements of auxiliary balances, and the vertical partitioning is for the sending amount and balance key fields of specific accounting items; For the auxiliary item data that needs to be aggregated or summarized, pre-calculate and store the aggregation results when the data is written or when processing tasks are executed regularly.
7. The auxiliary balance query method according to claim 5, wherein The pre-aggregation or summarization includes pre-calculating and storing the aggregation results when the data is written or when batch processing tasks are executed regularly to speed up the query.
8. An auxiliary balance query system, characterized in that, including: A definition module for determining the types of auxiliary accounting items to be managed and defining an auxiliary query table. The auxiliary query table includes an auxiliary query main table for managing the basic metadata of auxiliary accounting items, an auxiliary column detail table for defining the field attributes of each auxiliary accounting item, a help information table for decoupling field help information, and a filter condition table for constructing the logical relationship of query conditions; An identification module for identifying the detail fields, field descriptions, field types, field attributes, associated table requirements, and help information in the auxiliary column detail table; A query module for querying vouchers or auxiliary balances according to the user filter conditions and the accounting item information defined in the auxiliary query table.
9. An electronic device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, When the processor executes the program, the steps of the auxiliary balance query method according to any one of claims 1 to 7 are implemented.
10. A storage medium, on which a computer program is stored, characterized in that, When the computer program is executed by a processor, the steps of the auxiliary balance query method according to any one of claims 1 to 7 are implemented.