1. A quick generation method of a visual page is characterized by comprising the following steps:

acquiring original data to be stored in a database;

classifying the original data according to a preset classification rule;

converting the original data into a first data table according to the classified category;

saving the first data table to a cache folder;

establishing a first data mapping table which stores the position corresponding relation between the first data table and the original data;

according to the first data mapping table and preset visualization rules, target original data of a target category are inquired in the first data table, and the target original data are generated into a visualization page through a preset interface.

2. The method for rapidly generating a visualization page according to claim 1, wherein the querying, according to the first data mapping table, target raw data of a target category in the first data table, and generating a visualization page from the target raw data through a preset interface according to a preset visualization rule includes:

when request information for generating a visual page is received, the first data table is obtained from the cache folder according to the first data mapping table;

obtaining a target category according to a preset visualization rule;

inquiring whether the first data table contains the target category or not according to the first data mapping table;

and when the first data table contains the target category, generating target original data corresponding to the target category into a visual page through a preset interface.

3. A method for rapid generation of a visualization page as recited in claim 2, wherein when the first data table does not contain the object category, the method further comprises:

newly building an asynchronous task, and extracting target original data corresponding to the target category from the database;

converting the target raw data into a second data table;

saving the second data table to the cache folder;

and adding the position corresponding relation between the second data table and the target original data into the first data mapping table.

4. A method for the rapid generation of visualization pages as claimed in claim 2, wherein said object categories comprise a time dimension and an index category;

when the first data table contains the target category, generating a visual page by using the target raw data corresponding to the target category through a preset interface, wherein the visual page comprises:

acquiring time data corresponding to the time dimension;

acquiring index data corresponding to at least one index type;

generating an intermediate table by using the acquired time data and the index data;

and generating a visual page from the intermediate table through a preset interface.

5. A method for the rapid generation of visualization pages as claimed in claim 1,

a data bypass is arranged in front of the database;

the acquiring of the original data to be stored in the database includes:

and acquiring a copy of the original data through the data bypass, and taking the copy of the original data as the original data needing to be stored in a database.

6. A method for the rapid generation of visualization pages as claimed in claim 1, further comprising:

obtaining incremental data of the original data;

classifying the incremental data according to the preset classification rule;

looking up whether the first data table with the same target category exists in the first data mapping table;

if the first data table with the same target category exists, writing the classified incremental data into the first data table to generate a third data table;

and adding the position corresponding relation between the third data table and the incremental data into the first data mapping table.

7. The method for rapidly generating a visualization page according to claim 2, wherein the querying the target category from the first data table according to the preset visualization rule comprises: querying, by a virtual machine, the first data table for a target category;

when the request information for generating the visual page is received, the first data table is obtained from the cache folder, and the method comprises the following steps: and acquiring the first data table from the cache folder through the virtual machine.

8. An apparatus for rapidly generating a visual page, comprising:

the original data acquisition module is used for acquiring original data needing to be stored in a database;

the original data classification module is used for classifying the original data according to a preset classification rule;

the original data conversion module is used for converting the original data into a first data table according to the classified categories;

the data table storage module is used for storing the first data table into a cache folder;

the first data mapping table establishing module is used for establishing a first data mapping table which stores the position corresponding relation between the first data table and the original data;

and the visual page generation module is used for inquiring target original data of a target category in the first data table according to the first data mapping table and a preset visual rule, and generating a visual page from the target original data through a preset interface.

9. A computer device comprising a memory, a processor and a computer program stored in said memory and executable on said processor, characterized in that said processor, when executing said computer program, implements the steps of a method for the rapid generation of visualization pages as claimed in any one of claims 1 to 7.

10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of a method for the rapid generation of visualization pages according to any one of claims 1 to 7.

Background

At present, in order to give more personalized choices to users, more and more data is contained in orders used by enterprises, and the orders are stored in databases of the enterprises. On the other hand, big data is also gaining importance in each enterprise, and workers in the enterprise often need to analyze orders accumulated in sales of the enterprise to get past performance trend and to make reference for future policy making.

However, the requirement for big data analysis makes the performance requirement for the database higher and higher, and especially in the task of generating a statistical table in real time and the like, the database is greatly loaded. If the data volume is too large, the time is too long when the data is loaded each time, and even the data cannot be loaded.

Disclosure of Invention

The embodiment of the invention provides a method and a device for quickly generating a visual page, computer equipment and a storage medium, and aims to solve the problem that a database is greatly loaded when tasks such as generating a statistical table in real time and the like are performed.

In a first aspect of the present invention, a method for quickly generating a visual page is provided, including:

acquiring original data to be stored in a database;

classifying the original data according to a preset classification rule;

converting the original data into a first data table according to the classified category;

saving the first data table to a cache folder;

establishing a first data mapping table which stores the position corresponding relation between the first data table and the original data;

according to the first data mapping table and preset visualization rules, target original data of a target category are inquired in the first data table, and the target original data are generated into a visualization page through a preset interface.

In a second aspect of the present invention, an apparatus for quickly generating a visual page is provided, including:

the original data acquisition module is used for acquiring original data needing to be stored in a database;

the original data classification module is used for classifying the original data according to a preset classification rule;

the original data conversion module is used for converting the original data into a first data table according to the classified categories;

the data table storage module is used for storing the first data table into a cache folder;

the first data mapping table establishing module is used for establishing a first data mapping table which stores the position corresponding relation between the first data table and the original data;

and the visual page generation module is used for inquiring target original data of a target category in the first data table according to the first data mapping table and a preset visual rule, and generating a visual page from the target original data through a preset interface.

In a third aspect of the present invention, a computer device is provided, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor implements the steps of the above method for quickly generating a visual page when executing the computer program.

In a fourth aspect of the present invention, a computer-readable storage medium is provided, which stores a computer program, which when executed by a processor implements the steps of the above-mentioned method for fast generation of a visualized page.

According to the method and the device for quickly generating the visual page, the computer equipment and the storage medium, the original data needing to be input into the database can be classified according to the preset rules, the classified data are converted into the first data table, then the first data table is stored in the cache folder, and the first data mapping table storing the relation between the position of the first data table and the original data is established. Through the first data table and the first data mapping table generated in the steps, when an analyst analyzes data, the analyst can quickly generate a visual table according to the dimension type selected by the analyst according to the self requirement through the prestored first data table and the first data table recorded with time and data dimensions. In addition, if the original data is needed to be subjected to additional analysis, the needed dimension types can be quickly acquired from the first data table and the first data mapping table again, and the visual page is generated without being extracted from the database again, so that the load of the database is reduced.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the description of the embodiments of the present invention will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without inventive labor.

FIG. 1 is a schematic diagram of an application environment of a method for quickly generating a visual page according to an embodiment of the present invention;

FIG. 2 is a flowchart of a method for fast generation of a visualization page according to an embodiment of the present invention;

FIG. 3 is a flow chart of a method for rapid generation of a visualization page in another embodiment of the invention;

FIG. 4 is a flow chart of a method for rapid generation of a visualization page in another embodiment of the present invention;

FIG. 5 is a schematic structural diagram of an apparatus for rapidly generating a visualization page according to an embodiment of the present invention;

FIG. 6 is a schematic diagram of a computer device according to an embodiment of the invention.

Detailed Description

The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

The method for rapidly generating the visual page provided by the application can be applied to an application environment as shown in fig. 1, wherein the computer device communicates with the server through a network. The computer device may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, among others. The server may be implemented as a stand-alone server or as a server cluster consisting of a plurality of servers.

In an embodiment, as shown in fig. 2, a method for quickly generating a visualization page is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps: the proposal provides a method for quickly generating a visual page, which comprises the following steps:

s1: acquiring original data required to be stored in a database.

Specifically, the raw data refers to raw data for each dimension of the report, such as the policy data and the information included therein, and may specifically be the amount of the policy, the user information, and the like.

S2: and classifying the original data according to a preset classification rule.

Specifically, in order to generate a final visual report, the raw data needs to be classified according to a preset rule, in a specific embodiment, the classification may be to extract policy data in a certain time period, and then further extract a plurality of required dimensions in the policy data, for example, dimension data in terms of money amounts such as premium and premium, and dimension data of customer information including application time, application duration, version, risk type, age area, policy type, and the like, where the specific setting may be selected by an analyst. Meanwhile, the classification also comprises a splitting operation, namely, all dimensions contained in one policy are split according to the requirements of analysts, and the split dimension data are used in the subsequent steps.

S3: and converting the original data into a first data table according to the classified category.

Specifically, after splitting the dimension data of the original data according to the preset rule, the dimension data of the original data is converted into first table data, the first table data is a data table formed by recombining the split dimensions according to the requirements of an analyst, and specifically, a data table file with at least two dimensions is generated.

S4: and saving the first data table to a cache folder.

Specifically, the file of the first data table generated through the above steps is stored in the cache folder, that is, when called later, the generated data table can be called directly from the above folder without retrieving the needed dimension from the database and generating the data table. It should be noted that the above-mentioned cache folder is not limited to a single folder, and may be one or more folders.

S5: and establishing a first data mapping table which stores the position corresponding relation between the first data table and the original data.

Specifically, in order to enable the system to quickly find the corresponding data table, a first data mapping table between the location where the first data table is stored and the original data is also established, where the first data mapping table describes the storage location of the first data table in the cache folder, and which dimensions of data in the original data are specifically included in the first data table, and an analyst may directly find the corresponding first data table from the first data mapping table according to own needs.

S6: according to the first data mapping table and preset visualization rules, target original data of a target category are inquired in the first data table, and the target original data are generated into a visualization page through a preset interface.

Specifically, according to a target category required by an analyst, according to a first data mapping table and a preset visualization rule, target original data of the required target category are inquired in a classified first data table, and then the found original data are generated into a visualization page through a preset software interface.

Further, both the first data table and the second data table are preferably in an Excel file format, that is, the first data table is a first Excel file, and the second data table is a second Excel file. The Excel file format is the most used data table format at present, and is good in universality and convenient for analysts to use, so that the learning cost of the analysts can be greatly reduced by using the Excel file format in certain use scenes in which the data of the data table needs to be modified.

Specifically, since there are many software suites/interfaces on the market at present that can output the Excel file format as a visualized page, selecting the Excel file format as the file format for storing the data table can directly match the existing software suite/interface by utilizing the universality of the Excel file format, for example, by combining the microsoft office software function and the page, rapid page visualization is realized, and a web page or a document that can be used for data analysis is generated.

In some other embodiments, the data table may be in other data table file formats, such as CSV, JSON, XML, and the like.

The visualization rules comprise a displayed time dimension, a displayed data dimension and a display mode, wherein the display mode specifically comprises a digital list, a dot diagram, a linear diagram, a bar diagram and/or a pie diagram. The content contained in the visualization rule can be formulated by an analyst, so that the analyst can analyze the data in a more intuitive mode.

In addition, according to actual service requirements and available resources of the whole system, a plurality of asynchronous threads can be simultaneously set, namely, each asynchronous thread generates corresponding different first data tables according to different preset classification rules, so that analysts can analyze among the tables of a plurality of different dimensional data combinations, and the analysis efficiency is further improved.

The method for quickly generating the visual page provided by the invention can classify the original data needing to be input into the database according to the preset rule, convert the classified data into the first data table, store the first data table into the cache folder, and establish the first data mapping table storing the relationship between the position of the first data table and the original data. Through the first data table and the first data mapping table generated in the steps, when an analyst analyzes data, the analyst can quickly generate a visual table according to the dimension type selected by the analyst according to the self requirement through the prestored first data table and the first data table recorded with time and data dimensions. In addition, if the original data is needed to be subjected to additional analysis, the needed dimension types can be quickly acquired from the first data table and the first data mapping table again, and the visual page is generated without being extracted from the database again, so that the load of the database is reduced.

In a specific embodiment, the querying, according to the first data mapping table, target raw data of a target category in the first data table, and generating, according to a preset visualization rule, a visualization page from the target raw data through a preset interface includes:

s501: when request information for generating a visual page is received, the first data table is obtained from the cache folder according to the first data mapping table;

s502: obtaining a target category according to a preset visualization rule;

s503: inquiring whether the first data table contains the target category or not according to the first data mapping table;

s504: and when the first data table contains the target category, generating target original data corresponding to the target category into a visual page through a preset interface.

Specifically, when receiving request information for an analyst to call a target data table to generate a visual page, the system first searches whether the target data table exists in the first data mapping table, and if the target data table exists in the first data mapping table, reads the target data table from a storage location of the target data table recorded in the first data mapping table, and then reads the target data table from the cache folder.

Then, whether the obtained first data table contains a target type required by an analyst, where the target type is included in the request information, is queried by the system whether the target type is recorded in the first data table, and if so, obtaining original target data corresponding to the target type, and then generating a visual page from the target original data through a preset software interface.

Therefore, when the target data table is called, an analyst can directly search the first data mapping table for whether the target data table exists or not and directly obtain the target data table without regenerating through a database, and the load of the system is reduced.

In a specific embodiment, the step of retrieving the target data table in the first data mapping table according to the received request information further includes:

s511: newly building an asynchronous task, and extracting target original data corresponding to the target category from the database;

s512: converting the target raw data into a second data table;

s513: saving the second data table to the cache folder;

s514: and adding the position corresponding relation between the second data table and the target original data into the first data mapping table.

Specifically, in some application scenarios, data analysis of the scenario may not be involved at first, and therefore, the target data table with the desired dimension cannot be retrieved in the first data mapping table, an asynchronous task is created, and the target data and the included dimensions are directly extracted from the database. In a preferred embodiment, the asynchronous task may extract the target data and the included dimensions from a backup database or the like that is not responsible for the primary storage.

Further, target data obtained from the database and various included dimensions are converted into a second data table, and the second table data is a data table formed by recombining the split dimensions according to the new data dimension requirement of an analyst, wherein the data dimension requirement is different from that of the first table data.

Further, the file of the second data table generated through the above steps is also stored in the cache folder, that is, the generated data table can be directly called from the above folder when called subsequently.

Further, the storage location of the file of the second data table generated in the above steps and which dimensions of the data in the original data are specifically included in the second data table are added to the original first data table, and thus the second data mapping table is generated. At this time, if the analyst needs to call the second data table again in the future, the analyst may directly search the corresponding second data mapping table from the newly generated second data mapping table.

And finally, generating a visualization page by the second data mapping table, and presenting the visualization page to an analyst.

In a specific embodiment, the target categories include a time dimension and an index category;

when the first data table contains the target category, generating a visual page by using the target raw data corresponding to the target category through a preset interface, wherein the visual page comprises:

s521: acquiring time data corresponding to the time dimension;

s522: acquiring index data corresponding to at least one index type;

s523: generating an intermediate table by using the acquired time data and the index data;

s524: and generating a visual page from the intermediate table through a preset interface.

Specifically, the target category further includes a time dimension and an index category, and the time dimension may be a time range of a period or a specific date. The index data is a policy index such as a premium, a version, a risk species, an age, a region, and/or a disease category of the policy. In a specific application scenario, the generated visualization page at least includes a time dimension and time data corresponding to the time dimension, and includes at least one index category and index data corresponding to the index category. After the time data and the index data are obtained, firstly, an intermediate table is generated, and then, the intermediate table is generated into a visual page through a preset software interface. In some optional embodiments, the intermediate table may also be stored first when the storage space allows, so that the intermediate table may be directly called again when needed in subsequent analysis, so as to improve the analysis efficiency.

In a specific embodiment, the method for quickly generating a visualization page further includes:

s531: obtaining incremental data of the original data;

s532: classifying the incremental data according to the preset classification rule;

s533: looking up whether the first data table with the same target category exists in the first data mapping table;

s534: if the first data table with the same target category exists, writing the classified incremental data into the first data table to generate a third data table;

s535: and adding the position corresponding relation between the third data table and the incremental data into the first data mapping table.

Specifically, since the data amount of the original data is continuously increased over time, in a specific embodiment, the incremental data generated after the first data table and the first data mapping table are generated can also be directly written into the first data table having the same preset classification rule through the above steps without creating a new first data table again.

Specifically, the incremental data of the original data, that is, the data newly added after the last execution of the method for quickly generating the visual page, is obtained first. After the incremental data are classified, whether a first data table with the same target type exists or not is searched in the first data mapping table, if yes, the classified incremental data can be directly written into the first data table, and a new third data table is generated. And finally, updating the position corresponding relation between the third data table and the incremental data in the first data mapping table.

In a specific embodiment, the querying the target category from the first data table according to the preset visualization rule includes: querying, by a virtual machine, the first data table for a target category;

when the request information for generating the visual page is received, the first data table is obtained from the cache folder, and the method comprises the following steps: and acquiring the first data table from the cache folder through the virtual machine.

Specifically, in order to further reduce the load of the system, the virtual machine searches the target data table from the first data mapping table, and if the target data table is searched, the virtual machine reads the target data table from the cache folder (i.e., the disk). Further, how many virtual machines need to be deployed can be determined by the number of analysts or the amount of data that needs to be analyzed. In the step S511, the virtual machine may be used to generate the second data table. Specifically, the virtual machine may be a Java Virtual Machine (JVM), which is essentially a program that, when started on a command line, begins executing instructions stored in a byte code file. The universality of the Java language is based on the Java virtual machine. Any platform can run on the platform as long as the Java virtual machine for the platform is installed, namely 'once compiling and multiple running'. The Java virtual machine is not only cross-platform software, but also a new network computing platform. The platform includes a number of related technologies such as various APIs, optimization techniques, etc. that conform to the open interface standard. Java technology enables the same application to run on different platforms. One solution to the overload of the database in the existing system is to give the pressure of part of the database to the JVM virtual machine for processing and give the data to the stream, and the solution is only affected by the network. Thereby forming a split of the database and reducing the cost of database construction and maintenance.

In a specific embodiment, the database is preceded by a data bypass;

the acquiring of the original data to be stored in the database includes:

and acquiring a copy of the original data through the data bypass, and taking the copy of the original data as the original data needing to be stored in a database.

Specifically, the steps of the method for rapidly generating a visual page may be performed asynchronously, for example, before the original data is entered into the database, a copy may be copied, and pushed to the system provided by the present invention through a bypass arranged before the database, and the copy is processed as the original data to be stored into the database in the subsequent steps, and then the processing steps of the data table are executed, and then the obtained first data table is stored in the cache for subsequent use.

It should be understood that, the sequence numbers of the steps in the foregoing embodiments do not imply an execution sequence, and the execution sequence of each process should be determined by its function and inherent logic, and should not constitute any limitation to the implementation process of the embodiments of the present invention.

In an embodiment, a device for quickly generating a visual page is provided, and the device for quickly generating a visual page corresponds to the method for quickly generating a visual page in the above embodiments one to one. As shown in fig. 5, the processing apparatus of the data table includes a raw data obtaining module 101, a raw data classifying module 102, a raw data converting module 103, a data table saving module 104, a first data mapping table establishing module 105, and a visualization page generating module 106. The functional modules are explained in detail as follows:

the original data acquisition module 101 is used for acquiring original data to be stored in a database;

the original data classification module 102 is configured to classify the original data according to a preset classification rule;

a raw data conversion module 103, configured to convert the raw data into a first data table according to the classified category;

a data table saving module 104, configured to save the first data table to a cache folder;

a first data mapping table establishing module 105, configured to establish a first data mapping table in which a position correspondence relationship between the first data table and the original data is stored;

the visualization page generating module 106 is configured to query target raw data of a target category in the first data table according to the first data mapping table and a preset visualization rule, and generate a visualization page from the target raw data through a preset interface.

In a specific embodiment, the visualized page generating module 106 includes:

the first data table obtaining unit is used for obtaining the first data table from the cache folder according to the first data mapping table when request information for generating a visual page is received;

the target category acquiring unit is used for acquiring a target category according to a preset visualization rule;

a target category querying unit, configured to query whether the first data table includes the target category according to the first data mapping table;

and the visual page generating unit is used for generating visual pages from the target original data corresponding to the target category through a preset interface when the target category is contained in the first data table.

In a specific embodiment, the apparatus for rapidly generating a visualization page further includes:

the target original data extraction module is used for newly building an asynchronous task and extracting target original data corresponding to the target category from the database;

the second data table conversion module is used for converting the target original data into a second data table;

the second data table caching module is used for saving the second data table to the caching folder;

and the first data mapping table updating module is used for adding the position corresponding relation between the second data table and the target original data into the first data mapping table.

In a specific embodiment, the target categories include a time dimension and an index category;

the visualization page generation unit comprises:

the time data acquisition unit is used for acquiring time data corresponding to the time dimension;

the index data acquisition unit is used for acquiring index data corresponding to at least one index type;

an intermediate table generating unit configured to generate an intermediate table from the acquired time data and the acquired index data;

and the middle table visualization unit is used for generating a visualization page from the middle table through a preset interface.

In a specific embodiment, the database is preceded by a data bypass,

the raw data acquisition module 101 includes:

and the original data copy acquisition module is used for acquiring the copy of the original data through the data bypass and taking the copy of the original data as the original data needing to be stored in a database.

In a specific embodiment, the apparatus for rapidly generating a visualization page further includes:

the incremental data acquisition module is used for acquiring incremental data of the original data;

the incremental data classification module is used for classifying the incremental data according to the preset classification rule;

the same target class searching module is used for searching whether the first data table with the same target class exists in the first data mapping table;

a third data table generating module, configured to, if there is the first data table with the same target category, write the sorted incremental data into the first data table, and generate a third data table;

and the incremental data updating module is used for adding the position corresponding relation between the third data table and the incremental data into the first data mapping table.

In a specific embodiment, the visualization page generation module 106 includes

A virtual machine query unit, configured to query, by a virtual machine, a target category in the first data table;

the first data table acquisition unit includes:

and the virtual machine acquisition unit acquires the first data table from the cache folder through a virtual machine.

Wherein the meaning of "first" and "second" in the above modules/units is only to distinguish different modules/units, and is not used to define which module/unit has higher priority or other defining meaning. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or modules is not necessarily limited to those steps or modules explicitly listed, but may include other steps or modules not explicitly listed or inherent to such process, method, article, or apparatus, and such that a division of modules presented in this application is merely a logical division and may be implemented in a practical application in a further manner.

For specific limitations of the processing device of the data table, reference may be made to the above limitations of the processing method of the data table, which are not described herein again. The respective modules in the processing device of the above data table may be wholly or partially implemented by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.

In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 6. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile 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 an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data involved in the processing method of the data table. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of processing a data table.

In one embodiment, a computer device is provided, which includes a memory, a processor and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the processor implements the steps of the method for processing a data table in the above embodiments, such as the steps S1 to S6 shown in fig. 2 and other extensions of the method and related steps. Alternatively, the processor, when executing the computer program, implements the functions of the modules/units of the processing apparatus of the data table in the above-described embodiment, for example, the functions of the modules 101 to 106 shown in fig. 5. To avoid repetition, further description is omitted here.

The Processor may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, etc. The general purpose processor may be a microprocessor or the processor may be any conventional processor or the like which is the control center for the computer device and which connects the various parts of the overall computer device using various interfaces and lines.

The memory may be used to store the computer programs and/or modules, and the processor may implement various functions of the computer device by running or executing the computer programs and/or modules stored in the memory and invoking data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, video data, etc.) created according to the use of the cellular phone, etc.

The memory may be integrated in the processor or may be provided separately from the processor.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the steps of the method for processing a data table in the above-described embodiments, such as the steps S1 through S6 shown in fig. 2 and extensions of other extensions and related steps of the method. Alternatively, the computer program realizes the functions of the modules/units of the processing apparatus of the data table in the above-described embodiment, for example, the functions of the modules 101 to 106 shown in fig. 5, when being executed by the processor. To avoid repetition, further description is omitted here.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.