Table generation method and device, computer equipment and storage medium

Abstract

The invention relates to a table generation method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring business source data of each data provider under the condition that the current moment reaches a preset acquisition moment; determining at least one service entity and at least one piece of service index data of the corresponding service entity according to the service source data of each data provider; generating a service table matched with the table configuration data according to the table configuration data of different service tables, each service entity and the service index data of each service entity; the entity types of the service entities and the index types of the service indexes in different service tables are different. By adopting the method, the maintenance cost of the service table can be reduced, and the application scene of the service table is improved, so that the generated service table is more complete.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to a table generation method, apparatus, computer equipment and storage medium. Background Art

[0002] With the development of computer technology, there has emerged the construction of customized report optimization scenarios based on database data. With the increasing degree of business informatization, there is a practical need for the construction of autonomous and controllable supply chains. Therefore, how to generate more complete reports is crucial.

[0003] In traditional technology, the main one is multi-table direct association technology. Multi-table direct association technology (also known as "table connection") is a technology that links two or more tables through a common column (usually the relationship between primary key and foreign key) to obtain related data. This technology is common in many relational databases, including DAMO database. In DAMO database, you can use statements such as .JOIN of Structured Query Language (SQL) to directly associate multiple tables.

[0004] Although the report generation can be completed in the traditional technology, the report generation usually has the problem of being incomplete. Summary of the invention

[0005] Based on this, it is necessary to provide a table generation method, device, computer equipment and storage medium that can generate a complete table in response to the above technical problems.

[0006] In a first aspect, the present application provides a table generation method, comprising:

[0007] When the current time reaches the preset collection time, the business source data of each data provider is obtained;

[0008] Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0009] According to the table configuration data of different business tables, each business entity and the business indicator data of each business entity, a business table matching the table configuration data is generated; the entity types of the business entities and the indicator types of the business indicators in different business tables are different.

[0010] In one embodiment, at least one business entity and at least one business indicator data of the corresponding business entity are determined based on the business source data of each data provider, including:

[0011] Extracting at least one business entity from the business source data of each data provider;

[0012] For each business entity, according to the preset indicator type, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity.

[0013] In one embodiment, according to a preset indicator type, extracting business indicator data matching the indicator type from business source data corresponding to the business entity includes:

[0014] Determine the data provider of the business source data corresponding to the business entity;

[0015] Determine the indicator extraction method of the business indicator according to the provider type of the data provider and the preset indicator type;

[0016] Based on the indicator extraction method, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity.

[0017] In one embodiment, the table configuration data includes an entity type of at least one business entity and an indicator type of at least one business indicator; generating a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity includes:

[0018] For each business table's table configuration data, according to the entity type in the table configuration data, a target entity matching the entity type is selected from each business entity;

[0019] For each target entity, according to the indicator type in the table configuration data, select the target indicator that matches the indicator type from the business indicators corresponding to the target entity;

[0020] A business table matching the table configuration data is generated according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator.

[0021] In one embodiment, generating a business table matching the table configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator includes:

[0022] Generate an initial table matching the grid configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator;

[0023] Verify the integrity of the table contents of the initial table;

[0024] When the integrity verification passes, the initial table is used as a business table that matches the table configuration data.

[0025] In one embodiment, when the current time reaches the preset collection time, obtaining the service source data of each data provider includes:

[0026] Monitor the current timing of the timer corresponding to each data provider;

[0027] When the current timing of the timer reaches the preset collection time, the service source data of the data provider corresponding to the timer is obtained.

[0028] In a second aspect, the present application also provides a table generating device, comprising:

[0029] A data acquisition module is used to acquire the business source data of each data provider when the current time reaches the preset collection time;

[0030] A data determination module, used to determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0031] The table generation module is used to generate a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity; the entity types of business entities and the indicator types of business indicators in different business tables are different.

[0032] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0033] When the current time reaches the preset collection time, the business source data of each data provider is obtained;

[0034] Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0035] According to the table configuration data of different business tables, each business entity and the business indicator data of each business entity, a business table matching the table configuration data is generated; the entity types of the business entities and the indicator types of the business indicators in different business tables are different.

[0036] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0037] When the current time reaches the preset collection time, the business source data of each data provider is obtained;

[0038] Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0039] According to the table configuration data of different business tables, each business entity and the business indicator data of each business entity, a business table matching the table configuration data is generated; the entity types of the business entities and the indicator types of the business indicators in different business tables are different.

[0040] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:

[0041] When the current time reaches the preset collection time, the business source data of each data provider is obtained;

[0042] Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0043] According to the table configuration data of different business tables, each business entity and the business indicator data of each business entity, a business table matching the table configuration data is generated; the entity types of the business entities and the indicator types of the business indicators in different business tables are different.

[0044] The above table generation method, device, computer equipment and storage medium obtain the business source data of each data provider when the current moment reaches the preset collection moment; determine at least one business entity and at least one business indicator data of the corresponding business entity based on the business source data of each data provider; generate a business table that matches the table configuration data based on the table configuration data of different business tables, each business entity and the business indicator data of each business entity; the entity type of the business entity and the indicator type of the business indicator in different business tables are different. The present application can reduce the cost of business table maintenance and improve the application scenarios of business tables, thereby making the generated business table more complete. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0046] FIG1 is an application environment diagram of a table generation method provided by this embodiment;

[0047] FIG2 is a schematic diagram of a flow chart of a first table generation method provided in this embodiment;

[0048] FIG3 is a schematic diagram of a flow chart of a second table generation method provided in this embodiment;

[0049] FIG4 is a structural block diagram of a table generating device provided in this embodiment;

[0050] FIG5 is an internal structure diagram of a first computer device provided in this embodiment;

[0051] FIG6 is a diagram showing the internal structure of a second type of computer device provided in this embodiment. DETAILED DESCRIPTION

[0052] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0053] The table generation method provided in the embodiment of the present application can be applied in the application environment shown in FIG. 1. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. When the current moment reaches the preset collection moment, the computer device obtains the business source data of each data provider; according to the business source data of each data provider, at least one business entity and at least one business indicator data of the corresponding business entity are determined; according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity, a business table matching the table configuration data is generated; the entity type of the business entity in different business tables and the indicator type of the business indicator are different. Among them, the computer device can be both a terminal and a server. The terminal 102 can be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, Internet of Things devices and portable wearable devices. The Internet of Things devices can be smart speakers, smart TVs, smart air conditioners, smart car-mounted devices, etc. Portable wearable devices can be smart watches, smart bracelets, head-mounted devices, etc. The server 104 may be implemented as an independent server or a server cluster consisting of multiple servers.

[0054] In an exemplary embodiment, as shown in FIG2 , a table generation method is provided, which is described by taking the method applied to the computer device in FIG1 as an example, and includes the following steps 201 to 203. Among them:

[0055] Step 201: when the current time reaches the preset collection time, obtain the business source data of each data provider.

[0056] The data provider may be an object that provides business source data. Exemplarily, the data provider may be a business source table stored in the computer device, such as a project table, a project extension table, a project version table, a project change table, an annual investment table, an annual plan table, an annual scale table, etc., or a system in a third-party computer device, such as a marketing system, a financial system, a project subsystem, etc.

[0057] In one of the embodiments, when it is monitored that the current time reaches the preset collection time, for each data provider, the business source data is obtained from the data provider.

[0058] In another embodiment, the current timing moment of the timer corresponding to each data provider is monitored; when the current timing moment of the timer reaches the preset collection moment, the service source data of the data provider corresponding to the timer is acquired.

[0059] Among them, the timer can be a timer set for each data provider, for example, a project indicator timer, an equipment asset information collection timer, an initial investment indicator timer, etc. The execution time is set mainly between 1-3 am every day, and a log table is designed to record the entire execution process.

[0060] Specifically, for each timer corresponding to a data provider, the current timing moment of the timer is monitored, and when the current timing moment of the timer reaches a preset collection moment, the service source data of the data provider corresponding to the timer is acquired.

[0061] It should be noted that the creation of the timer in this embodiment is mainly based on the distributed task scheduling platform (xxl-job), and its core design goal is to develop a simple, easy-to-use, lightweight, and highly reliable distributed task scheduling framework. As a Java microservice implementation architecture, the method of integrating the scheduling platform may include: introducing the jar package, introducing the relevant jar package in the gradle file, implementation'com.xuxueli:xxl-job-core:2.3.0'; configuring the framework admin and other information, configuring the registered admin address and token, port and other information in the application.properties file; registering in the spring container, writing JobConig and registering in the spring container; implementing the timer method, compiling the timer class to inherit the IJobHandler class to implement the execute method; designing the timer execution log, and designing the relevant log table to record the entire process of timer execution.

[0062] The distributed task scheduling platform in this embodiment uses Quartz as its underlying technical support, so XXL-JOB also supports all the functions of Quartz. Supports multiple scheduling strategies, including CRON expressions, fixed rates, fixed delays, etc.; supports distributed task scheduling, and can schedule multiple task executors to execute tasks at the same time; supports task slicing, which can divide a large task into multiple small tasks for parallel processing; supports task logging and monitoring functions, and can view the execution status and log output of tasks in real time; adopts a distributed architecture design to ensure the reliable execution of tasks. The example of the present invention abandons the traditional practice of using database timers, reduces the resource consumption of the domestic database itself, and increases the flexibility and adaptability of the timer. The database timer cannot meet the situation that needs to be processed by Java program.

[0063] It should be noted that the timer in this embodiment can also set delay scenarios, such as t+1, t+n, etc. If you want to add real-time report data, you need to add spark, Flink and other big data stream batch processing computing frameworks, combined with synchronization to complete real-time data processing and real-time data synchronization, and finally obtain real-time report data, which greatly improves the user experience.

[0064] It should be noted that real-time data processing and real-time data synchronization can be completed based on the Change Data Capture (CDC) function in the Dameng Database. The CDC function allows users to capture events that change data in database tables and record these events. These events include insert, update, and delete operations, as well as row-level changes caused by triggers and constraints. Users can obtain these change data by querying CDC views or subscribing to CDC services. The CDC function of the Dameng Database can be used in a variety of scenarios, such as data synchronization, auditing, data warehouses, etc. It can help users understand data changes in the database in real time, so as to better manage and control data.

[0065] Step 202: Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider.

[0066] Among them, business indicators may include indicators such as preliminary projects, planning issues, preliminary plans, preliminary scale, investment projects, investment plans, investment scale, and equipment assets.

[0067] Specifically, for each data provider, according to the business source data of the data provider, a business entity and business indicator data corresponding to the business entity are obtained from the business source data.

[0068] Step 203 : generating a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity.

[0069] Among them, the entity types of business entities and the indicator types of business indicators in different business tables are different.

[0070] Specifically, for the table configuration data of each business table, determine the business source data corresponding to each business entity required for the business table and the business indicator data of each business entity according to the table configuration data of the business table; and generate a business table matching the table configuration data according to the business source data corresponding to the business entity and the business indicator data of each business entity.

[0071] The above table generation method obtains the business source data of each data provider when the current moment reaches the preset collection moment; determines at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider; generates a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity; the entity type of the business entity and the indicator type of the business indicator in different business tables are different. The present application can reduce the cost of business table maintenance and improve the application scenarios of business tables, thereby making the generated business table more complete.

[0072] In one embodiment, at least one business entity and at least one business indicator data of the corresponding business entity are determined based on the business source data of each data provider, including: extracting at least one business entity from the business source data of each data provider; for each business entity, according to a preset indicator type, extracting business indicator data matching the indicator type from the business source data corresponding to the business entity.

[0073] In one embodiment, business indicator data matching the indicator type is extracted from business source data corresponding to a business entity according to a preset indicator type, including: determining a data provider of the business source data corresponding to the business entity; determining an indicator extraction method for the business indicator according to the provider type of the data provider and the preset indicator type; and extracting business indicator data matching the indicator type from the business source data corresponding to the business entity based on the indicator extraction method.

[0074] In another embodiment, at least one business entity and at least one business indicator data of the corresponding business entity are determined based on the business source data of each data provider, and the data in the data provider can also be calculated or combined to generate business indicator data through a program or stored procedure, and repeated update operations are supported. For example, the planned investment of the project by the end of this year needs to be the investment completed in the previous year plus the planned investment this year, and the investment amount completed by the project by the end of the previous year needs to obtain the project progress from the project subsystem, and the project completed investment is obtained according to the relationship between the project progress ratio and the investment. The above action includes the dual processing of the stored procedure and the Java program, and finally obtains all the indicator data involved in the report, and involves the execution log related table to record the corresponding log.

[0075] It should be noted that in the process of determining business entities and business indicator data, in order to ensure the data processing execution effect as much as possible, it is necessary to design an execution log table to record the log of the processing execution process. This setting can effectively control various problems during execution, thereby ensuring the effective operation of the process to the greatest extent and ensuring the consistency of the data.

[0076] In this embodiment, at least one business entity is extracted from the business source data of each data provider; for each business entity, according to a preset indicator type, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity, so that the business indicator data can be obtained more accurately.

[0077] In one embodiment, the table configuration data includes an entity type of at least one business entity and an indicator type of at least one business indicator; a business table matching the table configuration data is generated based on the table configuration data of different business tables, each business entity and the business indicator data of each business entity, including: for the table configuration data of each business table, according to the entity type in the table configuration data, a target entity matching the entity type is selected from each business entity; for each target entity, according to the indicator type in the table configuration data, a target indicator matching the indicator type is selected from the business indicators corresponding to the target entity; and a business table matching the table configuration data is generated based on the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator.

[0078] It should be noted that the design of table configuration data needs to be based on the report requirements for high-level abstract design, sort out all entity and indicator attribute information, cohesively abstract related entities and corresponding indicator attributes, and design different levels of dimensions for different business scenarios, and finally obtain a highly cohesive and highly reused multi-dimensional data wide table based on the report requirement scenario. Specifically, list all business entities and various attribute indicators involved in the report requirements, summarize and integrate the relevant business entities and corresponding attribute indicator information from a global perspective, think about the integrated business entities and indicators in multiple dimensions, design according to the details and aggregation levels, reasonably combine and split, and decide whether to use the same wide table or another wide table according to the report presentation requirements. Wide table design technology usually refers to the practice of storing all attributes of an entity in one table in database design. The advantages of this method are simple and intuitive, easy to understand and query, while multi-dimensional wide tables mainly perform abstract designs of different levels of dimensions for different business indicators, forming indicator data of various statistical calibers, thereby meeting the report requirements of users of different types and roles. In custom report design, the design of multi-dimensional wide tables is particularly important, which can greatly simplify custom metadata definition and automatic script generation.

[0079] For example, there are many reports with complex styles, but after listing, sorting, analysis and cohesion, we finally designed wide tables of indicators such as preliminary projects, planning issues, preliminary plans, preliminary scale, investment projects, investment plans, investment scale, equipment assets, etc., as well as the corresponding aggregated wide table information according to voltage level and municipal level.

[0080] In one embodiment, a business table that matches the table configuration data is generated based on the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator, including: generating an initial table that matches the table configuration data based on the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator; performing integrity verification on the table content of the initial table; and if the integrity verification passes, using the initial table as a business table that matches the table configuration data.

[0081] It should be noted that, in the process of completion verification, the initial table can be visualized to determine whether it is generated, and performance testing can be performed according to the requirements of the requirements specification, thereby completing the overall optimization. In the example of the present invention, the report involved is a visual user-defined report. The user only needs to select and create various different reports through metadata. After multiple rounds of testing, the user's requirements are met in terms of stability and performance.

[0082] In this embodiment, for the table configuration data of each business table, a target entity matching the entity type is selected from each business entity according to the entity type in the table configuration data; for each target entity, a target indicator matching the indicator type is selected from the business indicators corresponding to the target entity according to the indicator type in the table configuration data; a business table matching the table configuration data is generated based on the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator, thereby making the generated business table more accurate.

[0083] In one embodiment, this embodiment provides an optional method for generating a table, and takes the method applied to a server as an example for explanation. As shown in FIG3 , the method includes the following steps:

[0084] Step 301: monitor the current timing of the timer corresponding to each data provider.

[0085] Step 302: When the current timing of the timer reaches the preset collection time, the service source data of the data provider corresponding to the timer is obtained.

[0086] Step 303: extract at least one business entity from the business source data of each data provider.

[0087] Step 304, for each business entity, determine the data provider of the business source data corresponding to the business entity, and determine the indicator extraction method of the business indicator based on the provider type of the data provider and the preset indicator type, and then based on the indicator extraction method, extract the business indicator data matching the indicator type from the business source data corresponding to the business entity.

[0088] Step 305 : for the table configuration data of each business table, according to the entity type in the table configuration data, select a target entity that matches the entity type from each business entity.

[0089] Step 306 : For each target entity, according to the indicator type in the table configuration data, select a target indicator that matches the indicator type from the business indicators corresponding to the target entity.

[0090] Step 307: Generate an initial table matching the grid configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator.

[0091] Step 308: Verify the integrity of the table content of the initial table.

[0092] Step 309: If the integrity verification passes, the initial table is used as a business table that matches the table configuration data.

[0093] Among them, the entity types of business entities and the indicator types of business indicators in different business tables are different.

[0094] This embodiment can improve the performance of reports: through the timer wide table combination technology, the situation of multi-table associated query is changed, and single-table query can be basically realized, and the performance can be greatly improved. In addition, the complexity of report script statement writing is reduced. Through the timer wide table combination technology, the indicator dimension of the report can be directly viewed in the table, and the corresponding report script can be written very intuitively, which greatly reduces the complexity and provides a basis for users to customize reports in various forms. At the same time, the maintenance cost of the report is reduced, and the reasonable wide table design greatly reduces the difficulty of report development, which makes it possible to divide the work between business development and report development. The business is responsible for filling the calculated indicator data into the wide table, and the report development only needs a single table query. Even if the business side changes, the report side can be unaffected. Finally, the applicable scenarios of domestic databases are improved. Domestic databases still have room for improvement in complex applications of big data. The application of this field can be appropriately expanded through the timer wide table combination technology.

[0095] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0096] Based on the same inventive concept, the embodiment of the present application also provides a table generation device for implementing the table generation method involved above. The implementation solution provided by the device to solve the problem is similar to the implementation solution recorded in the above method, so the specific limitations in one or more table generation device embodiments provided below can refer to the limitations on the table generation method above, and will not be repeated here.

[0097] In an exemplary embodiment, as shown in FIG4 , a table generating device is provided, comprising: a data acquiring module 10, a data determining module 11 and a table generating module 12, wherein:

[0098] The data acquisition module 10 is used to acquire the service source data of each data provider when the current time reaches the preset collection time;

[0099] The data determination module 11 is used to determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider;

[0100] The table generation module 12 is used to generate a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity; the entity types of business entities and the indicator types of business indicators in different business tables are different.

[0101] In one embodiment, the data determination module 11 in Figure 4 is also used to extract at least one business entity from the business source data of each data provider; for each business entity, according to a preset indicator type, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity.

[0102] In one embodiment, the data determination module 11 in Figure 4 is also used to determine the data provider of the business source data corresponding to the business entity; determine the indicator extraction method of the business indicator according to the provider type of the data provider and the preset indicator type; based on the indicator extraction method, extract the business indicator data matching the indicator type from the business source data corresponding to the business entity.

[0103] In one embodiment, the table generation module 12 in Figure 4 is also used to select a target entity that matches the entity type from each business entity according to the entity type in the table configuration data for the table configuration data of each business table; for each target entity, select a target indicator that matches the indicator type from the business indicators corresponding to the target entity according to the indicator type in the table configuration data; and generate a business table that matches the table configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator.

[0104] In one embodiment, the table generation module 12 in Figure 4 is also used to generate an initial table that matches the grid configuration data based on the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator; perform integrity verification on the table content of the initial table; and if the integrity verification passes, use the initial table as a business table that matches the table configuration data.

[0105] In one embodiment, the data acquisition module 10 in FIG. 4 is also used to monitor the current timing moment of the timer corresponding to each data provider; when the current timing moment of the timer reaches the preset collection moment, the service source data of the data provider corresponding to the timer is acquired.

