CN117056414A

CN117056414A - Method, system, computer and storage medium for rapidly displaying data

Info

Publication number: CN117056414A
Application number: CN202311011203.6A
Authority: CN
Inventors: 张霞
Original assignee: Ping An Bank Co Ltd
Current assignee: Ping An Bank Co Ltd
Priority date: 2023-08-11
Filing date: 2023-08-11
Publication date: 2023-11-14

Abstract

The application relates to the technical field of computers, in particular to a method, a system, a computer and a storage medium for rapidly displaying data, wherein the method comprises the following steps: acquiring system table parameters, wherein the system table parameters are generated by a rear end based on a system table in a database; generating an interface data script based on the system table parameters and a preset script template; transmitting the interface data script to a rear end; and if the interface data script of the rear end passes, generating a display interface based on the interface data script to display corresponding data. The application can improve the efficiency of the developer and display the data more quickly.

Description

Method, system, computer and storage medium for rapidly displaying data

Technical Field

The present application relates to the field of computer technologies, and in particular, to a method, a system, a computer, and a storage medium for quickly displaying data.

Background

With the development of big data technology, data-related processing work has gradually been transferred from a traditional database to a big data environment. Traditional Mysql and Oracle scripts are gradually replaced by HiveSql, sparkSql, and the large data environment is favored by data developers due to the advantages of simplicity in development, strong reusability, high efficiency and the like.

Because the security and stability of data are required to be ensured in the field of financial science and technology, a traditional database is used for storing and using business data, and although the data processing process is transferred to a big data environment, the data display process still needs to be developed based on the traditional database. While conventional databases are limited by database version, single function, complex business requirements, etc., a large number of codes may need to be written to implement a simple presentation page. How to display data quickly is a problem which needs to be solved at present.

Disclosure of Invention

In view of the above, the present application provides a method, system, computer and storage medium for fast data presentation.

The embodiment of the application provides a method for rapidly displaying data, which comprises the following steps:

acquiring system table parameters, wherein the system table parameters are generated by a rear end based on a system table in a database;

generating an interface data script based on the system table parameters and a preset script template;

transmitting the interface data script to a rear end;

and if the interface data script of the rear end passes, generating a display interface based on the interface data script to display corresponding data.

Further, in the method for rapidly displaying data, the generating an interface data script based on the system table parameters and a preset script template includes:

generating and displaying an interface based on the system table parameters and a preset script template;

receiving configuration parameters input by configuration personnel;

and generating an interface data script based on the configuration parameters, the system table parameters and the preset script template.

Further, in the method for rapidly displaying data, the method further includes:

acquiring a newly created display configuration table in a database;

and after the interface data script of the database passes, storing the configuration parameters into the display configuration table.

Further, in the method for quickly displaying data, the configuration parameters include at least one selected system table and associated fields, and the method further includes:

when the type of the system table is greater than 1, generating corresponding type conversion data according to the at least one system table and the associated field, and updating the configuration table based on the type conversion data.

Further, in the method for quickly displaying data, the configuration parameters include a configuration table name, a configuration field, and a configuration field type.

if the interface data script of the database does not pass, generating bullet box information to instruct configuration personnel to reconfigure parameters and submit the parameters.

and after the interface data script of the database passes, generating a configuration script based on the configuration parameters, and storing the configuration script into the database.

Another embodiment of the present application further provides a rapid data display system, including:

the system table parameter generation unit is used for generating system table parameters according to the system table parameters in the database;

the generation unit is used for generating an interface data script based on the system table parameters and a preset script template;

the transmission unit is used for transmitting the interface data script to the rear end;

and the display unit is used for generating a display interface based on the interface data script to display corresponding data if the interface data script at the rear end passes.

Another embodiment of the present application further provides a computer device, including a storage unit and a processing unit, where the storage unit stores a computer program, and the processing unit executes the steps of the method for quickly displaying data by calling the computer program stored in the storage unit.

Another embodiment of the present application also proposes a computer readable storage medium storing a computer program adapted to be loaded by a processor for performing the steps of the method for fast presentation of data described above.

The embodiment of the application has the following beneficial effects:

the embodiment of the application provides a data display method, which comprises the steps of obtaining a database system table and generating corresponding system table parameters, then generating an interface data script based on the system table parameters and a preset script template, transmitting the interface data script to a database for verification, and generating a display interface based on the interface data script to display corresponding data if the verification is passed. The scheme not only can enable developers to more conveniently conduct related operations of display data, but also improves development efficiency and reduces labor cost.

Drawings

