CN110502555B - Method and tool for dynamically generating cross table - Google Patents
Method and tool for dynamically generating cross table Download PDFInfo
- Publication number
- CN110502555B CN110502555B CN201910787356.7A CN201910787356A CN110502555B CN 110502555 B CN110502555 B CN 110502555B CN 201910787356 A CN201910787356 A CN 201910787356A CN 110502555 B CN110502555 B CN 110502555B
- Authority
- CN
- China
- Prior art keywords
- cross
- data
- statistics
- group
- column
- 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
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000013499 data model Methods 0.000 claims abstract description 11
- 238000004364 calculation method Methods 0.000 claims description 65
- 238000004422 calculation algorithm Methods 0.000 claims description 18
- 238000000547 structure data Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 claims description 5
- 230000002776 aggregation Effects 0.000 claims 2
- 238000004220 aggregation Methods 0.000 claims 2
- 239000003292 glue Substances 0.000 claims 1
- 238000004458 analytical method Methods 0.000 abstract description 8
- 238000004141 dimensional analysis Methods 0.000 description 4
- 238000009825 accumulation Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention discloses a method for dynamically generating a cross table, and relates to the technical field of data processing. The method converts two-dimensional table data of a relational database into formatted report data with intersecting multidimensional, and the implementation process comprises the following steps: step one, acquiring a two-dimensional table of a relational database, and organizing data contained in the two-dimensional table into a LIST form; setting parameters related to the rows and the columns based on the LIST LIST; step three, constructing a data model based on the data contained in the two-dimensional table to generate a page code in an HTML format, and finally outputting multi-dimensional crossed formatted report data, so that analysis can be performed by checking the converted multi-dimensional crossed report; particularly for applications where data is cross analyzed, development effort can be significantly reduced. The invention also discloses a tool for dynamically generating the cross table, which is combined with the method to convert the two-dimensional table data of the relational database into formatted report data with multi-dimensional cross.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method and a tool for dynamically generating a cross table.
Background
The multidimensional cross analysis of the two-dimensional data of the relational database is a necessary function of various data analysis and query systems at present. There are many BI tools currently on the market that provide for the generation of cross reports. But these tools are basically operated in a single deployment and are expensive; for some small application systems or application systems with only partial cross report presentation functions, purchasing these tool software is not necessarily appropriate from an economic or system architecture perspective.
Disclosure of Invention
Aiming at the needs and the shortcomings of the prior art development, the invention provides a method and a tool for dynamically generating a cross table, which realize the effect of converting two-dimensional data in a relational database into a cross report for analysis.
Firstly, the invention provides a method for dynamically generating a cross table, which solves the technical problems and adopts the following technical scheme:
a method for dynamically generating a cross table converts two-dimensional table data of a relational database into formatted report data with multi-dimensional cross, and the implementation process comprises the following steps:
step one, acquiring a two-dimensional table of a relational database, and organizing data contained in the two-dimensional table into a LIST form;
setting parameters related to the rows and the columns based on the LIST LIST;
and thirdly, constructing a data model based on the data contained in the two-dimensional table to generate a page code in an HTML format, and finally outputting the multi-dimensional crossed formatted report data.
In the first step, when the data contained in the two-dimensional table is organized into a LIST form, each unit of behavior inputLIST stores HASEMP structure data in the form of key value pairs;
wherein the keys are explicitly named and the values are corresponding data.
In the second step, parameters related to the rows and columns are set based on the LIST, and specific setting parameters include:
cross row parameter rowMeta;
cross column parameter colMeta;
cross statistics of the column group_col to be calculated;
cross statistics algorithm group_fun to be calculated;
alias group_aliasname of the cross statistics calculation result;
the aggregate field TotalColumn is to be generated.
In the third step, a title area part and a data area part are constructed according to the TABLE- > tr- > td format of the HTML;
the header area part classifies the data contained in the two-dimensional table based on the cross column parameter colMeta;
the data field groups and aggregates the data contained in the two-dimensional table based in part on the intersecting line parameter rowMeta.
Specifically, the related data area part comprises an aggregate calculation module, a cell calculation module, an HTML format colspan calculation module, an HTML format rowspan calculation module and an output module;
the total calculation module calculates the value of the total field based on the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasName of the cross statistics calculation result, and the field totalcumn to be generated in total;
the cell calculation module calculates the display content of the cells at each row and column intersection based on the intersection row parameter rowMeta, the intersection column parameter colMeta, the column group_col to be calculated by the intersection statistics, the algorithm group_fun to be calculated by the intersection statistics and the alias group_aliasName of the intersection statistics calculation result;
the HTML format colspan calculation module calculates the colspan of each cell;
the HTML-format rowspan calculation module is used for calculating rowspan of each cell;
and the output module is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
The invention further provides a tool for dynamically generating the cross table, which adopts the following technical scheme:
a tool for dynamically generating a cross-table, the tool converting two-dimensional table data of a relational database into multi-dimensional cross-formatted report data, the tool comprising:
the acquisition module is used for acquiring a two-dimensional table of the relational database and organizing data contained in the two-dimensional table into a LIST form;
a parameter setting module for setting parameters related to the rows and columns based on the LIST;
the construction module is used for constructing a data model based on the data contained in the two-dimensional table;
and the data model is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
Specifically, when the related acquisition module organizes the data contained in the two-dimensional table into a LIST form, each unit of behavior inputLIST stores HASEMP structure data in a key value pair form;
wherein the keys are explicitly named and the values are corresponding data.
Specifically, parameters that the parameter setting module involved can set include:
cross row parameter rowMeta;
cross column parameter colMeta;
cross statistics of the column group_col to be calculated;
cross statistics algorithm group_fun to be calculated;
alias group_aliasname of the cross statistics calculation result;
the aggregate field TotalColumn is to be generated.
Specifically, when the related construction module constructs a data model, the related construction module is used for constructing a title area part and a data area part according to the TABLE- > tr- > td format of HTML;
the header area part classifies the data contained in the two-dimensional table based on the cross column parameter colMeta;
the data field groups and aggregates the data contained in the two-dimensional table based in part on the intersecting line parameter rowMeta.
Specifically, the related data area part further comprises an aggregate calculation module, a cell calculation module, an HTML format colspan calculation module, an HTML format rowspan calculation module and an output module;
the total calculation module calculates the value of the total field based on the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasName of the cross statistics calculation result, and the field totalcumn to be generated in total;
the cell calculation module calculates the display content of the cells at each row and column intersection based on the intersection row parameter rowMeta, the intersection column parameter colMeta, the column group_col to be calculated by the intersection statistics, the algorithm group_fun to be calculated by the intersection statistics and the alias group_aliasName of the intersection statistics calculation result;
the HTML format colspan calculation module calculates the colspan of each cell;
the HTML-format rowspan calculation module is used for calculating rowspan of each cell;
and the output module is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
Compared with the prior art, the method and the tool for dynamically generating the cross table have the beneficial effects that:
1) The method and the tool can convert the two-dimensional table data of the relational database into formatted report data with intersecting multidimensional, so that the analysis can be performed by checking the converted multidimensional intersecting report, the analysis result is clear at a glance, and the efficiency is saved; particularly for the application of cross analysis of data, the development workload can be remarkably reduced;
2) The method and the tool can be embedded in various application systems, avoid complexity of deployment of BI, and simultaneously are core function parts of a multi-dimensional analysis tool, and can realize complex multi-dimensional analysis functions through secondary development.
Detailed Description
In order to make the technical solution, the technical problems to be solved and the technical effects of the present invention more apparent, the technical solution of the present invention will be clearly and completely described below in conjunction with specific embodiments, and it is apparent that the described embodiments are only some embodiments of the present invention, but not all embodiments. All embodiments obtained by a person skilled in the art without making any inventive effort are within the scope of the present invention based on the embodiments of the present invention.
Embodiment one:
the embodiment provides a method for dynamically generating a cross table, which converts two-dimensional table data of a relational database into formatted report data with cross multidimensional, and the implementation process comprises the following steps:
step one, acquiring a two-dimensional table of a relational database, and organizing data contained in the two-dimensional table into a LIST form;
setting parameters related to the rows and the columns based on the LIST LIST;
and thirdly, constructing a data model based on the data contained in the two-dimensional table to generate a page code in an HTML format, and finally outputting the multi-dimensional crossed formatted report data.
In step one of this embodiment, when organizing the data contained in the two-dimensional table into LIST form, each unit of behavior inputLIST stores HASSMA structure data in the form of key value pairs; wherein the keys are explicitly named and the values are corresponding data. Referring to table 1 below, which is an acquired two-dimensional table;
table 1:
wherein the HASSMAP structure: { (K: province- > V: shandong); (K: city- > V: jinan); (K: school type- > V: senior citizen); (K: sex- > V: male); (K: number of people- > V: 20); }.
Referring to table 1, specific setting parameters include:
cross row parameter rowMeta; referring to table 1, rowmeta may be { "school type", "gender" };
cross column parameter colMeta; referring to table 1, colMeta may be { "province", "city" };
cross statistics of the column group_col to be calculated; referring to table 1, group_col may be { "number of people", "number of people" };
cross statistics algorithm group_fun to be calculated; referring to table 1, group_fn may be {0,6}, and the number may represent a certain calculation method, in this embodiment, 0 represents accumulation, and 6 represents duty cycle;
alias group_aliasname of the cross statistics calculation result; referring to table 1, group_aliasname is { "number of people", "duty ratio" };
the field TotalColumn to be generated; referring to Table 1, totalColumn may be { "province", "city" }.
In step three, the header area portion and the data area portion are constructed in accordance with the TABLE- > tr- > td format of HTML, and thick solid lines in TABLE 2 distinguish header area portions and data area portions arranged one above the other.
Refer to Table 2 below, which is a multi-dimensionally interleaved formatted report.
Table 2:
the header area part classifies the data contained in the two-dimensional table based on the cross column parameter colMeta; referring to table 2, based on the types of schools, junior middle schools, and senior high schools, and on the basis of gender, the classification of the number of men and women is performed according to the above-described classification results, based on the number of people.
The data area part groups and sums the data contained in the two-dimensional table based on the cross line parameter rowMeta; referring to table 2, firstly, division into eastern and Jiangsu is based on provinces, secondly, division into eastern atan and chat, and Jiangsu's nanjing and Wuxi are based on cities, and meanwhile, the divided cities are calculated and aggregated according to the division results of the title region.
In this embodiment, referring to table 2, the related data area portion includes an aggregate calculation module, a cell calculation module, an HTML format colspan calculation module, an HTML format rowspan calculation module, and an output module;
the total calculation module calculates the value of the total field based on the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasName of the cross statistics calculation result, and the field totalcumn to be generated in total;
the cell calculation module calculates the display content of the cells at each row and column intersection based on the intersection row parameter rowMeta, the intersection column parameter colMeta, the column group_col to be calculated by the intersection statistics, the algorithm group_fun to be calculated by the intersection statistics and the alias group_aliasName of the intersection statistics calculation result;
the HTML format colspan calculation module calculates the colspan of each cell;
the HTML-format rowspan calculation module is used for calculating rowspan of each cell;
and the output module is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
Embodiment two:
the present embodiment proposes a tool for dynamically generating a cross table, which converts two-dimensional table data of a relational database into formatted report data of multi-dimensional cross,
the tool comprises:
the acquisition module is used for acquiring a two-dimensional table of the relational database and organizing data contained in the two-dimensional table into a LIST form;
a parameter setting module for setting parameters related to the rows and columns based on the LIST;
the construction module is used for constructing a data model based on the data contained in the two-dimensional table;
and the data model is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
In this embodiment, when the acquiring module organizes the data contained in the two-dimensional table into a LIST form, each unit of behavior inputLIST stores hash structure data in the form of key value pairs;
wherein the keys are explicitly named and the values are corresponding data.
Referring to table 1 below, which is an acquired two-dimensional table;
table 1:
as shown in table 1, it is a two-dimensional table obtained, wherein the HASHMAP structure: { (K: province- > V: shandong); (K: city- > V: jinan); (K: school type- > V: senior citizen); (K: sex- > V: male); (K: number of people- > V: 20); }
In this embodiment, parameters that may be set by the parameter setting module involved include:
cross row parameter rowMeta; referring to table 1, rowmeta may be { "school type", "gender" };
cross column parameter colMeta; referring to table 1, colMeta may be { "province", "city" };
cross statistics of the column group_col to be calculated; referring to table 1, group_col may be { "number of people", "number of people" };
cross statistics algorithm group_fun to be calculated; referring to table 1, group_fn may be {0,6}, and the number may represent a certain calculation method, in this embodiment, 0 represents accumulation, and 6 represents duty cycle;
alias group_aliasname of the cross statistics calculation result; referring to table 1, group_aliasname is { "number of people", "duty ratio" };
the field TotalColumn to be generated; referring to Table 1, totalColumn may be { "province", "city" }.
In this embodiment, when the related building module builds a data model, the related building module is configured to build a header area part and a data area part according to the TABLE- > tr- > td format of HTML; the thick solid line in table 2 distinguishes a header area portion and a data area portion arranged one above the other.
Refer to Table 2 below, which is a multi-dimensionally interleaved formatted report.
Table 2:
the header area part classifies the data contained in the two-dimensional table based on the cross column parameter colMeta; referring to table 2, based on school types, the classification is performed on the basis of schools, juniors, and high schools, sex-based classification is performed on the basis of sexes, male and female, and classification is performed on the basis of the number of people according to the classification results;
the data area part groups and sums the data contained in the two-dimensional table based on the cross line parameter rowMeta; referring to table 2, firstly, division into eastern and Jiangsu is based on provinces, secondly, division into eastern atan and chat, and Jiangsu's nanjing and Wuxi are based on cities, and meanwhile, the divided cities are calculated and aggregated according to the division results of the title region.
In this embodiment, referring to table 2, the related data area portion further includes an aggregate calculation module, a cell calculation module, an HTML format colspan calculation module, an HTML format rowspan calculation module, and an output module;
the total calculation module calculates the value of the total field based on the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasName of the cross statistics calculation result, and the field totalcumn to be generated in total;
the cell calculation module calculates the display content of the cells at each row and column intersection based on the intersection row parameter rowMeta, the intersection column parameter colMeta, the column group_col to be calculated by the intersection statistics, the algorithm group_fun to be calculated by the intersection statistics and the alias group_aliasName of the intersection statistics calculation result;
the HTML format colspan calculation module calculates the colspan of each cell;
the HTML-format rowspan calculation module is used for calculating rowspan of each cell;
and the output module is used for generating page codes in an HTML format and finally outputting the multi-dimensional crossed formatted report data.
In summary, by adopting the method and the tool for dynamically generating the cross table, the two-dimensional table data of the relational database can be converted into the formatted report data with cross multi-dimension, so that the analysis can be performed by checking the converted multi-dimension cross report, the analysis result is clear at a glance, and the efficiency is saved; particularly for applications where data is cross analyzed, development effort can be significantly reduced.
The method and the tool can be embedded in various application systems, avoid complexity of deployment of BI, and simultaneously are core function parts of a multi-dimensional analysis tool, and can realize complex multi-dimensional analysis functions through secondary development.
The foregoing describes the principles and embodiments of the present invention in detail using specific examples, which are only for aiding in understanding the core technical content of the present invention, and are not intended to limit the scope of the present invention, but the technical solutions of the present invention are not limited to the foregoing specific embodiments. Based on the above-mentioned embodiments of the present invention, any improvements and modifications made by those skilled in the art without departing from the principles of the present invention should fall within the scope of the present invention.
Claims (2)
1. A method for dynamically generating a cross table is characterized in that the method converts two-dimensional table data of a relational database into formatted report data with cross multidimensional, and the implementation process comprises the following steps:
step one, acquiring a two-dimensional table of a relational database, and organizing data contained in the two-dimensional table into a LIST form, wherein each unit of behavior inputLIST stores HASSMA structure data in a key value pair form, wherein keys are column names, and values are corresponding data;
step two, setting parameters related to the rows and the columns based on the LIST LIST, wherein the method specifically comprises the following steps: cross row parameter rowMeta, cross column parameter colMeta, cross statistics column group_col to be calculated, cross statistics algorithm group_fun to be calculated, alias group_aliasName of cross statistics calculation result, generate aggregate field TotalColumn;
step three, based on the data contained in the two-dimensional TABLE, constructing a header area part and a data area part according to the TABLE- > tr- > td format of the HTML, classifying the data contained in the two-dimensional TABLE by the header area part based on the cross column parameter colMeta, wherein the data area part comprises an aggregate calculation module, a cell calculation module, an HTML format colspan calculation module, an HTML format rowspan calculation module and an output module, wherein: the total calculation module calculates the value of the total field based on the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasname of the cross statistics calculation result, the total field totalcumn to be generated, the cell calculation module calculates the content displayed by the cells at each row and column intersection based on the cross row parameter rowMeta, the cross column parameter colMeta, the column group_col to be calculated by the cross statistics, the algorithm group_fun to be calculated by the cross statistics, the alias group_aliasname of the cross statistics calculation result, the HTML format colspan calculation module calculates the colspan of each cell, the HTML format rowspan calculation module calculates the rowspan of each cell, the output module is used for generating the page code of the HTML format, and finally outputting the formatted report data of the multi-dimensional intersection.
2. A tool for dynamically generating a cross-table, the tool converting two-dimensional table data of a relational database into multi-dimensional cross-formatted report data, the tool comprising:
the acquisition module is used for acquiring a two-dimensional table of the relational database, organizing data contained in the two-dimensional table into a LIST form, at the moment, storing HASEMP structure data in a key value pair form by each inputLIST unit, wherein keys are explicit names, and the values are corresponding data;
the parameter setting module is configured to set parameters related to the rows and the columns based on the LIST, and specifically includes: cross row parameter rowMeta, cross column parameter colMeta, cross statistics column group_col to be calculated, cross statistics algorithm group_fun to be calculated, alias group_aliasName of cross statistics calculation result, generate aggregate field TotalColumn;
the construction module is used for constructing a data model based on the data contained in the two-dimensional table;
the data model is divided into a header area part and a data area part according to a TABLE- > tr- > td format of HTML, the header area part classifies data contained in the two-dimensional TABLE based on cross column parameters colMeta, the data area part comprises an aggregation calculation module, a cell calculation module, an HTML format colspan calculation module and an output module, wherein the aggregation calculation module calculates the display content of cells at each intersection based on a column group_col to be calculated by cross statistics, an algorithm group_fun to be calculated by cross statistics, an alias group_aliaName of the cross statistics calculation result, a value of an aggregate field to be generated by the cross column parameters colMeta, a column group_col to be calculated by cross statistics, an algorithm group_fun to be calculated by cross statistics, an alias group_aliaName to be calculated by cross statistics, the HTML format column group_glue to be calculated by cross column parameters colMeta, the HTML format calculation module calculates the display content of cells at each intersection, and the HTML format data of the HTML format are output by the cell calculation module to be used for calculating the HTML format of the cross column code of each cross column.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910787356.7A CN110502555B (en) | 2019-08-23 | 2019-08-23 | Method and tool for dynamically generating cross table |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910787356.7A CN110502555B (en) | 2019-08-23 | 2019-08-23 | Method and tool for dynamically generating cross table |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110502555A CN110502555A (en) | 2019-11-26 |
CN110502555B true CN110502555B (en) | 2023-06-02 |
Family
ID=68589278
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910787356.7A Active CN110502555B (en) | 2019-08-23 | 2019-08-23 | Method and tool for dynamically generating cross table |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110502555B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112036140B (en) * | 2020-09-01 | 2023-08-18 | 中国银行股份有限公司 | Front-end table data grouping statistical method and device |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
FR2872606A1 (en) * | 2004-07-02 | 2006-01-06 | Univ Paris Dauphine Etablissem | ASSOCIATED SOFTWARE DATA PROCESSING METHOD |
CN101071413A (en) * | 2007-06-15 | 2007-11-14 | 南京联创科技股份有限公司 | Automatic packet method for cross report |
CN107480168A (en) * | 2017-06-27 | 2017-12-15 | 石化盈科信息技术有限责任公司 | A kind of Cross Report based on LIMS realizes system |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9524286B2 (en) * | 2012-12-04 | 2016-12-20 | Oracle International Corporation | Persistent layer labels for a pivot table or cross-tabular report |
-
2019
- 2019-08-23 CN CN201910787356.7A patent/CN110502555B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
FR2872606A1 (en) * | 2004-07-02 | 2006-01-06 | Univ Paris Dauphine Etablissem | ASSOCIATED SOFTWARE DATA PROCESSING METHOD |
CN101071413A (en) * | 2007-06-15 | 2007-11-14 | 南京联创科技股份有限公司 | Automatic packet method for cross report |
CN107480168A (en) * | 2017-06-27 | 2017-12-15 | 石化盈科信息技术有限责任公司 | A kind of Cross Report based on LIMS realizes system |
Non-Patent Citations (1)
Title |
---|
HTML表格向XML的智能转换;贾长云等;《计算机工程》;20090720(第14期);全文 * |
Also Published As
Publication number | Publication date |
---|---|
CN110502555A (en) | 2019-11-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105468605B (en) | Entity information map generation method and device | |
Zhao et al. | Modeling MongoDB with relational model | |
CN102722531B (en) | Query method based on regional bitmap indexes in cloud environment | |
CN103049581B (en) | A kind of web text classification method based on consistance cluster | |
US20160364402A1 (en) | System and method for compressing data in a database | |
CN107016501A (en) | A kind of efficient industrial big data multidimensional analysis method | |
CN102385585A (en) | Establishing method of webpage database, webpage searching method and relative device | |
CN103678550A (en) | Mass data real-time query method based on dynamic index structure | |
CN105786996A (en) | Electricity information data quality analyzing system | |
CN110502555B (en) | Method and tool for dynamically generating cross table | |
CN101894129A (en) | Video topic finding method based on online video-sharing website structure and video description text information | |
CN107025298A (en) | A kind of big data calculates processing system and method in real time | |
CN108280366A (en) | A kind of batch linear query method based on difference privacy | |
CN114048204A (en) | Beidou grid space indexing method and device based on database inverted index | |
CN111241076A (en) | Stream data increment processing method and device based on tensor chain decomposition | |
CN116501758B (en) | NetCDF data query method and terminal | |
CN105938469B (en) | Coding and storing method, text storing data structure and Text compression storage and statistics output method | |
CN111026759B (en) | Report generation method and device based on Hbase | |
CN115587096A (en) | System and method for realizing MySQL synchronous data to ES (extended services System) to construct wide table | |
Chiu et al. | The analysis of undesirable output to countries’ productivity: the example of the Asian countries | |
CN108664573A (en) | A kind of quick processing system of big data and method with double-channel data library | |
Burns et al. | A sector approach to the: formulation of system dynamics models | |
CN114428814A (en) | Self-service analysis modeling method for different-scale aggregation of large data set | |
Ishiyama et al. | A succinct data structure for multidimensional orthogonal range searching | |
CN109635023B (en) | Lightweight custom source data decomposition reading system and method based on ETL |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |