CN105488162B - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN105488162B CN105488162B CN201510857342.XA CN201510857342A CN105488162B CN 105488162 B CN105488162 B CN 105488162B CN 201510857342 A CN201510857342 A CN 201510857342A CN 105488162 B CN105488162 B CN 105488162B
- Authority
- CN
- China
- Prior art keywords
- nonumeric
- child node
- data
- different
- same
- 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.)
- Active
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/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
Abstract
The present invention provides a kind of data processing methods and a kind of data processing equipment, wherein, the data processing method, comprising: the XML data with child node is generated in the same nonumeric classification of 2-D data input interface typing and the different nonumeric property caches of the same nonumeric classification according to user；The XML data with child node is converted into the XML data without child node, the XML data branch without child node is stored in background data base table.According to the technical solution of the present invention, the treatment effeciency for being operated family more intuitive and convenient can be used, while improving data inputting, storing and show.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of data processing method and a kind of data processing
Device.
Background technique
Currently, showing in order to facilitate data inputting and intuitively in some developments, similar a plurality of data can be existed
It is safeguarded in a line at the interface of software, storage when saves into multirow again.Most commonly in clothing software, together
The different color size of a commodity requires to carry out two-dimentional quantity typing in a line, and when preservation needs to store according to item property
At multirow, a line for being merged into interface when showing again is read, with making user's intuitive and convenient operating software.
Therefore, it operates with how making user's more intuitive and convenient, with the processing for improving data inputting, storing and showing
Efficiency becomes technical problem urgently to be resolved.
Summary of the invention
The present invention is based on above-mentioned technical problem, proposes a kind of new technical solution, it is more intuitive that family can be used
The treatment effeciency for easily being operated, while improving data inputting, storing and show.
In view of this, first aspect of the present invention it is proposed a kind of data processing method, comprising: according to user in two dimension
The different nonumeric property caches of the same nonumeric classification of data inputting interface typing and the same nonumeric classification are raw
At the XML data with child node；The XML data with child node is converted into the XML data without child node, with
The XML data branch without child node is stored in background data base table.
In the technical scheme, when by the nonumeric classifications (for example, yarn, cotton, cloth) of difference of same commodity (for example, women's dress)
Relevant information when carrying out typing storage, first according to user in the same nonumeric classification of 2-D data input interface typing and
Its different nonumeric attribute (for example, cloth and its different colors) caching generates the XML (Extensible with child node
Markup Language, extensible markup language) data, i.e., record description is carried out to data by XML markup language, is convenient for
Self-defining data format, and then do not have child node by formatting generation to the XML data depth with child node
XML data be convenient for updating maintenance be stored in background data base table in lines, while family more intuitive and convenient can be used
Ground is operated, and the treatment effeciency of data inputting and storage is improved.
In the above-mentioned technical solutions, it is preferable that it is described according to user 2-D data input interface typing same non-number
The different nonumeric property caches for being worth classification and the same nonumeric classification generate the XML data with child node, specifically
It include: that the same nonumeric classification and the different nonumeric attributes are merged into processing respectively, it is different to generate
Nonumeric composite attribute；The same of same a line is buffered in using the different nonumeric composite attributes as child node merging
In column, to generate the XML data with child node.
It in the technical scheme, first will be in 2-D data typing circle during generating the XML data with child node
The same nonumeric classification of face typing and different nonumeric attributes merge processing and obtain different nonumeric composite attributes
(such as: cloth, it is red；Cloth is green；Cloth is purple；For three nonumeric composite attributes), then by the different nonumeric combination categories of generation
Property merge in the same row of the same a line for being buffered in such as front end grid control as different child node, so that generating has son
The XML data of node improves data-handling efficiency to realize to the unified storage management of the different attribute specification of the same category
It is convenient for background maintenance simultaneously.
In any of the above-described technical solution, it is preferable that described be converted to the XML data with child node does not have
The XML data branch without child node is stored in background data base table by the XML data of child node, specific to wrap
Include: the number for the child node for including according to the XML data with child node determines in the background data base table
The line number of the storage XML without byte point；It will be described according to the different nonumeric composite attributes and the line number
XML data branch without child node is stored in the background data base table.
In the technical scheme, the XML data with child node the XML data without child node is converted to deposit
Chu Shi counts the quantity for the child node that the XML data with child node includes in total, i.e., of nonumeric composite attribute first
Number, so that it is determined that the XML data for not having child node is stored the line number needed in background data base table, then according to difference
Nonumeric composite attribute and line number will not have child node XML data carry out branch's storage, in this way, can be according to different
Nonumeric composite attribute storage management data, i.e., different nonumeric composite attributes are respectively stored in different rows, in order to
The background maintenance of data.
In any of the above-described technical solution, it is preferable that further include: the user is received in the 2-D data input interface
The corresponding numerical value column information of the different nonumeric attributes of the same nonumeric classification of typing；The numerical value is arranged and is believed
Breath is stored into the corresponding nonumeric composite attribute different lines of the row.
In the technical scheme, in 2-D data typing together with same nonumeric classification and its different nonumeric attributes
Interface typing there are also corresponding numerical value column information (for example, quantity of commodity, unit price), then in storage, need according to numerical value
Numerical value column information is stored in background data base table by the one-to-one relationship of column information, nonumeric attribute and nonumeric classification
Corresponding nonumeric composite attribute different lines of the row in, specifically, according to same nonumeric classification and different non-
When numerical attribute merges generation different nonumeric composite attributes, simultaneously by the different corresponding numerical value column informations of nonumeric attribute
Total calculating is carried out, and aggregate result is subjected to corresponding caching, then according to different nonumeric composite attributes and line number point
When row stores the XML data without child node, correspondingly redistributes and calculate the aggregate result, and then numerical value column information is deposited
The corresponding nonumeric composite attribute different lines of the row in background data base table are stored up, the record of data is efficiently and accurately completed
Enter and store, achievees the purpose that carry out multirow preservation when similar a plurality of data storage.
In any of the above-described technical solution, it is preferable that further include: when showing the institute being stored in the background data base table
When stating the XML data without child node, the different nonumeric composite attributes, which is merged described in processing generation, to be had
The XML data of child node, to be showed in the same row of same a line；The different nonumeric composite attributes is corresponding
The numerical value column information carries out total processing, and it is of the row that aggregate result is presented in the XML data with child node
In different lines.
In the technical scheme, when needs show the XML data without child node being stored in background data base table
When, data processing on the contrary is carried out, i.e., directly merge to be presented in the same of same a line by different nonumeric composite attributes
Corresponding data value column information is carried out total processing, aggregate result is presented in the different lines of same a line, is reached by one column
The purpose that similar a plurality of data are safeguarded in a line, in this way, realize the different classes of of same commodity and
The different numerical informations of the other different attribute of every type and different attribute carry out two-dimentional typing in a line, according to attribute when storage
Multirow is stored into, is merged in a row again when reading shows, and is converted by the depth of XML data, is substantially increased at data
Efficiency is managed, is operated with making user's more intuitive and convenient, so that the user experience is improved.
According to the second aspect of the invention, propose a kind of data processing equipment, comprising: processing module, for according to
Family is in the same nonumeric classification of 2-D data input interface typing and the different nonumeric categories of the same nonumeric classification
Property caching generate have child node XML data；Conversion module, for being converted to not the XML data with child node
The XML data branch without child node is stored in background data base table by the XML data with child node.
In the technical scheme, when by the nonumeric classifications (for example, yarn, cotton, cloth) of difference of same commodity (for example, women's dress)
Relevant information when carrying out typing storage, first according to user in the same nonumeric classification of 2-D data input interface typing and
Its different nonumeric attribute (for example, cloth and its different colors) caching generates the XML (Extensible with child node
Markup Language, extensible markup language) data, i.e., record description is carried out to data by XML markup language, is convenient for
Self-defining data format, and then do not have child node by formatting generation to the XML data depth with child node
XML data be convenient for updating maintenance be stored in background data base table in lines, while family more intuitive and convenient can be used
Ground is operated, and the treatment effeciency of data inputting and storage is improved.
In the above-mentioned technical solutions, it is preferable that the processing module specifically includes: the first merging module, being used for will be described
Same nonumeric classification and the different nonumeric attributes merge processing respectively, to generate different nonumeric combination categories
Property；Cache module, for being buffered in the same of same a line for the different nonumeric composite attributes as child node merging
In one column, to generate the XML data with child node.
It in the technical scheme, first will be in 2-D data typing circle during generating the XML data with child node
The same nonumeric classification of face typing and different nonumeric attributes merge processing and obtain different nonumeric composite attributes
(such as: cloth, it is red；Cloth is green；Cloth, it is blue；For three nonumeric composite attributes), then by the different nonumeric combination categories of generation
Property merge in the same row of the same a line for being buffered in such as front end grid control as different child node, so that generating has son
The XML data of node improves data-handling efficiency to realize to the unified storage management of the different attribute specification of the same category
It is convenient for background maintenance simultaneously.
In any of the above-described technical solution, it is preferable that further include: determining module, for having child node according to
The number for the child node that XML data includes determines that storage is described without byte point in the background data base table
The line number of XML；First memory module, for not had by described according to the different nonumeric composite attributes and the line number
The XML data branch of child node is stored in the background data base table.
In the technical scheme, the XML data with child node the XML data without child node is converted to deposit
Chu Shi counts the quantity for the child node that the XML data with child node includes in total, i.e., of nonumeric composite attribute first
Number, so that it is determined that the XML data for not having child node is stored the line number needed in background data base table, then according to difference
Nonumeric composite attribute and line number will not have child node XML data carry out branch's storage, in this way, can be according to different
Nonumeric composite attribute storage management data, i.e., different nonumeric composite attributes are respectively stored in different rows, in order to
The background maintenance of data.
In any of the above-described technical solution, it is preferable that further include: receiving module, for receiving the user described two
The corresponding numerical value column information of the different nonumeric attributes of the same nonumeric classification of dimension data input interface typing；
And second memory module, it is of the row not to the corresponding nonumeric composite attribute for storing the numerical value column information
In same column.
In the technical scheme, in 2-D data typing together with same nonumeric classification and its different nonumeric attributes
Interface typing there are also corresponding numerical value column information (for example, quantity of commodity, unit price), then in storage, need according to numerical value
Numerical value column information is stored in background data base table by the one-to-one relationship of column information, nonumeric attribute and nonumeric classification
Corresponding nonumeric composite attribute different lines of the row in, specifically, according to same nonumeric classification and different non-
When numerical attribute merges generation different nonumeric composite attributes, simultaneously by the different corresponding numerical value column informations of nonumeric attribute
Total calculating is carried out, and aggregate result is subjected to corresponding caching, then according to different nonumeric composite attributes and line number point
When row stores the XML data without child node, correspondingly redistributes and calculate the aggregate result, and then numerical value column information is deposited
The corresponding nonumeric composite attribute different lines of the row in background data base table are stored up, the record of data is efficiently and accurately completed
Enter and store, achievees the purpose that carry out multirow preservation when similar a plurality of data storage.
In any of the above-described technical solution, it is preferable that further include: the second merging module, for when show be stored in it is described
When the XML data without child node in background data base table, the different nonumeric composite attributes is closed
And handle and generate the XML data with child node, to be showed in the same row of same a line；Computing module is used for
The corresponding numerical value column information of the different nonumeric composite attributes is subjected to total processing, and aggregate result is presented in
In the XML data with child node different lines of the row.
In the technical scheme, when needs show the XML data without child node being stored in background data base table
When, data processing on the contrary is carried out, i.e., directly merge to be presented in the same of same a line by different nonumeric composite attributes
Corresponding data value column information is carried out total processing, aggregate result is presented in the different lines of same a line, is reached by one column
The purpose that similar a plurality of data are safeguarded in a line, in this way, realize the different classes of of same commodity and
The different numerical informations of the other different attribute of every type and different attribute carry out two-dimentional typing in a line, according to attribute when storage
Multirow is stored into, is merged in a row again when reading shows, and is converted by the depth of XML data, is substantially increased at data
Efficiency is managed, is operated with making user's more intuitive and convenient, so that the user experience is improved.
By above technical scheme, operated family more intuitive and convenient can be used, at the same improve data inputting,
The treatment effeciency for storing and showing.
Detailed description of the invention
Fig. 1 shows the flow diagram of data processing method according to an embodiment of the invention；
Fig. 2 shows the block diagrams of data processing equipment according to an embodiment of the invention；
Fig. 3 shows the flow diagram of data processing method according to another embodiment of the invention；
Fig. 4 shows the schematic diagram of 2-D data input interface according to an embodiment of the invention；
What the result that Fig. 5 shows 2-D data input interface typing according to Fig.4, generated does not have child node
XML data shows schematic diagram.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention is further described in detail.It should be noted that in the absence of conflict, the implementation of the application
Feature in example and embodiment can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, still, the present invention may be used also
To be implemented using other than the one described here other modes, therefore, protection scope of the present invention is not by described below
Specific embodiment limitation.
Fig. 1 shows the flow diagram of data processing method according to an embodiment of the invention.
As shown in Figure 1, data processing method according to an embodiment of the invention, comprising: step 102, according to user
In the same nonumeric classification of 2-D data input interface typing and the different nonumeric attributes of the same nonumeric classification
Caching generates the XML data with child node；Step 104, the XML data with child node is converted to and does not have son section
The XML data branch without child node is stored in background data base table by the XML data of point.
In the technical scheme, when by the nonumeric classifications (for example, yarn, cotton, cloth) of difference of same commodity (for example, women's dress)
Relevant information when carrying out typing storage, first according to user in the same nonumeric classification of 2-D data input interface typing and
Its different nonumeric attribute (for example, cloth and its different colors) caching generates the XML (Extensible with child node
Markup Language, extensible markup language) data, i.e., record description is carried out to data by XML markup language, is convenient for
Self-defining data format, and then do not have child node by formatting generation to the XML data depth with child node
XML data be convenient for updating maintenance be stored in background data base table in lines, while family more intuitive and convenient can be used
Ground is operated, and the treatment effeciency of data inputting and storage is improved.
In the above-mentioned technical solutions, it is preferable that the step 102 specifically includes: by the same nonumeric classification and not
The same nonumeric attribute merges processing respectively, to generate different nonumeric composite attributes；It will be different described non-
Combinations of values attribute is buffered in the same row of same a line respectively as child node merging, to have child node described in generation
XML data.
It in the technical scheme, first will be in 2-D data typing circle during generating the XML data with child node
The same nonumeric classification of face typing and different nonumeric attributes merge processing and obtain different nonumeric composite attributes
(such as: cloth, it is red；Cloth is green；Cloth is purple；For three nonumeric composite attributes), then by the different nonumeric combination categories of generation
Property merge in the same row of the same a line for being buffered in such as front end grid control as different child node, so that generating has son
The XML data of node improves data-handling efficiency to realize to the unified storage management of the different attribute specification of the same category
It is convenient for background maintenance simultaneously.
In any of the above-described technical solution, it is preferable that the step 104 specifically includes: according to described with child node
The number for the child node that XML data includes determines that storage is described without byte point in the background data base table
The line number of XML；The XML data without child node is divided according to the different nonumeric composite attributes and the line number
Row is stored in the background data base table.
In the technical scheme, the XML data with child node the XML data without child node is converted to deposit
Chu Shi counts the quantity for the child node that the XML data with child node includes in total, i.e., of nonumeric composite attribute first
Number, so that it is determined that the XML data for not having child node is stored the line number needed in background data base table, then according to difference
Nonumeric composite attribute and line number will not have child node XML data carry out branch's storage, in this way, can be according to different
Nonumeric composite attribute storage management data, i.e., different nonumeric composite attributes are respectively stored in different rows, in order to
The background maintenance of data.
In any of the above-described technical solution, it is preferable that further include: the user is received in the 2-D data input interface
The corresponding numerical value column information of the different nonumeric attributes of the same nonumeric classification of typing；The numerical value is arranged and is believed
Breath is stored into the corresponding nonumeric composite attribute different lines of the row.
In the technical scheme, in 2-D data typing together with same nonumeric classification and its different nonumeric attributes
Interface typing there are also corresponding numerical value column information (for example, quantity of commodity, unit price), then in storage, need according to numerical value
Numerical value column information is stored in background data base table by the one-to-one relationship of column information, nonumeric attribute and nonumeric classification
Corresponding nonumeric composite attribute different lines of the row in, specifically, according to same nonumeric classification and different non-
When numerical attribute merges generation different nonumeric composite attributes, simultaneously by the different corresponding numerical value column informations of nonumeric attribute
Total calculating is carried out, and aggregate result is subjected to corresponding caching, then according to different nonumeric composite attributes and line number point
When row stores the XML data without child node, correspondingly redistributes and calculate the aggregate result, and then numerical value column information is deposited
The corresponding nonumeric composite attribute different lines of the row in background data base table are stored up, the record of data is efficiently and accurately completed
Enter and store, achievees the purpose that carry out multirow preservation when similar a plurality of data storage.
In any of the above-described technical solution, it is preferable that further include: when showing the institute being stored in the background data base table
When stating the XML data without child node, the different nonumeric composite attributes, which is merged described in processing generation, to be had
The XML data of child node, to be showed in the same row of same a line；The different nonumeric composite attributes is corresponding
The numerical value column information carries out total processing, and it is of the row that aggregate result is presented in the XML data with child node
In different lines.
In the technical scheme, when needs show the XML data without child node being stored in background data base table
When, data processing on the contrary is carried out, i.e., directly merge to be presented in the same of same a line by different nonumeric composite attributes
Corresponding data value column information is carried out total processing, aggregate result is presented in the different lines of same a line, is reached by one column
The purpose that similar a plurality of data are safeguarded in a line, in this way, realize the different classes of of same commodity and
The different numerical informations of the other different attribute of every type and different attribute carry out two-dimentional typing in a line, according to attribute when storage
Multirow is stored into, is merged in a row again when reading shows, and is converted by the depth of XML data, is substantially increased at data
Efficiency is managed, is operated with making user's more intuitive and convenient, so that the user experience is improved.
Fig. 2 shows the block diagrams of data processing equipment according to an embodiment of the invention.
As shown in Fig. 2, data processing equipment 200 according to an embodiment of the invention, comprising: 202 He of processing module
Conversion module 204.
Wherein, processing module 202, for according to user 2-D data input interface typing same nonumeric classification and
The different nonumeric property caches of the same nonumeric classification generate the XML data with child node；Conversion module 204,
For the XML data with child node to be converted to the XML data without child node, described will not have child node
XML data branch be stored in background data base table.
In the technical scheme, when by the nonumeric classifications (for example, yarn, cotton, cloth) of difference of same commodity (for example, women's dress)
Relevant information when carrying out typing storage, first according to user in the same nonumeric classification of 2-D data input interface typing and
Its different nonumeric attribute (for example, cloth and its different colors) caching generates the XML (Extensible with child node
Markup Language, extensible markup language) data, i.e., record description is carried out to data by XML markup language, is convenient for
Self-defining data format, and then do not have child node by formatting generation to the XML data depth with child node
XML data be convenient for updating maintenance be stored in background data base table in lines, while family more intuitive and convenient can be used
Ground is operated, and the treatment effeciency of data inputting and storage is improved.
In the above-mentioned technical solutions, it is preferable that the processing module 202 specifically includes: the first merging module 2022 is gentle
Storing module 2024.
Wherein, the first merging module 2022, for by the same nonumeric classification and the different nonumeric attributes
Processing is merged, respectively to generate different nonumeric composite attributes；Cache module 2024, for by the different non-numbers
Value composite attribute is buffered in the same row of same a line respectively as child node merging, to generate the XML with child node
Data.
It in the technical scheme, first will be in 2-D data typing circle during generating the XML data with child node
The same nonumeric classification of face typing and different nonumeric attributes merge processing and obtain different nonumeric composite attributes
(such as: cloth, it is red；Cloth is green；Cloth, it is blue；For three nonumeric composite attributes), then by the different nonumeric combination categories of generation
Property merge in the same row of the same a line for being buffered in such as front end grid control as different child node, so that generating has son
The XML data of node improves data-handling efficiency to realize to the unified storage management of the different attribute specification of the same category
It is convenient for background maintenance simultaneously.
In any of the above-described technical solution, it is preferable that further include: determining module 206 and the first memory module 208.
Wherein it is determined that module 206, of the child node for including according to the XML data with child node
Number determines the line number that the XML without byte point is stored in the background data base table；First memory module 208 is used
In the XML data branch without child node is stored according to the different nonumeric composite attributes and the line number
In the background data base table.
In the technical scheme, the XML data with child node the XML data without child node is converted to deposit
Chu Shi counts the quantity for the child node that the XML data with child node includes in total, i.e., of nonumeric composite attribute first
Number, so that it is determined that the XML data for not having child node is stored the line number needed in background data base table, then according to difference
Nonumeric composite attribute and line number will not have child node XML data carry out branch's storage, in this way, can be according to different
Nonumeric composite attribute storage management data, i.e., different nonumeric composite attributes are respectively stored in different rows, in order to
The background maintenance of data.
In any of the above-described technical solution, it is preferable that further include: receiving module 210 and the second memory module 212.
Wherein, receiving module 210, for receiving the user in the described same of the 2-D data input interface typing
The corresponding numerical value column information of the different nonumeric attributes of nonumeric classification；And second memory module 212, for by institute
Numerical value column information is stated to store into the corresponding nonumeric composite attribute different lines of the row.
In the technical scheme, in 2-D data typing together with same nonumeric classification and its different nonumeric attributes
Interface typing there are also corresponding numerical value column information (for example, quantity of commodity, unit price), then in storage, need according to numerical value
Numerical value column information is stored in background data base table by the one-to-one relationship of column information, nonumeric attribute and nonumeric classification
Corresponding nonumeric composite attribute different lines of the row in, specifically, according to same nonumeric classification and different non-
When numerical attribute merges generation different nonumeric composite attributes, simultaneously by the different corresponding numerical value column informations of nonumeric attribute
Total calculating is carried out, and aggregate result is subjected to corresponding caching, then according to different nonumeric composite attributes and line number point
When row stores the XML data without child node, correspondingly redistributes and calculate the aggregate result, and then numerical value column information is deposited
The corresponding nonumeric composite attribute different lines of the row in background data base table are stored up, the record of data is efficiently and accurately completed
Enter and store, achievees the purpose that carry out multirow preservation when similar a plurality of data storage.
In any of the above-described technical solution, it is preferable that further include: the second merging module 214 and computing module 216.
Wherein, the second merging module 214, for when show be stored in the background data base table described in do not have son
When the XML data of node, the different nonumeric composite attributes is merged into processing and generates the XML with child node
Data, to be showed in the same row of same a line；Computing module 216, for by the different nonumeric composite attributes
The corresponding numerical value column information carries out total processing, and aggregate result is presented in the XML data institute with child node
In the different lines being expert at.
In the technical scheme, when needs show the XML data without child node being stored in background data base table
When, data processing on the contrary is carried out, i.e., directly merge to be presented in the same of same a line by different nonumeric composite attributes
Corresponding data value column information is carried out total processing, aggregate result is presented in the different lines of same a line, is reached by one column
The purpose that similar a plurality of data are safeguarded in a line, in this way, realize the different classes of of same commodity and
The different numerical informations of the other different attribute of every type and different attribute carry out two-dimentional typing in a line, according to attribute when storage
Multirow is stored into, is merged in a row again when reading shows, and is converted by the depth of XML data, is substantially increased at data
Efficiency is managed, is operated with making user's more intuitive and convenient, so that the user experience is improved.
3 to Fig. 5 technical solution of the present invention is specifically described with reference to the accompanying drawing.
Fig. 3 shows the flow diagram of data processing method according to another embodiment of the invention.
Fig. 4 shows the schematic diagram of 2-D data input interface according to an embodiment of the invention.
What the result that Fig. 5 shows 2-D data input interface typing according to Fig.4, generated does not have child node
XML data shows schematic diagram.
As shown in figure 3, data processing method according to another embodiment of the invention, specifically includes: typing two-dimemsional number
According to rear, the XML data for having child node is generated, according to the 2-D data of typing in order to completely describe the two-dimemsional number in same a line
According to, such as different colours (different nonumeric attributes) in row where " cloth " shown in Fig. 4 (same nonumeric classification)
Quantity information (numerical value column information) completes train value data different in description current row by increasing XML child node, for example,
" cloth, red ", " cloth, green " are two different child nodes；Next the XML data containing child node is converted into without child node
XML data carry out branch's storage, i.e., when need these data are stored into database table when, first according to the more of child node
The how many rows for needing to be stored into database are generated less, that is to say, that " cloth, red " is a line, and " cloth, green " is a line, and corresponding
Quantity " 3 " carry out redistributing calculating, to complete the storage of numerical value column information, i.e., in database by it is each two dimension intersect column
There is the preservation of data in a row so that it is convenient to which data statistic analysis is inquired；In the process, by selection XML markup language come logarithm
According to record description is carried out, facilitates and freely define data format, quickly by formatting operation to XML depth, to mention
High data-handling efficiency.Finally, then executing the data handling procedure of contrary when needing display data, show effect ginseng
See Fig. 5, the child node and " cloth, green " composition of " cloth, red " composition of corresponding as " specification " node of " specification " column in figure
The amalgamation result of child node, and " (*) quantity " arranges the quantity that corresponding " 3 " are " red " and " green " different attribute in Fig. 4
Aggregate result.
Through the above technical solutions, mainly solve the problems, such as be: data store when one recorded in the grid control of front end
Row data are disassembled by given logic and are stored at multirow, are needed to carry out nonumeric column to replicate logarithm column in the process and are counted again
Point counting is matched；And reading data is needed by addition given logic to nonumeric after reading multirow data from database when showing
Column carry out directly merging logarithm column and carry out total operation, are organized into data line and show for the load of front end control.And then it can be with
More intuitive typing and the specifying information for checking commodity.
The technical scheme of the present invention has been explained in detail above with reference to the attached drawings, is grasped family more intuitive and convenient can be used
Make, while the treatment effeciency for improving data inputting, storing and showing.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, made any to repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (6)
1. a kind of data processing method characterized by comprising
According to user in the same nonumeric classification of 2-D data input interface typing and the difference of the same nonumeric classification
Nonumeric property cache generate have child node XML data；
The XML data with child node is converted into the XML data without child node, described will not have child node
XML data branch be stored in background data base table；
Wherein, it is described according to user 2-D data input interface typing same nonumeric classification and the same nonumeric class
Other different nonumeric property cache generates the XML data with child node, specifically includes:
The same nonumeric classification and the different nonumeric attributes are merged into processing respectively, it is different non-to generate
Combinations of values attribute；
It is buffered in the different nonumeric composite attributes as child node merging in the same row of same a line, to generate
The XML data with child node；
It is described that the XML data with child node is converted into the XML data without child node, described will not have son
The XML data branch of node is stored in background data base table, specifically includes:
The number for the child node for including according to the XML data with child node determines in the background data base table
The line number of the storage XML without child node；
The XML data branch without child node is stored according to the different nonumeric composite attributes and the line number
In the background data base table.
2. data processing method according to claim 1, which is characterized in that further include:
Receive the user the 2-D data input interface typing the same nonumeric classification it is different described non-
The corresponding numerical value column information of numerical attribute；
The numerical value column information is stored into the corresponding nonumeric composite attribute different lines of the row.
3. data processing method according to claim 2, which is characterized in that further include: the backstage is stored in when showing
When the XML data without child node in database table,
The different nonumeric composite attributes is merged into processing and generates the XML data with child node, same
Showed in the same row of a line；
The corresponding numerical value column information of the different nonumeric composite attributes is subjected to total processing, and by aggregate result exhibition
Now in the XML data different lines of the row with child node.
4. a kind of data processing equipment characterized by comprising
Processing module, for according to user in 2-D data input interface typing same nonumeric classification and the same non-number
The different nonumeric property caches for being worth classification generate the XML data with child node；
Conversion module, for the XML data with child node to be converted to the XML data without child node, by institute
The XML data branch without child node is stated to be stored in background data base table；
Wherein, the processing module specifically includes:
First merging module, for the same nonumeric classification and the different nonumeric attributes to be merged place respectively
Reason, to generate different nonumeric composite attributes；
Cache module, for being buffered in the same of same a line for the different nonumeric composite attributes as child node merging
In one column, to generate the XML data with child node；
The number of determining module, the child node for including according to the XML data with child node is determined described
The line number of the XML without child node is stored in background data base table；
First memory module, for that described will not have child node according to the different nonumeric composite attributes and the line number
XML data branch be stored in the background data base table.
5. data processing equipment according to claim 4, which is characterized in that further include:
Receiving module, for receiving the user in the same nonumeric classification of the 2-D data input interface typing
The corresponding numerical value column information of the different nonumeric attribute；And
Second memory module, it is of the row not to the corresponding nonumeric composite attribute for storing the numerical value column information
In same column.
6. data processing equipment according to claim 5, which is characterized in that further include:
Second merging module, for when show be stored in the background data base table described in do not have child node XML number
According to when, the different nonumeric composite attributes is merged into processing and generates the XML data with child node, same
Showed in the same row of a line；
Computing module, for the corresponding numerical value column information of the different nonumeric composite attributes to be carried out total processing,
And aggregate result is presented in the XML data different lines of the row with child node.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510857342.XA CN105488162B (en) | 2015-11-30 | 2015-11-30 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510857342.XA CN105488162B (en) | 2015-11-30 | 2015-11-30 | Data processing method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105488162A CN105488162A (en) | 2016-04-13 |
| CN105488162B true CN105488162B (en) | 2019-04-16 |
Family
ID=55675136
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510857342.XA Active CN105488162B (en) | 2015-11-30 | 2015-11-30 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105488162B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108694249B (en) * | 2018-05-30 | 2022-02-25 | 平安科技（深圳）有限公司 | Data processing method, data processing device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1632792A (en) * | 2004-12-29 | 2005-06-29 | 复旦大学 | XML data based highly effective path indexing method |
| CN102222088A (en) * | 2011-05-30 | 2011-10-19 | 大连银行股份有限公司 | System and method for checking, summarizing and displaying data quality according to multidimensional attribute |
| CN103530840A (en) * | 2013-10-10 | 2014-01-22 | 中国中医科学院 | Accurate and quick electronic medical record type-in system |
| US8762424B2 (en) * | 2012-01-25 | 2014-06-24 | International Business Machines Corporation | Generating views of subsets of nodes of a schema |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US9935907B2 (en) * | 2012-11-20 | 2018-04-03 | Dropbox, Inc. | System and method for serving a message client |
-
2015
- 2015-11-30 CN CN201510857342.XA patent/CN105488162B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1632792A (en) * | 2004-12-29 | 2005-06-29 | 复旦大学 | XML data based highly effective path indexing method |
| CN102222088A (en) * | 2011-05-30 | 2011-10-19 | 大连银行股份有限公司 | System and method for checking, summarizing and displaying data quality according to multidimensional attribute |
| US8762424B2 (en) * | 2012-01-25 | 2014-06-24 | International Business Machines Corporation | Generating views of subsets of nodes of a schema |
| CN103530840A (en) * | 2013-10-10 | 2014-01-22 | 中国中医科学院 | Accurate and quick electronic medical record type-in system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105488162A (en) | 2016-04-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8793567B2 (en) | Automated suggested summarizations of data | |
| Xie et al. | VAET: A visual analytics approach for e-transactions time-series | |
| CN104965886B (en) | Data dimension processing method | |
| CN107193967A (en) | A kind of multi-source heterogeneous industry field big data handles full link solution | |
| CN103678468B (en) | The system and method for improved consumption model for profiling | |
| US20150032708A1 (en) | Database analysis apparatus and method | |
| CN103077070B (en) | Cloud computing management system and management method for cloud computing systems | |
| CN104346698B (en) | Based on the analysis of the food and drink member big data of cloud computing and data mining and checking system | |
| CN106294439A (en) | A kind of data recommendation system and data recommendation method thereof | |
| CN105512265A (en) | Method and device for displaying data through figure | |
| CN108595604A (en) | A kind of data visualisation system and method for intelligent report forms | |
| CN106067132A (en) | The method to set up of item property and device | |
| CN107797797A (en) | Quantify back to survey with quantifying method of commerce and device, storage medium, equipment and system | |
| CN106408435A (en) | Process compiling system and process compiling method | |
| CN108536718A (en) | A kind of method and system for the IT application in management realized based on input and output semantization | |
| CN109800401A (en) | Information report automatic generation method and device | |
| CN108268615A (en) | A kind of data processing method, device and system | |
| CN105808682A (en) | Relational graph display method and apparatus | |
| CN105488162B (en) | Data processing method and device | |
| CN107943863A (en) | Agile Modeling method and system based on business intelligence | |
| CN109241510A (en) | A kind of autochart generation system and its implementation based on wechat small routine | |
| WO2020201830A1 (en) | Systems and methods for generating, monitoring, and analyzing event networks from event data | |
| US10860651B2 (en) | Method, apparatus, and computer-readable medium for generation of missing data | |
| CN103778154A (en) | Form property reverse writing method and device | |
| CN115330420A (en) | Jade tracing method and system based on standard |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |