Data processing methods, apparatus, equipment and storage media
By using grid data tables and view information technology in financial business scenarios, data from target business scenarios can be quickly matched and output, solving the problem of low data query efficiency and achieving efficient data sharing and feedback.
Patent Information
- Application Number
- CN202410294213.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-03-14
- Publication Date
- 2026-11-10
- Estimated Expiration
- 2044-03-14
AI Technical Summary
In existing technologies, data query efficiency is low in financial business scenarios, making it difficult to provide timely feedback of relevant data and affecting business processing efficiency.
By acquiring grid data tables, key fields or time periods for multiple preset business scenarios are identified, and second view information is generated based on this information. The view information of the corresponding preset business scenario is matched according to the request of the target business scenario, thereby quickly acquiring and outputting relevant data.
It improved data query efficiency, enhanced data sharing efficiency in financial business scenarios, and ensured the timely feedback of relevant data.
Smart Images

Figure CN118152625B_ABST
Abstract
Description
Technical Field
[0001] This application relates to the field of data management technology, and in particular to a data processing method, apparatus, device and storage medium. Background Technology
[0002] In the financial industry, various business systems generate data in real time when processing transactions and record it in the business database, making it convenient for various financial departments to obtain relevant data for different business scenarios.
[0003] Existing technologies rely on querying or retrieving data corresponding to relevant fields in a business database that stores large amounts of data, based on the needs of financial business scenarios. This reduces the efficiency of determining relevant data and makes it difficult to provide timely feedback on the data required for relevant financial business scenarios, thereby affecting the processing of relevant financial transactions. Summary of the Invention
[0004] This application provides a data processing method, apparatus, device, and storage medium to solve the problem that the time spent determining relevant data in the prior art leads to reduced data sharing efficiency.
[0005] In a first aspect, this application provides a data processing method, comprising: acquiring a grid data table, the grid data table being used to record data corresponding to multiple field sets under multiple dates; the grid data table including multiple grid data, each grid data corresponding to a date and a field set; determining multiple preset business scenarios and key fields or time periods corresponding to each preset business scenario, the key fields being at least one field in the multiple field sets; determining second view information corresponding to each preset business scenario based on the time period or key field of each preset business scenario; the second view information being used to indicate the first view information corresponding to each date within the time period or the first view information corresponding to each field in the field set to which the key field belongs; wherein, the first view information corresponding to each date is used to indicate the grid data corresponding to all field sets under the date, and the first view information corresponding to each field set is used to indicate the grid data corresponding to the fields within all dates; receiving a data sharing request for a target business scenario, determining the second view information of a preset business scenario matching the target business scenario based on the target key field and / or target time period corresponding to the target business scenario; determining and outputting the grid data corresponding to the target business scenario based on the second view information corresponding to the matching preset business scenario.
[0006] In one possible design, the method further includes: determining multiple initial fields, and determining multiple sets of fields based on the relationships between the multiple initial fields; wherein each set of fields includes: at least two fields that have a relationship, or a field that has no relationship with any of the other fields in the multiple initial fields.
[0007] In one possible design, the method further includes: every preset period, obtaining multiple data to be added within the preset period, the data to be added including data corresponding to each field in multiple field sets under each date within the preset period;
[0008] Based on the date and field set corresponding to multiple data to be added, add the corresponding grid data to the grid data table, and update the added grid data to obtain the updated grid data table.
[0009] In one possible design, the second view information of a preset business scenario that matches the target business scenario is determined based on the target key fields and / or target time period corresponding to the target business scenario. This includes: determining whether the target time period and target key fields exist in the data sharing request of the target business scenario; if only the target time period exists, then the second view information is determined to be the second view information of the preset business scenario that matches the target time period.
[0010] If a target time period and target key fields exist, the second view information is determined to be the second view information of a preset business scenario that matches the target time period;
[0011] If only the target key field exists, then the second view information is determined to be the second view information of the preset business scenario that matches the target key field.
[0012] In one possible design, if there is a target time period and a target key field, and the time period corresponding to the preset business scenario exceeds the target time period, the grid data corresponding to the target business scenario is determined and output based on the second view information corresponding to the preset business scenario. This includes: determining a portion of the dates in the second view information of the preset business scenario that correspond to each date within the target time period; determining the second view information corresponding to the target business scenario, which includes the first view information corresponding to each date within the portion of dates; and determining and outputting the corresponding grid data based on the second view information corresponding to the target business scenario.
[0013] In one possible design, the corresponding grid data is determined and output based on the second view information corresponding to the target business scenario, including: determining the grid data corresponding to all fields within a certain date range indicated by the second view information corresponding to the target business scenario; determining the partial fields corresponding to each field in the target key fields from all fields within the partial date range; and determining the output grid data, which includes the grid data corresponding to the partial fields within the partial date range.
[0014] In one possible design, if only a target time period exists and the target time period is the latest date, the matching preset business scenario is: a preset business scenario whose corresponding time period is the most recent preset duration; the latest date is used to indicate the date closest to the current time and for which corresponding data exists in the grid data table; accordingly, based on the second view information corresponding to the preset business scenario, the grid data corresponding to the target business scenario is determined and output, including: determining a sampling area based on the grid data of multiple dates contained in the second view information of the matching preset business scenario, the sampling area including grid data of some dates among the multiple dates; determining the latest date in the sampling area, and determining whether there is at least one grid data date in the non-sampling area that is earlier than the latest date in the sampling area; if not, the grid data corresponding to the target business scenario is output, the grid data corresponding to the target business scenario includes the grid data corresponding to all fields within the latest date in the sampling area.
[0015] In one possible design, the method further includes: if the date of at least one grid data in the non-sampling area is earlier than the latest date in the sampling area, then determine the updated latest date, which is the latest date among the dates of at least one grid data; output the grid data corresponding to the target business scenario, which includes the grid data corresponding to all fields within the updated latest date.
[0016] Secondly, this application provides a data processing apparatus, comprising: an acquisition module for acquiring a grid data table, the grid data table recording data corresponding to multiple field sets under multiple dates; the grid data table including multiple grid data, each grid data corresponding to a date and a field set; a processing module for determining multiple preset business scenarios and key fields or time periods corresponding to each preset business scenario, the key fields being at least one field in the multiple field sets; the processing module for determining second view information corresponding to each preset business scenario based on the time period or key field of each preset business scenario; the second view information indicating the first view information corresponding to each date within the time period or the first view information corresponding to each field in the field set to which the key field belongs; wherein, the first view information corresponding to each date indicates the grid data corresponding to all field sets under the date, and the first view information corresponding to each field set indicates the grid data corresponding to the fields within all dates; a receiving module for receiving a data sharing request for a target business scenario, determining the second view information of a preset business scenario matching the target business scenario based on the target key field and / or target time period corresponding to the target business scenario; and the processing module for determining and outputting the grid data corresponding to the target business scenario based on the second view information corresponding to the matching preset business scenario.
[0017] Thirdly, embodiments of this application provide an electronic device, including: at least one processor and a memory; the memory stores computer-executable instructions; the at least one processor executes the computer-executable instructions stored in the memory, causing the at least one processor to perform the data processing method as described in the first aspect and various possible designs of the first aspect.
[0018] Fourthly, embodiments of this application provide a computer-readable storage medium storing computer-executable instructions. When a processor executes the computer-executable instructions, it implements the data processing method described in the first aspect and various possible designs of the first aspect.
[0019] Fifthly, embodiments of this application provide a computer program product, including a computer program, which, when executed by a processor, implements the data processing method described in the first aspect and various possible designs of the first aspect.
[0020] The data processing method, apparatus, device, and storage medium provided in this application acquire grid data corresponding to each field set under each date in a grid data table, determine key fields or time periods corresponding to multiple preset business scenarios based on the grid data, and determine the second view information of the preset business scenario based on the time period or key fields corresponding to the preset business scenario. When receiving and acquiring the target key fields and / or target time periods of a target business scenario, the second view information of the preset business scenario matching the target business scenario is determined. Then, based on the second view information of the matching preset business scenario, the first view information corresponding to each field set within the target key fields and / or each date within the target time period corresponding to the target business scenario is determined. The grid data corresponding to the target business scenario is determined and output using the first view information. Therefore, it is possible to query the data required by complex business scenarios and improve the data query efficiency for different business scenarios. Attached Figure Description
[0021] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with this application and, together with the description, serve to explain the principles of this application.
[0022] Figure 1 A diagram illustrating application scenarios for data processing using existing technologies;
[0023] Figure 2 This is an application scenario diagram of the data processing method applicable to the embodiments of this application;
[0024] Figure 3 A flowchart illustrating the data processing method provided in the embodiments of this application;
[0025] Figure 4(a) is an example diagram of the data processing method provided in the embodiments of this application;
[0026] Figure 4(b) is another example diagram of the data processing method provided in the embodiments of this application;
[0027] Figure 5 A flowchart illustrating a data processing method for determining a matching preset business scenario, provided in an embodiment of this application;
[0028] Figure 6 A flowchart illustrating the data processing method for a target time period and target key fields provided in this application embodiment;
[0029] Figure 7 This is a schematic diagram of the structure of the data processing apparatus provided in the embodiments of this application;
[0030] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application.
[0031] The accompanying drawings illustrate specific embodiments of this application, which will be described in more detail below. These drawings and descriptions are not intended to limit the scope of the concept in any way, but rather to illustrate the concepts of this application to those skilled in the art through reference to particular embodiments. Detailed Implementation
[0032] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numbers in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with some aspects of this application as detailed in the appended claims.
[0033] Terminology Explanation:
[0034] A view is a virtual table that includes row and column data.
[0035] Figure 1 This is a diagram illustrating application scenarios for data processing using existing technologies. For example... Figure 1 As shown, this application scenario includes: multiple business systems, databases, processing systems, and multiple business scenarios.
[0036] In existing technologies, multiple business systems record real-time data into a database when processing business transactions. When multiple business systems stop processing business transactions, the data generated on the current date is imported into the processing system. The processing system then processes the imported data on the next date and generates a globally used key table, which can be used in multiple financial business scenarios.
[0037] Due to the complexity of financial business scenarios, each financial business scenario requires a significant amount of time to retrieve data related to each field from key tables based on multiple dimensions, which reduces the efficiency of data querying and data processing for various financial business scenarios.
[0038] For example, when the fields in the financial business scenarios of three departments all include card numbers, the existing technology selects the data corresponding to the field from the database based on the card number and establishes data marts for the three financial business scenarios of the three departments respectively, generating data marts for the first financial business scenario, the second financial business scenario, and the third financial business scenario. The data mart for the first financial business scenario includes data corresponding to card numbers, the data mart for the second financial business scenario includes data corresponding to card numbers, and the data mart for the third financial business scenario includes data corresponding to card numbers. That is, there are multiple copies of data for the same field, which occupies storage space. When updating the data corresponding to the card number field for the current date, it is necessary to update the copies of the data corresponding to each field in turn, resulting in untimely updates and reduced data processing efficiency.
[0039] To address the aforementioned technical issues, this application proposes the following technical concept: Multiple data sets to be added are acquired at preset intervals. Based on the dates and field sets corresponding to these multiple data sets, grid data in the grid data table is added and updated. Based on the updated grid data table, first-view information corresponding to each date and each field set is determined. Multiple key fields or time periods for preset business scenarios are identified. Second-view information corresponding to the preset business scenario is determined based on the first-view information corresponding to the field sets within the key fields of each preset business scenario or the first-view information corresponding to each date within the time period. Second-view information matching the field sets and / or dates of the determined target business scenario is determined based on the target key fields and / or time periods. Grid data corresponding to the target business scenario is determined and output based on the first-view information corresponding to each date or field set in the second-view information. In this way, by selecting matching preset business scenarios based on target key fields or target time periods, and acquiring data based on the first-view information corresponding to each field set and date within the preset business scenario, data sharing in complex financial business scenarios is achieved while improving the efficiency of data acquisition and sharing.
[0040] The technical solution of this application and how the technical solution of this application solves the above-mentioned technical problems are described in detail below with specific embodiments. These specific embodiments can be combined with each other, and the same or similar concepts or processes may not be described again in some embodiments. The embodiments of this application will now be described with reference to the accompanying drawings.
[0041] Figure 2 This is an application scenario diagram illustrating the data processing method applicable to embodiments of this application. For example... Figure 2 As shown, this application scenario includes: multiple business systems, databases, processing systems, and multiple target business scenarios, where the database includes view information.
[0042] Multiple business systems are used to transmit the generated data to the database to generate new data. The processing system is used to process the new data on the next date to obtain view information.
[0043] When a sharing instruction for a target business scenario is obtained, the target key fields and / or target time period of the target business scenario are determined, and the matching view information is determined based on the target key fields and / or target time period. The data obtained using the view information is further processed to obtain the data indicated by the sharing instruction for the target business scenario, and the data is shared to the corresponding target business scenario.
[0044] based on Figure 2 As shown in the application scenario, this application provides a data processing method. Figure 3 Flowchart of the data processing method provided in the embodiments of this application Figure 1 .like Figure 3 As shown, the data processing method includes:
[0045] S301. Obtain the grid data table.
[0046] More specifically, the entity executing the method in this embodiment may be... Figure 2 The processing system shown herein acquires a grid data table, which records data corresponding to multiple field sets for multiple dates. The grid data table comprises multiple grid data sets, each corresponding to a date and a field set, and each grid data set records data for the corresponding field set for the corresponding date.
[0047] In one possible embodiment, each row in the grid data table corresponds to grid data of all fields for a given date, and each column corresponds to grid data of all fields for all dates.
[0048] Optionally, at each preset period, multiple data to be added within the preset period are obtained. When the preset period is a date, the data to be added includes the data corresponding to each field in multiple field sets under a date within the preset period.
[0049] In one possible embodiment, when the preset period is multiple dates, the data to be added includes the data corresponding to each field in multiple field sets under each date within the preset period.
[0050] Optionally, based on the date and field set corresponding to multiple data to be added, corresponding grid data is added to the grid data table, and the added grid data is updated to obtain the updated grid data table.
[0051] In one possible embodiment, based on the dates and field sets corresponding to multiple data to be added, multiple grid data points for the corresponding dates are added to the grid data table. Each grid data point is located in one grid of the grid data table, and the number of grids for that date in the grid data table is equal to the number of field sets for that date. The content of the added grid data is then updated according to the data to be added corresponding to each field in each field set for that date, resulting in an updated grid data table.
[0052] Optionally, the field set may include one or more fields or an initial set of fields.
[0053] In one possible embodiment, multiple initial fields are determined, and multiple field sets are determined based on the relationships between these initial fields. Each field set includes at least two fields that are related, or a field that is not related to any of the other fields in the multiple initial fields. Thus, based on the fields in the multiple field sets for each date, the data corresponding to each field is determined, and the data to be added in each field set for that date is obtained. The grid data in the grid data table, indicated by the corresponding field set for the corresponding date, is then updated with this data to be added.
[0054] For example: Retrieve multiple data points corresponding to multiple initial fields under date 1, where the multiple initial fields include initial field 1, initial field 2, and initial field 3. Based on the relationship between initial field 1 and initial field 2 under date 1, generate field set 1 for initial field 1 and initial field 2. Since there is no relationship between initial field 3 and initial field 1 and initial field 2, generate field set 2 for initial field 3 under date 1. Then, generate the data to be added in field set 1 under date 1 from the data in initial field 1, and generate the data to be added in field set 2 under date 1 from the data in initial field 3 under date 1.
[0055] Optionally, add a whole row of grid corresponding to date 1 in the grid data table according to date 1, and divide the whole row of grid into grid 1 corresponding to field set 1 and grid 2 corresponding to field set 2 according to field set 1 and field set 2. Update the grid data in grid 1 according to the data to be added corresponding to field set 1 under date 1, and update the grid data in grid 2 according to the data to be added corresponding to field set 2 under date 1 to obtain the updated grid data table.
[0056] S302. Determine multiple preset business scenarios and the key fields or time periods corresponding to each preset business scenario.
[0057] More specifically, multiple preset business scenarios are identified, where each preset business scenario consists of the dates and fields corresponding to the relevant data required in multiple business scenarios in actual work. The time period corresponding to each preset business scenario is determined based on the dates related to the relevant data, where the time period includes one or more dates.
[0058] Optionally, based on the relevant data, determine the field set to which each initial field in the grid data table belongs, and determine the key field corresponding to the preset business scenario based on the field set to which it belongs. The key field includes one or more field sets, and each field set includes one or more fields.
[0059] For example: If the dates related to the preset business scenario are January 1, January 2, and January 3, then the time period of the preset business scenario is determined to be the three dates from January 1 to January 3.
[0060] For example, if the initial fields related to a pre-defined business scenario are name, card number, and loan type, and the relationships between these initial fields indicate a relationship between loan type and loan amount within that scenario, then the initial field corresponding to name in the grid data table is determined to be "name," the initial field corresponding to card number is "card number," and the initial field corresponding to loan type is "loan type" and "loan amount." Therefore, the key fields corresponding to the pre-defined business scenario include name, card number, loan type, and loan amount.
[0061] S303. Determine the second view information corresponding to each preset business scenario based on the time period or key fields of each preset business scenario.
[0062] More specifically, based on the dates and field sets corresponding to each grid in the updated grid data table, and according to the time period or key fields of each preset business scenario, the second view information corresponding to the preset business scenario is determined. The second view information is used to indicate the first view information corresponding to each date within that time period, or the first view information corresponding to each field in the field set to which the key field belongs.
[0063] In one possible embodiment, as shown in Figure 4(a), the preset business scenario 1 requires data corresponding to field set 1, field set 2, field set 3... field set n-1 and field set n under date 1 and date 2 respectively. As shown in Figure 4(b), the preset business scenario 2 requires data corresponding to field set 3, field set n-1 and field set n under date 1, date 2, date 3... date m-1 and date m respectively.
[0064] Optionally, the first view information corresponding to each date is used to indicate the grid data corresponding to all field sets under that date.
[0065] For example, the first view information corresponding to date 1 is the name of each of the fields under date 1. By running the relevant instructions of the first view information, the identifier of the date and field set corresponding to each grid in the grid data table is used to determine the entire row of grids corresponding to date 1 in the first view information, and the grid data in the entire row of grids is output.
[0066] Optionally, the first view information corresponding to each field set is used to indicate the grid data corresponding to the field set across all dates. Specifically, when a field set includes one field, the first view information corresponding to that field is the first view information corresponding to that field and is used to indicate the grid data corresponding to that field across all dates; when a field set includes multiple fields, the first view information corresponding to that field set includes the first view information corresponding to each of the multiple fields under all dates, and the first view information corresponding to that field set is used to indicate the grid data corresponding to each of the multiple fields within that field set across all dates.
[0067] For example: The first view information corresponding to field set 1 is the name of each date in field set 1. By running the relevant instructions of the first view information, the date and field set identifier of each grid in the grid data table are used to determine the entire column of grid corresponding to field set 1 in the first view information, and the grid data in the entire column of grid is output.
[0068] In one possible embodiment, grid data corresponding to all field sets for any date indicated by the second view information can be obtained by running the first view information.
[0069] Optionally, when the processing system obtains multiple data to be added within a preset period and processes the multiple data to be added to obtain an updated grid data table, and determines the second view information of the preset business scenario based on the updated grid data table, it waits in real time to receive a data sharing request from the target business scenario, and executes step S304 when it receives the data sharing request.
[0070] S304. Receive a data sharing request for the target business scenario, and determine the second view information of the preset business scenario that matches the target business scenario based on the target key fields and / or target time period corresponding to the target business scenario.
[0071] More specifically, when the processing system receives a data sharing request for a target business scenario, it determines the target key fields and / or target time periods related to the target business scenario indicated by the data sharing request, and determines the second view information of the preset business scenario that matches the target business scenario based on the target key fields and / or target time periods.
[0072] Optionally, if at least one preset business scenario corresponds to the same time period as the target time period of the target business scenario, the preset business scenario corresponding to the same time period as the target time period is selected as the preset business scenario that matches the target business scenario.
[0073] Optionally, if there is no preset business scenario whose corresponding time period is different from the target time period of the target business scenario, but at least one preset business scenario has a key field that is the same as the target key field, the preset business scenario corresponding to the key field that is the same as the target key field is selected as the preset business scenario that matches the target business scenario.
[0074] Optionally, if there is no preset business scenario whose corresponding time period is different from the target time period of the target business scenario, and there is no preset business scenario whose corresponding key field is the same as the target key field, the preset business scenario corresponding to the time period including the target time period is selected as the preset business scenario that matches the target business scenario.
[0075] Optionally, the method for determining the second view information of a preset business scenario that matches the target business scenario is as follows: Figure 5 As shown, it includes the following steps:
[0076] S501. Determine if a target time period exists.
[0077] More specifically, determine whether the target time period exists in the data sharing requests of the target business scenario.
[0078] Optionally, if it is determined that a target time period exists, step S502 is executed; if it is determined that a target time period does not exist, step S503 is executed.
[0079] S502. Determine that the second view information is the second view information of a preset business scenario that matches the target time period.
[0080] More specifically, when a target time period exists in the data sharing request of the target business scenario, the second view information that matches the target business scenario is determined to be the second view information of the preset business scenario that matches the target time period.
[0081] In one possible embodiment, if the target time period is date 1 and date 2, and the time period of the second view information of the preset business scenario 1 is determined to be date 1, and the time period of the second view information of the preset business scenario 2 is date 1, date 2 and date 3, then the time period corresponding to the preset business scenario including date 1 and date 2 in the target time period is selected as the preset business scenario that matches the target business scenario, i.e., preset business scenario 2, thereby determining the second view information of the target business scenario as the second view information of the preset business scenario 2 that matches the target time period.
[0082] Optionally, after determining that the second view information of the target business scenario is the second view information of a preset business scenario that matches the target time period, it is determined whether there are still target key fields in the data sharing request of the target business scenario, as in step S503.
[0083] S503. Determine if the target key field exists.
[0084] More specifically, when it is determined that the target time period does not exist in the data sharing request of the target business scenario, it is determined whether the target key field exists in the data sharing request of the target business scenario.
[0085] Optionally, if the existence of the target key field is determined, step S504 is performed.
[0086] Optionally, if the target time period and target key field are not found in the data sharing request for the target business scenario, a request is made to resend the data sharing request for the target business scenario, and step S501 is executed upon receiving the resent data sharing request for the target business scenario.
[0087] S504. Determine that the second view information is the second view information of a preset business scenario that matches the target key field.
[0088] More specifically, when it is determined that a target key field exists in the data sharing request of the target business scenario, the second view information that matches the target business scenario is determined to be the second view information of a preset business scenario that matches the target key field.
[0089] In one possible embodiment, if the target key fields are field set 1 and field set 2, and the key field of the second view information of the preset business scenario 3 is determined to be field set 1, and the key fields of the second view information of the preset business scenario 4 are field set 1, field set 2 and field set 3, then the key field corresponding to the preset business scenario including field set 1 and field set 2 in the target key fields is selected as the preset business scenario that matches the target business scenario, i.e., preset business scenario 4, thereby determining the second view information of the target business scenario as the second view information of the preset business scenario 4 that matches the target key field.
[0090] In this embodiment, by determining whether a target time period and target key fields exist in the data sharing request of the target business scenario, and by determining the result to select the second view information of the preset business scenario that matches the target business scenario, the second view information of the preset business scenario that matches the target business scenario can be selected more quickly from a large amount of data by using the identifier of the date and field set. This enables faster exclusion of data that is not related to the target business scenario from the database, improves the efficiency of subsequent data query, and further improves the efficiency of data processing.
[0091] S305. Based on the second view information corresponding to the matching preset business scenario, determine the grid data corresponding to the target business scenario and output it.
[0092] More specifically, based on the second view information corresponding to the matching preset business scenario, the second view information is processed to obtain the grid data indicated by the relevant second view information, thereby determining and outputting the grid data corresponding to the target business scenario.
[0093] In this embodiment, a grid data table is established, which includes a set of fields generated by associating various dates and fields. Based on the grid data table, a second view information of a preset business scenario is determined. When a data sharing request for a target business scenario is received, the second view information of the matching preset business scenario is determined according to the target time period and target key fields indicated in the request. Based on the second view information, the grid data corresponding to the target business scenario is further filtered out, thereby improving the data processing efficiency of the database and the efficiency of obtaining the grid data corresponding to the target business scenario, and further improving the data sharing efficiency.
[0094] Optionally, in step S304, if it is determined that the data sharing request for the target business scenario has a target time period and a target key field, and the time period corresponding to the preset business scenario exceeds the target time period, then after determining that the second view information of the preset business scenario matching the target business scenario is the second view information of the preset business scenario matching the target time period, as follows... Figure 6 As shown, it includes the following steps:
[0095] S601. Determine the portion of dates in the second view information of the preset business scenario that correspond to each date within the target time period.
[0096] More specifically, identify the dates in the second view information that match the preset business scenario and correspond to each date within the target time period.
[0097] For example, if the dates within the target time period are Date 1 and Date 2, and the time period in the second view information of the matching preset business scenario is from Date 1 to Date 5, then Date 1 and Date 2 corresponding to the target time period are determined from the second view information of the matching preset business scenario.
[0098] S602. Determine the second view information corresponding to the target business scenario.
[0099] More specifically, the second view information corresponding to the target business scenario is determined based on the partial dates corresponding to each date within the target time period in the second view information of the matching preset business scenario. The second view information corresponding to the target business scenario includes the first view information corresponding to each date within the partial dates.
[0100] For example: Determine the first view information of date 1 and the first view information of date 2 in the second view information of the matching preset business scenario that correspond to the target time period, and generate the second view information of the target business scenario from the first view information of date 1 and the first view information of date 2.
[0101] S603. Determine and output the corresponding grid data based on the second view information corresponding to the target business scenario.
[0102] More specifically, determine the grid data corresponding to all fields within a certain date range indicated by the second view information corresponding to the target business scenario; determine the partial fields corresponding to each field in the target key fields from all fields within the partial dates, and determine the output grid data based on the partial fields, wherein the output grid data includes the grid data corresponding to the partial fields within the partial dates.
[0103] For example: When the target key fields are Field 1 and Field 2, determine Field 1 and Field 2 based on the first view information of all fields within Date 1 included in the second view information of the target business scenario. Then, determine the corresponding grid data for Field 1 and Field 2 within Date 1. Finally, determine the corresponding grid data for Field 1 and Field 2 within Date 1 and Date 2 based on the first view information of all fields within the first view information of Date 2. Output the corresponding grid data for Field 1 and Field 2 within Date 1 and Date 2.
[0104] In this embodiment of the application, when there are target time periods and target key fields in the target business scenario, the preset business scenario that matches the target time period is first determined, and the second view information corresponding to the target business scenario is determined by filtering out some dates that correspond to the target time period. Then, in the first view information corresponding to the some dates indicated by the second view information, the grid data corresponding to some fields in the target business scenario is determined according to some fields in the target key fields, thereby improving the efficiency of data processing and sharing required for the target business scenario with target time periods and target key fields.
[0105] Optionally, in step S304, if only a target time period exists, after determining the second view information of the preset business scenario matching the target business scenario, the partial dates corresponding to each date within the target time period in the second view information of the preset business scenario are determined. Then, based on the first view information corresponding to each date in this partial date range, the grid data corresponding to all field sets under each date within the target time period of the target business scenario is determined. Finally, the grid data corresponding to all field sets under each date within the target time period is shared with the side sending the data sharing request for the target business scenario. The field set includes at least one field. In this embodiment, by determining the first view information of each date corresponding to the target time period to obtain the grid data of each field set under that date for a target business scenario where only a target time period exists, based on the second view information of the matching preset business scenario, the sharing efficiency of the data required for a target business scenario where only a target time period exists is improved.
[0106] In one possible embodiment, in step S304, if only a target time period exists and the target time period is the latest date, wherein the latest date is used to indicate the date closest to the current time and corresponding data exists in the grid data table, and the matching preset business scenario is: when the corresponding time period is the latest preset duration preset business scenario, a sampling area is determined based on the grid data of multiple dates contained in the second view information of the matching preset business scenario. The sampling area includes grid data of some dates among multiple dates, and the latest date in the sampling area is determined. After determining the latest date in the sampling area, it is determined whether there is at least one grid data date in the non-sampling area that is earlier than the latest date in the sampling area.
[0107] Optionally, if no date earlier than the latest date in the sampling area exists, the grid data corresponding to the target business scenario is output. The grid data corresponding to the target business scenario includes the grid data corresponding to all fields within the latest date of the sampling area. The grid data corresponding to the target business scenario is then output based on the grid data corresponding to all fields within the latest date of the sampling area.
[0108] Optionally, if the date of at least one grid data in the non-sampling area is earlier than the latest date in the sampling area, then the updated latest date is determined, and the updated latest date is the latest date among the dates of at least one grid data. Based on the grid data corresponding to all fields within the updated latest date, the grid data corresponding to the target business scenario is output.
[0109] For example, determining the grid data of the target business scenario for the most recent day based on the second-view information of a preset business scenario over the past month includes: sampling the grid data for each date in the second-view information of the preset business scenario over the past month to obtain grid data for multiple dates in the sampling area; querying and determining the date corresponding to the latest day in the grid data for multiple dates in the sampling area; and after determining the date corresponding to the latest day in the sampling area, querying and determining whether there is a date earlier than the latest day in the sampling area in each grid data in the non-sampling area. If the existence of data for the latest day is determined, the date of the latest day queried in the sampling area and the first-view information corresponding to that date are directly obtained, thereby obtaining the grid data corresponding to all fields under the latest day. In this embodiment of the application, by sampling the grid data corresponding to the preset business scenario, the range for querying and determining the latest date is further narrowed, improving data processing efficiency.
[0110] Optionally, in step S304, if only the target key field exists, after determining the second view information of the preset business scenario matching the target business scenario, a partial field set corresponding to each field set in the key field is determined from the second view information of the matching preset business scenario, and the first view information corresponding to each field set in the partial field set under all dates is determined. Then, grid data corresponding to the target business scenario is obtained and output based on the first view information corresponding to each field set in the partial field set. In this embodiment, for a target business scenario with only the target key field, a partial field set corresponding to the matching preset business scenario is determined, thereby determining the first view information corresponding to multiple field sets corresponding to the target business scenario, thus obtaining the indicated grid data, improving the processing and sharing efficiency of data required for a target business scenario with only the target key field.
[0111] Optionally, before adding corresponding grid data to the grid data table based on the date and field sets corresponding to multiple data to be added, and before updating the added grid data, the preset frequency of each field set is determined based on the key fields of each preset business scenario, the order of each field set in the grid data table is determined based on the value of the preset frequency corresponding to each field set, and the field sets of the grid data table are updated.
[0112] For example: if the preset frequency of the "card number" field set is determined to be 0.2, the preset frequency of the "name" field set to be 0.7, and the preset frequency of the "amount" field set to be 0.1 based on the key fields of each preset business scenario, then in the grid data table, the "name" field set will be updated to the first column field set of the grid data table, the "card number" field set will be updated to the second column field set of the grid data table, and the "amount" field set will be updated to the third column field set of the grid data table.
[0113] In one possible embodiment, the row order in the grid data table from top to bottom represents the sorting of dates from the current date to historical dates, and the column order in the grid data table from left to right represents the sorting of the field set from the highest to the lowest importance.
[0114] In one possible embodiment, if only a target key field exists, and the target key field is the most important field set, the most important field set is used to indicate the field set used most frequently in the grid data table, and the matching preset business scenario is: when the preset business scenario corresponds to a preset number of important field sets, first determine the arrangement order of each field set in the grid data table, and determine the partial field set corresponding to the target key field from the order of each field set in the key field corresponding to the preset business scenario, determine the first view information corresponding to each field set in the partial field set, and obtain and output the grid data corresponding to each field set in the indicated target key field based on the first view information corresponding to each field set in the partial field set.
[0115] For example, determining the grid data of the target business scenario based on the second view information of the preset business scenario using the first six important field sets includes: determining the first-ranked field set as the most important field set based on the first six important field sets in the second view information of the preset business scenario, and determining the first view information corresponding to the most important field set, thereby obtaining and outputting the grid data corresponding to the most important field set for all dates. In this embodiment, sorting the various field sets in the grid data table according to the frequency of use of the field sets facilitates faster acquisition of data indicated by the target business scenario related to sharing and sorting.
[0116] Optionally, in step S304, if there is a target time period and target key fields, and the target time period is the latest date, the target key fields are the most important field set, the latest date is used to indicate the date closest to the current time and has corresponding data in the grid data table, the most important field set is used to indicate the field set used most frequently in the grid data table, and the matching preset business scenario is: when the corresponding time period is the most recent preset duration preset business scenario, firstly, based on the second view information of the preset business scenario, filter out the first view information corresponding to each date in the target time period of the target business scenario, and determine the grid data of each field set in the corresponding target key fields from the first view information corresponding to each date in the target time period, thereby obtaining the grid data corresponding to the target business scenario and outputting it.
[0117] For example, determining the grid data of the target business scenario based on the second-view information of a preset business scenario over the past month, focusing on the most important field set within the most recent day, includes: sampling the grid data for each date in the second-view information of the preset business scenario over the past month to obtain grid data for multiple dates in the sampling area; querying and determining the date corresponding to the latest day in the grid data for multiple dates in the sampling area; after determining the date corresponding to the latest day in the sampling area, querying and determining whether there is a date earlier than the latest day in the sampling area in the grid data of each non-sampling area; if the existence of data for the latest day is determined, directly obtaining the date of the latest day queried from the sampling area and the first-view information corresponding to that date, thereby obtaining the grid data corresponding to all field sets under the latest day. Then, determining and outputting the grid data corresponding to the field set that is the first field set from the left in the row of the grid data table corresponding to the latest day's date from all field sets. In this embodiment, by sampling the grid data corresponding to the preset business scenario, the range for querying and determining the latest date is further narrowed, improving data processing efficiency, and providing a more effective and faster processing method for the target business scenario with relevant field sets, enhancing the applicability to the target business scenario.
[0118] Figure 7 This is a schematic diagram of the structure of the data processing apparatus provided in an embodiment of this application. Figure 7 As shown, the data processing device includes: an acquisition module 701, a processing module 702, and a receiving module 703;
[0119] The acquisition module 701 is used to acquire a grid data table, which records data corresponding to multiple field sets under multiple dates. The grid data table includes multiple grid data, and each grid data corresponds to a date and a field set.
[0120] Processing module 702 is used to determine multiple preset business scenarios and the key fields or time periods corresponding to each preset business scenario. The key fields are at least one field in a set of multiple fields.
[0121] The processing module 702 is used to determine the second view information corresponding to the preset business scenario based on the time period or key field of each preset business scenario; the second view information is used to indicate the first view information corresponding to each date within the time period or the first view information corresponding to each field in the field set to which the key field belongs; wherein, the first view information corresponding to each date is used to indicate the grid data corresponding to all field sets under the date, and the first view information corresponding to each field set is used to indicate the grid data corresponding to the fields within all dates;
[0122] The receiving module 703 is used to receive data sharing requests from the target business scenario and determine the second view information of the preset business scenario that matches the target business scenario based on the target key fields and / or target time period corresponding to the target business scenario.
[0123] The processing module 702 is used to determine and output the grid data corresponding to the target business scenario based on the second view information corresponding to the matching preset business scenario.
[0124] In some embodiments, the processing module 702 is further configured to determine a plurality of initial fields and, based on the association relationships between the plurality of initial fields, determine a plurality of field sets; wherein each field set includes: at least two fields that have an association relationship, or a field that has no association relationship with any of the other fields among the plurality of initial fields.
[0125] In some embodiments, the acquisition module 701 is further configured to acquire multiple data to be added within a preset period at regular intervals, the data to be added including data corresponding to each field in multiple field sets under each date within the preset period; and to add corresponding grid data to the grid data table according to the dates and field sets corresponding to the multiple data to be added, and update the added grid data to obtain the updated grid data table.
[0126] In some embodiments, the processing module 702 is further configured to determine second view information of a preset business scenario that matches the target business scenario based on the target key field and / or target time period corresponding to the target business scenario, including: determining whether the data sharing request of the target business scenario contains a target time period and a target key field; if only the target time period exists, then determining the second view information to be the second view information of the preset business scenario that matches the target time period; if both the target time period and the target key field exist, then determining the second view information to be the second view information of the preset business scenario that matches the target time period; if only the target key field exists, then determining the second view information to be the second view information of the preset business scenario that matches the target key field.
[0127] In some embodiments, the processing module 702 is further configured to, if a target time period and a target key field exist, and the time period corresponding to the preset business scenario exceeds the target time period, determine and output the grid data corresponding to the target business scenario based on the second view information corresponding to the preset business scenario, including: determining a portion of the dates in the second view information of the preset business scenario that correspond to each date within the target time period; determining the second view information corresponding to the target business scenario, wherein the second view information corresponding to the target business scenario includes the first view information corresponding to each date within the portion of dates; and determining and outputting the corresponding grid data based on the second view information corresponding to the target business scenario.
[0128] In some embodiments, the processing module 702 is further configured to determine and output corresponding grid data based on the second view information corresponding to the target business scenario, including: determining the grid data corresponding to all fields within a certain period of the second view information indicating the target business scenario; determining some fields corresponding to each field in the target key fields from all fields within the certain period of ...
[0129] In some embodiments, the processing module 702 is further configured to, if only a target time period exists and the target time period is the latest date, match the preset business scenario as follows: a preset business scenario whose corresponding time period is the most recent preset duration; the latest date is used to indicate the date closest to the current time and for which corresponding data exists in the grid data table; accordingly, determine and output the grid data corresponding to the target business scenario based on the second view information corresponding to the preset business scenario, including: determining a sampling area based on the grid data of multiple dates contained in the second view information of the matching preset business scenario, the sampling area including grid data of some dates among the multiple dates; determining the latest date in the sampling area, and determining whether there is at least one grid data date in the non-sampling area that is earlier than the latest date in the sampling area; if not, output the grid data corresponding to the target business scenario, the grid data corresponding to the target business scenario including the grid data corresponding to all fields within the latest date in the sampling area.
[0130] In some embodiments, the processing module 702 is further configured to: if the date of at least one grid data in the non-sampling area is earlier than the latest date in the sampling area, determine the updated latest date, wherein the updated latest date is the latest date among the dates of at least one grid data; and output the grid data corresponding to the target business scenario, wherein the grid data corresponding to the target business scenario includes the grid data corresponding to all fields within the updated latest date.
[0131] The data processing apparatus provided in this application embodiment can be used to execute the technical solution of the data processing method in the above embodiment. Its implementation principle and technical effect are similar, and will not be described again here.
[0132] It should be noted that the division of the various modules in the above device is merely a logical functional division. In actual implementation, they can be fully or partially integrated into a single physical entity, or they can be physically separated. Furthermore, these modules can be implemented entirely in software via processing element calls; they can be fully implemented in hardware; or some modules can be implemented by processing element calls to software, while others are implemented in hardware. Moreover, these modules can be fully or partially integrated together, or implemented independently. The processing element here can be an integrated circuit with signal processing capabilities. During implementation, each step of the above method or each of the above modules can be completed through the integrated logic circuits in the hardware of the processor element or through software instructions.
[0133] Figure 8 This is a schematic diagram of the structure of an electronic device provided in an embodiment of this application. Figure 8 As shown, the electronic device may include: a transceiver 801, a processor 802, and a memory 803.
[0134] Processor 802 executes computer execution instructions stored in memory, causing processor 802 to perform the scheme in the above embodiments. Processor 802 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA), or other programmable logic devices, discrete gate or transistor logic devices, or discrete hardware components.
[0135] The memory 803 is connected to the processor 802 via the system bus and completes communication between them. The memory 803 is used to store computer program instructions.
[0136] Transceiver 801 can be used to obtain the task to be run and its configuration information.
[0137] The system bus can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus, etc. The system bus can be divided into address bus, data bus, control bus, etc. For ease of representation, only one thick line is used in the diagram, but this does not indicate that there is only one bus or one type of bus. Transceivers are used to enable communication between database access devices and other computers (e.g., clients, read-write libraries, and read-only libraries). Memory may include random access memory (RAM) and may also include non-volatile memory.
[0138] The electronic device provided in this application embodiment can be the terminal device described in the above embodiments.
[0139] This application also provides a chip for executing instructions, which is used to execute the data processing method described in the above embodiments.
[0140] This application also provides a computer-readable storage medium storing computer instructions that, when executed on a computer, cause the computer to perform the data processing method described in the above embodiments.
[0141] This application also provides a computer program product, which includes a computer program stored in a computer-readable storage medium. At least one processor can read the computer program from the computer-readable storage medium, and when the at least one processor executes the computer program, it can implement the technical solution of the data processing method in the above embodiments.
[0142] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative; for instance, the division of modules is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple modules may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the coupling or direct coupling or communication connection shown or discussed may be indirect coupling or communication connection through some interfaces, devices, or modules, and may be electrical, mechanical, or other forms.
[0143] The modules described as separate components may or may not be physically separate. The components shown as modules may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the modules can be selected to implement the solution of this embodiment according to actual needs.
[0144] Furthermore, the functional modules in the various embodiments of this application can be integrated into one processing unit, or each module can exist physically separately, or two or more modules can be integrated into one unit. The unit composed of the above modules can be implemented in hardware or in the form of hardware plus software functional units.
[0145] The integrated modules described above, implemented as software functional modules, can be stored in a computer-readable storage medium. These software functional modules, stored in a storage medium, include several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) or processor to execute some steps of the methods of the various embodiments of this application.
[0146] It should be understood that the aforementioned processor can be a Central Processing Unit (CPU), or other general-purpose processors, digital signal processors (DSPs), application-specific integrated circuits (ASICs), etc. A general-purpose processor can be a microprocessor or any conventional processor. The steps of the method disclosed in this invention can be directly manifested as being executed by a hardware processor, or executed by a combination of hardware and software modules within the processor.
[0147] The memory may include high-speed RAM, and may also include non-volatile storage (NVM), such as at least one disk storage device, and may also be a USB flash drive, external hard drive, read-only memory, disk or optical disc, etc.
[0148] The bus can be an Industry Standard Architecture (ISA) bus, a Peripheral Component Interconnect (PCI) bus, or an Extended Industry Standard Architecture (EISA) bus, etc. Buses can be categorized as address buses, data buses, control buses, etc. For ease of illustration, the buses shown in the accompanying drawings are not limited to a single bus or a single type of bus.
[0149] The aforementioned storage medium can be implemented from any type of volatile or non-volatile storage device or a combination thereof, such as static random access memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic storage, flash memory, magnetic disk, or optical disk. The storage medium can be any available medium accessible to general-purpose or special-purpose computers.
[0150] An exemplary storage medium is coupled to a processor, enabling the processor to read information from and write information to the storage medium. Alternatively, the storage medium can be an integral part of the processor. The processor and storage medium can reside in an Application Specific Integrated Circuit (ASIC). Alternatively, the processor and storage medium can exist as discrete components in an electronic control unit or main control device.
[0151] Those skilled in the art will understand that all or part of the steps of the above-described method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When executed, the program performs the steps of the above-described method embodiments; and the aforementioned storage medium includes various media capable of storing program code, such as ROM, RAM, magnetic disks, or optical disks.
[0152] The collection, storage, use, processing, transmission, provision, and disclosure of financial data or user data involved in the technical solution of this application all comply with the provisions of relevant laws and regulations and do not violate public order and good morals.
[0153] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of this application, and are not intended to limit them. Although this application has been described in detail with reference to the foregoing embodiments, those skilled in the art should understand that modifications can still be made to the technical solutions described in the foregoing embodiments, or equivalent substitutions can be made to some or all of the technical features therein. Such modifications or substitutions do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of this application.
Claims
1. A data processing method, characterized in that, include: Obtain a grid data table, which is used to record data corresponding to multiple field sets under multiple dates; The grid data table includes multiple grid data, each grid data corresponding to a date and a set of fields; Determine multiple preset business scenarios and the key fields or time periods corresponding to each preset business scenario, wherein the key field is at least one field in the set of multiple fields; Based on the time period or key fields of each preset business scenario, determine the second view information corresponding to the preset business scenario; The second view information is used to indicate the first view information corresponding to each date within the time period or the first view information corresponding to each field in the field set to which the key field belongs; wherein, the first view information corresponding to each date is used to indicate the grid data corresponding to all field sets under the date, and the first view information corresponding to each field set is used to indicate the grid data corresponding to the field within all dates; Receive a data sharing request for a target business scenario, and determine the second view information of a preset business scenario that matches the target business scenario based on the target key fields and / or target time period corresponding to the target business scenario; Based on the second view information corresponding to the matching preset business scenario, determine and output the grid data corresponding to the target business scenario.
2. The method according to claim 1, characterized in that, The method further includes: Determine multiple initial fields, and based on the relationships between these initial fields, determine multiple field sets; Each set of fields includes: at least two fields that are related, or a field that is not related to any of the other fields in the initial set of fields.
3. The method according to claim 1, characterized in that, The method further includes: Every preset period, multiple data to be added within the preset period are obtained. The data to be added includes data corresponding to each field in the multiple field sets for each date within the preset period. Based on the date and field set corresponding to the multiple data to be added, the corresponding grid data is added to the grid data table, and the added grid data is updated to obtain the updated grid data table.
4. The method according to claim 1, characterized in that, Based on the target key fields and / or target time period corresponding to the target business scenario, determine the second view information of the preset business scenario that matches the target business scenario, including: Determine whether the data sharing request for the target business scenario contains the target time period and target key fields; If only the target time period exists, then the second view information is determined to be the second view information of a preset business scenario that matches the target time period; If the target time period and the target key field exist, then the second view information is determined to be the second view information of a preset business scenario that matches the target time period; If only the target key field exists, then the second view information is determined to be the second view information of a preset business scenario that matches the target key field.
5. The method according to claim 4, characterized in that, If the target time period and the target key field exist, and the time period corresponding to the preset business scenario exceeds the target time period, then based on the second view information corresponding to the preset business scenario, determine and output the grid data corresponding to the target business scenario, including: Determine a subset of dates in the second view information of the preset business scenario that correspond to each date within the target time period; Determine the second view information corresponding to the target business scenario, wherein the second view information corresponding to the target business scenario includes the first view information corresponding to each date in the partial dates; The corresponding grid data is determined and output based on the second view information corresponding to the target business scenario.
6. The method according to claim 5, characterized in that, Based on the second view information corresponding to the target business scenario, determine the corresponding grid data and output it, including: Determine the grid data corresponding to all fields within the specified dates indicated by the second view information corresponding to the target business scenario; From all fields within the specified dates, determine the partial fields that correspond to each field in the target key fields; Determine the output grid data, which includes the grid data corresponding to the specified fields within the specified dates.
7. The method according to claim 4, characterized in that, If only the target time period exists and the target time period is the latest date, the matching preset business scenario is: a preset business scenario where the corresponding time period is the most recent preset duration; the latest date is used to indicate the date closest to the current time and for which corresponding data exists in the grid data table; Accordingly, based on the second view information corresponding to the preset business scenario, the grid data corresponding to the target business scenario is determined and output, including: Based on the grid data of multiple dates contained in the second view information of the matching preset business scenario, a sampling area is determined, wherein the sampling area includes grid data of a portion of the multiple dates; Determine the latest date in the sampling area, and determine whether there exists at least one grid data in the non-sampling area whose date is earlier than the latest date in the sampling area; If it does not exist, the grid data corresponding to the target business scenario will be output. The grid data corresponding to the target business scenario includes the grid data corresponding to all fields within the latest date of the sampling area.
8. The method according to claim 7, characterized in that, The method further includes: If the date of at least one grid data in the non-sampling area is earlier than the latest date in the sampling area, then the updated latest date is determined, and the updated latest date is the latest date among the dates of the at least one grid data. Output the grid data corresponding to the target business scenario, which includes the grid data corresponding to all fields within the latest updated date.
9. A data processing apparatus, characterized in that, include: The acquisition module is used to acquire a grid data table, which records data corresponding to multiple field sets under multiple dates; The grid data table includes multiple grid data, each grid data corresponding to a date and a set of fields; The processing module is used to determine multiple preset business scenarios and the key fields or time periods corresponding to each preset business scenario, wherein the key fields are at least one field in the set of multiple fields; The processing module is used to determine the second view information corresponding to each preset business scenario based on the time period or key fields of each preset business scenario. The second view information is used to indicate the first view information corresponding to each date within the time period or the first view information corresponding to each field in the field set to which the key field belongs; wherein, the first view information corresponding to each date is used to indicate the grid data corresponding to all field sets under the date, and the first view information corresponding to each field set is used to indicate the grid data corresponding to the field within all dates; The receiving module is used to receive data sharing requests from target business scenarios and determine second view information of a preset business scenario that matches the target business scenario based on the target key fields and / or target time periods corresponding to the target business scenario. The processing module is used to determine and output the grid data corresponding to the target business scenario based on the second view information corresponding to the matching preset business scenario.
10. An electronic device, characterized in that, include: A processor, and a memory communicatively connected to the processor; The memory stores computer-executed instructions; The processor executes computer execution instructions stored in the memory to implement the method as described in any one of claims 1-8.
11. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer-executable instructions, which, when executed by a processor, are used to implement the method as described in any one of claims 1-8.
12. A computer program product, characterized in that, Includes a computer program that, when executed by a processor, implements the method of any one of claims 1-8.
Citation Information
Patent Citations
Method for database multi-list union query
CN107273506A
Parameter management method and device, electronic equipment and storage medium
CN115438113A
