CN107766309A - Data form generation method, device and storage medium, electronic installation - Google Patents

Data form generation method, device and storage medium, electronic installation Download PDF

Info

Publication number
CN107766309A
CN107766309A CN201710759326.6A CN201710759326A CN107766309A CN 107766309 A CN107766309 A CN 107766309A CN 201710759326 A CN201710759326 A CN 201710759326A CN 107766309 A CN107766309 A CN 107766309A
Authority
CN
China
Prior art keywords
data
client
data form
cell
gauge outfit
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201710759326.6A
Other languages
Chinese (zh)
Other versions
CN107766309B (en
Inventor
程雯
廖力
江烁
龙赐
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Tencent Technology Shenzhen Co Ltd
Original Assignee
Tencent Technology Shenzhen Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Tencent Technology Shenzhen Co Ltd filed Critical Tencent Technology Shenzhen Co Ltd
Priority to CN201710759326.6A priority Critical patent/CN107766309B/en
Publication of CN107766309A publication Critical patent/CN107766309A/en
Application granted granted Critical
Publication of CN107766309B publication Critical patent/CN107766309B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Data Mining & Analysis (AREA)
  • User Interface Of Digital Computer (AREA)

Abstract

The invention discloses a kind of data form generation method, device and storage medium, electronic installation.This method includes:The first touch control operation is detected in the client, and the first touch control operation is used to ask generation data form, and data form has multiple dimensions, and the first touch control operation selects multiple dimensions for instruction;In the case where detecting the first touch control operation, the intersection data of any two dimension in multiple dimensions are obtained;Multiple dimensions are added into the gauge outfit cell in data form, and data will be intersected and be added to data cells corresponding to any two dimension intersection;Output data form in the client, wherein, data form includes gauge outfit cell and data cells.The present invention solves correlation technique to realize that the alternate analysis of different dimensions data usually requires to export data from database, then data generation data form derived from institute is subjected to data cross analysis manually using EXCEL, causes the technical problem that data analysis is less efficient.

Description

Data form generation method, device and storage medium, electronic installation
Technical field
The present invention relates to computer realm, is situated between in particular to a kind of data form generation method, device and storage Matter, electronic installation.
Background technology
The mode observed data of analysis and user's portrait analysis is bored in data analysis, under generally use.Lower brill analysis is logical Cross funnel model and check decay of the data on certain index path, user, which draws a portrait to analyze, passes through the displaying of each user property dimension Data distribution situation, but the distribution for being distributed and analyzing any number of indexs for finding the temperature of big data and intersect data, Then have to rely on complexity data analysis tool by write code realize, in general game operation personnel for cost compared with Height, effect is poor, and efficiency is low.
At present, common people will realize the alternate analysis of two kinds of different dimensions, it is necessary to which index is exported from database, The manually implemented alternate analysis in the spreadsheets such as EXCEL using derived index section, its is cumbersome, and using effect is poor, General analysis personnel at most make the form of two dimensions, dimension increase, and manufacture difficulty increases, and analysis efficiency is low.
For it is above-mentioned the problem of, not yet propose effective solution at present.
The content of the invention
The embodiments of the invention provide a kind of data form generation method, device and storage medium, electronic installation, so that Correlation technique is solved less in order to realize that the alternate analysis of different dimensions data usually requires to export data from database, then Data generation data form derived from institute is subjected to data cross analysis manually using EXCEL, causes data analysis less efficient Technical problem.
One side according to embodiments of the present invention, there is provided a kind of data form generation method, including:In the client The first touch control operation is detected, wherein, the first touch control operation is used to ask generation data form, and data form has multiple dimensions, First touch control operation selects multiple dimensions for instruction;In the case where detecting the first touch control operation, multiple dimensions are obtained The intersection data of middle any two dimension;Multiple dimensions are added into the gauge outfit cell in data form, and added data are intersected It is added to data cells corresponding to any two dimension intersection;Output data form in the client, wherein, data form includes Gauge outfit cell and data cells.
Another aspect according to embodiments of the present invention, data form generating means are additionally provided, including:First detection is single Member, for detecting the first touch control operation in the client, wherein, the first touch control operation is used to ask generation data form, data Form has multiple dimensions, and the first touch control operation selects multiple dimensions for instruction;Second detection unit, for detecting In the case of first touch control operation, the intersection data of any two dimension in multiple dimensions are obtained;Adding device, for will be multiple Dimension adds the gauge outfit cell in data form, and will intersect data and be added to data sheet corresponding to any two dimension intersection First lattice;First output unit, for output data form in the client, wherein, data form includes gauge outfit cell sum According to cell.
Another aspect according to embodiments of the present invention, additionally provides a kind of storage medium, and the storage medium includes storage Program, wherein, described program run when perform the embodiment of the present invention in any one data form generation method.
Another aspect according to embodiments of the present invention, additionally provides a kind of electronic installation, including memory, processor and deposits The computer program that can be run on the memory and on the processor is stored up, the processor passes through the computer journey Sequence performs any one data form generation method in the embodiment of the present invention.
In embodiments of the present invention, data form has multiple dimensions, and the first touch control operation is used to ask generation tables of data Lattice, and indicate to select multiple dimensions, touch control operation is detected by client, and in the situation for detecting the first touch control operation Under, the intersection data of any two dimension in multiple dimensions are obtained, then multiple dimensions are added to the gauge outfit unit of data form Lattice, and data will be intersected and be added in data cells corresponding to any two dimension intersection, then output is wrapped in the client Gauge outfit cell and the data form of data cells are included, can solve correlation technique to realize the friendship of different dimensions data Fork analysis is usually required to export data from database, and data derived from institute then are generated into tables of data manually using EXCEL Lattice carry out data cross analysis, cause the technical problem that data analysis is less efficient, and then automatically to different dimensions data Carry out alternate analysis, improve data analysis efficiency technique effect.
Brief description of the drawings
Accompanying drawing described herein is used for providing a further understanding of the present invention, forms the part of the application, this hair Bright schematic description and description is used to explain the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings:
Fig. 1 is the schematic diagram of the hardware environment of data form generation method according to embodiments of the present invention;
Fig. 2 is a kind of flow chart of optional data form generation method according to embodiments of the present invention;
Fig. 3 is a kind of schematic diagram of optional various dimensions alternate analysis data according to embodiments of the present invention;
Fig. 4 is a kind of schematic diagram of optional data display scene according to embodiments of the present invention;
Fig. 5 is a kind of schematic diagram of optional column data forms of 100,000 row * 100 according to embodiments of the present invention;
Fig. 6 is a kind of schematic diagram one of optional manufacture container according to embodiments of the present invention;
Fig. 7 is a kind of schematic diagram two of optional manufacture container according to embodiments of the present invention;
Fig. 8 is a kind of schematic diagram three of optional manufacture container according to embodiments of the present invention;
Fig. 9 is a kind of schematic diagram four of optional manufacture container according to embodiments of the present invention;
Figure 10 is a kind of schematic diagram five of optional manufacture container according to embodiments of the present invention;
Figure 11 is a kind of schematic diagram of the realization principle of optional multilayer gauge outfit part according to embodiments of the present invention;
Figure 12 is a kind of schematic diagram of optional list head array according to embodiments of the present invention;
Figure 13 is a kind of schematic diagram of the final rendering effect of optional form according to embodiments of the present invention;
Figure 14 is the schematic diagram one at the interface in a kind of optional interaction according to embodiments of the present invention;
Figure 15 is the schematic diagram two at the interface in a kind of optional interaction according to embodiments of the present invention;
Figure 16 is the schematic diagram three at the interface in a kind of optional interaction according to embodiments of the present invention;
Figure 17 is the schematic diagram four at the interface in a kind of optional interaction according to embodiments of the present invention;
Figure 18 is the schematic diagram five at the interface in a kind of optional interaction according to embodiments of the present invention;
Figure 19 is a kind of schematic diagram of optional data form generating means according to embodiments of the present invention;And
Figure 20 is a kind of structured flowchart of electronic installation according to embodiments of the present invention.
Embodiment
In order that those skilled in the art more fully understand the present invention program, below in conjunction with the embodiment of the present invention Accompanying drawing, the technical scheme in the embodiment of the present invention is clearly and completely described, it is clear that described embodiment is only The embodiment of a part of the invention, rather than whole embodiments.Based on the embodiment in the present invention, ordinary skill people The every other embodiment that member is obtained under the premise of creative work is not made, it should all belong to the model that the present invention protects Enclose.
It should be noted that term " first " in description and claims of this specification and above-mentioned accompanying drawing, " Two " etc. be for distinguishing similar object, without for describing specific order or precedence.It should be appreciated that so use Data can exchange in the appropriate case, so as to embodiments of the invention described herein can with except illustrating herein or Order beyond those of description is implemented.In addition, term " comprising " and " having " and their any deformation, it is intended that cover Cover it is non-exclusive include, be not necessarily limited to for example, containing the process of series of steps or unit, method, system, product or equipment Those steps or unit clearly listed, but may include not list clearly or for these processes, method, product Or the intrinsic other steps of equipment or unit.
First, the part noun or term occurred during the embodiment of the present invention is described is applied to as follows Explain:
The data storage end:For the server or server group of data storage, wherein installation data library software, user's storage Data.
Logical process end:For handling the server or server group of client and the data storage end data interaction.
Terminal:Family expenses or PC.
Web browser:For browsing the terminal software of web presence.
Table labels:For writing the code label of webpage, generally drawn for form.
Div tag:For writing the code label of webpage, generally drawn for webpage rectangle.
It is lower to bore analysis:It is deep into from combined data from detail data is carried out or increases new dimension.For example, customer analysis is " each During area, the sales situation in city ", each annual sales volume can be subdivided into the sales volume in some city, to a certain The sales volume in year, can continue to be subdivided into the sales volume in each season.By the function of drilling through, enable user deeper to data Enter to understand, it is easier to pinpoint the problems, make correct decision-making.
User draws a portrait:User's portrait is taken out according to information such as user's social property, habits and customs and consumer behaviors A labeling user model.The core work for building user's portrait is to be labeled " " to user, and label is to pass through To the highly refined signature identification of user profile analysis.
Index:Some social property, such as " age ", " educational background ", " province ", " sex " etc..
Section:There is " 1~10 " years old, " 10~20 " years old, " 20~30 " years old under the details of index, such as " age " section Deng.
Dimension:The nickname of index, various dimensions refer to multi objective.
Embodiment 1
According to embodiments of the present invention, there is provided a kind of data form generation method embodiment.
Alternatively, in the present embodiment, above-mentioned data form generation method can apply to as shown in Figure 1 by server 102 and the hardware environment that is formed of terminal 104 in.As shown in figure 1, server 102 is attached by network and terminal 104, Above-mentioned network includes but is not limited to:Wide area network, Metropolitan Area Network (MAN) or LAN, terminal 104 are not limited to PC, mobile phone, tablet personal computer Deng.The data form generation method of the embodiment of the present invention can be performed by server 102, can also be performed by terminal 104, It can also be and performed jointly by server 102 and terminal 104.Wherein, terminal 104 performs the data form life of the embodiment of the present invention Can also be performed by client mounted thereto into method.
Fig. 2 is a kind of flow chart of optional data form generation method according to embodiments of the present invention, as shown in Fig. 2 This method may comprise steps of:
Step S202, the first touch control operation is detected in the client, wherein, the first touch control operation is used to ask generation data Form, data form have multiple dimensions, and the first touch control operation selects multiple dimensions for instruction;
Step S204, in the case where detecting the first touch control operation, obtain the friendship of any two dimension in multiple dimensions Pitch data;
Step S206, multiple dimensions are added into the gauge outfit cell in data form, and be added to data are intersected arbitrarily Data cells corresponding to two dimensions intersections;
Step S208, output data form in the client, wherein, data form includes gauge outfit cell and data cell Lattice.
By above-mentioned steps S202 to step S208, data form has multiple dimensions, and the first touch control operation is used to ask Data form is generated, and indicates to select multiple dimensions, touch control operation is detected by client, and detecting the first touch-control behaviour In the case of work, the intersection data of any two dimension in multiple dimensions are obtained, then multiple dimensions are added to data form Gauge outfit cell, and data will be intersected and be added in data cells corresponding to any two dimension intersection, then in client Middle output includes gauge outfit cell and the data form of data cells, can solve correlation technique to realize different dimensions The alternate analysis of data usually requires to export data from database, is then manually given birth to data derived from institute using EXCEL Data cross analysis is carried out into data form, causes the technical problem that data analysis is less efficient, and then automatically to difference The technique effect of the progress alternate analysis of dimension data.
In the technical scheme that step S202 is provided, client can be the application in browser, can also be using visitor Family end.First touch control operation can refer to target drag operation, and user sends the first touch control operation, request generation data form. Data form can have multiple dimensions, and the multiple dimensions that can select data form are manipulated by the first touch-control.
The intersection data of any two dimension, can be between two indices in the technical scheme that step S204 is provided Caused intersection data, for example, it is necessary to unite in the case of age, Sex distribution in ten one points of Nanshan District of statistics sleep crowd Sex index and Age Indices, i.e. two dimensions of sex and age are counted, different sexes are two in the personnel amount of all ages and classes The intersection data of individual dimension, for example, the male of Nanshan District 40-50 year is 7859 people in the number of ten one points of sleeps, then in male Intersection data with two dimensions of 40-50 year are 7859.
It should be noted that the intersection data in embodiment can be, but not limited to be the data with two dimensions, for example, In the case of age, Sex distribution in the above-mentioned ten one points of sleep crowds in statistics Nanshan District, the male of Nanshan District 40-50 year is ten Some number of sleep is 7859 people, then 7859 is intersect data, and the intersection data include the age dimension in " 40-50 year ", And the sex dimension of " male ".
Alternatively, the intersection data in embodiment can be, but not limited to be the row where the gauge outfit of cross direction profiles in the table With the data of the crossover location of the row where the gauge outfit of genesis analysis.
For example, the data C that the row where gauge outfit A intersect with the row where gauge outfit B is to intersect data, the two of data C Individual dimension is respectively the dimension represented by gauge outfit A and gauge outfit B.
Table 1 is a kind of optional data form according to the above embodiment of the present invention, as shown in table 1, in the table, N1 Row M2The data of row are C22If data C22To intersect data, then data C22Two dimensions be respectively N1Row gauge outfit Represented dimension, and M2Dimension represented by list head.
Table 1:
M1 M2
N1 C11 C12
N2 C21 C22
Alternatively, client can obtain any two in multiple dimensions in the case where detecting the first touch control operation The intersection data of dimension.
In the technical scheme that step S206 is provided, data form includes gauge outfit cell part and data cells portion Point, gauge outfit cell part can insert the index of data, for example, age, property in the ten one points of sleep crowds in statistics Nanshan District Not Fen Bu in the case of, insert sex index and Age Indices in gauge outfit cell part, such as, the gauge outfit for form of being expert at is inserted Sex index, " man ", " female " and " unknown sex ";Age Indices are inserted in the gauge outfit of list lattice, such as, in list lattice Gauge outfit inserts Age Indices, " 0-10 year ", " 10-20 year ", " 20-30 year ", " 30-40 year ", " 40-50 year " and " 50-60 Year ".Multiple dimensions are inserted in the gauge outfit cell of data form, intersection data are added into any two dimension cross-pair answers Data cells, so as to represent the friendship of any two dimension in multiple dimensions, and multiple dimensions with data cells Pitch data.
In the technical scheme that step S208 is provided, data form includes gauge outfit cell and data cells, will be more Individual dimension is added to after gauge outfit cell, and the intersection data of any two dimension are intersected added to any two dimension After corresponding data cells, the data form is exported by client, shows multiple dimensions, and any two dimension Intersect data.
As a kind of optional embodiment, output data form can include in the client:Determine in client laterally Set cell indicated by scroll bar and vertical scroll bar, wherein, horizontal scroll bar is used to indicate the list in data form First lattice, vertical scroll bar are used to indicate the row cell in data form, and Set cell is that column unit lattice are handed over row cell The cell of fork;Target data form is exported in the client, wherein, the target data unit lattice in target data form are with number It is initial data cell according to the Set cell in form, the object table head unit lattice in target data form are data form In target data unit lattice corresponding to gauge outfit cell, the overall width of column unit lattice is less than or equal to visitor in target data form The pagewidth at family end, the total height of row cell is less than or equal to the page height of client in target data form.
It can include being used to indicate the column unit lattice in data form using the above embodiment of the present invention, in customer terminal webpage Horizontal scroll bar, and for indicating the vertical scroll bar of the row cell in data form;Column unit lattice in data form It is Set cell with the cell that row cell intersects;Object table head unit lattice in target data form are with data form In Set cell as start element lattice;Object table head unit lattice in target data form are the target in data form Gauge outfit cell corresponding to data cells;The overall width of column unit lattice is less than or equal to the page of client in target data form Face width;The total height of row cell is less than or equal to the page height of client in target data form, and then by determining visitor Horizontal scroll bar and the Set cell indicated by vertical scroll bar in the end of family, and target data form is exported in the client, So as to realize in the client by rolling scroll bar come the data of the partial table in display data form.
As a kind of optional embodiment, object table head unit lattice include parent gauge outfit cell and sub- level gauge outfit unit Lattice, parent gauge outfit cell include at least one sub- level gauge outfit cell, and sub- level gauge outfit cell is target data unit lattice institute Corresponding gauge outfit cell, wherein, exporting target data form in the client can include:It is determined that belong to same parent table The quantity of the sub- level gauge outfit cell of head unit lattice;The overall width of the sub- level gauge outfit cell of quantity is arranged to same parent The width of gauge outfit cell.
Using the above embodiment of the present invention, object table head unit lattice include parent gauge outfit cell and sub- level gauge outfit unit Lattice, wherein, parent gauge outfit cell is corresponding with least one sub- level gauge outfit cell, per height level gauge outfit cell and number of targets It is corresponding according to cell, during exporting target data form in the client, it can first determine to belong to same parent gauge outfit list The quantity of the sub- level gauge outfit cell of first lattice, it is then determined that the width of parent gauge outfit cell is to belong to the parent gauge outfit cell More height level gauge outfit cells width sum, so as to show multi-level table head unit lattice in the client.
As an optional example, target gauge outfit form includes two parent gauge outfit cells, respectively cell A With cell B, each parent gauge outfit cell includes three sub- level gauge outfit cells, sub- level gauge outfit list corresponding to cell A First lattice are respectively cell a1, cell a2, cell a3;Sub- level gauge outfit cell is respectively cell corresponding to cell B B1, cell b2, cell b3.More height level gauge outfit cells are N, i.e. cell a1, cell a2, cell a3, And cell b1, cell b2, cell b3 width are N, then cell A width be cell a1, cell a2, And cell a3 width sum, i.e. cell A width is 3N;Cell B width be cell b1, cell b2, And cell b3 width sum, i.e. cell B width is also 3N.
As a kind of optional embodiment, in the client after output data form, the embodiment can also include: Temperature figure is exported in client, wherein, temperature figure is used to indicate data distribution temperature situation in data form, and/or tables of data The partial table that client currently exports in lattice, block diagram mark of regional location of the partial table in data form in temperature figure Note represents.
Using the above embodiment of the present invention, temperature figure can indicate the distribution temperature situation of data in data form, may be used also To represent partial table that data form the exports in the client region position in data form with the block diagram mark in temperature figure Put, so as to be easy to the distribution situation of all data of the user in temperature figure display data form, and current presentation Region of the partial data form in complete data form.
As a kind of optional embodiment, after exporting temperature map grid in the client, the embodiment can also include: Detection marks the second performed touch control operation to the block diagram in temperature figure in client, wherein, the second touch control operation is used to refer to Show output par, c form in the client;In the case where detecting the second touch control operation, output box icon is remembered in the client Indicated partial table.
Using the above embodiment of the present invention, the second touch control operation is used to indicate output par, c form in the client, in visitor Detected in the end of family in the case of performing the second touch control operation to the block diagram mark in temperature figure, block diagram is exported in client town The indicated partial table of mark, the form of different piece is checked in the client so as to realize by pulling block diagram mark Data.
As a kind of optional embodiment, in the client after output data form, the embodiment can also include:It is right Data in the data form exported in client carry out data analysis according to different dimensions, obtain data results.
Using the above embodiment of the present invention, output data form includes multiple dimensions, and any two dimension in client The intersection data of degree, data analysis is carried out according to different dimensions by the data in the data form to being exported in client, i.e., The result of the progress alternate analysis to the data of different dimensions can be obtained, it is achieved thereby that the intersection point to different dimensions data Analysis.
Table 2 is the data form exported in a kind of optional client according to the above embodiment of the present invention, such as the institute of table 2 Show, " A ", " B ", " C ", and " a ", " b " represent multiple dimensions of data form, " N1 " represents the friendship of dimension " A " and dimension " a " Data are pitched, " N2 " represents the intersection data of dimension " B " and dimension " a ", and " N3 " represents the intersection data of dimension " C " and dimension " a ", " N4 " represents the intersection data of dimension " A " and dimension " b ", and " N5 " represents the intersection data of dimension " B " and dimension " b ", " N6 " table Show the intersection data of dimension " B " and dimension " b ", by carrying out data analysis to " N1 ", " N2 ", " N3 ", " N4 " and " N5 ", It can be achieved to carry out alternate analysis to " A ", " B ", " C ", and " a ", the data of " b " dimension, show that above-mentioned multiple dimensions are corresponding Alternate analysis result.
Table 2:
A B C
a N1 N2 N3
b N4 N5 N6
Present invention also offers a kind of preferred embodiment, the preferred embodiment provides a kind of various dimensions alternate analysis data Method.
The method of various dimensions alternate analysis data provided by the invention, can run in web browser, and user passes through visit This application website is asked to use the present invention.
It should be noted that the present invention includes data storage end, logical process end, and WEB client side.
Alternatively, data storage end uses the structure that distributed data stores, it is possible to achieve parallel dilatation with calculating in real time. Data storage end has used JIT compiler dynamic sql technique of compiling simultaneously, can lift the execution efficiency of query statement, can prop up Hold the smooth inquiry of 100,000 DBMSs.
It should be noted that the English full name of JIT compiler is:Just-In-Time Compiler, Chinese is i.e. When compiler, microsoft intermediate language (MSIL) can be compiled into a variety of machine codes, be put down with system corresponding to adapting to Platform, finally calling program is set successfully to be run in goal systems.
It should be noted that SQL English full name is Structured Query Language, Chinese is structure Change query language, be a kind of programmer of specific purposes, be a kind of data inquiry and programming language soon, for data storage And inquiry, renewal and administrative relationships Database Systems.
Alternatively, logical process end is completed using HyperText Preprocessor (PHP), and boundary will be applied when user accesses by realizing Face returns to the function of client terminal, will pass through logical process end when user is being inquired about in terminal using web browser Data query is carried out in end is stored, then the one-dimensional data structure organization inquired is back to user's end into two dimensional data structure In the WEB client side at end, WEB client side realizes data render.
Alternatively, WEB client side is completed using js, html, css, ajax, cavans, is realized and is supported 100,000 series The effect that form is shown in WEB terminal smoothness according to this, wherein, the displaying of 100,000 DBMS amounts of WEB client side, referring to can With in WEB client side that the data of the row above of 100000 row * 10 are disposable and smoothness shows user.It and in general are shown Unlike method, existing scheme is typically after the returned data of logical process end directly using table labels disposably by form Complete, but this scheme will result in WEB client side interim card more than 100 row * 10 row, experience is poor, and browse efficiency is low.This Scheme of the invention is to draw form using div tag, and in logical end returned data first by data buffer storage in terminal internal memory, only Visible data in user's form are drawn, when user, which triggers scroll bar, to be browsed, then data are rendered to displaying one by one, beyond user The data row of form visible range, it will destroyed, so can realizes 100,000 DBMS amounts of WEB client side Browse.
Fig. 3 is a kind of schematic diagram of optional various dimensions alternate analysis data according to embodiments of the present invention, such as Fig. 3 institutes Show, front end is connected by the method for various dimensions alternate analysis data by CGI with accumulation layer, its frame structure and process, such as Fig. 3 It is shown, wherein, CGI English full name is Common Gateway Interface, and Chinese is CGI, is outside Nominal interface between application program and Web server, it is the process of the transmission information between cgi script and Web programs.
Alternatively, in the framework of various dimensions alternate analysis data, CGI includes real time data processing, off-line data is handled, Data conversion treatment, temperature figure storage processing;Front end include AjaxProxy (Ajax agency), common (common part), QuotaContale (quota controls), Tool Bar (toolbar), Mutil Control (more controls), Quota Editor are (fixed Volume editor), Table Control (table control), Big Table (distributed data-storage system), Cross Analysis (hand over Fork analysis).
Alternatively, during various dimensions alternate analysis data, front end request data is sent, then the basis in CGI The front end request data generation off-line data and real time data, form index further according to real time data and index are segmented, Yi Jitong SQL is crossed to input index and index segmentation to accumulation layer.
Alternatively, during various dimensions alternate analysis data, after accumulation layer obtains data, will be obtained in CGI Data carry out data conversion and the storage of temperature figure, change data form, and rendering data are then carried out in front end.
Alternatively, the present invention needs disposably to show with forms mode more than 100,000 row * suitable for web browser The scene of 100 column datas, the technical program include gauge outfit part and list data part.
Fig. 4 is a kind of schematic diagram of optional data display scene according to embodiments of the present invention, as shown in figure 4, first Individual part is gauge outfit part, wherein, the displaying of ranks N levels gauge outfit is held by table header branch.The second part is list data displaying, its In, list data displaying includes a scroll bar realized using javascript.
Fig. 5 is according to embodiments of the present invention a kind of optional 100, the schematic diagram of the column data forms of 000 row * 100, is such as schemed Shown in 5, the technical program support realization principle of the disposable displaying more than the column data forms of 100,000 row * 100 as shown in figure 5, Arranged in the case of 16 row * 8, establish the row, column coordinate of form respectively, and position corresponding to the row, column coordinate in form shows data Data.
For example, have received one group of 2-D data from server in the page, and it is stored among internal memory.Acknowledge receipt of and From after the data of server, technical scheme provided by the invention, a container will be manufactured in WEB page.
Fig. 6 is a kind of schematic diagram one of optional manufacture container according to embodiments of the present invention, as shown in fig. 6, using div Manufacture a container.
Fig. 7 is a kind of schematic diagram two of optional manufacture container according to embodiments of the present invention, as shown in fig. 7, in Fig. 6 institutes On the basis of showing scheme, table ranks numbers can just be accommodated by producing it according to div container size.
Fig. 8 is a kind of schematic diagram three of optional manufacture container according to embodiments of the present invention, as shown in figure 8, in Fig. 7 institutes On the basis of showing scheme, horizontal scroll bar and vertical scroll bar are established respectively, manually implemented one group of scroll bar, is determined by scroll bar Position data (rather than pixel is positioned by scroll bar).
Fig. 9 is a kind of schematic diagram four of optional manufacture container according to embodiments of the present invention, as shown in figure 9, in Fig. 8 institutes On the basis of showing scheme, the subscript according to pointed by scroll bar, display is filled to the grid in form using the data in internal memory It is worth (data).
Figure 10 is a kind of schematic diagram five of optional manufacture container according to embodiments of the present invention, as shown in Figure 10, in Fig. 9 On the basis of shown scheme, when scroll bar rolls, the content in these grid is emptied again, and number is marked under The data of current location are found in, and are put into grid.
Figure 11 is a kind of schematic diagram of the realization principle of optional multilayer gauge outfit part according to embodiments of the present invention, is such as schemed Shown in 11, list head array is established, multiple gauge outfits is marked with subscript 0, subscript 1 ... subscript N respectively, is recorded in each gauge outfit every The multilayer gauge outfit of individual gauge outfit, for example, " subscript 0 " includes " gauge outfit 0 ", and " word gauge outfit " gauge outfit 0_1 ", " table of gauge outfit 0 " The multilayer gauge outfits such as head 0_2 ".
Alternatively, the data structure shown in Figure 10 is received from server, is stored in internal memory.The data structure is used for The multilayer gauge outfit of one n-layer level is described, itself is an one-dimension array, and each element includes a unlimited pole in its array Tree.
Figure 12 is a kind of schematic diagram of optional list head array according to embodiments of the present invention, as shown in figure 12, list Each column data that each least significant end element of element is corresponded in data form in head array.
Alternatively, on the page, the step of data above structure is rendered into gauge outfit shown in the page, is:
1. first rendering form, and scroll bar is initialized in the table.
2. the data structure of gauge outfit in internal memory is once calculated again, bivariate table is calculated as, and will be every in bivariate table The link of original gauge outfit data structure is added in one element.
3. in the bivariate table after calculating, the subscript passed back using scroll bar starts to use div elements in last column Circulation renders gauge outfit, using the link in last column element, the primitive element being linked in tree data structure and to parent Element extends and judges that the number of daughter element determines its parent element width that will be manufactured in parent element, and uses div If the form parent element that element renders parent element still has parent element, repeat more than operation until can not be upward again Stretching, extension.Manufacture is completed to enter back into the manufacture of next element after parent element and to repeat procedure above total until manufactured gauge outfit The width that width exceedes current form display area just stops manufacturing gauge outfit.
4. when rolling operation occurs for the scroll bar in form, scroll bar will notify gauge outfit object to use new data subscript Again gauge outfit is rendered.
Figure 13 is a kind of schematic diagram of the final rendering effect of optional form according to embodiments of the present invention, such as Figure 13 institutes Show, form it is horizontal and vertical on include two level gauge outfit, wherein, in the transverse direction of form, four width phases can be included With one-level gauge outfit, include two width identical two level gauge outfits, the width sum of two two level gauge outfits under each one-level gauge outfit It is identical with the width of one-level gauge outfit, and the width of each two level gauge outfit is identical with the width of element in form display area, one The height of level gauge outfit and two level gauge outfit is identical with the height of element in form display area;On the longitudinal direction of form, it can wrap Eight height identical one-level gauge outfits are included, include eight height identical two level gauge outfits, two secondary tables under each one-level gauge outfit The height sum of head is identical with the height of one-level gauge outfit, and the height phase of the height and form display area of each two level gauge outfit Together, the height of one-level gauge outfit and two level gauge outfit is identical with the width of element in form display area.
Figure 14 is the schematic diagram one at the interface in a kind of optional interaction according to embodiments of the present invention, such as Figure 14 institutes Show, user accesses this application in web browser, and this application will show the interface of left-right layout, is arranged on the left side at interface Be index, the right shows form.
Figure 15 is the schematic diagram two at the interface in a kind of optional interaction according to embodiments of the present invention, such as Figure 15 institutes Show, can be by the index in index list by mouse drag to " OK " region or " row " region, for example, can will " year Age " index is dragged to column region, and " sex " index is dragged into row region.
Figure 16 is the schematic diagram three at the interface in a kind of optional interaction according to embodiments of the present invention, such as Figure 16 institutes Show, after the completion of dragging, the index operated in index list will become unusable state.It will be shown in form current The data of the index of dragging, for example, on the basis of Figure 14, show the content shown in table 3.Table 3 is to be used to count Nanshan District ten Some sleep population ages, the statistical form of sex respectively, pass through age of the table 3 to ten one points of Nanshan District sleep crowd and sex The alternate analysis of dimension, learn the age 10~20 years old, 20~30 years old, male's quantity highest of 30~40 years old, Nv Xingqi It is secondary.
Table 3:
1-10 10-20 20-30 30-40 40-50 50-60
Man 234 254,986 346,578 356,354 7,859 230
Female 120 34,567 463,546 470,564 7,437 125
It is unknown 0 1,568 2,457 3,150 430 2
Figure 17 is the schematic diagram four at the interface in a kind of optional interaction according to embodiments of the present invention, such as Figure 17 institutes Show, multiple indexs can be pulled simultaneously and gone to row or column, so form various dimensions and intersect form, facilitate data analyst to enter Row analysis, for example, on the basis of sex, the dimension form of " educational background " and " province " is set, on the basis of " sex " distribution, " educational background " dimension is added, such as " junior middle school ", " senior middle school ", " junior college ", " undergraduate course ", " master ";On the basis of " age " is distributed, increase Add " province " dimension, such as " Guangdong Province ", " Hunan Province ".
Figure 18 is the schematic diagram five at the interface in a kind of optional interaction according to embodiments of the present invention, such as Figure 18 institutes Show, when data volume is big, for the ease of searching critical data position, is also equipped with temperature figure, temperature figure form, temperature can be opened The temperature situation of current all data is not only shown in figure form, the region that active sheet is shown is also showed that, with rectangle Mark.On this basis, operating personnel can not only use mouse pointer to pull scroll bar and be checked, can also pull heat Rectangular window in degree figure window checks data, facilitates operating personnel to browse in some data focuses.
Using the above embodiment of the present invention, compared with existing data analysing method, data analysis side provided by the invention The advantage of method has:
1. by storage end distribution can parallel dilatation coordinate JIT dynamic sql techniques of compiling, ten million DBMS can be most fast Inquired about and complete in 0.533 second.
2. being rendered by WEB front-end segmented, smooth 100,000 DBMSs can be shown, and coordinate temperature figure to help user to look for To data focus.
By selecting any section constantly to segment 3. temperature chart-pattern can be coordinated to find user for shadow of playing Loud critical data.
4. after temperature figure lock onto target user, this crowd of user can be quickly drawn a circle to approve on form, and extracted, drawn Picture and tracking, complete depth analysis.
According to the above embodiment of the present invention, the on-line data analysis application that can be realized by web browser, pass through dragging Can be with the completion data analysis function that troublesome operation could be realized in EXCEL Deng operation.
, can be by WEB 100,000 grades of two-dimensional data tables of smooth displaying according to the above embodiment of the present invention, and support temperature figure Display.
, can be by going to make the section of bivariate table constantly thin in drag operation to row or column according to the above embodiment of the present invention Point.
According to the above embodiment of the present invention, after completing targeted customer's locking using temperature figure, the user of delineation is entered again Row extraction, portrait and trace analysis.
, can be quick by the midpoint crossing expansion to various dimensions in data analysis using the above embodiment of the present invention The data-intensive point that preview is concerned about to a data analyst, also, can quickly be opened up in the case where supporting multiple dimensions Open analysis it is concluded that.
The above embodiment of the present invention, more bigger display data amounts can be supported on the premise of independent of EXCEL, More easily operate, data analyst only needs to open application in web browser can be to carry out various dimensions midpoint crossing Analysis, it is not necessary to data export is put into EXCEL again and made by hand.
, can be with pin in the case of carrying out various dimensions alternate analysis in web browser using the above embodiment of the present invention Lower brill analysis is carried out to its data-intensive point and user draws a portrait and operated.
It should be noted that for foregoing each method embodiment, in order to be briefly described, therefore it is all expressed as a series of Combination of actions, but those skilled in the art should know, the present invention is not limited by described sequence of movement because According to the present invention, some steps can use other orders or carry out simultaneously.Secondly, those skilled in the art should also know Know, embodiment described in this description belongs to preferred embodiment, and involved action and module are not necessarily of the invention It is necessary.
Through the above description of the embodiments, those skilled in the art can be understood that according to above-mentioned implementation The method of example can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but a lot In the case of the former be more preferably embodiment.Based on such understanding, technical scheme is substantially in other words to existing The part that technology contributes can be embodied in the form of software product, and the computer software product is stored in a storage In medium (such as ROM/RAM, magnetic disc, CD), including some instructions to cause a station terminal equipment (can be mobile phone, calculate Machine, server, or network equipment etc.) perform method described in each embodiment of the present invention.
Embodiment 2
According to embodiments of the present invention, a kind of data form life for being used to implement above-mentioned data form generation method is additionally provided Into device.Figure 19 is a kind of schematic diagram of optional data form generating means according to embodiments of the present invention, as shown in figure 19, The device can include:First detection unit 1901, for detecting the first touch control operation in the client, wherein, the first touch-control Operate for asking generation data form, data form has multiple dimensions, and the first touch control operation is selected multiple for instruction Dimension;Second detection unit 1903, in the case where detecting the first touch control operation, obtaining any two in multiple dimensions The intersection data of dimension;Adding device 1905, for multiple dimensions to be added to the gauge outfit cell in data form, and it will intersect Data are added to data cells corresponding to any two dimension intersection;First output unit 1907, for defeated in the client Go out data form, wherein, data form includes gauge outfit cell and data cells.
It should be noted that the first detection unit 1901 in the embodiment can be used for performing in the embodiment of the present application 1 Step S202, the second detection unit 1903 in the embodiment can be used for performing the step S204 in the embodiment of the present application 1, Adding device 1905 in the embodiment can be used for performing the step S206 in the embodiment of the present application 1, and the in the embodiment One output unit 1907 can be used for performing the step S208 in the embodiment of the present application 1.
Herein it should be noted that above-mentioned module is identical with example and application scenarios that corresponding step is realized, but not It is limited to the disclosure of that of above-described embodiment 1.It should be noted that above-mentioned module as a part for device may operate in as It in hardware environment shown in Fig. 1, can be realized, can also be realized by hardware by software.
As a kind of optional embodiment, output unit includes:First determining module, for determining laterally to roll in client Set cell indicated by dynamic bar and vertical scroll bar, wherein, horizontal scroll bar is used to indicate the column unit in data form Lattice, vertical scroll bar are used to indicate the row cell in data form, and Set cell is that column unit lattice intersect with row cell Cell;Output module, for exporting target data form in the client, wherein, the number of targets in target data form According to cell using the Set cell in data form as initial data cell, the object table head unit in target data form Lattice are the gauge outfit cell corresponding to the target data unit lattice in data form, the beam overall of column unit lattice in target data form Degree is less than or equal to the pagewidth of client, and the total height of row cell is less than or equal to the page of client in target data form Highly.
As a kind of optional embodiment, object table head unit lattice include parent gauge outfit cell and sub- level gauge outfit unit Lattice, parent gauge outfit cell include at least one sub- level gauge outfit cell, and sub- level gauge outfit cell is target data unit lattice institute Corresponding gauge outfit cell, wherein, output module can include:Second determining module, for determining to belong to same parent table The quantity of the sub- level gauge outfit cell of head unit lattice;Setup module, for the overall width of the sub- level gauge outfit cell of quantity to be set It is set to the width of same parent gauge outfit cell.
As a kind of optional embodiment, the embodiment can also include:Second output unit, for defeated in the client Go out after data form, export temperature figure in the client, wherein, temperature figure is used to indicate data distribution temperature in data form The partial table that client currently exports in situation, and/or data form, regional location of the partial table in data form are used Block diagram mark in temperature figure represents.
As a kind of optional embodiment, the embodiment can also include:3rd detection unit, in the client heat outputting Spend after map grid, for detecting second touch control operation performed to the block diagram mark in temperature figure in the client, wherein, the Two touch control operations are used to indicate output par, c form in the client;3rd output unit, for detecting the second touch-control behaviour In the case of work, output box icon remembers indicated partial table in the client.
As a kind of optional embodiment, the embodiment can also include:Analytic unit, for exporting number in the client After form, data analysis is carried out according to different dimensions to the data in the data form that is exported in client, counted According to analysis result.
By above-mentioned module, data form has multiple dimensions, and the first touch control operation is used to ask generation data form, and Multiple dimensions are selected in instruction, and touch control operation is detected by client, and in the case where detecting the first touch control operation, are obtained The intersection data of any two dimension in multiple dimensions, then multiple dimensions are added to the gauge outfit cell of data form, and will Intersect data to be added in data cells corresponding to any two dimension intersection, then output includes gauge outfit list in the client The data form of first lattice and data cells, can solve correlation technique to realize that the alternate analysis of different dimensions data is led to Often need to export data from database, data generation data form derived from institute is then entered into line number manually using EXCEL According to alternate analysis, cause the technical problem that data analysis is less efficient, and then handing over to different dimensions data automatically Pitch the technique effect of analysis.
Embodiment 3
According to embodiments of the present invention, a kind of electronic installation for being used to implement above-mentioned data form generation method is additionally provided.
Figure 20 is a kind of structured flowchart of electronic installation according to embodiments of the present invention, as shown in figure 20, the electronic installation It can include:One or more (one is only shown in figure) processor 201, memory 203 and transmitting devices 205, such as Figure 20 Shown, the electronic installation can also include input-output equipment 207.
Wherein, memory 203 can be used for storage software program and module, such as the data form life in the embodiment of the present invention Into programmed instruction/module corresponding to method and apparatus, processor 201 is stored in the software program in memory 203 by operation And module, so as to perform various function application and data processing, that is, realize above-mentioned data form generation method.Memory 203 may include high speed random access memory, can also include nonvolatile memory, as one or more magnetic storage device, Flash memory or other non-volatile solid state memories.In some instances, memory 203 can further comprise relative to processing The remotely located memory of device 201, these remote memories can pass through network connection to terminal.The example of above-mentioned network includes But it is not limited to internet, intranet, LAN, mobile radio communication and combinations thereof.
Above-mentioned transmitting device 205 is used to data are received or sent via a network.Above-mentioned network instantiation It may include cable network and wireless network.In an example, transmitting device 205 includes a network adapter (Network Interface Controller, NIC), its can be connected by netting twine with other network equipments with router so as to interconnection Net or LAN are communicated.In an example, transmitting device 205 is radio frequency (Radio Frequency, RF) module, its For wirelessly being communicated with internet.
Wherein, specifically, memory 203 is used to store application program.
Processor 201 can call the application program that memory 203 stores, to perform following step:Examine in the client The first touch control operation is surveyed, wherein, the first touch control operation is used to ask generation data form, and data form has multiple dimensions, the One touch control operation selects multiple dimensions for instruction;In the case where detecting the first touch control operation, obtain in multiple dimensions The intersection data of any two dimension;Multiple dimensions are added into the gauge outfit cell in data form, and data addition will be intersected To data cells corresponding to any two dimension intersection;Output data form in the client, wherein, data form includes table Head unit lattice and data cells.
Processor 201 is additionally operable to perform following step:Determine in client indicated by horizontal scroll bar and vertical scroll bar Set cell, wherein, horizontal scroll bar is used to indicate column unit lattice in data form, and vertical scroll bar is used for indicated number According to the row cell in form, Set cell is the cell that column unit lattice intersect with row cell;Export in the client Target data form, wherein, target data unit lattice in target data form are using the Set cell in data form to rise Beginning data cells, the object table head unit lattice in target data form are corresponding to the target data unit lattice in data form Gauge outfit cell, the overall width of column unit lattice is less than or equal to the pagewidth of client, target data in target data form The total height of row cell is less than or equal to the page height of client in form.
Processor 201 is additionally operable to perform following step:It is determined that belong to the sub- level gauge outfit list of same parent gauge outfit cell The quantity of first lattice;The overall width of the sub- level gauge outfit cell of quantity is arranged to the width of same parent gauge outfit cell.
Processor 201 is additionally operable to perform following step:In the client after output data form, export in the client Temperature figure, wherein, temperature figure is used to indicate data distribution temperature situation in data form, and/or client is worked as in data form The partial table of preceding output, the block diagram mark in regional location temperature figure of the partial table in data form represent.
Processor 201 is additionally operable to perform following step:After exporting temperature map grid in the client, detect in the client Second touch control operation performed to the block diagram mark in temperature figure, wherein, the second touch control operation is used to indicate in the client Output par, c form;In the case where detecting the second touch control operation, output box icon remembers indicated part in the client Form.
Processor 201 is additionally operable to perform following step:It is defeated to institute in client in the client after output data form Data in the data form gone out carry out data analysis according to different dimensions, obtain data results.
Using the embodiment of the present invention, there is provided a kind of data form generates scheme.Data form has multiple dimensions, and first Touch control operation is used to ask generation data form, and indicates to select multiple dimensions, by client detection touch control operation, and In the case of detecting the first touch control operation, the intersection data of any two dimension in multiple dimensions are obtained, then by multiple dimensions It is added to the gauge outfit cell of data form, and data will be intersected and be added to data cells corresponding to any two dimension intersection In, then output includes gauge outfit cell and the data form of data cells in the client, can solve correlation technique It is then manual using EXCEL in order to realize that the alternate analysis of different dimensions data usually requires to export data from database Data generation data form derived from institute is subjected to data cross analysis, causes the technical problem that data analysis is less efficient, enters And reach the technique effect of the progress alternate analysis to different dimensions data automatically.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2 Example, the present embodiment will not be repeated here.
It will appreciated by the skilled person that the structure shown in Figure 20 is only to illustrate, electronic installation can be intelligence Mobile phone (such as Android phone, iOS mobile phones), tablet personal computer, palm PC and mobile internet device (Mobile Internet Devices, MID), the terminal device such as PAD.Figure 20 it does not cause to limit to the structure of above-mentioned electronic installation.Example Such as, electronic installation may also include than shown in Figure 20 more either less components (such as network interface, display device) or With the configuration different from shown in Figure 20.
One of ordinary skill in the art will appreciate that all or part of step in the various methods of above-described embodiment is can To be completed by program come command terminal device-dependent hardware, the program can be stored in a computer-readable recording medium In, storage medium can include:Flash disk, read-only storage (Read-Only Memory, ROM), random access device (Random Access Memory, RAM), disk or CD etc..
Embodiment 4
Embodiments of the invention additionally provide a kind of storage medium.Alternatively, in the present embodiment, above-mentioned storage medium can For performing the program code of data form generation method.
Alternatively, in the present embodiment, above-mentioned storage medium can be located at multiple in the network shown in above-described embodiment On at least one network equipment in the network equipment.
Alternatively, in the present embodiment, storage medium is arranged to the program code that storage is used to perform following steps:
S1, the first touch control operation is detected in the client, wherein, the first touch control operation is used to ask generation data form, Data form has multiple dimensions, and the first touch control operation selects multiple dimensions for instruction;
S2, in the case where detecting the first touch control operation, obtain the intersection data of any two dimension in multiple dimensions;
S3, multiple dimensions are added into the gauge outfit cell in data form, and data will be intersected and be added to any two dimension Data cells corresponding to degree intersection;
S4, output data form in the client, wherein, data form includes gauge outfit cell and data cells.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps:Determine in client Set cell indicated by horizontal scroll bar and vertical scroll bar, wherein, horizontal scroll bar is used to indicate in data form Column unit lattice, vertical scroll bar are used to indicate the row cell in data form, and Set cell is column unit lattice and row unit The cell that lattice intersect;Target data form is exported in the client, wherein, the target data unit lattice in target data form Using the Set cell in data form as initial data cell, the object table head unit lattice in target data form are data The gauge outfit cell corresponding to target data unit lattice in form, the overall width of column unit lattice is less than etc. in target data form The total height of row cell is less than or equal to the page height of client in the pagewidth of client, target data form.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps:It is determined that belong to same The quantity of the sub- level gauge outfit cell of individual parent gauge outfit cell;The overall width of the sub- level gauge outfit cell of quantity is arranged to same The width of one parent gauge outfit cell.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps:It is defeated in the client Go out after data form, export temperature figure in the client, wherein, temperature figure is used to indicate data distribution temperature in data form The partial table that client currently exports in situation, and/or data form, regional location of the partial table in data form are used Block diagram mark in temperature figure represents.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps:It is defeated in the client Go out after temperature map grid, detect second touch control operation performed to the block diagram mark in temperature figure in the client, wherein, the Two touch control operations are used to indicate output par, c form in the client;In the case where detecting the second touch control operation, in client The indicated partial table of output box icon note in end.
Alternatively, storage medium is also configured to the program code that storage is used to perform following steps:It is defeated in the client Go out after data form, data analysis is carried out according to different dimensions to the data in the data form that is exported in client, obtained To data results.
Alternatively, the specific example in the present embodiment may be referred to showing described in above-described embodiment 1 and embodiment 2 Example, the present embodiment will not be repeated here.
Alternatively, in the present embodiment, above-mentioned storage medium can include but is not limited to:USB flash disk, read-only storage (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disc or CD etc. is various can be with the medium of store program codes.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
If the integrated unit in above-described embodiment is realized in the form of SFU software functional unit and is used as independent product Sale or in use, the storage medium that above computer can be read can be stored in.Based on such understanding, skill of the invention The part or all or part of the technical scheme that art scheme substantially contributes to prior art in other words can be with soft The form of part product is embodied, and the computer software product is stored in storage medium, including some instructions are causing one Platform or multiple stage computers equipment (can be personal computer, server or network equipment etc.) perform each embodiment institute of the present invention State all or part of step of method.
In the above embodiment of the present invention, the description to each embodiment all emphasizes particularly on different fields, and does not have in some embodiment The part of detailed description, it may refer to the associated description of other embodiment.
In several embodiments provided herein, it should be understood that disclosed client, can be by others side Formula is realized.Wherein, device embodiment described above is only schematical, such as the division of the unit, and only one Kind of division of logic function, can there is an other dividing mode when actually realizing, for example, multiple units or component can combine or Another system is desirably integrated into, or some features can be ignored, or do not perform.It is another, it is shown or discussed it is mutual it Between coupling or direct-coupling or communication connection can be INDIRECT COUPLING or communication link by some interfaces, unit or module Connect, can be electrical or other forms.
The unit illustrated as separating component can be or may not be physically separate, show as unit The part shown can be or may not be physical location, you can with positioned at a place, or can also be distributed to multiple On NE.Some or all of unit therein can be selected to realize the mesh of this embodiment scheme according to the actual needs 's.
In addition, each functional unit in each embodiment of the present invention can be integrated in a processing unit, can also That unit is individually physically present, can also two or more units it is integrated in a unit.Above-mentioned integrated list Member can both be realized in the form of hardware, can also be realized in the form of SFU software functional unit.
Described above is only the preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art For member, under the premise without departing from the principles of the invention, some improvements and modifications can also be made, these improvements and modifications also should It is considered as protection scope of the present invention.

Claims (14)

  1. A kind of 1. data form generation method, it is characterised in that including:
    The first touch control operation is detected in the client, wherein, first touch control operation is used to ask generation data form, described Data form has multiple dimensions, and first touch control operation selects the multiple dimension for instruction;
    In the case where detecting first touch control operation, the crossing number of any two dimension in the multiple dimension is obtained According to;
    The multiple dimension is added into the gauge outfit cell in the data form, and the intersection data are added to described appoint Data cells corresponding to two dimensions intersections of meaning;
    The data form is exported in the client, wherein, the data form includes the gauge outfit cell and described Data cells.
  2. 2. according to the method for claim 1, it is characterised in that described that the data form bag is exported in the client Include:
    The Set cell indicated by horizontal scroll bar and vertical scroll bar in the client is determined, wherein, the laterally rolling Dynamic bar is used to indicate the column unit lattice in the data form, and the vertical scroll bar is used to indicate the row in the data form Cell, the Set cell are the cell that the column unit lattice intersect with the row cell;
    Target data form is exported in the client, wherein, target data unit lattice in the target data form with The Set cell in the data form is initial data cell, the target gauge outfit list in the target data form First lattice are the gauge outfit cell corresponding to the target data unit lattice in the data form, in the target data form The overall width of column unit lattice is less than or equal to the pagewidth of the client, total height of row cell in the target data form Page height of the degree less than or equal to the client.
  3. 3. according to the method for claim 2, it is characterised in that the object table head unit lattice include parent gauge outfit cell With sub- level gauge outfit cell, the parent gauge outfit cell includes at least one sub- level gauge outfit cell, the sub- level table Head unit lattice are the gauge outfit cell corresponding to the target data unit lattice, wherein, it is described that institute is exported in the client Stating target data form includes:
    It is determined that belong to the quantity of the sub- level gauge outfit cell of the same parent gauge outfit cell;
    The overall width of the sub- level gauge outfit cell of the quantity is arranged to the same parent gauge outfit cell Width.
  4. 4. according to the method for claim 1, it is characterised in that after the data form is exported in the client, Methods described also includes:
    Temperature figure is exported in the client, wherein, the temperature figure is used to indicate data distribution heat in the data form Degree situation, and/or the partial table that client currently exports described in the data form, the partial table is in the data Regional location in form is represented with the block diagram mark in the temperature figure.
  5. 5. according to the method for claim 4, it is characterised in that described after exporting temperature map grid in the client Method also includes:
    Detection marks the second performed touch control operation to the block diagram in the temperature figure in the client, wherein, Second touch control operation is used to indicate to export the partial table in the client;
    In the case where detecting second touch control operation, the indicated institute of the block diagram mark is exported in the client State partial table.
  6. 6. method according to any one of claim 1 to 5, it is characterised in that the number is exported in the client After form, methods described also includes:
    Data analysis is carried out according to different dimensions to the data in the data form that is exported in the client, counted According to analysis result.
  7. A kind of 7. data form generating means, it is characterised in that including:
    First detection unit, for detecting the first touch control operation in the client, wherein, first touch control operation is used to ask Data form is generated, the data form has multiple dimensions, and first touch control operation is selected the multiple for instruction Dimension;
    Second detection unit, it is any in the multiple dimension in the case where detecting first touch control operation, obtaining The intersection data of two dimensions;
    Adding device, for by the addition of the multiple dimension the data form gauge outfit cell, and by the crossing number According to be added to any two dimension intersect corresponding to data cells;
    First output unit, for exporting the data form in the client, wherein, the data form includes described Gauge outfit cell and the data cells.
  8. 8. device according to claim 7, it is characterised in that the output unit includes:
    First determining module, for determining the object element in the client indicated by horizontal scroll bar and vertical scroll bar Lattice, wherein, the horizontal scroll bar is used to indicate the column unit lattice in the data form, and the vertical scroll bar is used to indicate Row cell in the data form, the Set cell are the unit that the column unit lattice intersect with the row cell Lattice;
    Output module, for exporting target data form in the client, wherein, the target in the target data form Data cells are using the Set cell in the data form as initial data cell, in the target data form Object table head unit lattice be the data form in the target data unit lattice corresponding to gauge outfit cell, the mesh The overall width for marking column unit lattice in data form is less than or equal to the pagewidth of the client, is gone in the target data form The total height of cell is less than or equal to the page height of the client.
  9. 9. device according to claim 8, it is characterised in that the object table head unit lattice include parent gauge outfit cell With sub- level gauge outfit cell, the parent gauge outfit cell includes at least one sub- level gauge outfit cell, the sub- level table Head unit lattice are the gauge outfit cell corresponding to the target data unit lattice, wherein, the output module includes:
    Second determining module, the number of the sub- level gauge outfit cell for determining to belong to the same parent gauge outfit cell Amount;
    Setup module, for the overall width of the sub- level gauge outfit cell of the quantity to be arranged into the same father The width of level gauge outfit cell.
  10. 10. device according to claim 7, it is characterised in that described device also includes:
    Second output unit, after exporting the data form in the client, the heat outputting in the client Degree figure, wherein, the temperature figure is used to indicate data distribution temperature situation in the data form, and/or the data form Described in the partial table that currently exports of client, regional location of the partial table in the data form heat The block diagram mark spent in figure represents.
  11. 11. device according to claim 10, it is characterised in that described device also includes:
    3rd detection unit, after exporting temperature map grid in the client, for being detected in the client to described The second touch control operation performed by block diagram mark in temperature figure, wherein, second touch control operation is used to indicate in institute State and the partial table is exported in client;
    3rd output unit, described in the case where detecting second touch control operation, being exported in the client The indicated partial table of block diagram mark.
  12. 12. the device according to any one of claim 7 to 11, it is characterised in that described device also includes:
    Analytic unit, after exporting the data form in the client, to the institute exported in the client The data stated in data form carry out data analysis according to different dimensions, obtain data results.
  13. A kind of 13. storage medium, it is characterised in that the storage medium includes the program of storage, wherein, when described program is run Perform the method described in any one of claim 1 to 6.
  14. 14. a kind of electronic installation, including memory, processor and it is stored on the memory and can transports on the processor Capable computer program, it is characterised in that the processor performs the claim 1 to 6 times by the computer program Method described in one.
CN201710759326.6A 2017-08-29 2017-08-29 Data table generation method and device, storage medium and electronic device Active CN107766309B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710759326.6A CN107766309B (en) 2017-08-29 2017-08-29 Data table generation method and device, storage medium and electronic device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710759326.6A CN107766309B (en) 2017-08-29 2017-08-29 Data table generation method and device, storage medium and electronic device

Publications (2)

Publication Number Publication Date
CN107766309A true CN107766309A (en) 2018-03-06
CN107766309B CN107766309B (en) 2021-06-25

Family

ID=61265763

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710759326.6A Active CN107766309B (en) 2017-08-29 2017-08-29 Data table generation method and device, storage medium and electronic device

Country Status (1)

Country Link
CN (1) CN107766309B (en)

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108920145A (en) * 2018-05-08 2018-11-30 陕西法士特齿轮有限责任公司 A kind of UI table color lump moving method
CN109165377A (en) * 2018-06-11 2019-01-08 玖富金科控股集团有限责任公司 Generate the method and tabulating equipment of form data
CN109299449A (en) * 2018-10-10 2019-02-01 拉扎斯网络科技(上海)有限公司 Form processing method, device, electronic equipment and readable storage medium storing program for executing
CN109492031A (en) * 2018-09-13 2019-03-19 广州虎牙信息科技有限公司 Display methods, server and the computer storage medium of list data
CN109670157A (en) * 2018-12-25 2019-04-23 金蝶软件(中国)有限公司 A kind of control method and relevant device of table height
CN109871524A (en) * 2019-02-21 2019-06-11 腾讯科技(深圳)有限公司 A kind of chart generation method and device
CN110569469A (en) * 2019-09-06 2019-12-13 四川长虹电器股份有限公司 Method for dynamically generating HTML (hypertext markup language) form based on data configuration
CN111581933A (en) * 2020-04-01 2020-08-25 北京明略软件系统有限公司 Method and device for managing forms in webpage
CN111881146A (en) * 2020-09-28 2020-11-03 南京吉拉福网络科技有限公司 Method, computing device and medium for charging a fee
CN112214978A (en) * 2020-10-10 2021-01-12 金蝶云科技有限公司 Data processing method and related equipment
CN113779943A (en) * 2021-01-12 2021-12-10 北京沃东天骏信息技术有限公司 Table generation method, table generation device, storage medium, and electronic apparatus

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104036040A (en) * 2014-06-30 2014-09-10 贝壳网际(北京)安全技术有限公司 Method and device for generating report
US20150039984A1 (en) * 2013-07-31 2015-02-05 Hitachi, Ltd. Table format multi-dimensional data translation method and device
CN104699398A (en) * 2010-01-06 2015-06-10 苹果公司 Device, method, and device for manipulating tables using multi-contact gestures
CN105630986A (en) * 2015-12-25 2016-06-01 中国航天系统工程有限公司 Method for acquiring multidimensional data from database for grid display
CN106095919A (en) * 2016-06-12 2016-11-09 上海交通大学 Data variation trend spring visualization system and method towards analysis of central issue
CN107066439A (en) * 2017-04-07 2017-08-18 广州市玄武无线科技股份有限公司 A kind of method, device and the electronic equipment of custom form control

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104699398A (en) * 2010-01-06 2015-06-10 苹果公司 Device, method, and device for manipulating tables using multi-contact gestures
US20150039984A1 (en) * 2013-07-31 2015-02-05 Hitachi, Ltd. Table format multi-dimensional data translation method and device
CN104036040A (en) * 2014-06-30 2014-09-10 贝壳网际(北京)安全技术有限公司 Method and device for generating report
CN105630986A (en) * 2015-12-25 2016-06-01 中国航天系统工程有限公司 Method for acquiring multidimensional data from database for grid display
CN106095919A (en) * 2016-06-12 2016-11-09 上海交通大学 Data variation trend spring visualization system and method towards analysis of central issue
CN107066439A (en) * 2017-04-07 2017-08-18 广州市玄武无线科技股份有限公司 A kind of method, device and the electronic equipment of custom form control

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108920145A (en) * 2018-05-08 2018-11-30 陕西法士特齿轮有限责任公司 A kind of UI table color lump moving method
CN109165377A (en) * 2018-06-11 2019-01-08 玖富金科控股集团有限责任公司 Generate the method and tabulating equipment of form data
CN109492031A (en) * 2018-09-13 2019-03-19 广州虎牙信息科技有限公司 Display methods, server and the computer storage medium of list data
CN109299449A (en) * 2018-10-10 2019-02-01 拉扎斯网络科技(上海)有限公司 Form processing method, device, electronic equipment and readable storage medium storing program for executing
CN109670157B (en) * 2018-12-25 2023-08-04 金蝶软件(中国)有限公司 Control method for table height and related equipment
CN109670157A (en) * 2018-12-25 2019-04-23 金蝶软件(中国)有限公司 A kind of control method and relevant device of table height
CN109871524A (en) * 2019-02-21 2019-06-11 腾讯科技(深圳)有限公司 A kind of chart generation method and device
CN110569469A (en) * 2019-09-06 2019-12-13 四川长虹电器股份有限公司 Method for dynamically generating HTML (hypertext markup language) form based on data configuration
CN110569469B (en) * 2019-09-06 2022-02-01 四川长虹电器股份有限公司 Method for dynamically generating HTML (hypertext markup language) form based on data configuration
CN111581933A (en) * 2020-04-01 2020-08-25 北京明略软件系统有限公司 Method and device for managing forms in webpage
CN111881146A (en) * 2020-09-28 2020-11-03 南京吉拉福网络科技有限公司 Method, computing device and medium for charging a fee
CN111881146B (en) * 2020-09-28 2020-12-15 南京吉拉福网络科技有限公司 Method, computing device and medium for charging a fee
CN112214978A (en) * 2020-10-10 2021-01-12 金蝶云科技有限公司 Data processing method and related equipment
CN113779943A (en) * 2021-01-12 2021-12-10 北京沃东天骏信息技术有限公司 Table generation method, table generation device, storage medium, and electronic apparatus

Also Published As

Publication number Publication date
CN107766309B (en) 2021-06-25

Similar Documents

Publication Publication Date Title
CN107766309A (en) Data form generation method, device and storage medium, electronic installation
Zhu et al. A survey on automatic infographics and visualization recommendations
US20080120257A1 (en) Automatic online form filling using semantic inference
CN107220386A (en) Information-pushing method and device
CN109299258A (en) A kind of public sentiment event detecting method, device and equipment
CN107577682A (en) Users' Interests Mining and user based on social picture recommend method and system
Jou et al. A study on the improvements of new product development procedure performance–an application of design for Six Sigma in a semi-conductor equipment manufacturer
CN106815192A (en) Model training method and device and sentence emotion identification method and device
CN109815331A (en) Construction method, device and the computer equipment of text emotion disaggregated model
CN111079387A (en) Automatic questionnaire generation method and device, computer equipment and storage medium
CN109918561A (en) A kind of study recommended method of library's (studying space)
CN109582876A (en) Tourism industry user portrait building method, device and computer equipment
CN107239993A (en) A kind of matrix decomposition recommendation method and system based on expansion label
CN104750771A (en) Method and system for contextual data analysis using domain information
CN107292666A (en) Sales potential determination methods and device
Liu et al. GenealogyVis: A system for visual analysis of multidimensional genealogical data
CN103491116A (en) Method and device for processing text-related structural data
CN105930507A (en) Method and apparatus for obtaining Web browsing interest of user
CN105512980B (en) Information processing method and device
CN106157118A (en) A kind of ecommerce OTO terminal distribution system data processing method
CN111860484B (en) Region labeling method, device, equipment and storage medium
CN108959204A (en) Internet monetary items information extraction method and system
CN114049631A (en) Data labeling method and device, computer equipment and storage medium
TWI570579B (en) An information retrieving method utilizing webpage visual features and webpage language features and a system using thereof
CN106126567A (en) Method based on trust data recommendation service

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant