CN107766309B

CN107766309B - Data table generation method and device, storage medium and electronic device

Info

Publication number: CN107766309B
Application number: CN201710759326.6A
Authority: CN
Inventors: 程雯; 廖力; 江烁; 龙赐
Original assignee: Tencent Technology Shenzhen Co Ltd
Current assignee: Tencent Technology Shenzhen Co Ltd
Priority date: 2017-08-29
Filing date: 2017-08-29
Publication date: 2021-06-25
Anticipated expiration: 2037-08-29
Also published as: CN107766309A

Abstract

The invention discloses a data table generating method and device, a storage medium and an electronic device. The method comprises the following steps: detecting a first touch operation in a client, wherein the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, and the first touch operation is used for indicating selection of the multiple dimensions; under the condition that a first touch operation is detected, acquiring cross data of any two dimensions of a plurality of dimensions; adding a plurality of dimensions into a table head cell of a data table, and adding cross data into a data cell which is crossed and corresponding to any two dimensions; and outputting the data table in the client, wherein the data table comprises a table head cell and a data cell. The invention solves the technical problem that the data analysis efficiency is low because the data are generally required to be exported from a database in order to realize the cross analysis of the data with different dimensions in the related art and then the exported data are manually generated into a data table for data cross analysis by using EXCEL.

Description

Data table generation method and device, storage medium and electronic device

Technical Field

The present invention relates to the field of computers, and in particular, to a data table generation method and apparatus, a storage medium, and an electronic apparatus.

Background

In data analysis, data is typically observed in a drill-down analysis and a user portrait analysis. The drill-down analysis checks the attenuation of data on a certain index path through a funnel model, the user portrait analysis shows the data distribution situation through each user attribute dimension, but for searching the heat distribution of big data and analyzing the distribution of any multiple index cross data, the user portrait analysis must rely on a complex data analysis tool to realize through code writing, and the cost is higher for general game operators, the effect is poor, and the efficiency is low.

At present, to realize cross analysis of two different dimensions, an ordinary person needs to export indexes from a database, and manually realize cross analysis in form software such as EXCEL by using the exported index intervals, so that the operation is complex, the use effect is poor, the ordinary analyst can make a form of two dimensions at most, the dimensions are increased, the making difficulty is increased, and the analysis efficiency is low.

In view of the above problems, no effective solution has been proposed.

Disclosure of Invention

The embodiment of the invention provides a data table generation method and device, a storage medium and an electronic device, and at least solves the technical problem that in order to realize cross analysis of data with different dimensions, data is generally required to be exported from a database in the related art, and then the exported data is manually generated into a data table to be subjected to data cross analysis by using EXCEL, so that the data analysis efficiency is low.

According to an aspect of an embodiment of the present invention, there is provided a data table generating method, including: detecting a first touch operation in a client, wherein the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, and the first touch operation is used for indicating selection of the multiple dimensions; under the condition that a first touch operation is detected, acquiring cross data of any two dimensions of a plurality of dimensions; adding a plurality of dimensions into a table head cell of a data table, and adding cross data into a data cell which is crossed and corresponding to any two dimensions; and outputting the data table in the client, wherein the data table comprises a table head cell and a data cell.

According to another aspect of the embodiments of the present invention, there is also provided a data table generating apparatus, including: the client side comprises a first detection unit, a second detection unit and a third detection unit, wherein the first detection unit is used for detecting a first touch operation in the client side, the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, and the first touch operation is used for indicating selection of the multiple dimensions; the second detection unit is used for acquiring cross data of any two dimensions in the multiple dimensions under the condition that the first touch operation is detected; the adding unit is used for adding a plurality of dimensions into a table head cell of the data table and adding cross data into a data cell which is crossed and corresponding to any two dimensions; the first output unit is used for outputting the data table in the client, wherein the data table comprises a table head cell and a data cell.

According to another aspect of the embodiments of the present invention, there is also provided a storage medium, where the storage medium includes a stored program, and the program executes any one of the data table generating methods in the embodiments of the present invention when running.

According to another aspect of the embodiments of the present invention, there is also provided an electronic apparatus, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor executes any one of the data table generating methods according to the embodiments of the present invention through the computer program.

In the embodiment of the invention, the data table has multiple dimensions, the first touch operation is used for requesting to generate the data table and indicating that multiple dimensions are selected, the touch operation is detected through the client, the cross data of any two dimensions in the multiple dimensions is acquired under the condition that the first touch operation is detected, then the multiple dimensions are added to the header cell of the data table, the cross data is added to the data cell corresponding to any two dimensions in a cross mode, then the data table comprising the header cell and the data cell is output in the client, the technical problem that in the related technology, in order to realize the cross analysis of data with different dimensions, data is generally required to be exported from a database, then the exported data is manually generated into the data table by using EXCEL to perform the data cross analysis, so that the technical problem of low data analysis efficiency is caused, and further, the cross analysis of the data with different dimensions is automatically performed, the technical effect of improving the data analysis efficiency is achieved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:

FIG. 1 is a schematic diagram of a hardware environment for a data table generation method according to an embodiment of the present invention;

FIG. 2 is a flow diagram of an alternative data table generation method according to an embodiment of the present invention;

FIG. 3 is a schematic diagram of an alternative multidimensional cross analysis data in accordance with an embodiment of the present invention;

FIG. 4 is a schematic diagram of an alternative data presentation scenario in accordance with an embodiment of the present invention;

fig. 5 is a schematic diagram of an alternative 100,000 rows by 100 columns data table according to an embodiment of the invention;

FIG. 6 is a first schematic view of an alternative manufacturing vessel according to embodiments of the invention;

FIG. 7 is a second schematic illustration of an alternative manufacturing vessel according to embodiments of the invention;

FIG. 8 is a third schematic view of an alternative manufacturing vessel according to embodiments of the invention;

FIG. 9 is a fourth schematic view of an alternative manufacturing vessel in accordance with embodiments of the invention;

FIG. 10 is a fifth schematic view of an alternative manufacturing vessel according to embodiments of the invention;

FIG. 11 is a schematic diagram of an alternative multi-layer header portion implementation in accordance with an embodiment of the present invention;

FIG. 12 is a schematic diagram of an alternative list head array in accordance with embodiments of the present invention;

FIG. 13 is a diagram of an alternative table final rendering effect according to an embodiment of the invention;

FIG. 14 is a first schematic diagram of an interface in an alternative interaction process, according to an embodiment of the invention;

FIG. 15 is a second schematic diagram of an alternative interface in an interactive process, according to an embodiment of the present invention;

FIG. 16 is a third schematic diagram of an interface in an alternative interaction process, according to an embodiment of the invention;

FIG. 17 is a fourth schematic view of an alternative interface in an interactive process, in accordance with embodiments of the present invention;

FIG. 18 is a fifth illustration of an interface in an alternative interaction process, according to an embodiment of the invention;

FIG. 19 is a schematic diagram of an alternative data table generating apparatus according to an embodiment of the present invention; and

fig. 20 is a block diagram of an electronic device according to an embodiment of the present invention.

Detailed Description

In order to make the technical solutions of the present invention better understood, 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 only a part of the embodiments of the present invention, and not all of the embodiments. 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.

It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. 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 elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

First, partial terms or terms appearing in the description of the embodiments of the present invention are applied to the following explanations:

a data storage end: a server or group of servers for storing data, in which database software is installed, and users store data.

The logic processing end: a server or group of servers for handling data interactions between clients and data stores.

A terminal: a home or personal computer.

A WEB browser: terminal software for browsing web pages.

A table tag: code labels for writing web pages are typically used for table drawing.

The div tag: the code tags used to write a web page are typically used for rectangular rendering of the web page.

Drill-down analysis: observing or adding new dimensions from summary data deep into detail data. For example, when the user analyzes "sales conditions of regions and cities", the sales of a certain city may be subdivided into sales of various years, and the sales of a certain year may be further subdivided into sales of various seasons. Through the drilling function, the user can more deeply understand the data, can more easily find problems and make correct decisions.

User portrait: a user representation is a tagged user model that is abstracted based on information such as user social attributes, lifestyle habits, and consumption behaviors. The core task in constructing a user representation is to label the user with a "tag", which is a highly refined feature identifier obtained by analyzing the user information.

Indexes are as follows: a social attribute, such as "age", "school calendar", "province", "gender", and the like.

Interval: the detailed information of the index includes, for example, ages of 1 to 10, 10 to 20, and 20 to 30 in the age range.

Dimension: the different names of the indexes refer to multi-indexes, and the multi-dimension refers to multi-indexes.

Example 1

According to an embodiment of the present invention, an embodiment of a data table generating method is provided.

Alternatively, in the present embodiment, the data table generating method described above may be applied to a hardware environment formed by the server 102 and the terminal 104 as shown in fig. 1. As shown in fig. 1, a server 102 is connected to a terminal 104 via a network including, but not limited to: the terminal 104 is not limited to a PC, a mobile phone, a tablet computer, etc. in a wide area network, a metropolitan area network, or a local area network. The data table generating method according to the embodiment of the present invention may be executed by the server 102, the terminal 104, or both the server 102 and the terminal 104. The data table generating method of the embodiment of the present invention executed by the terminal 104 may also be executed by a client installed thereon.

Fig. 2 is a flowchart of an alternative data table generation method according to an embodiment of the present invention, and as shown in fig. 2, the method may include the following steps:

step S202, detecting a first touch operation in a client, wherein the first touch operation is used for requesting to generate a data table, the data table has multiple dimensions, and the first touch operation is used for indicating that the multiple dimensions are selected;

step S204, acquiring cross data of any two dimensions in the multiple dimensions under the condition that the first touch operation is detected;

step S206, adding a plurality of dimensions into a table head cell of a data table, and adding cross data into a data cell which is crossed and corresponding to any two dimensions;

and step S208, outputting a data table in the client, wherein the data table comprises a table head cell and a data cell.

Through the above steps S202 to S208, the data table has multiple dimensions, the first touch operation is used to request generation of the data table and indicate selection of multiple dimensions, the touch operation is detected by the client, in the case that the first touch operation is detected, intersection data of any two dimensions of the multiple dimensions is obtained, then the multiple dimensions are added to the header cell of the data table, and the intersection data is added to the data cell corresponding to any two dimensions in an intersection manner, and then the data table including the header cell and the data cell is output in the client, which can solve the technical problem that in the related art, in order to implement intersection analysis of data of different dimensions, data is generally required to be exported from the database, and then the exported data generation data table is manually subjected to data intersection analysis by using the EXCEL, resulting in low data analysis efficiency, and further achieve the technical effect of automatically performing cross analysis on data with different dimensions.

In the technical solution provided in step S202, the client may be an application in a browser, or may be an application client. The first touch operation may be a drag operation of an index, and the user issues the first touch operation to request generation of the data table. The data table may have a plurality of dimensions, and the plurality of dimensions of the data table may be selected by the first touch manipulation.

In the technical solution provided in step S204, the intersection data of any two dimensions may be intersection data generated between two indexes, for example, in the case of counting the ages and gender distributions of people who sleep at eleven points in the southern mountain area, it is necessary to count a gender index and an age index, that is, two dimensions of gender and age, and the number of people with different genders at different ages is the intersection data of two dimensions, for example, the number of people who sleep at eleven points in the southern mountain area is 7859 people, and the intersection data of two dimensions of men and 40-50 years is 7859.

It should be noted that the cross data in the embodiment may be, but not limited to, data with two dimensions, for example, in the case of counting the age and gender distribution of the population sleeping at eleven points in the southern mountain area, the number of the men sleeping at eleven points in the southern mountain area is 7859, and then 7859 is the cross data, and the cross data includes the age dimension of "40-50 years" and the gender dimension of "men".

Alternatively, the intersection data in the embodiment may be, but is not limited to, data of intersection positions of columns where the transversely distributed headers are located and rows where the longitudinally distributed headers are located in the table.

For example, data C in which the column where the header a is located and the row where the header B is located intersect is intersection data, and two dimensions of the data C are dimensions represented by the header a and the header B, respectively.

Table 1 is an alternative data table according to the above embodiment of the present invention, as shown in Table 1, in which the Nth data table₁Line M₂Column data is C₂₂If the data C₂₂For interleaved data, the data C₂₂Are respectively of the Nth dimension₁Dimension represented by the head of the Row, and Mth₂The dimensions indicated by the list header.

Table 1:

	M₁	M₂
			N₁	C₁₁	C₁₂
N₂	C₂₁	C₂₂

optionally, the client may acquire intersection data of any two dimensions of the multiple dimensions when the first touch operation is detected.

In the technical solution provided in step S206, the data table includes a header cell portion and a data cell portion, and the header cell portion may be filled with indicators of data, for example, in the case of counting the age and gender distribution of the people who sleep at eleven points in the south mountain area, the header cell portion is filled with a gender indicator and an age indicator, for example, the head of the row table is filled with a gender indicator, "male", "female", and "unknown gender"; the age index is filled in the head of the list, for example, the age index is filled in the head of the list, "0 to 10 years old", "10 to 20 years old", "20 to 30 years old", "30 to 40 years old", "40 to 50 years old", and "50 to 60 years old". Filling a plurality of dimensions in a table head cell of the data table, and adding cross data into a data cell corresponding to any two dimensions in a cross mode, so that the data cell can represent the plurality of dimensions and the cross data of any two dimensions in the plurality of dimensions.

In the technical solution provided in step S208, the data table includes a header cell and a data cell, and after the multiple dimensions are added to the header cell and the cross data of any two dimensions are added to the data cell corresponding to the intersection of any two dimensions, the data table is output by the client, and the multiple dimensions and the cross data of any two dimensions are displayed.

As an alternative embodiment, outputting the data table in the client may include: determining target cells indicated by a transverse scroll bar and a longitudinal scroll bar in a client, wherein the transverse scroll bar is used for indicating column cells in a data table, the longitudinal scroll bar is used for indicating row cells in the data table, and the target cells are cells in which the column cells and the row cells are crossed; and outputting a target data table in the client, wherein the target data cell in the target data table takes the target cell in the data table as an initial data cell, the target header cell in the target data table is a header cell corresponding to the target data cell in the data table, the total width of the column cells in the target data table is less than or equal to the page width of the client, and the total height of the row cells in the target data table is less than or equal to the page height of the client.

By adopting the above embodiment of the present invention, the client page may include a horizontal scroll bar for indicating a column cell in the data table, and a vertical scroll bar for indicating a row cell in the data table; the cell where the column cell and the row cell intersect in the data table is a target cell; the target table head cell in the target data table takes the target cell in the data table as a starting cell; the target head cells in the target data table are the head cells corresponding to the target data cells in the data table; the total width of the column cells in the target data table is less than or equal to the page width of the client; the total height of the row cells in the target data table is less than or equal to the page height of the client, and then the target cells indicated by the horizontal scroll bar and the vertical scroll bar in the client are determined, and the target data table is output in the client, so that the data of part of tables in the data table can be displayed by scrolling the scroll bar in the client.

As an optional embodiment, the target header cells include a parent header cell and a child header cell, where the parent header cell includes at least one child header cell, and the child header cell is a header cell corresponding to the target data cell, and outputting the target data table in the client may include: determining the number of sub-level header cells belonging to the same parent-level header cell; and setting the total width of the number of the sub-level table head cells as the width of the same parent-level table head cell.

By adopting the above embodiment of the present invention, the target header cells include the parent header cells and the child header cells, where the parent header cells correspond to at least one child header cell, and each child header cell corresponds to a target data cell, and in the process of outputting the target data table in the client, the number of child header cells belonging to the same parent header cell may be determined first, and then the width of the parent header cell is determined to be the sum of the widths of a plurality of child header cells belonging to the parent header cell, so that the multiple stages of header cells may be displayed in the client.

As an optional example, the target header table includes two parent header cells, which are cell a and cell B, respectively, each parent header cell includes three child header cells, and the child header cells corresponding to cell a are cell a1, cell a2, and cell a3, respectively; the sub-level table head cells corresponding to the cell B are cell B1, cell B2 and cell B3 respectively. All the sub-level header cells are N, that is, the widths of the cell a1, the cell a2, the cell a3, the cell b1, the cell b2 and the cell b3 are N, so that the width of the cell a is the sum of the widths of the cell a1, the cell a2 and the cell a3, that is, the width of the cell a is 3N; the width of the cell B is the sum of the widths of the cell B1, the cell B2, and the cell B3, i.e., the width of the cell B is also 3N.

As an alternative embodiment, after the data table is output in the client, the embodiment may further include: and outputting a heat map in the client, wherein the heat map is used for indicating the distribution heat of the data in the data table, and/or a part of the data currently output by the client in the data table, and the region position of the part of the data in the data table is represented by a block diagram mark in the heat map.

By adopting the above embodiment of the present invention, the heat map may indicate the distribution heat condition of the data in the data table, and the block diagram mark in the heat map may also be used to represent the location of the area of the partial table output by the data table in the client in the data table, so that the user may conveniently show the distribution condition of all the data in the data table and the area of the currently shown partial data table in the complete data table according to the heat map.

As an optional embodiment, after the output of the heat grid in the client, the embodiment may further include: detecting a second touch operation executed on a block diagram mark in the heat map in the client, wherein the second touch operation is used for indicating that a partial table is output in the client; and in the case that the second touch operation is detected, outputting the part of the table indicated by the block diagram mark in the client.

With the above embodiment of the present invention, the second touch operation is used to instruct the client to output a part of the table, and when the client detects that the second touch operation is performed on the block diagram mark in the heat map, the part of the table indicated by the block diagram mark is output in the client town, so that by dragging the block diagram mark, the client can view table data of different parts.

As an alternative embodiment, after the data table is output in the client, the embodiment may further include: and performing data analysis on the data in the data table output by the client according to different dimensions to obtain a data analysis result.

By adopting the embodiment of the invention, the data table output from the client comprises a plurality of dimensions and the cross data of any two dimensions, and the data in the data table output from the client is subjected to data analysis according to different dimensions, so that the result of the cross analysis of the data of different dimensions can be obtained, and the cross analysis of the data of different dimensions is realized.

Table 2 is a data table output from an optional client according to the above embodiment of the present invention, as shown in table 2, "a", "B", "C", and "a", "B" indicate multiple dimensions of the data table, "N1" indicates intersection data of dimension "a" and dimension "a", "N2" indicates intersection data of dimension "B" and dimension "a", "N3" indicates intersection data of dimension "C" and dimension "a", "N4" indicates intersection data of dimension "a" and dimension "B", "N5" indicates intersection data of dimension "B" and dimension "B", "N6" indicates intersection data of dimension "B" and dimension "B", and the intersection analysis of the data of dimensions "N1", "N2", "N3", "N4", and "N5" can be implemented by performing data analysis on the data of dimensions "a", "B", "C", and "a", "B", and obtaining the cross analysis results corresponding to the multiple dimensions.

Table 2:

	A	B	C
				a	N1	N2	N3
b	N4	N5	N6

the invention also provides a preferred embodiment, which provides a method for cross-analyzing data in multiple dimensions.

The method for multi-dimensional cross analysis of data provided by the invention can be operated on a WEB browser, and a user can use the method by accessing the application site.

It should be noted that the present invention includes a data storage end, a logic processing end, and a WEB client.

Optionally, the data storage end uses a distributed data storage structure, and parallel capacity expansion and real-time calculation can be realized. Meanwhile, the data storage end uses the JIT compiler dynamic SQL compiling technology, so that the execution efficiency of query statements can be improved, and the smooth query of hundred thousand-level data can be supported.

It should be noted that the JIT compiler is called all in english: Just-In-Time Compiler, the name of Chinese is Just-In Compiler, can compile Microsoft intermediate language (MSIL) into various different machine codes to adapt to corresponding system platforms, and finally enables the program to smoothly run In the target system.

It should be noted that, SQL is called Structured Query Language in english, and is a Structured Query Language in chinese, which is a special purpose programmer, and is a data fast Query and programming Language for storing data and querying, updating and managing a relational database system.

Optionally, the logic processing end is implemented by using a hypertext preprocessor (PHP), so as to implement a function of returning the application interface to the client terminal when the user accesses the terminal, when the user uses a WEB browser to perform query on the terminal, the logic processing end performs data query in the storage end, and then organizes the queried one-dimensional data structure into a two-dimensional data structure to return to the WEB client of the user terminal, so that the WEB client implements data rendering.

Optionally, the WEB client uses js, html, css, ajax, and cavans to complete the process, and an effect that one hundred thousand levels of data are smoothly displayed on the WEB client in a table form is realized and supported, wherein the display of the one hundred thousand levels of data amount of the WEB client means that data of 100000 rows by 10 columns can be smoothly displayed to a user in a one-time parallel flow manner in the WEB client. The method is different from a general display method in that the conventional scheme generally finishes drawing the table at one time by directly using a table label after the logic processing end returns data, but the scheme exceeds 100 rows by 10 columns, so that the WEB client is blocked, the experience is poor, and the browsing efficiency is low. The scheme of the invention is to use the div label to draw the table, cache the data in the terminal memory when the logic end returns the data, only draw the data visible in the user window, when the user triggers the scroll bar to browse, then render and display the data one by one, and destroy the data row beyond the visible range of the user window, thus realizing the browse of the data amount of one hundred thousand grade of the WEB client.

Fig. 3 is a schematic diagram of an alternative multidimensional cross analysis data according to an embodiment of the present invention, as shown in fig. 3, a method for multidimensional cross analysis data connects a front end with a storage layer through a CGI, and a framework structure and a process thereof are shown in fig. 3, where CGI is a Common Gateway Interface in english, and a Common Gateway Interface in chinese is a nominal Interface between an external application program and a Web server, and is a process for transferring information between a CGI program and a Web program.

Optionally, in a framework of multidimensional cross analysis data, the CGI includes real-time data processing, offline data processing, data conversion processing, and heat map storage processing; the front end includes AjaxProxy, common, quote Control, Tool Bar, Mutil Control, quote Editor, Table Control, Big Table, Cross Analysis.

Optionally, in the process of multidimensional cross analysis of data, front-end request data is sent out, then offline data and real-time data are generated in the CGI according to the front-end request data, then indexes and index segments are formed according to the real-time data, and the indexes and the index segments are input to the storage layer through SQL.

Optionally, in the process of multidimensional cross analysis of data, after data is acquired from the storage layer, data conversion and heat map storage are performed on the acquired data in the CGI, and then data format conversion and data rendering are performed in the front end.

Optionally, the method is applicable to a scene in which more than 100,000 rows by 100 columns of data need to be displayed in a tabular manner at one time in the WEB browser, and the technical scheme includes a header part and a tabular data part.

Fig. 4 is a schematic diagram of an alternative data presentation scenario according to an embodiment of the present invention, as shown in fig. 4, the first part is a header part, wherein the header part supports row-N level header presentation. The second part is a tabular data presentation, wherein the tabular data presentation comprises a scroll bar implemented using javascript.

Fig. 5 is a schematic diagram of an alternative 100,000 rows by 100 columns data table according to an embodiment of the present invention, as shown in fig. 5, an implementation principle of the present technical solution that supports displaying more than 100,000 rows by 100 columns data table at a time is shown in fig. 5, taking 16 rows by 8 columns as an example, respectively establishing row and column coordinates of the table, and displaying data at positions corresponding to the row and column coordinates of the table.

For example, a set of two-dimensional data from a server is received in a page and stored in memory. After the data from the server is confirmed, the technical scheme provided by the invention is to manufacture a container in the WEB page.

Fig. 6 is a schematic illustration of an alternative container manufacturing process according to an embodiment of the invention, as shown in fig. 6, a container is manufactured using div.

Fig. 7 is a second schematic diagram of an alternative manufacturing container according to an embodiment of the present invention, as shown in fig. 7, which is manufactured according to the size of the container of div and can just accommodate the number of table rows and columns based on the scheme shown in fig. 6.

Fig. 8 is a third schematic diagram of an alternative manufacturing container according to an embodiment of the present invention, as shown in fig. 8, based on the scheme shown in fig. 7, a horizontal scroll bar and a vertical scroll bar are respectively established, and a set of scroll bars is manually implemented, and data is located by the scroll bars (instead of locating pixels by the scroll bars).

Fig. 9 is a fourth schematic diagram of an alternative manufacturing container according to an embodiment of the present invention, as shown in fig. 9, based on the scheme shown in fig. 8, the data in the memory is used to fill the grid in the table with display values (data) according to the subscripts pointed by the scroll bars.

Fig. 10 is a schematic diagram five of an alternative manufacturing container according to an embodiment of the present invention, as shown in fig. 10, based on the scheme shown in fig. 9, when the scroll bar is scrolled, the contents in the grids are emptied again, and the data at the current position is found in the data according to the subscript and is put into the grids.

Fig. 11 is a schematic diagram of an implementation principle of an optional multilayer header part according to an embodiment of the present invention, as shown in fig. 11, a list header array is created, a plurality of headers are respectively labeled with subscript 0 and subscript 1 … …, and multiple layers of headers of each header are recorded in each header, for example, multiple layers of headers, such as a word header "header 0_ 1" and a word header "header 0_ 2" of "header 0" are included in "subscript 0".

Alternatively, the data structure shown in fig. 10 is received from the server and stored in the memory. The data structure is used to describe an n-level multi-level header, which is itself a one-dimensional array in which each element contains an infinite tree.

Fig. 12 is a diagram of an alternative list head array according to an embodiment of the present invention, and as shown in fig. 12, each endmost element of the list head array corresponds to each column of data in the data table.

Optionally, on the page, the step of rendering the above data structure into a header shown in the page is:

1. the table is rendered first and the scroll bar is initialized in the table.

2. And calculating the data structure of the header in the memory again to form a two-dimensional table, and adding the link of the original header data structure into each element in the two-dimensional table.

3. And circularly rendering the header of the table in the last row by using div elements from the subscript returned by the scroll bar in the calculated two-dimensional table, linking to the original elements in the tree-shaped data structure by using the link in the elements in the last row, extending to the parent elements, judging the number of the child elements in the parent elements to determine the width of the parent elements to be manufactured, rendering the table of the parent elements by using the div elements, and repeating the above operations until the parent elements still exist in the parent elements. After the manufacture of the parent element is finished, the manufacture of the next element is started and the above procedures are repeated until the total width of the manufactured header exceeds the width of the current table display area, and then the manufacture of the header is stopped.

4. When a scroll operation occurs on the scroll bar in the table, the scroll bar will inform the header object to re-render the header using the new data index.

Fig. 13 is a schematic diagram of an optional final rendering effect of the table according to an embodiment of the present invention, as shown in fig. 13, including two level headers in both the horizontal direction and the vertical direction of the table, where, in the horizontal direction of the table, four level headers with the same width may be included, two level headers with the same width are included under each level header, the sum of the widths of the two level headers is the same as the width of the level header, and the width of each level header is the same as the width of an element in the table display area, and the heights of the level headers are the same as the height of the element in the table display area; in the longitudinal direction of the table, eight primary headers with the same height can be included, eight secondary headers with the same height are included under each primary header, the sum of the heights of the two secondary headers is the same as the height of the primary header, the height of each secondary header is the same as the height of the table display area, and the heights of the primary headers and the secondary headers are the same as the width of the elements in the table display area.

Fig. 14 is a schematic diagram of an interface in an optional interaction process according to an embodiment of the present invention, where as shown in fig. 14, when a user accesses the application in a WEB browser, the application displays left and right interfaces, the left of the interface is arranged with a pointer, and the right displays a table.

Fig. 15 is a schematic diagram of a second interface in an alternative interaction process according to an embodiment of the present invention, and as shown in fig. 15, the pointer in the pointer list may be dragged to the "row" area or the "column" area through a mouse, for example, the "age" pointer may be dragged to the column area, and the "gender" pointer may be dragged to the row area.

Fig. 16 is a third schematic diagram of an interface in an alternative interaction process according to an embodiment of the present invention, and as shown in fig. 16, after the drag is completed, the operated indicator in the indicator list becomes unusable. The data of the currently dragged index is shown in the table, for example, on the basis of fig. 14, the contents shown in table 3 are shown. Table 3 is a statistical table for calculating the age and gender of the ten-bit sleeping population in the southern mountain area, and it is found through cross analysis of the age and gender dimensions of the ten-bit sleeping population in the southern mountain area in table 3 that the number of males aged 10 to 20, 20 to 30 and 30 to 40 is the highest and the number of females is the second.

Table 3:

	1-10	10-20	20-30	30-40	40-50	50-60
							for male	234	254,986	346,578	356,354	7,859	230
Woman	120	34,567	463,546	470,564	7,437	125
							Is unknown	0	1,568	2,457	3,150	430	2

Fig. 17 is a schematic diagram of an interface in an optional interaction process according to an embodiment of the present invention, as shown in fig. 17, multiple indexes may be simultaneously dragged to rows or columns, so as to form a multi-dimensional cross table, which is convenient for a data analyst to analyze, for example, a dimension table of "academic records" and "provinces" is set on the basis of gender, and "academic records" dimensions, such as "junior middle school", "senior high school", "major, basic science", and "master", are added on the basis of "gender" distribution; on the basis of the distribution of the age, the dimension of provinces is increased, such as Guangdong province and Hunan province.

Fig. 18 is a schematic diagram of an interface in an optional interaction process according to an embodiment of the present invention, which is a fifth schematic diagram, and as shown in fig. 18, when the data size is large, in order to facilitate searching for a key data location, a heat map window is further provided, and the heat map window may be opened, where the heat map window not only displays heat conditions of all current data, but also displays an area shown in a current table, and the area is marked with a rectangle. On the basis, an operator can use a mouse pointer to drag a scroll bar for checking, and can also drag a rectangular window in a heat map window for checking data, so that the operator can conveniently browse certain data hot spots.

By adopting the above embodiment of the present invention, compared with the existing data analysis method, the data analysis method provided by the present invention has the following advantages:

1. by means of the storage end distributed parallel capacity expansion and JIT dynamic SQL compiling technology, ten million-level data can be queried and completed within 0.533 second at the fastest speed.

2. Through WEB front end sectional type rendering, one hundred thousand-level data can be smoothly displayed, and a heat map is matched to help a user to find data hot spots.

3. The key data of the user on the game influence can be found by selecting any interval and continuously subdividing and matching with the heat map mode.

4. After the target users are locked through the heat map, the batch of users can be quickly defined on the table, extraction, image drawing and tracking are carried out, and deep analysis is completed.

According to the embodiment of the invention, the online data analysis application can be realized through the WEB browser, and the data analysis function which can be realized only through complicated operations in the EXCEL can be completed through operations such as dragging.

According to the embodiment of the invention, one hundred thousand-level two-dimensional data tables can be smoothly displayed through WEB, and the display of the heat map is supported.

According to the above embodiment of the present invention, the interval of the two-dimensional table can be continuously subdivided by dragging operation to the row or the column.

According to the embodiment of the invention, after the target user is locked by using the heat map, the circled users are extracted again, and the images and the tracking analysis are performed.

By adopting the embodiment of the invention, in data analysis, a data dense point concerned by a data analyst can be quickly previewed by alternately expanding multi-dimensional intervals, and a conclusion can be quickly obtained by expanding analysis under the condition of supporting multiple dimensions.

The embodiment of the invention can support more and larger display data volume on the premise of not depending on EXCEL, is more convenient to operate, can perform multi-dimensional interval cross analysis by a data analyzer only by opening application in a WEB browser, and does not need to export data and then put the data into the EXCEL for manual production.

By adopting the embodiment of the invention, under the condition of carrying out multi-dimensional cross analysis in the WEB browser, drilling analysis and user portrait operation can be carried out on data dense points.

It should be noted that, for simplicity of description, the above-mentioned method embodiments are described as a series of acts or combination of acts, but those skilled in the art will recognize that the present invention is not limited by the order of acts, as some steps may occur in other orders or concurrently in accordance with the invention. Further, those skilled in the art should also appreciate that the embodiments described in the specification are preferred embodiments and that the acts and modules referred to are not necessarily required by the invention.

Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.

Example 2

According to the embodiment of the invention, the invention also provides a data table generating device for implementing the data table generating method. Fig. 19 is a schematic diagram of an alternative data table generating apparatus according to an embodiment of the present invention, as shown in fig. 19, the apparatus may include: a first detecting unit 1901, configured to detect a first touch operation in the client, where the first touch operation is used to request generation of a data table, the data table has multiple dimensions, and the first touch operation is used to indicate that the multiple dimensions are selected; a second detecting unit 1903, configured to acquire cross data of any two dimensions of the multiple dimensions when the first touch operation is detected; an adding unit 1905, configured to add multiple dimensions to a header cell of the data table, and add cross data to a data cell where any two dimensions cross; a first output unit 1907, configured to output a data table in the client, where the data table includes a header cell and a data cell.

It should be noted that the first detecting unit 1901 in this embodiment may be configured to execute step S202 in embodiment 1 of this application, the second detecting unit 1903 in this embodiment may be configured to execute step S204 in embodiment 1 of this application, the adding unit 1905 in this embodiment may be configured to execute step S206 in embodiment 1 of this application, and the first outputting unit 1907 in this embodiment may be configured to execute step S208 in embodiment 1 of this application.

It should be noted here that the modules described above are the same as the examples and application scenarios implemented by the corresponding steps, but are not limited to the disclosure of embodiment 1 described above. It should be noted that the modules described above as a part of the apparatus may operate in a hardware environment as shown in fig. 1, and may be implemented by software or hardware.

As an alternative embodiment, the output unit includes: the client side comprises a first determining module, a second determining module and a display module, wherein the first determining module is used for determining a target cell indicated by a transverse scroll bar and a longitudinal scroll bar in the client side, the transverse scroll bar is used for indicating a column cell in a data table, the longitudinal scroll bar is used for indicating a row cell in the data table, and the target cell is a cell in which the column cell and the row cell are crossed; the output module is used for outputting a target data table in the client, wherein the target data cells in the target data table use the target cells in the data table as initial data cells, the target header cells in the target data table are header cells corresponding to the target data cells in the data table, the total width of the column cells in the target data table is less than or equal to the page width of the client, and the total height of the row cells in the target data table is less than or equal to the page height of the client.

As an optional embodiment, the target header cells include a parent header cell and a child header cell, the parent header cell includes at least one child header cell, and the child header cell is a header cell corresponding to the target data cell, where the output module may include: the second determining module is used for determining the number of the sub-level table head cells belonging to the same parent-level table head cell; and the setting module is used for setting the total width of the sub-level table head cells as the width of the same parent-level table head cell.

As an alternative embodiment, the embodiment may further include: and the second output unit is used for outputting a heat map in the client after the data table is output in the client, wherein the heat map is used for indicating the data distribution heat condition in the data table and/or a part table currently output by the client in the data table, and the area position of the part table in the data table is represented by a block diagram mark in the heat map.

As an alternative embodiment, the embodiment may further include: the third detection unit is used for detecting a second touch operation executed on the block diagram mark in the heat map in the client after the heat map grid is output in the client, wherein the second touch operation is used for indicating that a partial table is output in the client; and the third output unit is used for outputting the partial table indicated by the block diagram mark in the client under the condition that the second touch operation is detected.

As an alternative embodiment, the embodiment may further include: and the analysis unit is used for performing data analysis on the data in the data table output by the client according to different dimensions after the data table is output by the client, so as to obtain a data analysis result.

Through the modules, the data table has a plurality of dimensions, the first touch operation is used for requesting to generate the data table and indicating that the plurality of dimensions are selected, detecting touch operation through a client, acquiring cross data of any two dimensions in a plurality of dimensions under the condition of detecting a first touch operation, adding the plurality of dimensions into a table head cell of a data table, adding the cross data into a data cell corresponding to any two dimensions in a cross mode, and then outputting the data table comprising the table head cells and the data cells in the client, the problem that the data is usually required to be exported from a database in order to realize the cross analysis of the data with different dimensions in the related art can be solved, and then, the data cross analysis is performed on the exported data generation data table by using EXCEL manually, so that the technical problem of low data analysis efficiency is caused, and the technical effect of automatically performing cross analysis on data with different dimensions is further achieved.

Example 3

According to the embodiment of the invention, the electronic device for implementing the data table generation method is also provided.

Fig. 20 is a block diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 20, the electronic device may include: one or more processors 201 (only one of which is shown), a memory 203, and a transmission device 205, as shown in fig. 20, the electronic device may further include an input-output device 207.

The memory 203 may be used to store software programs and modules, such as program instructions/modules corresponding to the data table generating method and apparatus in the embodiments of the present invention, and the processor 201 executes various functional applications and data processing by running the software programs and modules stored in the memory 203, that is, implements the data table generating method described above. The memory 203 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 203 may further include memory located remotely from the processor 201, which may be connected to the terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.

The transmission device 205 is used for receiving or transmitting data via a network. Examples of the network may include a wired network and a wireless network. In one example, the transmission device 205 includes a Network adapter (NIC) that can be connected to a router via a Network cable and other Network devices to communicate with the internet or a local area Network. In one example, the transmission device 205 is a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.

Wherein the memory 203 is specifically used for storing application programs.

The processor 201 may call an application stored in the memory 203 to perform the following steps: detecting a first touch operation in a client, wherein the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, and the first touch operation is used for indicating selection of the multiple dimensions; under the condition that a first touch operation is detected, acquiring cross data of any two dimensions of a plurality of dimensions; adding a plurality of dimensions into a table head cell of a data table, and adding cross data into a data cell which is crossed and corresponding to any two dimensions; and outputting the data table in the client, wherein the data table comprises a table head cell and a data cell.

The processor 201 is further configured to perform the following steps: determining target cells indicated by a transverse scroll bar and a longitudinal scroll bar in a client, wherein the transverse scroll bar is used for indicating column cells in a data table, the longitudinal scroll bar is used for indicating row cells in the data table, and the target cells are cells in which the column cells and the row cells are crossed; and outputting a target data table in the client, wherein the target data cell in the target data table takes the target cell in the data table as an initial data cell, the target header cell in the target data table is a header cell corresponding to the target data cell in the data table, the total width of the column cells in the target data table is less than or equal to the page width of the client, and the total height of the row cells in the target data table is less than or equal to the page height of the client.

The processor 201 is further configured to perform the following steps: determining the number of sub-level header cells belonging to the same parent-level header cell; and setting the total width of the number of the sub-level table head cells as the width of the same parent-level table head cell.

The processor 201 is further configured to perform the following steps: after the data table is output in the client, a heat map is output in the client, wherein the heat map is used for indicating the data distribution heat condition in the data table, and/or a partial table currently output by the client in the data table, and the area position of the partial table in the data table is represented by a block mark in the heat map.

The processor 201 is further configured to perform the following steps: after the heat map grid is output in the client, detecting a second touch operation executed on a block diagram mark in the heat map in the client, wherein the second touch operation is used for indicating that a partial table is output in the client; and in the case that the second touch operation is detected, outputting the part of the table indicated by the block diagram mark in the client.

The processor 201 is further configured to perform the following steps: after the data table is output in the client, data analysis is carried out on data in the data table output in the client according to different dimensions, and a data analysis result is obtained.

The embodiment of the invention provides a data table generation scheme. The data table has a plurality of dimensions, the first touch operation is used for requesting to generate the data table and indicating that the plurality of dimensions are selected, detecting touch operation through a client, acquiring cross data of any two dimensions in a plurality of dimensions under the condition of detecting a first touch operation, adding the plurality of dimensions into a table head cell of a data table, adding the cross data into a data cell corresponding to any two dimensions in a cross mode, and then outputting the data table comprising the table head cells and the data cells in the client, the problem that the data is usually required to be exported from a database in order to realize the cross analysis of the data with different dimensions in the related art can be solved, and then, the data cross analysis is performed on the exported data generation data table by using EXCEL manually, so that the technical problem of low data analysis efficiency is caused, and the technical effect of automatically performing cross analysis on data with different dimensions is further achieved.

Optionally, the specific examples in this embodiment may refer to the examples described in embodiment 1 and embodiment 2, and this embodiment is not described herein again.

It will be understood by those skilled in the art that the structure shown in fig. 20 is only an illustration, and the electronic device may be a terminal device such as a smart phone (e.g., an Android phone, an iOS phone, etc.), a tablet computer, a palm computer, and a Mobile Internet Device (MID), a PAD, etc. Fig. 20 is a diagram illustrating a structure of the electronic device. For example, the electronic device may also include more or fewer components (e.g., network interfaces, display devices, etc.) than shown in FIG. 20, or have a different configuration than shown in FIG. 20.

Those skilled in the art will appreciate that all or part of the steps in the methods of the above embodiments may be implemented by a program instructing hardware associated with the terminal device, where the program may be stored in a computer-readable storage medium, and the storage medium may include: flash disks, Read-Only memories (ROMs), Random Access Memories (RAMs), magnetic or optical disks, and the like.

Example 4

The embodiment of the invention also provides a storage medium. Alternatively, in the present embodiment, the storage medium may be a program code for executing the data table generating method.

Optionally, in this embodiment, the storage medium may be located on at least one of a plurality of network devices in a network shown in the above embodiment.

Optionally, in this embodiment, the storage medium is configured to store program code for performing the following steps:

s1, detecting a first touch operation in the client, wherein the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, and the first touch operation is used for indicating selection of the multiple dimensions;

s2, acquiring cross data of any two dimensions of the multiple dimensions under the condition that the first touch operation is detected;

s3, adding a plurality of dimensions into a table head cell of the data table, and adding cross data into a data cell which is crossed and corresponding to any two dimensions;

and S4, outputting the data table in the client, wherein the data table comprises a table head cell and a data cell.

Optionally, the storage medium is further arranged to store program code for performing the steps of: determining target cells indicated by a transverse scroll bar and a longitudinal scroll bar in a client, wherein the transverse scroll bar is used for indicating column cells in a data table, the longitudinal scroll bar is used for indicating row cells in the data table, and the target cells are cells in which the column cells and the row cells are crossed; and outputting a target data table in the client, wherein the target data cell in the target data table takes the target cell in the data table as an initial data cell, the target header cell in the target data table is a header cell corresponding to the target data cell in the data table, the total width of the column cells in the target data table is less than or equal to the page width of the client, and the total height of the row cells in the target data table is less than or equal to the page height of the client.

Optionally, the storage medium is further arranged to store program code for performing the steps of: determining the number of sub-level header cells belonging to the same parent-level header cell; and setting the total width of the number of the sub-level table head cells as the width of the same parent-level table head cell.

Optionally, the storage medium is further arranged to store program code for performing the steps of: after the data table is output in the client, a heat map is output in the client, wherein the heat map is used for indicating the data distribution heat condition in the data table, and/or a partial table currently output by the client in the data table, and the area position of the partial table in the data table is represented by a block mark in the heat map.

Optionally, the storage medium is further arranged to store program code for performing the steps of: after the heat map grid is output in the client, detecting a second touch operation executed on a block diagram mark in the heat map in the client, wherein the second touch operation is used for indicating that a partial table is output in the client; and in the case that the second touch operation is detected, outputting the part of the table indicated by the block diagram mark in the client.

Optionally, the storage medium is further arranged to store program code for performing the steps of: after the data table is output in the client, data analysis is carried out on data in the data table output in the client according to different dimensions, and a data analysis result is obtained.

Optionally, in this embodiment, the storage medium may include, but is not limited to: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.

The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.

The integrated unit in the above embodiments, if implemented in the form of a software functional unit and sold or used as a separate product, may be stored in the above computer-readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for causing one or more computer devices (which may be personal computers, servers, network devices, etc.) to execute all or part of the steps of the method according to the embodiments of the present invention.

In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the several embodiments provided in the present application, it should be understood that the disclosed client may be implemented in other manners. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one type of division of logical functions, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims

1. A data table generating method, comprising:

detecting a first touch operation in a client, wherein the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, the first touch operation is used for indicating selection of the multiple dimensions, and the first touch operation comprises a dragging operation of the multiple dimensions;

under the condition that the first touch operation is detected, acquiring cross data of any two dimensions of the multiple dimensions;

adding the dimensions into a table head cell of the data table, and adding the cross data into a data cell which is crossed and corresponding to any two dimensions;

outputting the data table in the client, wherein the data table comprises the header cell and the data cell;

after outputting the data table in the client, the method further comprises: outputting a heat map in the client, wherein the heat map is used for indicating the distribution heat of data in the data table, and/or a partial table currently output by the client in the data table, and the area position of the partial table in the data table is represented by a block mark in the heat map;

wherein the header cells are obtained by rendering, the rendering of the header cells comprising:

s1, rendering a table, and initializing a scroll bar in the table;

s2, calculating the data structure of the header in the memory to obtain a two-dimensional table, and adding the link of the original header data structure into each element in the two-dimensional table;

s3, circularly rendering a header in the last row by using div elements from the subscript returned by the scroll bar in the two-dimensional table, using the link in the last row of elements, linking to the original elements in the tree-shaped data structure, extending to the parent elements, judging the number of the child elements in the parent elements to determine the width of the parent elements, and rendering the table of the parent elements by using the div elements;

s4, in case the parent element still exists, repeating S3 until no more upward extension is possible;

s5, after the manufacture of the parent element, the manufacture of the next element is started and the steps S3-S4 are repeated until the total width of the manufactured header exceeds the width of the current table display area, and then the manufacture of the header is stopped;

s6, in case of a scroll operation of the scroll bar in the table, the scroll bar will inform the header object to re-render the header using the new data index.

2. The method of claim 1, wherein outputting the data table in the client comprises:

determining a target cell indicated by a horizontal scroll bar and a vertical scroll bar in the client, wherein the horizontal scroll bar is used for indicating a column cell in the data table, the vertical scroll bar is used for indicating a row cell in the data table, and the target cell is a cell in which the column cell and the row cell are crossed;

outputting a target data table in the client, wherein a target data cell in the target data table takes the target cell in the data table as a starting data cell, a target header cell in the target data table is a header cell corresponding to the target data cell in the data table, the total width of column cells in the target data table is less than or equal to the page width of the client, and the total height of row cells in the target data table is less than or equal to the page height of the client.

3. The method of claim 2, wherein the target header cells comprise a parent header cell and a child header cell, the parent header cell comprising at least one of the child header cells, and the child header cell being a header cell corresponding to the target data cell, wherein the outputting the target data table in the client comprises:

determining the number of the sub-level header cells belonging to the same parent-level header cell;

setting the total width of the sub-level head cells of the number as the width of the same parent-level head cell.

4. The method of claim 1, wherein after outputting the heat map in the client, the method further comprises:

detecting, in the client, a second touch operation performed on the block diagram mark in the heat map, wherein the second touch operation is used for instructing to output the partial table in the client;

in the case that the second touch operation is detected, outputting the partial table indicated by the block diagram mark in the client.

5. The method according to any one of claims 1 to 4, wherein after outputting the data table in the client, the method further comprises:

and performing data analysis on the data in the data table output by the client according to different dimensions to obtain a data analysis result.

6. A data table generating apparatus, comprising:

the device comprises a first detection unit, a second detection unit and a third detection unit, wherein the first detection unit is used for detecting a first touch operation in a client, the first touch operation is used for requesting generation of a data table, the data table has multiple dimensions, the first touch operation is used for indicating selection of the multiple dimensions, and the first touch operation comprises a dragging operation of the multiple dimensions;

the second detection unit is used for acquiring cross data of any two dimensions in the plurality of dimensions under the condition that the first touch operation is detected;

the adding unit is used for adding the dimensions into a table head cell of the data table and adding the cross data into a data cell which is crossed and corresponding to any two dimensions;

a first output unit, configured to output the data table in the client, where the data table includes the header cell and the data cell;

the device further comprises: a second output unit, configured to output a heat map in the client after the data table is output in the client, where the heat map is used to indicate a data distribution heat situation in the data table, and/or a partial table currently output by the client in the data table, and a region position of the partial table in the data table is represented by a block mark in the heat map;

wherein the header cell is obtained by rendering, and the apparatus is further configured to implement the rendering of the header cell by:

s1, rendering a table, and initializing a scroll bar in the table;

7. The apparatus of claim 6, wherein the output unit comprises:

a first determining module, configured to determine a target cell indicated by a horizontal scroll bar and a vertical scroll bar in the client, where the horizontal scroll bar is used to indicate a column cell in the data table, the vertical scroll bar is used to indicate a row cell in the data table, and the target cell is a cell where the column cell and the row cell intersect;

the output module is used for outputting a target data table in the client, wherein a target data cell in the target data table takes the target cell in the data table as a starting data cell, a target header cell in the target data table is a header cell corresponding to the target data cell in the data table, the total width of column cells in the target data table is less than or equal to the page width of the client, and the total height of row cells in the target data table is less than or equal to the page height of the client.

8. The apparatus of claim 7, wherein the target header cell comprises a parent header cell and a child header cell, the parent header cell comprises at least one of the child header cells, and the child header cell is a header cell corresponding to the target data cell, wherein the output module comprises:

the second determining module is used for determining the number of the sub-level table head cells belonging to the same parent-level table head cell;

and the setting module is used for setting the total width of the sub-level table head cells of the number to the width of the same parent-level table head cell.

9. The apparatus of claim 6, further comprising:

a third detecting unit, configured to detect, in the client, a second touch operation performed on the block diagram mark in the heat map after outputting the heat map in the client, where the second touch operation is used to instruct to output the partial table in the client;

a third output unit, configured to output, in the client, the partial table indicated by the block diagram flag if the second touch operation is detected.

10. The apparatus of any one of claims 6 to 9, further comprising:

and the analysis unit is used for performing data analysis on the data in the data table output by the client according to different dimensions after the data table is output by the client, so as to obtain a data analysis result.

11. A storage medium, characterized in that the storage medium comprises a stored program, wherein the program when executed performs the method of any one of claims 1 to 5.

12. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor executes the method of any one of claims 1 to 5 by means of the computer program.