CN110147404A - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN110147404A CN110147404A CN201710910014.0A CN201710910014A CN110147404A CN 110147404 A CN110147404 A CN 110147404A CN 201710910014 A CN201710910014 A CN 201710910014A CN 110147404 A CN110147404 A CN 110147404A
- Authority
- CN
- China
- Prior art keywords
- data
- configuration item
- preset configuration
- datagram
- tables
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/904—Browsing; Visualisation therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2216/00—Indexing scheme relating to additional aspects of information retrieval not explicitly covered by G06F16/00 and subgroups
- G06F2216/03—Data mining
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
A kind of data processing method provided by the invention and device, data processing method obtain the tables of data to visualized data first；Then generation is corresponding with the data field in the tables of data pulls control；User is received later by the drag operation for pulling control and being drawn in preset configuration item；Data field corresponding with the preset configuration item is determined according to the drag operation；The finally corresponding relationship according to the preset configuration item and data field draws datagram corresponding with the tables of data；Show the datagram.It is determined according to the user's choice due to the foundation of the corresponding datagram of drawing data table in technical solution of the present invention, configuration mode is more flexible, same data source various configurations scheme may be implemented, realize multi-angle display data, be more advantageous to the data mining of multi-angle.
Description
Technical field
The present invention relates to data processing field more particularly to a kind of data processing method and devices.
Background technique
Data visualization is the scientific and technical research about data Visual exhibition form of stage design, it can be common that data are used chart
Mode show.For example, the data in Excel table are configured by the way of classification-numerical value, generation classification,
Numerical value is the chart of data axis, so that the visualization of data is realized, to realize the excavation to data.
Continuous with internet is popularized, and people are no longer satisfied using only Excel table the visualization for realizing data,
Therefore, there is data visualization platform, in order to realize data visualization in Web page, to preferably complete logarithm
According to excavation.Wherein, user can in data visualization platform input data source, later, data visualization platform is according to solid
Fixed configuration mode automatically generates chart.
But due to configuration mode be it is fixed, cannot achieve a variety of charts under same data source and come display data, user
It experiences poor.
Summary of the invention
In view of the above problems, it proposes on the present invention overcomes the above problem or at least be partially solved in order to provide one kind
State a kind of data processing method and device of problem.
The present invention provides a kind of data processing methods, comprising:
Obtain the tables of data of pending data visualization；
Generate movable control corresponding with the data field in the tables of data；
Receive the moving operation that the movable control is moved to preset configuration item by user；
Data field corresponding with the preset configuration item is determined according to the result of the moving operation；
According to the corresponding relationship of the preset configuration item and data field, datagram corresponding with the tables of data is drawn；
Show the datagram.
Preferably, data field corresponding with the preset configuration item is determined according to the result of the moving operation described
Later, the method also includes:
Determine be corresponding in all preset configuration items data field each preset configuration item constitute configuration item combination whether
It is drawn for the combination of preset configuration item if so, determining the corresponding relationship needed according to the preset configuration item and data field
Datagram corresponding with the tables of data.
Preferably, the configuration item combination that each preset configuration item of data field is constituted is corresponding in all preset configuration items
When not combined for preset configuration item, the method also includes:
It exports the prompt information of configuration item composition error and shows each preset configuration item combination to prompt user according to aobvious
The preset configuration item combination shown carries out moving operation to the movable control.
Preferably, the corresponding relationship according to the preset configuration item and data field is drawn and the tables of data pair
The datagram answered, comprising:
Determine metadata of the corresponding data field of the preset configuration item in the tables of data；
Metadata table is generated according to the metadata；
Pivot operation is carried out to the metadata table according to the preset configuration item for being corresponding with data field, generates data
Scheme corresponding array, wherein include at least one of: dimension data, classification data and numeric data in the array；
The corresponding datagram of the metadata table is drawn according to the array.
Preferably, the moving operation is drag operation, also, each preset configuration item has corresponding display area,
The moving operation are as follows: the movable control is moved in the corresponding display area of preset configuration item.
Another aspect of the present invention provides a kind of data processing equipment, comprising:
Acquiring unit, for obtaining the tables of data of pending data visualization；
Control generation unit, for generating movable control corresponding with the data field in the tables of data；
Instruction receiving unit is moved to the moving operation of preset configuration item for receiving user for the movable control；
As a result determination unit, for determining data corresponding with the preset configuration item according to the result of the moving operation
Field；
Datagram drawing unit, for the corresponding relationship according to the preset configuration item and data field, draw with it is described
The corresponding datagram of tables of data；
Display unit, for showing the datagram.
Preferably, further includes:
Judging unit, for determine be corresponding in all preset configuration items data field each preset configuration item constitute match
Set whether item combination is the combination of preset configuration item, needs if so, determining according to the preset configuration item and data field
Corresponding relationship draws datagram corresponding with the tables of data.
Preferably, the datagram drawing unit includes:
Metadata determining module, for determining member of the corresponding data field of the preset configuration item in the tables of data
Data；
Metadata table generation module, for generating metadata table according to the metadata；
Pivot module, for carrying out data to the metadata table according to the preset configuration item for being corresponding with data field
Pivot operation generates the corresponding array of datagram, wherein includes at least one of in the array: dimension data, classification number
Accordingly and numeric data；
Datagram drafting module, for drawing the corresponding datagram of the metadata table according to the array.
Another aspect of the present invention provides a kind of storage medium, and the storage medium includes the program of storage, wherein described
Program executes data processing method described above.
Another aspect of the present invention provides a kind of processor, and the processor is for running program, wherein described program fortune
Data processing method described above is executed when row.
By above-mentioned technical proposal, a kind of data processing method provided by the invention and device, data processing method is first
Obtain the tables of data to visualized data；Then generation is corresponding with the data field in the tables of data pulls control；
User is received later by the drag operation for pulling control and being drawn in preset configuration item；It is determined according to the drag operation
Data field corresponding with the preset configuration item；The finally corresponding relationship according to the preset configuration item and data field, draws
Make datagram corresponding with the tables of data；Show the datagram.Since drawing data table is corresponding in technical solution of the present invention
The foundation of datagram determine that configuration mode is more flexible, it is more that same data source may be implemented according to the user's choice
Kind allocation plan, realizes multi-angle display data, is more advantageous to the data mining of multi-angle.
The above description is only an overview of the technical scheme of the present invention, in order to better understand the technical means of the present invention,
And it can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, the followings are specific embodiments of the present invention.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings:
Fig. 1 shows a kind of a kind of flow diagram of data processing method provided in an embodiment of the present invention；
Fig. 2 shows a kind of another flow diagrams of data processing method provided in an embodiment of the present invention；
Fig. 3 shows a kind of another flow diagram of data processing method provided in an embodiment of the present invention；
Fig. 4 shows a kind of structural schematic diagram of data processing equipment provided in an embodiment of the present invention；
Fig. 5 shows a kind of hardware structural diagram of data processing equipment in the embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
It is fully disclosed to those skilled in the art.
The invention discloses a kind of data processing methods, are mainly used in the terminal measurement equipment of data visualization platform,
Data visualization platform may include terminal side equipment and service side apparatus, and wherein terminal side equipment can be PC, mobile terminal
Or PAD etc., service side apparatus mainly includes various types of servers, such as database server, data storage server.
Goal of the invention of the invention essentially consists in, and for the same data source, provides various configurations scheme, can be from more
A angle display data excavates convenient for the multi-angle of data.It describes in detail below to technical solution of the present invention.
As shown in Figure 1, Fig. 1 is a kind of a kind of flow diagram of data processing method provided in an embodiment of the present invention.
A kind of data processing method provided by the invention, comprising:
S101, the tables of data for obtaining pending data visualization；
In the embodiment of the present invention, the tables of data of pending data visualization is obtained first.
Specifically mode may include:
Receive the operation that user selects tables of data in the database being connected with terminal device；
According to operation, the tables of data of pending data visualization is obtained.
It should be noted that including data field in tables of data, multiple data are corresponding under each data field.
It such as, include the data such as Henan, Shandong, Shanxi under province.
S102, generation movable control corresponding with the data field in tables of data；
After obtaining tables of data, the data field in the tables of data is automatically generated into movable control；And it is shown in aobvious
Show in interface.Wherein, movable control title is corresponding with the title of data field, can find tables of data by the title
In data field.
It is understood that the form of movable control can be automatically adjusted according to actual needs.Such as according to word
The length of name section come be sized, the design parameters such as shape, or according to the color adjust automatically color of current interface, herein
It is not defined specifically.
Movable control is drawn to the moving operation in preset configuration item by S103, reception user；
S104, data field corresponding with preset configuration item is determined according to the result of moving operation；
After movable control is demonstrated, the movable control of needs can be dragged to the pre- establishing at preset configuration interface by user
It sets in item.Wherein, preset configuration item is specially dimension configuration item, classification configurations item and numerical value configuration item.
The dragged movable control in configuration item, it can be understood as user configures configuration rule.For example,
Movable control includes province, clicking rate, jumps out these movable controls of rate, click volume, amount of access, medium type, user
Province therein is pushed away and is pulled to classification configurations item, will click on rate, amount of access is dragged in numerical value configuration item, is completed to allocation plan
Formulation.At this point, determining data field corresponding with configuration item in tables of data.For example, determining classification configurations item in tables of data
This field of corresponding province.
Optionally, it is preferred that the moving operation is drag operation, also, each preset configuration item has corresponding show
Show region, the moving operation are as follows: the movable control is moved in the corresponding display area of preset configuration item.
In technical solution of the present invention, moving operation is preferably drag operation, it is to be understood that can also be click,
Operation of double-click etc., as long as preset configuration item is moved into, herein without specifically limiting.
S105, the corresponding relationship according to preset configuration item and data field, draw datagram corresponding with tables of data；
Then, the configuration rule according to user's selection, carrys out drawing data figure.
It is understood that the type of the datagram in the present invention may include histogram, bar chart, line chart and/or
Any one in radar map.
It should be noted that can also include the class for obtaining the selected drawing data figure of user before step S105
Type.Then drawing data figure can be the type that a kind of datagram for needing to show is pre-selected by user, then call and the number
The drafting mode to match according to the type of figure, draws the datagram.If user does not select the type of datagram, can make
With the mode of default type.
S106, display datagram.
It is shown in display interface after drawing data figure.
A kind of data processing method provided by the invention, obtains the tables of data of pending data visualization first；Then it gives birth to
At movable control corresponding with the data field in the tables of data；User is received later to pull the movable control
Moving operation into preset configuration item；Data corresponding with the preset configuration item are determined according to the result of the moving operation
Field；The finally corresponding relationship according to the preset configuration item and data field draws datagram corresponding with the tables of data；
Show the datagram.Since the foundation of the corresponding datagram of drawing data table in technical solution of the present invention is the choosing according to user
It selects to determine, configuration mode is more flexible, and same data source various configurations scheme may be implemented, and realizes that multi-angle shows number
According to being more advantageous to the data mining of multi-angle.
As shown in Fig. 2, Fig. 2 is a kind of another flow diagram of data processing method provided in an embodiment of the present invention.
It is described in above-described embodiment and data field corresponding with preset configuration item is determined according to the result of moving operation
Process can also include to the process for carrying out legal judgement with the configuration rule postponed, below to this after this step S104
Process is introduced.
After the determining data field corresponding with the preset configuration item according to the result of the moving operation, institute
State method further include:
S200, the configuration item combination that each preset configuration item that data field is corresponding in all preset configuration items is constituted is determined
It whether is preset configuration item combination, if so, determine the corresponding relationship needed according to the preset configuration item and data field,
Draw datagram corresponding with the tables of data.
In the embodiment of the present invention, user has also judged data field after movable control is dragged to configuration item
The configuration item combination that is constituted of configuration item whether meet the combination of preset configuration item.
In actual use, if the configuration item combination that the configuration item with data field is constituted meets preset configuration item
Combination, thens follow the steps S105.
It is understood that the configuration item combination that the configuration item with data field is constituted not necessarily may be implemented, example
As the corresponding configuration item of radar map be dimension configuration item and/or classification configurations item can be it is empty, numerical value configuration item is at least one,
If user pulls in numerical value configuration item adds any movable control, mean the combined mode of such configuration without
Method generates radar map.
It is understood that configuration item combination can also be the specific movable control that each configuration item allows to configure.Example
As only allowed to configure clicking rate in numerical value configuration item, jumping out these movable controls of rate, click volume, amount of access.If do not existed
In these controls, then belong to incongruent situation.
The configuration item combination that configuration item with data field is constituted executes if meeting preset configuration item combination
Step S210, it is not combined in the configuration item combination that each preset configuration item for being corresponding with data field is constituted for preset configuration item
When, it exports the prompt information of configuration item composition error and shows that each preset configuration item is combined to prompt user according to the pre- of display
If configuration item combination to movable control carry out moving operation.
Wherein, preset configuration item combination may include the type that specific configuration item allows to configure, it is of course also possible to just
It is the type of datagram.The mode of display can be translucent mode, be also possible to pop up information bar mode, herein not into
Row is specific to be limited.
Therefore, the embodiment of the present invention can also judge whether meet preset configuration item group after user pulls movable control
It closes, translucent information can be prompted if there is mistake, prompt correct configuration item to combine to user, improve user experience.
As shown in figure 3, Fig. 3 is a kind of another flow diagram of data processing method provided in an embodiment of the present invention.
S301, the tables of data for obtaining pending data visualization；
S302, generation movable control corresponding with the data field in tables of data；
Movable control is drawn to the drag operation in preset configuration item by S303, reception user；
S304, data field corresponding with preset configuration item is determined according to drag operation；
Wherein, step S301- step S304 is referred to step S101- step S104, herein without repeating.
S305, metadata of the corresponding data field of preset configuration item in tables of data is determined；
In the embodiment of the present invention, metadata of the movable control pulled in preset configuration item in tables of data is determined.
It specifically can be and completed by way of inquiring field name.
S306, metadata table is generated according to metadata；
Pivot operation is carried out to metadata table according to the preset configuration item for being corresponding with data field, generates datagram pair
The array answered, wherein include at least one of: dimension data, classification data and numeric data in the array；
Later, S307, the corresponding datagram of the metadata table is drawn according to array.
In the embodiment of the present invention, can according to metadata generate metadata table, metadata table can be understood as by screening and
Filter the table having comprising there are the data in tables of data.
Then pivot operation can be carried out to the metadata table, obtains the array of datagram.Wherein, the data in numerical value
For drawing data figure.Such as the classification data and numeric data that can use in array draw cake chart, classification data is used for
The corresponding data of cake chart classification axis are drawn, and numeric data is for drawing in cake chart corresponding to each specific sorting field
Specific value.
In actual use, the corresponding first number of the metadata obtained after post-processing is set in dimension configuration item and numerical value configuration item
It is as follows according to table:
Using the value of dimension as classification, the value of numerical value is as serial (series)
The corresponding array of datagram obtained after pivot processing is as follows:
Classification=[d00, d01..., d0i...]；Series=[i00, i01..., i0i...].
It should be noted that pivot operation belongs to mature technology in the prior art, herein without repeating.
Another way is to have one data word section in dimension configuration item, is had in classification configurations item and numerical value configuration item more
A data field, the then metadata table obtained are as follows:
| D0 | C0 | C1 | ... | I0 | I1 | ... |
| d00 | c00 | c11 | ... | i00 | i10 | ... |
| d00 | c00 | c12 | ... | i01 | i11 | ... |
| ... | ... | ... | ... | ... | ... | ... |
With a dimension, the case where a classification a, numerical value from the point of view of, facilitate explanation.
In such cases, the value i of numerical value can with correlation of classifying accordingly,
Such as dimension D0It is medium type, classify C0It is province, numerical value I0It is clicking rate,
[d00, d01...] and corresponding [UC browser, take a trip to where net, wechat ...]
[c00, c01...] and corresponding [Guangdong, Zhejiang, Shandong ...]
The value i of numerical value should be the clicking rate that province is corresponded under some medium type:
In the clicking rate in Guangdong Province under corresponding social category media
In the clicking rate in Zhejiang Province under corresponding social category media
...
In the clicking rate in Guangdong Province under corresponding portal
In the clicking rate in Zhejiang Province under corresponding portal
...
In the clicking rate in Guangdong Province under corresponding portal
In the clicking rate in Zhejiang Province under corresponding portal
The corresponding array of datagram obtained after pivot processing is as follows:
Classification=[d00, d01..., d0i...]；
Certainly, other way is also similar, herein without enumerating.
S308, display datagram.
Finally show datagram.
It, can be from more as can be seen that the embodiment of the present invention can provide various configurations scheme for the same data source
A angle display data excavates convenient for the multi-angle of data.
Another aspect of the present invention provides a kind of data processing equipment.
Acquiring unit 1, for obtaining the tables of data of pending data visualization；
Control generation unit 2, for generating movable control corresponding with the data field in the tables of data；
Instruction receiving unit 3 is moved to the moving operation of preset configuration item for receiving user for the movable control；
As a result determination unit 4, for determining number corresponding with the preset configuration item according to the result of the moving operation
According to field；
Datagram drawing unit 5, for the corresponding relationship according to the preset configuration item and data field, draw with it is described
The corresponding datagram of tables of data；
Display unit 6, for showing the datagram.
Preferably, further includes:
Judging unit, for determine be corresponding in all preset configuration items data field each preset configuration item constitute match
Set whether item combination is the combination of preset configuration item, needs if so, determining according to the preset configuration item and data field
Corresponding relationship draws datagram corresponding with the tables of data.
Preferably, the datagram drawing unit includes:
Metadata determining module, for determining member of the corresponding data field of the preset configuration item in the tables of data
Data；
Metadata table generation module, for generating metadata table according to the metadata；
Pivot module, for carrying out data to the metadata table according to the preset configuration item for being corresponding with data field
Pivot operation generates the corresponding array of datagram, wherein includes at least one of in the array: dimension data, classification number
Accordingly and numeric data；
Datagram drafting module, for drawing the corresponding datagram of the metadata table according to the array.
The implementation of modules is referred in above-described embodiment in a kind of data processing equipment provided by the invention
A kind of data processing method, for realizing whole technical solutions in above method embodiment, the function of modules can
To be implemented according to the method in above method embodiment, specific implementation process can refer to the correlation in above-described embodiment and retouch
It states, details are not described herein again.
A kind of data processing equipment provided by the invention, first acquiring unit obtain the tables of data to visualized data；So
The generation of control generation unit is corresponding with the data field in the tables of data afterwards pulls control；Instruction receiving unit later
User is received by the drag operation for pulling control and being drawn in preset configuration item；As a result determination unit is according to the dragging
Operation determines data field corresponding with the preset configuration item；Final data figure drawing unit according to the preset configuration item with
The corresponding relationship of data field draws datagram corresponding with the tables of data；Show datagram described in display unit.Due to this
The foundation of the corresponding datagram of drawing data table determines that configuration mode is more according to the user's choice in inventive technique scheme
Add flexibly, same data source various configurations scheme may be implemented, realizes multi-angle display data, be more advantageous to the data of multi-angle
It excavates.
The data processing equipment includes processor 51 and memory 52, above-mentioned acquiring unit, control generation unit, instruction
Receiving unit, result determination unit, datagram drawing unit etc. store in memory as program unit, are held by processor
Above procedure unit stored in memory go to realize corresponding function.
Include kernel in processor, is gone in memory to transfer corresponding program unit by kernel.Kernel can be set one
Or more, come to provide various configurations scheme for the same data source by adjusting kernel parameter, can be shown from multiple angles
Data are excavated convenient for the multi-angle of data.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM), memory includes at least one storage
Chip.
The embodiment of the invention provides a kind of storage mediums, are stored thereon with program, real when which is executed by processor
The existing data processing method.
The embodiment of the invention provides a kind of processor, the processor is for running program, wherein described program operation
Data processing method described in Shi Zhihang.
The embodiment of the invention provides a kind of equipment, equipment include processor, memory and storage on a memory and can
The program run on a processor, processor perform the steps of when executing program
Obtain the tables of data of pending data visualization；
Generate movable control corresponding with the data field in the tables of data；
Receive the moving operation that the movable control is moved to preset configuration item by user；
Data field corresponding with the preset configuration item is determined according to the result of the moving operation；
According to the corresponding relationship of the preset configuration item and data field, datagram corresponding with the tables of data is drawn；
Show the datagram.
Preferably, data field corresponding with the preset configuration item is determined according to the result of the moving operation described
Later, the method also includes:
Determine be corresponding in all preset configuration items data field each preset configuration item constitute configuration item combination whether
It is drawn for the combination of preset configuration item if so, determining the corresponding relationship needed according to the preset configuration item and data field
Datagram corresponding with the tables of data.
Preferably, the configuration item combination that each preset configuration item of data field is constituted is corresponding in all preset configuration items
When not combined for preset configuration item, the method also includes:
It exports the prompt information of configuration item composition error and shows each preset configuration item combination to prompt user according to aobvious
The preset configuration item combination shown carries out moving operation to the movable control.
Preferably, the corresponding relationship according to the preset configuration item and data field is drawn and the tables of data pair
The datagram answered, comprising:
Determine metadata of the corresponding data field of the preset configuration item in the tables of data；
Metadata table is generated according to the metadata；
Pivot operation is carried out to the metadata table according to the preset configuration item for being corresponding with data field, generates data
Scheme corresponding array, wherein include at least one of: dimension data, classification data and numeric data in the array；
The corresponding datagram of the metadata table is drawn according to the array.
Preferably, the moving operation is drag operation, also, each preset configuration item has corresponding display area,
The moving operation are as follows: the movable control is moved in the corresponding display area of preset configuration item.
Equipment herein can be server, PC, PAD, mobile phone etc..
Present invention also provides a kind of computer program products, when executing on data processing equipment, are adapted for carrying out just
The program of beginningization there are as below methods step:
Obtain the tables of data of pending data visualization；
Generate movable control corresponding with the data field in the tables of data；
Receive the moving operation that the movable control is moved to preset configuration item by user；
Data field corresponding with the preset configuration item is determined according to the result of the moving operation；
According to the corresponding relationship of the preset configuration item and data field, datagram corresponding with the tables of data is drawn；
Show the datagram.
Preferably, data field corresponding with the preset configuration item is determined according to the result of the moving operation described
Later, the method also includes:
Determine be corresponding in all preset configuration items data field each preset configuration item constitute configuration item combination whether
It is drawn for the combination of preset configuration item if so, determining the corresponding relationship needed according to the preset configuration item and data field
Datagram corresponding with the tables of data.
Preferably, the configuration item combination that each preset configuration item of data field is constituted is corresponding in all preset configuration items
When not combined for preset configuration item, the method also includes:
It exports the prompt information of configuration item composition error and shows each preset configuration item combination to prompt user according to aobvious
The preset configuration item combination shown carries out moving operation to the movable control.
Preferably, the corresponding relationship according to the preset configuration item and data field is drawn and the tables of data pair
The datagram answered, comprising:
Determine metadata of the corresponding data field of the preset configuration item in the tables of data；
Metadata table is generated according to the metadata；
Pivot operation is carried out to the metadata table according to the preset configuration item for being corresponding with data field, generates data
Scheme corresponding array, wherein include at least one of: dimension data, classification data and numeric data in the array；
The corresponding datagram of the metadata table is drawn according to the array.
Preferably, the moving operation is drag operation, also, each preset configuration item has corresponding display area,
The moving operation are as follows: the movable control is moved in the corresponding display area of preset configuration item.
It should be understood by those skilled in the art that, embodiments herein can provide as method, system or computer program
Product.Therefore, complete hardware embodiment, complete software embodiment or reality combining software and hardware aspects can be used in the application
Apply the form of example.Moreover, it wherein includes the computer of computer usable program code that the application, which can be used in one or more,
The computer program implemented in usable storage medium (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.) produces
The form of product.
The application is referring to method, the process of equipment (system) and computer program product according to the embodiment of the present application
Figure and/or block diagram describe.It should be understood that every one stream in flowchart and/or the block diagram can be realized by computer program instructions
The combination of process and/or box in journey and/or box and flowchart and/or the block diagram.It can provide these computer programs
Instruct the processor of general purpose computer, special purpose computer, Embedded Processor or other programmable data processing devices to produce
A raw machine, so that being generated by the instruction that computer or the processor of other programmable data processing devices execute for real
The device for the function of being specified in present one or more flows of the flowchart and/or one or more blocks of the block diagram.
These computer program instructions, which may also be stored in, is able to guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works, so that it includes referring to that instruction stored in the computer readable memory, which generates,
Enable the manufacture of device, the command device realize in one box of one or more flows of the flowchart and/or block diagram or
The function of being specified in multiple boxes.
These computer program instructions also can be loaded onto a computer or other programmable data processing device, so that counting
Series of operation steps are executed on calculation machine or other programmable devices to generate computer implemented processing, thus in computer or
The instruction executed on other programmable devices is provided for realizing in one or more flows of the flowchart and/or block diagram one
The step of function of being specified in a box or multiple boxes.
In a typical configuration, calculating equipment includes one or more processors (CPU), input/output interface, net
Network interface and memory.
Memory may include the non-volatile memory in computer-readable medium, random access memory (RAM) and/
Or the forms such as Nonvolatile memory, such as read-only memory (ROM) or flash memory (flashRAM).Memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitory media), such as the data-signal and carrier wave of modulation.
It should also be noted that, the terms "include", "comprise" or its any other variant are intended to nonexcludability
It include so that the process, method, commodity or the equipment that include a series of elements not only include those elements, but also to wrap
Include other elements that are not explicitly listed, or further include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including element
There is also other identical elements in process, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can provide as method, system or computer program product.
Therefore, complete hardware embodiment, complete software embodiment or embodiment combining software and hardware aspects can be used in the application
Form.It is deposited moreover, the application can be used to can be used in the computer that one or more wherein includes computer usable program code
The shape for the computer program product implemented on storage media (including but not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The above is only embodiments herein, are not intended to limit this application.To those skilled in the art,
Various changes and changes are possible in this application.It is all within the spirit and principles of the present application made by any modification, equivalent replacement,
Improve etc., it should be included within the scope of the claims of this application.
Claims (10)
1. a kind of data processing method characterized by comprising
Obtain the tables of data of pending data visualization；
Generate movable control corresponding with the data field in the tables of data；
Receive the moving operation that the movable control is moved to preset configuration item by user；
Data field corresponding with the preset configuration item is determined according to the result of the moving operation；
According to the corresponding relationship of the preset configuration item and data field, datagram corresponding with the tables of data is drawn；
Show the datagram.
2. data processing method according to claim 1, which is characterized in that in the result according to the moving operation
After determining data field corresponding with the preset configuration item, the method also includes:
Whether the configuration item combination for determining that each preset configuration item that data field is corresponding in all preset configuration items is constituted is pre-
If configuration item combination, need corresponding relationship according to the preset configuration item and data field if so, determining, draw and institute
State the corresponding datagram of tables of data.
3. data processing method according to claim 2, which is characterized in that be corresponding with data in all preset configuration items
When the configuration item combination that each preset configuration item of field is constituted is not combined for preset configuration item, the method also includes:
It exports the prompt information of configuration item composition error and shows that each preset configuration item is combined to prompt user according to display
Preset configuration item combination carries out moving operation to the movable control.
4. according to claim 1 to data processing method described in 3 any one, which is characterized in that described according to described default
The corresponding relationship of configuration item and data field draws datagram corresponding with the tables of data, comprising:
Determine metadata of the corresponding data field of the preset configuration item in the tables of data；
Metadata table is generated according to the metadata；
Pivot operation is carried out to the metadata table according to the preset configuration item for being corresponding with data field, generates datagram pair
The array answered, wherein include at least one of: dimension data, classification data and numeric data in the array；
The corresponding datagram of the metadata table is drawn according to the array.
5. according to claim 1 to data processing method described in 3 any one, which is characterized in that the moving operation is to drag
Operation is dragged, also, each preset configuration item has corresponding display area, the moving operation are as follows: by the movable control
It is moved in the corresponding display area of preset configuration item.
6. a kind of data processing equipment characterized by comprising
Acquiring unit, for obtaining the tables of data of pending data visualization；
Control generation unit, for generating movable control corresponding with the data field in the tables of data；
Instruction receiving unit is moved to the moving operation of preset configuration item for receiving user for the movable control；
As a result determination unit, for determining data word corresponding with the preset configuration item according to the result of the moving operation
Section；
Datagram drawing unit is drawn and the data for the corresponding relationship according to the preset configuration item and data field
The corresponding datagram of table；
Display unit, for showing the datagram.
7. data processing equipment according to claim 6, which is characterized in that further include:
Judging unit, the configuration item constituted for determining each preset configuration item for being corresponding with data field in all preset configuration items
Whether combination is preset configuration item combination, if so, determining that needs are corresponding with data field according to the preset configuration item
Relationship draws datagram corresponding with the tables of data.
8. data processing equipment according to claim 6, which is characterized in that the datagram drawing unit includes:
Metadata determining module, for determining first number of the corresponding data field of the preset configuration item in the tables of data
According to；
Metadata table generation module, for generating metadata table according to the metadata；
Pivot module, for carrying out pivot to the metadata table according to the preset configuration item for being corresponding with data field
Operation generates the corresponding array of datagram, wherein includes at least one of in the array: dimension data, classification data with
And numeric data；
Datagram drafting module, for drawing the corresponding datagram of the metadata table according to the array.
9. a kind of storage medium, which is characterized in that the storage medium includes the program of storage, wherein described program right of execution
Benefit require any one of 1 to 5 described in data processing method.
10. a kind of processor, which is characterized in that the processor is for running program, wherein right of execution when described program is run
Benefit require any one of 1 to 5 described in data processing method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710910014.0A CN110147404A (en) | 2017-09-29 | 2017-09-29 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710910014.0A CN110147404A (en) | 2017-09-29 | 2017-09-29 | Data processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110147404A true CN110147404A (en) | 2019-08-20 |
Family
ID=67588095
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710910014.0A Pending CN110147404A (en) | 2017-09-29 | 2017-09-29 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110147404A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515525A (en) * | 2019-08-30 | 2019-11-29 | 佳都新太科技股份有限公司 | Visualized data processing method, device, equipment and storage medium |
| CN113779037A (en) * | 2021-09-23 | 2021-12-10 | 上海淇玥信息技术有限公司 | Worksheet processing method and device and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104216701A (en) * | 2013-05-30 | 2014-12-17 | 西门子公司 | System and method for creating a graphical user interface within a manufacturing execution system |
| CN106325849A (en) * | 2015-07-10 | 2017-01-11 | 腾讯科技（深圳）有限公司 | Data processing method and data processing device |
| CN106407170A (en) * | 2016-09-30 | 2017-02-15 | 上海冰穹网络科技有限公司 | Rapid generation method and system for data report |
-
2017
- 2017-09-29 CN CN201710910014.0A patent/CN110147404A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104216701A (en) * | 2013-05-30 | 2014-12-17 | 西门子公司 | System and method for creating a graphical user interface within a manufacturing execution system |
| CN106325849A (en) * | 2015-07-10 | 2017-01-11 | 腾讯科技（深圳）有限公司 | Data processing method and data processing device |
| CN106407170A (en) * | 2016-09-30 | 2017-02-15 | 上海冰穹网络科技有限公司 | Rapid generation method and system for data report |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110515525A (en) * | 2019-08-30 | 2019-11-29 | 佳都新太科技股份有限公司 | Visualized data processing method, device, equipment and storage medium |
| CN110515525B (en) * | 2019-08-30 | 2021-07-23 | 佳都科技集团股份有限公司 | Visualized data processing method, device, equipment and storage medium |
| CN113779037A (en) * | 2021-09-23 | 2021-12-10 | 上海淇玥信息技术有限公司 | Worksheet processing method and device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108833458B (en) | Application recommendation method, device, medium and equipment | |
| CN105009078A (en) | Building applications for configuring processes | |
| Halim et al. | Quantifying and optimizing visualization: An evolutionary computing-based approach | |
| CN104516904A (en) | Key knowledge point recommendation method and system | |
| US9472003B2 (en) | Generating a tree map | |
| CN112597239A (en) | Visual modeling method and device and electronic equipment | |
| CN110069312A (en) | A kind of method and device of UI component Configuration and generation UI Component Gallery | |
| CN107578055A (en) | A kind of image prediction method and apparatus | |
| CN110147404A (en) | Data processing method and device | |
| CN116881353A (en) | Financial data display method and device, storage medium and electronic equipment | |
| US9355481B2 (en) | Dynamic visualization for optimization processes | |
| CN104102662A (en) | Method and device for determining interest and preference similarity of users | |
| CN106294530B (en) | The method and system of rule match | |
| Glumov et al. | Assessment of drained gas reserves in the process of gas and gas condensate field operation in water drive | |
| CN109033224A (en) | A kind of Risk Text recognition methods and device | |
| CN105989276A (en) | Role optimization method and apparatus in RBAC permission system | |
| CN110020298A (en) | Parameter display method and apparatus | |
| CN104239072B (en) | The generation method and device of the program code of software | |
| WO2014003984A2 (en) | System and method for generating a flow based on multiple types of interactions | |
| CN109492086A (en) | A kind of answer output method, device, electronic equipment and storage medium | |
| CN109598016A (en) | Robot adding method and device | |
| Eeg et al. | Combining linear programming and reservoir simulation to optimize asset value | |
| CN108241643A (en) | The achievement data analysis method and device of keyword | |
| CN106325849A (en) | Data processing method and data processing device | |
| Kayalvily et al. | Data analysis and rating prediction on *** play store using data-mining techniques |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| CB02 | Change of applicant information |
Address after: 100080 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. Address before: 100086 Beijing city Haidian District Shuangyushu Area No. 76 Zhichun Road cuigongfandian 8 layer A Applicant before: BEIJING GRIDSUM TECHNOLOGY Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190820 |
|
| RJ01 | Rejection of invention patent application after publication |