Accounting data storage searching method and device, storage medium and electronic equipment

Abstract

Embodiments of the present application provide a kind of accounting data storage search method, device, storage medium and electronic equipment, the method comprises: obtaining the data in warehouse obtained after peripheral system in the accounting data of business date year month table is handled;Corresponding accounting amount of each data in warehouse is obtained, and a plurality of preset amount interval is obtained, based on accounting amount and preset amount interval, data in warehouse is batched, at least one batch of first target data in warehouse is obtained;Each batch of first target data in warehouse is stored in different data repository respectively;Obtain preset data table, the storage address of each data repository, and the amount interval of each batch of first target data in warehouse stored in each data repository is recorded in preset data table;The target accounting amount corresponding to the data in warehouse to be searched is received, and the corresponding target data repository is found from preset data table based on target accounting amount, and the data in warehouse to be searched is found from target data repository.

Description

Technical Field

[0001] This application relates to the field of data processing technology, and in particular to a method, apparatus, storage medium and electronic device for storing and searching accounting data. Background Technology

[0002] The external system processes incoming data from a table with the same business date (year / month) and stores the resulting data in a data storage repository. Since each incoming data entry corresponds to an incoming amount, knowing the amount of a particular incoming data entry allows retrieval of that data from the data storage repository. However, in existing technology, the external system does not batch the incoming data and store each batch separately in different data storage repositories; instead, it stores all the data together in the same data storage repository. When there is a large amount of incoming data in the business date table, the resulting data set is extensive. Storing all the data together in one repository can make retrieving the corresponding data from the data storage repository based on the incoming amount less convenient and inefficient.

[0003] Therefore, existing technologies have shortcomings and need to be improved and developed. Summary of the Invention

[0004] This application provides a method, apparatus, storage medium, and electronic device for searching and storing accounting data, which can quickly find the accounting data to be searched from the data storage database, thereby improving search efficiency.

[0005] This application provides a method for storing and retrieving accounting data, the method including:

[0006] Obtain the inbound data obtained by the external system after processing the inbound data in the business date month-year table, where the inbound data in the same business date month-year table have the same business date;

[0007] Obtain the amount of each inbound data and multiple preset amount ranges. Divide the inbound data into batches based on the amount of each inbound data and the preset amount ranges to obtain at least one batch of first target inbound data.

[0008] Obtain the first data volume of each batch of the first target data entering the warehouse, and determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0009] If so, the second target data is divided into multiple batches of third target data based on the second data volume of the second target data, and the amount range corresponding to each batch of third target data is obtained. The data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0010] Each batch of the first target data, the second target data, and the third target data is stored in a different data storage database.

[0011] Obtain a preset data table and record the storage address of each data storage library, as well as the amount range of each batch of first target data, second target data, or third target data stored in each data storage library, in the preset data table.

[0012] Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

[0013] In the data storage and retrieval method for incoming data described in this application embodiment, the steps of obtaining the incoming amount corresponding to each incoming data, obtaining multiple preset amount ranges, and batching the incoming data based on the incoming amount and the preset amount ranges to obtain at least one batch of first target incoming data include:

[0014] Obtain the amount credited to the database for each of the aforementioned data entries;

[0015] Multiple preset amount ranges are obtained, and the amount of each piece of data entering the database is matched with the preset amount ranges.

[0016] Data entries with the same preset amount range are considered as the same batch of first target data entries, resulting in at least one batch of first target data entries.

[0017] In the data storage and retrieval method for incoming accounts described in this application embodiment, the step of taking incoming data with the same preset amount range as the same batch of first target incoming data to obtain at least one batch of first target incoming data includes:

[0018] Data entries with the same preset amount range are treated as the same batch of first target data entries, resulting in at least one batch of first target data entries before processing.

[0019] Obtain the third data volume of the first target data entering the database before each batch of processing, and obtain the first preset data volume.

[0020] The third data volume is compared with the first preset data volume. The first target data before processing with a third data volume greater than the first preset data volume is taken as the first target data before processing. Two batches of the first target data before processing with a second data volume less than or equal to the second preset data volume are merged into a batch of the first target data before processing to obtain at least one batch of the first target data before processing.

[0021] In the data storage and retrieval method for incoming accounts described in this application embodiment, the steps of receiving the target incoming account amount corresponding to the data to be retrieved, finding the corresponding target data storage based on the target incoming account amount from the preset data table, and retrieving the data to be retrieved from the target data storage include:

[0022] Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched.

[0023] Based on the target amount range, locate the corresponding target data storage database;

[0024] Search for the data to be searched in the target data storage.

[0025] In the data storage and retrieval method for incoming payment data described in this application embodiment, the preset data table further records the business date of each batch of first target incoming payment data, each batch of second target incoming payment data, or each batch of third target incoming payment data stored in each data storage library. The business date is the same for each batch of first target incoming payment data, each batch of second target incoming payment data, or each batch of third target incoming payment data stored in the same data storage library. The steps of receiving the target incoming payment amount corresponding to the incoming payment data to be searched, finding the corresponding target data storage library from the preset data table based on the target incoming payment amount, and searching for the incoming payment data to be searched from the target data storage library include:

[0026] Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched.

[0027] Based on the target amount range, at least one corresponding first data storage database is located;

[0028] Obtain the target business date corresponding to the data to be searched and entered into the database. Based on the target business date, obtain the target data storage database from the first data storage database that has the same business date as the target business date.

[0029] Search for the data to be searched in the target data storage.

[0030] In the data storage and retrieval method for accounting data described in this application embodiment, the step of obtaining the first data volume size of each batch of the first target data inbound, and determining whether there is second target data inbound that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, includes:

[0031] Obtain the first data volume of each batch of the first target data entering the warehouse, and obtain the preset maximum data volume threshold;

[0032] Compare the first data volume with the preset maximum data volume threshold;

[0033] If the size of the first data volume is greater than the preset maximum data volume threshold, it is determined that there is a second target data in the first target data that needs to be saved in batches.

[0034] In the data storage and retrieval method for accounting data described in this application embodiment, after obtaining the first data volume size of each batch of the first target data in storage, and determining whether there is second target data in storage that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, the method further includes:

[0035] If not, then each batch of the first target data and the second target data will be stored in different data storage databases.

[0036] Obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data or each batch of second target data stored in each data storage library in the preset data table.

[0037] Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

[0038] This application embodiment also provides an accounting data storage and retrieval device, the device comprising:

[0039] The acquisition module is used to acquire the data that the external system obtains after processing the accounting data in the business date month-year table. The accounting data in the same business date month-year table have the same business date.

[0040] The first batching module is used to obtain the amount of each inbound data and multiple preset amount ranges, and to batch the inbound data based on the amount of the inbound data and the preset amount ranges to obtain at least one batch of first target inbound data.

[0041] The judgment module is used to obtain the first data volume of each batch of the first target data entering the warehouse, and to determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0042] The second batching module is used to divide the second target data into multiple batches of third target data according to the second data volume of the second target data, and obtain the amount range corresponding to each batch of third target data, wherein the data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0043] The storage module is used to store each batch of the first target data, the second target data, and the third target data in different data storage databases.

[0044] The recording module is used to obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data, second target data, or third target data stored in each data storage library in the preset data table.

[0045] The search module is used to receive the target amount of the data to be searched, find the corresponding target data storage based on the target amount of the data to be searched, and search for the data to be searched in the target data storage.

[0046] This application also provides a computer-readable storage medium storing a computer program that, when run on a computer, causes the computer to execute the accounting data storage and retrieval method described in any embodiment.

[0047] This application also provides an electronic device, which includes a processor and a memory. The memory stores a computer program, and the processor executes the accounting data storage and retrieval method described in any embodiment by calling the computer program stored in the memory.

[0048] In this embodiment, after processing the accounting data in the business date and month table in the peripheral system to obtain the warehousing data, the system obtains the accounting amount corresponding to each warehousing data, divides the warehousing data into batches according to the accounting amount, and then saves each batch of warehousing data in a different data storage. Next, the storage address of each data storage and the amount range of each batch of warehousing data stored in each data storage are recorded in a preset data table. When the accounting amount corresponding to the warehousing data to be searched is received, the corresponding target data storage is found from the preset data table according to the accounting amount, and then the warehousing data to be searched is searched from the target data storage, thereby enabling the warehousing data to be searched to be quickly found from the data storage and improving the search efficiency. Attached Figure Description

[0049] To more clearly illustrate the technical solutions in the embodiments of this application, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of this application. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0050] Figure 1 This is a flowchart illustrating the data storage and retrieval method for accounting entries provided in this application embodiment.

[0051] Figure 2 This is a schematic diagram of the structure of the accounting data storage and retrieval device provided in the embodiments of this application.

[0052] Figure 3 This is another schematic diagram of the accounting data storage and retrieval device provided in the embodiments of this application.

[0053] Figure 4 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. Detailed Implementation

[0054] The technical solutions of the embodiments of this application will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only a part of the embodiments of this application, and not all of them. All other embodiments obtained by those skilled in the art based on the embodiments of this application without creative effort are within the protection scope of this application.

[0055] This application provides a method for storing and searching entry data, which is applied to an external system.

[0056] Please see Figure 1 , Figure 1This is a flowchart illustrating the accounting data storage and retrieval method provided in this application embodiment. The accounting data storage and retrieval method is applied in an electronic device and may include the following steps:

[0057] Step 101: Obtain the inbound data obtained by the external system after processing the inbound data in the business date month-year table. Among them, the inbound data in the same business date month-year table have the same business date.

[0058] There are multiple business date year-month tables, and each business date year-month table records multiple accounting entries. The accounting entries in the same business date year-month table have the same business date.

[0059] Among them, the business date is the date on which the core system processes transaction data for accounting purposes. The core system obtains the accounting data after processing the transaction data for accounting purposes.

[0060] Step 102: Obtain the amount of each inbound data and a plurality of preset amount ranges. Based on the amount of the inbound data and the preset amount ranges, divide the inbound data into batches to obtain at least one batch of first target inbound data.

[0061] Each data entry corresponds to an accounting amount, and those skilled in the art can set multiple preset amount ranges according to actual circumstances.

[0062] In some embodiments, obtaining the amount received for each piece of data received and obtaining multiple preset amount ranges, and batching the data received based on the amount received and the preset amount ranges to obtain at least one batch of first target data received, includes:

[0063] Obtain the amount credited to the database for each of the aforementioned data entries;

[0064] Multiple preset amount ranges are obtained, and the amount of each piece of data entering the database is matched with the preset amount ranges.

[0065] Data entries with the same preset amount range are considered as the same batch of first target data entries, resulting in at least one batch of first target data entries.

[0066] In some embodiments, the step of taking the inbound data with the same preset amount range as the same batch of first target inbound data to obtain at least one batch of first target inbound data includes:

[0067] Data entries with the same preset amount range are treated as the same batch of first target data entries, resulting in at least one batch of first target data entries before processing.

[0068] Obtain the third data volume of the first target data entering the database before each batch of processing, and obtain the first preset data volume.

[0069] The third data volume is compared with the first preset data volume. The first target data before processing with a third data volume greater than the first preset data volume is taken as the first target data before processing. Two batches of the first target data before processing with a second data volume less than or equal to the second preset data volume are merged into a batch of the first target data before processing to obtain at least one batch of the first target data before processing.

[0070] The first preset data size is greater than the second data size.

[0071] To ensure that the amount of the first target data to be stored is not too small (to avoid wasting data storage space), when the amounts of the two batches of the first target data to be stored are both less than the second preset data size, these two batches of the first target data to be stored are merged into one batch. The amount of the first target data to be stored after merging these two batches is greater than the first preset data size.

[0072] Step 103: Obtain the first data volume of each batch of the first target data entering the warehouse, and determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0073] Those skilled in the art can set a preset maximum data volume threshold according to the actual situation.

[0074] In some embodiments, obtaining the first data volume size of each batch of the first target inbound data, and determining whether there is second target inbound data that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, includes:

[0075] Obtain the first data volume of each batch of the first target data entering the warehouse, and obtain the preset maximum data volume threshold;

[0076] Compare the first data volume with the preset maximum data volume threshold;

[0077] If the size of the first data volume is greater than the preset maximum data volume threshold, it is determined that there is a second target data in the first target data that needs to be saved in batches.

[0078] In some embodiments, after obtaining the first data volume size of each batch of the first target inbound data, and determining whether there is second target inbound data that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, the method further includes:

[0079] If not, then each batch of the first target data and the second target data will be stored in different data storage databases.

[0080] Obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data or each batch of second target data stored in each data storage library in the preset data table.

[0081] Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

[0082] Step 104: If yes, then the second target data is divided into multiple batches of third target data according to the second data volume of the second target data, and the amount range corresponding to each batch of third target data is obtained. The data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0083] In order to ensure that the amount of data in each batch of first target data is not too large, so as to facilitate the search for a specific data, when the amount of data in a certain batch of first target data is found to be too large, the batch of first target data is divided into multiple batches of third target data, resulting in multiple batches of third target data and the corresponding amount range for each batch of third target data.

[0084] Step 105: Store each batch of the first target data, the second target data, and the third target data in different data storage databases.

[0085] Step 106: Obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data, second target data, or third target data stored in each data storage library in the preset data table.

[0086] Step 107: Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched from the preset data table, and search for the data to be searched from the target data storage.

[0087] In some embodiments, receiving the target amount of the data to be searched for, finding the corresponding target data storage based on the target amount from the preset data table, and searching for the data to be searched from the target data storage includes:

[0088] Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched.

[0089] Based on the target amount range, locate the corresponding target data storage database;

[0090] Search for the data to be searched in the target data storage.

[0091] In some embodiments, the preset data table further records the business dates of each batch of first target inbound data, each batch of second target inbound data, or each batch of third target inbound data stored in each data storage repository. The business dates of each batch of first target inbound data, each batch of second target inbound data, or each batch of third target inbound data stored in the same data storage repository are the same. The steps of receiving the target amount corresponding to the inbound data to be searched, finding the corresponding target data storage repository from the preset data table based on the target amount, and searching for the inbound data to be searched from the target data storage repository include:

[0092] Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched.

[0093] Based on the target amount range, at least one corresponding first data storage database is located;

[0094] Obtain the target business date corresponding to the data to be searched and entered into the database. Based on the target business date, obtain the target data storage database from the first data storage database that has the same business date as the target business date.

[0095] Search for the data to be searched in the target data storage.

[0096] The business date of the data entering the warehouse is the same as the business date of the accounting data.

[0097] All of the above-mentioned optional technical solutions can be combined in any way to form the optional embodiments of this application, and will not be described in detail here.

[0098] In practice, this application is not limited by the execution order of the described steps. Without causing conflicts, some steps may be performed in other orders or simultaneously.

[0099] As can be seen from the above, the accounting data storage and retrieval method provided in this application embodiment processes the accounting data in the business date and month table in the peripheral system to obtain the accounting data, obtains the accounting amount corresponding to each accounting data, divides the accounting data into batches according to the accounting amount, and then saves each batch of accounting data in different data storage databases; then, the storage address of each data storage database and the amount range of each batch of accounting data stored in each data storage database are recorded in a preset data table. When the accounting amount corresponding to the accounting data to be searched is received, the corresponding target data storage database is found from the preset data table according to the accounting amount, and then the accounting data to be searched is searched from the target data storage database, thereby enabling the accounting data to be searched to be quickly found from the data storage database and improving the search efficiency.

[0100] This application also provides an accounting data storage and retrieval device, which can be integrated into an electronic device.

[0101] Please see Figure 2 , Figure 2 This is a schematic diagram of the structure of the accounting data storage and retrieval device provided in an embodiment of this application. The accounting data storage and retrieval device 30 may include:

[0102] The acquisition module 31 is used to acquire the inbound data obtained by the external system after processing the inbound data in the business date month-year table, wherein the inbound data in the same business date month-year table have the same business date;

[0103] The first batching module 32 is used to obtain the amount of each inbound data and multiple preset amount ranges, and to batch the inbound data based on the amount of the inbound data and the preset amount ranges to obtain at least one batch of first target inbound data.

[0104] The judgment module 33 is used to obtain the first data volume of each batch of the first target data entering the warehouse, and to determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0105] The second batching module 34 is used to divide the second target data into multiple batches of third target data according to the second data volume of the second target data, and obtain the amount range corresponding to each batch of third target data, wherein the data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0106] Storage module 35 is used to store each batch of the first target data, the second target data, and the third target data in different data storage databases.

[0107] The recording module 36 is used to obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data, second target data, or third target data stored in each data storage library in the preset data table.

[0108] The lookup module 37 is used to receive the target amount of the data to be looked up, find the corresponding target data storage based on the target amount of the data to be looked up in the preset data table, and search for the data to be looked up in the target data storage.

[0109] In some embodiments, the first batching module 32 is used to obtain the amount of each inbound data; obtain multiple preset amount ranges, match the amount of each inbound data with the preset amount ranges; and take the inbound data with the same preset amount range as the same batch of first target inbound data to obtain at least one batch of first target inbound data.

[0110] In some embodiments, the first batching module 32 is used to take the incoming data with the same preset amount range as the same batch of first target incoming data to obtain at least one batch of first target incoming data before processing; obtain the third data size of each batch of first target incoming data before processing, and obtain the first preset data size; compare the third data size with the first preset data size, take the first target incoming data before processing with the third data size greater than the first preset data size as the first target incoming data, and merge two batches of first target incoming data before processing with the second data size less than or equal to the second preset data size into one batch of first target incoming data to obtain at least one batch of first target incoming data.

[0111] In some embodiments, the judgment module 33 is used to obtain the first data volume size of each batch of the first target data to be stored, and to obtain a preset maximum data volume threshold; compare the first data volume size with the preset maximum data volume threshold; if the first data volume size is greater than the preset maximum data volume threshold, it is determined that there is a second target data to be stored in the first target data to be stored that needs to be stored in batches.

[0112] In some embodiments, the search module 37 is configured to receive the target amount of the data to be searched for, find the corresponding target amount range from the preset data table based on the target amount, find the corresponding target data storage based on the target amount range, and search for the data to be searched in the target data storage.

[0113] In some embodiments, the search module 37 is configured to receive a target amount corresponding to the data to be searched for, search for a corresponding target amount range from the preset data table based on the target amount; search for at least one corresponding first data storage based on the target amount range; obtain a target business date corresponding to the data to be searched for, and obtain a target data storage with the same business date as the target business date from the first data storage based on the target business date; and search for the data to be searched from the target data storage.

[0114] In practice, the above modules can be implemented as independent entities or combined in any way to be implemented as the same or several entities.

[0115] As can be seen from the above, the accounting data storage and retrieval device 30 provided in this application embodiment obtains the accounting data obtained by the peripheral system after processing the accounting data in the business date month-year table through the acquisition module 31, wherein the accounting data in the same business date month-year table have the same business date; the first batching module 32 obtains the accounting amount corresponding to each batch of accounting data and obtains multiple preset amount ranges, and batches the accounting data based on the accounting amount and the preset amount ranges to obtain at least one batch of first target accounting data; the judgment module 33 obtains the first data volume size of each batch of the first target accounting data, and judges whether there is a second target accounting data that needs to be saved in batches in the first target accounting data according to the first data volume size and the preset maximum data volume threshold; if so, the second batching module 34 divides the first batch of accounting data into batches according to the second data volume size of the second target accounting data. The two target data entries are divided into multiple batches of third target data entries, resulting in an amount range for each batch of third target data entries. The amount of data in each batch of third target data entries does not exceed the preset maximum data volume threshold. Storage module 35 stores each batch of the first, second, and third target data entries in different data storage repositories. Recording module 36 obtains a preset data table, recording the storage address of each data repository and the amount range for each batch of the first, second, or third target data entries stored in each data repository. Search module 37 receives the target amount corresponding to the data to be searched, finds the corresponding target data repository from the preset data table based on the target amount, and then searches for the data to be searched in the target data repository.

[0116] Please see Figure 3 , Figure 3This is another schematic diagram of the accounting data storage and retrieval device provided in this application embodiment. The accounting data storage and retrieval device 30 includes a memory 120, one or more processors 180, and one or more application programs, wherein the one or more application programs are stored in the memory 120 and configured to be executed by the processors 180. The processors 180 may include an acquisition module 31, a first batching module 32, a judgment module 33, a second batching module 34, a storage module 35, a recording module 36, and a retrieval module 37. For example, the structure and connection relationship of the above components can be as follows:

[0117] Memory 120 can be used to store applications and data. The applications stored in memory 120 contain executable code. Applications can be composed of various functional modules. Processor 180 executes various functional applications and data processing by running the applications stored in memory 120. Furthermore, memory 120 may include high-speed random access memory and may also include non-volatile memory, such as at least one disk storage device, flash memory device, or other volatile solid-state storage device. Accordingly, memory 120 may also include a memory controller to provide processor 180 with access to memory 120.

[0118] The processor 180 is the control center of the device, connecting various parts of the terminal through various interfaces and lines. It performs various functions and processes data by running or executing applications stored in the memory 120 and calling data stored in the memory 120, thereby providing overall monitoring of the device. Optionally, the processor 180 may include one or more processing cores; preferably, the processor 180 may integrate an application processor and a modem processor, wherein the application processor mainly handles the operating system, user interface, and applications.

[0119] Specifically, in this embodiment, the processor 180 loads the executable code corresponding to the processes of one or more applications into the memory 120 according to the following instructions, and the processor 180 runs the applications stored in the memory 120 to achieve various functions:

[0120] The acquisition module 31 is used to acquire the inbound data obtained by the external system after processing the inbound data in the business date month-year table, wherein the inbound data in the same business date month-year table have the same business date;

[0121] The first batching module 32 is used to obtain the amount of each inbound data and multiple preset amount ranges, and to batch the inbound data based on the amount of the inbound data and the preset amount ranges to obtain at least one batch of first target inbound data.

[0122] The judgment module 33 is used to obtain the first data volume of each batch of the first target data entering the warehouse, and to determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0123] The second batching module 34 is used to divide the second target data into multiple batches of third target data according to the second data volume of the second target data, and obtain the amount range corresponding to each batch of third target data, wherein the data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0124] Storage module 35 is used to store each batch of the first target data, the second target data, and the third target data in different data storage databases.

[0125] The recording module 36 is used to obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data, second target data, or third target data stored in each data storage library in the preset data table.

[0126] The lookup module 37 is used to receive the target amount of the data to be looked up, find the corresponding target data storage based on the target amount of the data to be looked up in the preset data table, and search for the data to be looked up in the target data storage.

[0127] This application also provides an electronic device. Please refer to [link / reference]. Figure 4 , Figure 4 A schematic diagram of the structure of an electronic device provided in an embodiment of this application is shown. This electronic device can be used to implement the accounting data storage and retrieval method provided in the above embodiments.

[0128] like Figure 4 As shown, the electronic device 1200 may include an RF (Radio Frequency) circuit 110, a memory 120 including one or more (only one is shown in the figure) computer-readable storage media, an input unit 130, a display unit 140, a sensor 150, an audio circuit 160, a transmission module 170, a processor 180 including one or more (only one is shown in the figure) processing cores, and a power supply 190, etc. Those skilled in the art will understand that... Figure 4 The structure of the electronic device 1200 shown does not constitute a limitation on the electronic device 1200, and may include more or fewer components than shown, or combine certain components, or have different component arrangements. Wherein:

[0129] RF circuit 110 is used to receive and transmit electromagnetic waves, realizing the mutual conversion between electromagnetic waves and electrical signals, thereby enabling communication with communication networks or other devices. RF circuit 110 may include various existing circuit elements used to perform these functions, such as antennas, radio frequency transceivers, digital signal processors, encryption / decryption chips, Subscriber Identity Module (SIM) cards, memory, etc. RF circuit 110 can communicate with various networks such as the Internet, corporate intranets, and wireless networks, or communicate with other devices via wireless networks.

[0130] The memory 120 can be used to store software programs and modules, such as the program instructions / modules corresponding to the data entry data retrieval method in the above embodiment. The processor 180 executes various functional applications and data processing by running the software programs and modules stored in the memory 120, enabling it to quickly retrieve the data to be retrieved from the data storage database, thus improving retrieval efficiency. The memory 120 may include high-speed random access memory (RAM) and non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memories. In some instances, the memory 120 may further include memory remotely located relative to the processor 180, which can be connected to the electronic device 1200 via a network. Examples of such networks include, but are not limited to, the Internet, corporate intranets, local area networks (LANs), mobile communication networks, and combinations thereof.

[0131] The input unit 130 can be used to receive input digital or character information, and to generate keyboard, mouse, joystick, optical, or trackball signal inputs related to user settings and function control. Specifically, the input unit 130 may include a touch-sensitive surface 131 and other input devices 132. The touch-sensitive surface 131, also known as a touch display screen or touchpad, can collect touch operations performed by the user on or near it (such as operations performed by the user using a finger, stylus, or any suitable object or accessory on or near the touch-sensitive surface 131), and drive the corresponding connection device according to a pre-set program. Optionally, the touch-sensitive surface 131 may include two parts: a touch detection device and a touch controller. The touch detection device detects the user's touch position and the signal generated by the touch operation, and transmits the signal to the touch controller; the touch controller receives touch information from the touch detection device, converts it into touch point coordinates, sends it to the processor 180, and can receive and execute commands from the processor 180. In addition, the touch-sensitive surface 131 can be implemented using various types such as resistive, capacitive, infrared, and surface acoustic wave. In addition to the touch-sensitive surface 131, the input unit 130 may also include other input devices 132. Specifically, other input devices 132 may include, but are not limited to, one or more of the following: physical keyboard, function keys (such as volume control buttons, power buttons, etc.), trackball, mouse, joystick, etc.

[0132] Display unit 140 can be used to display information input by the user or information provided to the user, as well as various graphical user interfaces of electronic device 1200. These graphical user interfaces can be composed of graphics, text, icons, video, and any combination thereof. Display unit 140 may include display panel 141, optionally configured as LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), etc. Further, touch-sensitive surface 131 may cover display panel 141. When touch-sensitive surface 131 detects a touch operation on or near it, it transmits the information to processor 180 to determine the type of touch event. Subsequently, processor 180 provides corresponding visual output on display panel 141 according to the type of touch event. Although in Figure 4 In this embodiment, the touch-sensitive surface 131 and the display panel 141 are implemented as two separate components to realize input and output functions. However, in some embodiments, the touch-sensitive surface 131 and the display panel 141 can be integrated to realize input and output functions.

[0133] The electronic device 1200 may also include at least one sensor 150, such as a light sensor, a motion sensor, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor. The ambient light sensor can adjust the brightness of the display panel 141 according to the ambient light level, and the proximity sensor can turn off the display panel 141 and / or backlight when the electronic device 1200 is moved to the ear. As a type of motion sensor, a gravity acceleration sensor can detect the magnitude of acceleration in various directions (generally three axes). When stationary, it can detect the magnitude and direction of gravity and can be used for applications that recognize the phone's posture (such as landscape / portrait switching, related games, magnetometer posture calibration), vibration recognition related functions (such as pedometer, tapping), etc. Other sensors that may be configured in the electronic device 1200, such as gyroscopes, barometers, hygrometers, thermometers, and infrared sensors, will not be described in detail here.

[0134] Audio circuitry 160, speaker 161, and microphone 162 provide an audio interface between the user and electronic device 1200. Audio circuitry 160 converts received audio data into electrical signals, which are then transmitted to speaker 161, where they are converted into sound signals for output. Conversely, microphone 162 converts collected sound signals into electrical signals, which are received by audio circuitry 160, converted back into audio data, and then processed by processor 180 before being transmitted via RF circuitry 110 to, for example, another terminal, or output to memory 120 for further processing. Audio circuitry 160 may also include an earphone jack to facilitate communication between external headphones and electronic device 1200.

[0135] Electronic device 1200, through transmission module 170 (e.g., Wi-Fi module), enables users to send and receive emails, browse web pages, and access streaming media, providing users with wireless broadband internet access. Although Figure 4 The transmission module 170 is shown, but it is understood that it is not an essential component of the electronic device 1200 and can be omitted as needed without changing the nature of the invention.

[0136] The processor 180 is the control center of the electronic device 1200. It connects to various parts of the phone via various interfaces and lines, and performs various functions and processes data of the electronic device 1200 by running or executing software programs and / or modules stored in the memory 120, and by calling data stored in the memory 120. Optionally, the processor 180 may include one or more processing cores; in some embodiments, the processor 180 may integrate an application processor and a modem processor, wherein the application processor mainly handles the operating system, user interface, and applications, and the modem processor mainly handles wireless communication. It is understood that the modem processor may also not be integrated into the processor 180.

[0137] The electronic device 1200 also includes a power supply 190 (such as a battery) that supplies power to various components. In some embodiments, the power supply may be logically connected to the processor 180 through a power management system, thereby enabling functions such as charging, discharging, and power consumption management through the power management system. The power supply 190 may also include one or more DC or AC power supplies, recharging systems, power fault detection circuits, power converters or inverters, power status indicators, and other arbitrary components.

[0138] Although not shown, the electronic device 1200 may also include a camera (such as a front-facing camera and a rear-facing camera), a Bluetooth module, etc., which will not be described in detail here. Specifically, in this embodiment, the display unit 140 of the electronic device 1200 is a touch screen display, and the electronic device 1200 also includes a memory 120 and one or more programs, one or more of which are stored in the memory 120 and configured to be executed by one or more processors 180. One or more programs contain instructions for performing the following operations:

[0139] Obtain the inbound data obtained by the external system after processing the inbound data in the business date month-year table, where the inbound data in the same business date month-year table have the same business date;

[0140] Obtain the amount of each inbound data and multiple preset amount ranges. Divide the inbound data into batches based on the amount of each inbound data and the preset amount ranges to obtain at least one batch of first target inbound data.

[0141] Obtain the first data volume of each batch of the first target data entering the warehouse, and determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold.

[0142] If so, the second target data is divided into multiple batches of third target data based on the second data volume of the second target data, and the amount range corresponding to each batch of third target data is obtained. The data volume of each batch of third target data does not exceed the preset maximum data volume threshold.

[0143] Each batch of the first target data, the second target data, and the third target data is stored in a different data storage database.

[0144] Obtain a preset data table and record the storage address of each data storage library, as well as the amount range of each batch of first target data, second target data, or third target data stored in each data storage library, in the preset data table.

[0145] Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

[0146] In some embodiments, the processor 180 is configured to obtain the amount of each inbound data corresponding to the inbound data; obtain multiple preset amount ranges, match the amount of each inbound data corresponding to the inbound data with the preset amount ranges; and take the inbound data with the same amount range as the same batch of first target inbound data to obtain at least one batch of first target inbound data.

[0147] In some embodiments, the processor 180 is configured to treat incoming data with the same preset amount range as the same batch of first target incoming data, to obtain at least one batch of first target incoming data before processing; obtain the third data size of each batch of first target incoming data before processing, and obtain the first preset data size; compare the third data size with the first preset data size, and treat the first target incoming data before processing with the third data size greater than the first preset data size as the first target incoming data, and merge two batches of first target incoming data before processing with the second data size less than or equal to the second preset data size into one batch of first target incoming data, to obtain at least one batch of first target incoming data.

[0148] In some embodiments, the processor 180 is configured to receive a target amount corresponding to the data to be searched for, find a corresponding target amount range from the preset data table based on the target amount, find a corresponding target data storage based on the target amount range, and search for the data to be searched from the target data storage.

[0149] In some embodiments, the processor 180 is configured to receive a target amount corresponding to the data to be searched for in the database, find a corresponding target amount range from the preset data table based on the target amount; find at least one corresponding first data storage database according to the target amount range; obtain a target business date corresponding to the data to be searched for in the database, and obtain a target data storage database from the first data storage database with the same business date as the target business date based on the target business date; and search for the data to be searched for in the database from the target data storage database.

[0150] In some embodiments, the processor 180 is configured to obtain the first data volume size of each batch of the first target data to be stored, and to obtain a preset maximum data volume threshold; compare the first data volume size with the preset maximum data volume threshold; if the first data volume size is greater than the preset maximum data volume threshold, it is determined that there is a second target data to be stored in the first target data to be stored that needs to be stored in batches.

[0151] In some embodiments, the processor 180 is configured to, if not, store each batch of the first target inbound data and the second target inbound data in different data storage databases; obtain a preset data table, and record the storage address of each data storage database and the amount range of each batch of the first target inbound data or each batch of the second target inbound data stored in each data storage database in the preset data table; receive the target amount of the inbound data to be searched, find the corresponding target data storage database from the preset data table based on the target amount of the inbound data, and search for the inbound data to be searched from the target data storage database.

[0152] As can be seen from the above, this application embodiment provides an electronic device 1200, which performs the following steps: obtaining the inbound data obtained by the peripheral system after processing the inbound data in the business date month-year table, wherein the business dates of the inbound data in the same business date month-year table are the same; obtaining the inbound amount corresponding to each inbound data, and obtaining multiple preset amount ranges, and dividing the inbound data into batches based on the inbound amount and the preset amount ranges to obtain at least one batch of first target inbound data; obtaining the first data volume size of each batch of the first target inbound data, and determining whether there is second target inbound data that needs to be saved in batches in the first target inbound data according to the first data volume size and the preset maximum data volume threshold; if so, then dividing the inbound data into batches according to the second data volume size of the second target inbound data. The second target data is divided into multiple batches of third target data, and the amount range corresponding to each batch of third target data is obtained. The amount of data in each batch of third target data does not exceed the preset maximum data volume threshold. Each batch of first target data, second target data, and third target data is stored in different data storage databases. A preset data table is obtained, and the storage address of each data storage database and the amount range of each batch of first target data, second target data, or third target data stored in each data storage database are recorded in the preset data table. The target amount of the data to be searched is received, and the corresponding target data storage database is found from the preset data table based on the target amount of the data to be searched. The data to be searched is then searched from the target data storage database.

[0153] This application also provides a storage medium storing a computer program. When the computer program is run on a computer, the computer executes the accounting data storage and retrieval method described in any of the above embodiments.

[0154] It should be noted that, regarding the accounting data storage and retrieval method described in this application, those skilled in the art will understand that implementing all or part of the process of the accounting data storage and retrieval method described in the embodiments of this application can be accomplished by a computer program controlling related hardware. The computer program can be stored in a computer-readable storage medium, such as in the memory of an electronic device, and executed by at least one processor within the electronic device. During execution, it can include the process of the embodiments of the accounting data storage and retrieval method described. The storage medium can be a magnetic disk, optical disk, read-only memory (ROM), random access memory (RAM), etc.

[0155] For the accounting data storage and retrieval device described in this application embodiment, its functional modules can be integrated into a single processing chip, or each module can exist physically separately, or two or more modules can be integrated into one module. The integrated module can be implemented in hardware or as a software functional module. If the integrated module is implemented as a software functional module and sold or used as an independent product, it can also be stored in a computer-readable storage medium, such as a read-only memory, a disk, or an optical disk.

[0156] The foregoing has provided a detailed description of the data storage and retrieval method, apparatus, storage medium, and electronic device for accounting data provided in the embodiments of this application. Specific examples have been used to illustrate the principles and implementation methods of this application. The descriptions of the embodiments above are merely for the purpose of helping to understand the methods and core ideas of this application. Furthermore, those skilled in the art will recognize that, based on the ideas of this application, there will be changes in the specific implementation methods and application scope. Therefore, the content of this specification should not be construed as a limitation of this application.

Claims

1. A method for storing and retrieving accounting data, characterized in that, The method includes: Obtain the inbound data obtained by the external system after processing the inbound data in the business date month-year table, where the inbound data in the same business date month-year table have the same business date; Obtain the amount of each inbound data and multiple preset amount ranges. Divide the inbound data into batches based on the amount of each inbound data and the preset amount ranges to obtain at least one batch of first target inbound data. Obtain the first data volume of each batch of the first target data entering the warehouse, and determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold. If so, the second target data is divided into multiple batches of third target data based on the second data volume of the second target data, and the amount range corresponding to each batch of third target data is obtained. The data volume of each batch of third target data does not exceed the preset maximum data volume threshold. Each batch of the first target data, the second target data, and the third target data is stored in a different data storage database. Obtain a preset data table and record the storage address of each data storage library, as well as the amount range of each batch of first target data, second target data, or third target data stored in each data storage library, in the preset data table. Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

2. The data storage and retrieval method for accounting entries as described in claim 1, characterized in that, The process involves obtaining the amount received for each piece of data and multiple preset amount ranges, then batching the data based on the received amount and the preset amount ranges to obtain at least one batch of first target data, including: Obtain the amount credited to the database for each of the aforementioned data entries; Multiple preset amount ranges are obtained, and the amount of each piece of data entering the database is matched with the preset amount ranges. Data entries with the same preset amount range are considered as the same batch of first target data entries, resulting in at least one batch of first target data entries.

3. The data storage and retrieval method for accounting entries as described in claim 2, characterized in that, The step of classifying incoming data with the same preset amount range as the same batch of first target incoming data to obtain at least one batch of first target incoming data includes: Data entries with the same preset amount range are treated as the same batch of first target data entries, resulting in at least one batch of first target data entries before processing. Obtain the third data volume of the first target data entering the database before each batch of processing, and obtain the first preset data volume. The third data volume is compared with the first preset data volume. The first target data before processing with a third data volume greater than the first preset data volume is taken as the first target data before processing. Two batches of the first target data before processing with a second data volume less than or equal to the second preset data volume are merged into a batch of the first target data before processing to obtain at least one batch of the first target data before processing.

4. The data storage and retrieval method for accounting entries as described in claim 1, characterized in that, The process of receiving the target amount corresponding to the data to be searched for, finding the corresponding target data storage based on the target amount from the preset data table, and searching for the data to be searched from the target data storage includes: Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched. Based on the target amount range, locate the corresponding target data storage database; Search for the data to be searched in the target data storage.

5. The data storage and retrieval method for accounting entries as described in claim 1, characterized in that, The preset data table also records the business dates of each batch of first target inbound data, second target inbound data, or third target inbound data stored in each data storage repository. The business dates of each batch of first target inbound data, second target inbound data, or third target inbound data stored in the same data storage repository are the same. The process of receiving the target amount corresponding to the inbound data to be searched, finding the corresponding target data storage repository based on the target amount, and searching for the inbound data to be searched in the target data storage repository includes: Receive the target amount of the data to be searched for, and find the corresponding target amount range from the preset data table based on the target amount of the data to be searched. Based on the target amount range, at least one corresponding first data storage database is located; Obtain the target business date corresponding to the data to be searched and entered into the database. Based on the target business date, obtain the target data storage database from the first data storage database that has the same business date as the target business date. Search for the data to be searched in the target data storage.

6. The data storage and retrieval method for accounting entries as described in claim 1, characterized in that, The step of obtaining the first data volume size of each batch of the first target data entering the warehouse, and determining whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, includes: Obtain the first data volume of each batch of the first target data entering the warehouse, and obtain the preset maximum data volume threshold; Compare the first data volume with the preset maximum data volume threshold; If the size of the first data volume is greater than the preset maximum data volume threshold, it is determined that there is a second target data in the first target data that needs to be saved in batches.

7. The data storage and retrieval method for accounting entries as described in claim 1, characterized in that, After obtaining the first data volume size of each batch of the first target inbound data, and determining whether there is second target inbound data that needs to be saved in batches based on the first data volume size and a preset maximum data volume threshold, the method further includes: If not, then each batch of the first target data and the second target data will be stored in different data storage databases. Obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data or each batch of second target data stored in each data storage library in the preset data table. Receive the target amount of the data to be searched for, find the corresponding target data storage based on the target amount of the data to be searched for, and search for the data to be searched for in the target data storage.

8. A device for storing and retrieving accounting data, characterized in that, The device includes: The acquisition module is used to acquire the data that the external system obtains after processing the accounting data in the business date month-year table. The accounting data in the same business date month-year table have the same business date. The first batching module is used to obtain the amount of each inbound data and multiple preset amount ranges, and to batch the inbound data based on the amount of the inbound data and the preset amount ranges to obtain at least one batch of first target inbound data. The judgment module is used to obtain the first data volume of each batch of the first target data entering the warehouse, and to determine whether there is second target data entering the warehouse that needs to be saved in batches based on the first data volume and the preset maximum data volume threshold. The second batching module is used to divide the second target data into multiple batches of third target data according to the second data volume of the second target data, and obtain the amount range corresponding to each batch of third target data, wherein the data volume of each batch of third target data does not exceed the preset maximum data volume threshold. The storage module is used to store each batch of the first target data, the second target data, and the third target data in different data storage databases. The recording module is used to obtain a preset data table and record the storage address of each data storage library and the amount range of each batch of first target data, second target data, or third target data stored in each data storage library in the preset data table. The search module is used to receive the target amount of the data to be searched, find the corresponding target data storage based on the target amount of the data to be searched, and search for the data to be searched in the target data storage.

9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program that, when run on a computer, causes the computer to perform the accounting data storage and retrieval method according to any one of claims 1 to 7.

10. An electronic device, characterized in that, The electronic device includes a processor and a memory, the memory storing a computer program, and the processor executes the accounting data storage and retrieval method according to any one of claims 1 to 7 by calling the computer program stored in the memory.

Images