[0106] Each module in the above table generation device can be implemented in whole or in part by software, hardware, or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module.

[0107] In an exemplary embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be shown in FIG5. The computer device includes a processor, a memory, an input / output interface (Input / Output, referred to as I / O) and a communication interface. The processor, the memory and the input / output interface are connected via a system bus, and the communication interface is connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used to store data. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal via a network connection. When the computer program is executed by the processor, a table generation method is implemented.

[0108] In an exemplary embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be shown in FIG6. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit, and an input device. The processor, the memory, and the input / output interface are connected via a system bus, and the communication interface, the display unit, and the input device are connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner may be implemented through WIFI, a mobile cellular network, NFC (near field communication) or other technologies. When the computer program is executed by the processor, a table generation method is implemented. The display unit of the computer device is used to form a visually visible picture, which may be a display screen, a projection device, or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0109] Those skilled in the art will understand that the structures shown in FIGS. 5 and 6 are merely block diagrams of partial structures related to the scheme of the present application, and do not constitute a limitation on the computer device to which the scheme of the present application is applied. The specific computer device may include more or fewer components than those shown in the figures, or combine certain components, or have a different arrangement of components.

[0110] In one embodiment, a computer device is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above method embodiments when executing the computer program.

[0111] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.

[0112] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0113] It should be noted that the data involved in this application (including but not limited to data used for analysis, stored data, displayed data, etc.) are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0114] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetoresistive random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, etc., but are not limited to this.

[0115] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0116] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A table generation method, characterized in that: The method comprises: When the current time reaches the preset collection time, the business source data of each data provider is obtained; Determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider; A business table matching the table configuration data is generated according to table configuration data of different business tables, each business entity and business indicator data of each business entity; the entity types of the business entities and the indicator types of the business indicators in the different business tables are different.

2. The method according to claim 1, characterized in that The determining, based on the business source data of each data provider, at least one business entity and at least one business indicator data of the corresponding business entity comprises: Extracting at least one business entity from the business source data of each data provider; For each business entity, according to a preset indicator type, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity.

3. The method according to claim 2, characterized in that The extracting, according to the preset indicator type, business indicator data matching the indicator type from the business source data corresponding to the business entity includes: Determine a data provider of the business source data corresponding to the business entity; Determining an indicator extraction method for the business indicator according to a provider type of the data provider and a preset indicator type; Based on the indicator extraction method, business indicator data matching the indicator type is extracted from the business source data corresponding to the business entity.

4. The method according to claim 1, characterized in that: The table configuration data includes at least one entity type of a business entity and at least one indicator type of a business indicator; the generating of a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity includes: For each business table's table configuration data, according to the entity type in the table configuration data, select a target entity that matches the entity type from each business entity; For each target entity, according to the indicator type in the table configuration data, a target indicator matching the indicator type is selected from the business indicators corresponding to the target entity; A business table matching the table configuration data is generated according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator.

5. The method according to claim 4, characterized in that The generating a business table matching the table configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator includes: Generate an initial table matching the grid configuration data according to the business source data corresponding to the target entity and the business indicator data corresponding to the target indicator; Verifying the integrity of the table content of the initial table; When the integrity verification is passed, the initial table is used as a business table matching the table configuration data.

6. The method according to claim 1, characterized in that When the current time reaches the preset collection time, the business source data of each data provider is obtained, including: Monitor the current timing of the timer corresponding to each data provider; When the current timing moment of the timer reaches the preset collection moment, the service source data of the data provider corresponding to the timer is obtained.

7. A table generating device, characterized in that: The device comprises: A data acquisition module is used to acquire the business source data of each data provider when the current time reaches the preset collection time; A data determination module, used to determine at least one business entity and at least one business indicator data of the corresponding business entity according to the business source data of each data provider; The table generation module is used to generate a business table matching the table configuration data according to the table configuration data of different business tables, each business entity and the business indicator data of each business entity; the entity types of the business entities and the indicator types of the business indicators in the different business tables are different.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images