In order to more clearly illustrate the technical solutions of the present application, the drawings that are required for the embodiments will be briefly described, it being understood that the following drawings only illustrate some embodiments of the present application and therefore should not be considered as limiting the scope of the present application. Like elements are numbered alike in the various figures.

FIG. 1 is a schematic diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 2 is a first flow diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 3 illustrates an interface diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 4 is a second flow diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 5 illustrates a third flow diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 6 is a fourth flow diagram of a method for rapid presentation of data according to some embodiments of the application;

FIG. 7 is a fifth flow chart of a method for rapid presentation of data according to some embodiments of the application;

fig. 8 is a schematic diagram of a data quick presentation system according to some embodiments of the present application.

Detailed Description

The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments.

The components of the embodiments of the present application generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations. Thus, the following detailed description of the embodiments of the application, as presented in the figures, is not intended to limit the scope of the application, as claimed, but is merely representative of selected embodiments of the application. All other embodiments, which can be made by a person skilled in the art without making any inventive effort, are intended to be within the scope of the present application.

The terms "comprises," "comprising," "including," or any other variation thereof, are intended to cover a specific feature, number, step, operation, element, component, or combination of the foregoing, which may be used in various embodiments of the present application, and are not intended to first exclude the presence of or increase the likelihood of one or more other features, numbers, steps, operations, elements, components, or combinations of the foregoing.

Furthermore, the terms "first," "second," "third," and the like are used merely to distinguish between descriptions and should not be construed as indicating or implying relative importance.

Unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which various embodiments of the application belong. The terms (such as those defined in commonly used dictionaries) will be interpreted as having a meaning that is the same as the context of the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein in connection with the various embodiments of the application.

Some embodiments of the present application are described in detail below with reference to the accompanying drawings. The embodiments described below and features of the embodiments may be combined with each other without conflict.

Typically, when a developer needs to make a data presentation, a large number of scripts need to be written to implement a simple page presentation, which undoubtedly increases the workload of the developer.

In addition, the codes written by the scheme in the prior art cannot be stored in the database and are only configured into the back-end codes, the back-end codes cannot be conveniently and rapidly modified at any time and any place and cannot be separated from the database, so that the later maintenance cost is increased. In addition, if the requirement development is to be completed, only the database personnel can carry out coding, and other personnel cannot participate in the coding due to the technical problem, so that the application range is narrow.

Accordingly, in order to solve the above-mentioned problems, the present application provides a method, system, computer and storage medium for fast data presentation suitable for use in the field of financial technology or other related fields.

Referring to fig. 1, a schematic structural diagram of a method for quickly displaying data according to an embodiment of the present application is shown. The method for rapidly displaying the data is applied to computers, such as front-end computers and back-end computers for developing financial business applications.

In some embodiments, as shown in fig. 2, a method for rapidly presenting data includes:

s110, acquiring system table parameters, wherein the system table parameters are generated by the back end based on the system table in the database.

Specifically, the front end, the back end and the server are used as a complete system, and the back end acquires the system table in the database and extracts the system table parameters in the system table. The system data table is a special table in the database system and is used for storing metadata information of various objects in the database, such as tables, columns, indexes, views, storage processes, triggers and the like. The system table provides the infrastructure of a database management system (DBMS) that allows users and developers to query, examine, and update metadata of the database. The querying and use of system tables may be implemented using SQL statements. For example, the SELECT statement may be used to retrieve table and column information from the system table, the ALTER statement may be used to modify table and column attribute information, the GRANT and revole statements may be used to GRANT or REVOKE access rights for the user, and so on.

The system table parameters comprise parameters required by automatically generating query codes, such as table names, field types and the like. The system tables in different databases are different, the system tables are automatically generated when the database is built, and the attributes of all tables in the database, including table names, field types and the like, are recorded.

S210, generating an interface data script based on the system table parameters and a preset script template.

Specifically, the interface data script is a data script corresponding to an interface to be displayed at the front end, and according to the interface data script, the corresponding interface can be displayed, including data fields (such as fields of order date, customer name, sales number, product name, etc.) in various financial services to be displayed in the interface, various buttons to be displayed in the interface, and a form template for statistics of various data fields, etc. The preset script template is a template of a preset script, and an interface data script can be generated according to the script template and selected parameters.

Illustratively, if the table selected by the configurator is table a, the selected data fields are the date ordered, customer name, product name, sales quantity, and total sales amount. The buttons configured by the configuration personnel comprise buttons for inquiring, adding, printing, deriving and the like, and the interface finally displayed is the interface shown in fig. 3.

Alternatively, the script templates may not be preset, and different interface data scripts may be generated by using different script templates according to the selection made by the configurator. Specifically, the front end displays a script template frame for selecting and using before displaying the initial interface, and any script template can be selected in the frame. When the configurator selects, the subsequent operation is continued according to the script template selected by the configurator, which is not described in detail herein.

In the method for quickly displaying data in some embodiments, as shown in fig. 4, generating an interface data script based on system table parameters and a preset script template includes:

s211, generating and displaying an interface based on the system table parameters and a preset script template.

Specifically, according to the system table parameters and the preset script template, an initial interface is generated and displayed for a configurator to select various parameters required by the interface, wherein the configuration parameters comprise configuration table names, configuration fields, configuration field types, various table names, fields and other input boxes required to be displayed, and various table templates, buttons and addresses associated with the buttons.

S212, receiving configuration parameters input by a configuration personnel.

S213, generating an interface data script based on the configuration parameters, the system table parameters and the preset script template.

Specifically, after the initial interface is displayed, a configurator inputs configuration parameters, a front end receives the configuration parameters input by the configurator, acquires system table parameters and a preset script template transmitted by a rear end, and then generates a corresponding interface data script according to the acquired configuration parameters, the system table parameters and the preset script template.

And S310, transmitting the interface data script to the back end.

Specifically, in order to verify the correctness and the feasibility of the interface data script, the interface data script needs to be transmitted to a back end for verification, and the back end transmits the interface data script to a database for compiling, so that the correctness of codes in the interface data script is verified.

S410, if the interface data script at the back end passes, generating a display interface based on the interface data script to display corresponding data.

Specifically, when the interface data script passes verification, the back end transmits the verified information to the front end, and after the current end receives the verified information, a display interface is generated based on the interface data script to display corresponding data.

In some embodiments, as shown in fig. 5, the method for rapidly presenting data further includes:

s411, acquiring a newly created display configuration table in the database.

In particular, to facilitate the configurator's ability to reuse the same configured parameters, the system or configurator may create a new presentation configuration table in the database.

S412, after the interface data script of the database passes, the configuration parameters are stored in the display configuration table.

Specifically, each time the interface data script passes, the configuration parameters are stored in the display configuration table to finish storing the parameters configured by the current configuration personnel.

In some embodiments, as shown in fig. 6, the method for rapidly presenting data further includes:

s510, after the interface data script of the database passes, generating a configuration script based on the configuration parameters, and storing the configuration script into the database.

Specifically, when the information of the current configuration needs to be reused later, more time is not needed to reconfigure again, and the display configuration table with the same parameters stored before configuration is directly called. And simultaneously, the script after successful configuration is downloaded from the database by the user.

Further, in order to facilitate storage, the configuration table needs to be split and then stored, and each split fragment data has associated data. Thus, when needed, the data can be searched and combined into a complete configuration table according to the associated data. For splitting, because each configuration table has repeated data, if the same data in the database is stored multiple times, the proportion of repeated data in the huge amount of data will be very high, so that the storage inefficiency of the database will be reduced.

For example, if the configuration table a contains the data a1, a2, a3, B1, B2, and B3, and the configuration table B contains the data a1, a2, a3, B1, C2, and C3, the configuration table C contains the data a1, a2, a3, B1, C1, and C3, and if the configuration tables A, B and C are stored completely, they are not stored separately. Assuming that the number of occupied spaces of each data is 1, the data a1 occupies 3 memory spaces, a2 occupies 3 memory spaces, a3 occupies 3 memory spaces, b1 occupies 3 memory spaces, b2 occupies 1 memory space, b3 occupies 1 memory space, c1 occupies 1 memory space, c2 occupies 1 memory space, and c3 occupies 2 memory spaces, so that 18 total data are required. If the data are split, the data a1, a2, a3, b1, b2, b3, c1, c2 and c3 occupy only one space, and the association relationship between the data of each configuration table occupies a certain space. Therefore, if the space occupied by the relation is not considered, the space is saved by 12. And more space will be saved for a huge database.

In the method for quickly presenting data of some embodiments, the configuration parameters include at least one selected system table and associated fields, and the method further includes:

when the category of the system table is greater than 1, corresponding type conversion data is generated according to at least one system table and the associated field, and the configuration table is updated based on the type conversion data.

Specifically, the data stored in a general system table is an entity object, and there are some relations between the objects, and these relations are basically represented by association fields in the table design.

When the user configures parameters, different system tables can be selected for configuration, fields in the different system tables can be associated to obtain associated fields, and because the types of the fields comprise numerical value-to-character, character-to-numerical value, character-to-time, time-to-character and the like, the conversion of the field types can be involved in the data indexing, and the codes converted by the field types are used as type conversion data. And updating data at the corresponding type conversion location in the configuration table based on the type conversion data.

The field type is required to be converted because in MySQL (relational database management system), index failure may be caused if the associated field type used in multi-table association is different. This is because the index of MySQL is created based on the type of field, and if the associated field types used in the two tables are different, the MSQL cannot use the index to optimize the query. This results in slower execution of the query and also increases the load on the server and therefore should be ensured as much as possible that the type of association field used in both tables is the same when performing multi-table association. If it is different, then a conversion function is required to convert one of the fields to the type of the other field so that MySQL can use the index to optimize the query.

For example, assuming that 3 tables are financial commodity tables, the first table includes commodity names and commodity correspondence unique numbers of various commodities, the second table includes commodity price and commodity correspondence unique numbers of each commodity, and the third table includes commodity sales number and commodity correspondence unique numbers of each commodity, the 3 tables are correlated with each other and correlated by the unique numbers of the commodities. However, since the fields in each table correspond to field types, it is also necessary to generate corresponding type conversion data to update the configuration table.

In some embodiments, as shown in fig. 7, the method for rapidly presenting data further includes:

and S610, if the interface data script of the database does not pass, generating bullet box information to instruct configuration personnel to reconfigure parameters and submit the parameters.

Specifically, if the interface data script fails, it indicates that the configuration is wrong, and a configuration personnel is required to reconfigure the configuration.

The mode that a developer needs to write the sql script in the database is converted into the mode that the code configuration is carried out on the front-end interface, and in the mode, all operations can be completed on the front-end interface without writing a large number of codes which need to be written due to code normalization, and the developer only needs to select table names and field names, so that the development efficiency is greatly improved.

After the script development is improved by the scheme, the efficiency of developers is improved, and various business requirements can be completed on the premise of not modifying front and back ends and database codes. The related script code configuration is also stored in the database, so that the situation of script loss is not worried. If the business requirement is modified, the updating operation can be directly carried out on the front-end interface, the back-end external code does not need to be additionally modified, the data in the database does not need to be manually updated, a new version does not need to be released, and the association with the application version is reduced besides the version.

For business personnel with insufficient development experience, the database script can be configured at the front end, what fields are required to be displayed, and what fields are configured, so that various custom requirements of the business are completely realized.

Another embodiment of the present application further proposes a rapid data presentation system 700, as shown in fig. 8, the system 700 includes:

an obtaining unit 710, configured to obtain system table parameters, where the system table parameters are generated by the backend base system table in the database.

And the generating unit 720 is configured to generate an interface data script based on the system table parameters and the preset script template.

And the transmission unit 730 is configured to transmit the interface data script to the back end.

And the display unit 740 is configured to generate a display interface based on the interface data script to display the corresponding data if the interface data script at the back end passes.

It will be appreciated that the method steps of the present embodiment correspond to the data quick display method in the above embodiment, where the options of the data quick display method are equally applicable to the present embodiment, and will not be repeated here.

In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flow diagrams and block diagrams in the figures, which illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

In addition, functional modules or units in various embodiments of the application may be integrated together to form a single part, or the modules may exist alone, or two or more modules may be integrated to form a single part.

The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a smart phone, a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.

The foregoing is merely illustrative of the present application, and the present application is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present application.

Claims

1. A method for rapid presentation of data, comprising:

transmitting the interface data script to a rear end;

2. The method for quickly displaying data according to claim 1, wherein the generating an interface data script based on the system table parameters and a preset script template includes:

receiving configuration parameters input by configuration personnel;

3. The method for rapid presentation of data according to claim 2, further comprising:

acquiring a newly created display configuration table in a database;

4. A method of rapid presentation of data according to claim 3 wherein the configuration parameters include at least one selected system table and associated fields, the method further comprising:

5. The method for quickly presenting data according to claim 2, wherein the configuration parameters include a configuration table name, a configuration field, and a configuration field type.

6. The method for rapid presentation of data according to claim 2, further comprising:

7. The method for rapid presentation of data according to claim 2, further comprising:

8. A rapid data presentation system, comprising:

9. A computer device comprising a storage unit in which a computer program is stored and a processing unit which performs the steps of the method for rapid presentation of data according to any one of claims 1 to 7 by invoking the computer program stored in the storage unit.

10. A computer-readable storage medium, characterized in that it stores a computer program adapted to be loaded by a processor for performing the steps of the method for fast presentation of data according to any of claims 1 to 7.