CN104699748A - Method and system for showing report form with non-fixed column numbers - Google Patents
Method and system for showing report form with non-fixed column numbers Download PDFInfo
- Publication number
- CN104699748A CN104699748A CN201410792260.7A CN201410792260A CN104699748A CN 104699748 A CN104699748 A CN 104699748A CN 201410792260 A CN201410792260 A CN 201410792260A CN 104699748 A CN104699748 A CN 104699748A
- Authority
- CN
- China
- Prior art keywords
- row
- candidate
- data
- interim
- field
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and a system for showing a report form with non-fixed column numbers. The method comprises steps as follows: A, all column data of related report forms are acquired from a database according to an inquiry condition to form candidate columns; B, a first report form is created according to the candidate columns when no temporary report form identical to the candidate columns exists in the database; C, data inquiry is performed, the first report form is filled in, and the final report form is generated. The problem of uncertainty of the number of to-be-shown columns of the report form is effectively solved through arrangement of an extra temporary report form and according to creation and judgment ways of the extra temporary report form, report forms with different column numbers can be output according to different inquiry conditions, and the management of enterprise operation is further facilitated.
Description
Technical field
The present invention relates to Oracle E-Business Suites systems technology field, particularly relate to method and system thereof that row form is not fixed in a kind of displaying.
Background technology
Inscriptions on bones or tortoise shells e-commerce suite system (Oracle E-Business Suites) is widely used in global enterprise, it is by feat of the system architecture of maturation and abundant business function, the degree of depth agrees with Modern Enterprise Administration theory and management system, for enterprise provides efficient resource planning to manage.Wherein the preset form of system and self-defined report can provide effective data directly perceived, facilitate enterprise accurately control operation situation.In enterprise practical business activities, there is the service interaction between multiple object of the same type, how to add up exactly and to show the business datum between some objects and other object, current preset form and self-defined report are not both also decided on a verdict.The present invention's perfection achieves the data statistics of aforementioned type of service and exports displaying.At inscriptions on bones or tortoise shells e-commerce suite EBS(Oracle E-Business Suites) submit request window to, each input is different but submit request to after effective query argument, the PL/SQL storing process that request call compiles in a database, perform SQL statement (structured query sentence Structured Query Language) wherein, obtain the query results of the row-column list structure of a different two dimension.In this result set, line number is not fixed, but the data type of columns and row is fixed.Finally result set to be shown as form, generally can adopt two kinds of methods: rtf file calls the XML text of loading data or data assemblies is spliced into the file of html format.
First method is, use XML tag combination query arguments etc. are as header (Header), again by Query Result concentrate data searching loop line by line, by each column data in XML tag combination row as row information (Line), export the XML text of the capable structure of a head (Header-Line).Then be loaded in rtf file, the row for the form finished in advance bind the row in XML file.Upload rtf file to EBS server, association rtf file and request.Rerun request, then generate the report file that is loaded the specified file format (Excel, Pdf etc.) of Query Result.
Second method is, query results is directly combined into a complete html text by the labels such as <TABLE>, <TR> and <TD> in use html language.The wherein row of searching loop result set, then the row in row are used the splicing of <TD> label.When inquiry request exports, EBS can call browser and will comprise the html text of data as web displaying, or also Office Excel software can be used to show Query Result by format conversion.
But in enterprise practical business activities, there is the service interaction between multiple object of the same type, the some objects of each input are as parameter, the Query Result of the row-column list structure of the two dimension obtained is concentrated, line number is not fixed, and the data type of row (having the object of service interaction with the parameter of input) is fixed but columns can not be fixed.Use above-mentioned two kinds of methods that result set cannot be applicable to be shown as form.
Therefore, prior art need development.
Summary of the invention
In view of above-mentioned the deficiencies in the prior art part, the object of the present invention is to provide a kind of displaying not fix method and the system thereof of row form, be intended to solve in existing methods of exhibiting when arrange (with input parameter have the object of service interaction) data type fix but columns can not be fixed time cannot be suitable for problem result set being shown as form.
In order to achieve the above object, this invention takes following technical scheme:
A method for row form is not fixed in displaying, and wherein, described method comprises:
A, foundation querying condition, obtain the data of the row of all relevant forms from database, forms candidate's row;
B, when do not exist in database to arrange identical interim form with candidate time, arrange establishment first form according to candidate;
C, carry out data query and fill the first form, generating final form.
The method of row form is not fixed in described displaying, and wherein, described step B specifically comprises:
B1, judge that whether candidate's number of columns is equal with the quantity of the row of interim form;
B2, when the quantity of the row of candidate's number of columns and described interim form is unequal, delete this interim form, arrange establishment first form according to candidate;
B3, when candidate's number of columns is equal with the quantity of the row of described interim form, deletes the data in this interim form, it can be used as the first form.
The method of row form is not fixed in described displaying, and wherein, described step C specifically comprises:
C1, carry out Querying by group by the field comprising candidate's row, obtain the query results of actual row and corresponding data desired value in practical business under current queries condition;
C2, be filled in described first form by corresponding for this query results;
C3, inquire about from the first form and show the final form of row and the corresponding data meeting querying condition.
The method of row form is not fixed in described displaying, and wherein, described step C2 is specially: the row title of the reality concentrated according to Query Result upgrades the data target value of corresponding field in temporary table, completes data stuffing.
The method of row form is not fixed in described displaying, and wherein, described step C3 specifically comprises:
All in the interim form of C31, cyclic query candidate's row, find in field all values that to exist be not empty field, and this field of buffer memory, in array, determines that this inquiry needs the row shown;
This inquiry of C32, circular buffer needs the array of the row shown, the value of field described in interim form is separated with special character in order and is spliced into a character string, from interim form, then inquire corresponding results set;
C33, splicing HTML character string, circulation character string result set, press each field after special string fractionation by <TD> tag combination, then wrap up with before and after <TR> label, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
The system of row form is not fixed in a kind of displaying, wherein, described system comprises: enquiry module, for foundation querying condition, the data of the row of all relevant forms are obtained from database, form candidate's row, interim Reports module, for when do not exist in database to arrange identical interim form with candidate time, establishment first form is arranged according to candidate, fill display module, for carrying out data query and filling the first form, generate final form.
The system of row form is not fixed in described displaying, and wherein, described interim Reports module specifically comprises:
Judging unit, for judging that whether candidate's number of columns is equal with the quantity of the row of interim form;
Creating unit, when the quantity for the row when candidate's number of columns and described interim form is unequal, deletes this interim form, arranges establishment first form according to candidate;
Data delete unit, for when candidate's number of columns is equal with the quantity of the row of described interim form, deletes the data in this interim form, it can be used as the first form.
The system of row form is not fixed in described displaying, and wherein, described filling display module specifically comprises:
Result set obtains unit, for carrying out Querying by group by the field comprising candidate's row, obtains the query results of actual row and corresponding data desired value in practical business under current queries condition;
Filler cells, is filled in described first form by corresponding for this query results;
Display unit, for inquiring about and showing the final form of row and the corresponding data meeting querying condition from the first form.
The system of row form is not fixed in described displaying, wherein, described filler cells specifically for, the row title of the reality concentrated according to Query Result upgrades the data target value of corresponding field in temporary table, completes data stuffing.
The system of row form is not fixed in described displaying, and wherein, described display unit specifically comprises:
Cyclic query subelement, for candidates all in the interim form of cyclic query row, find in field all values that to exist be not empty field, this field of buffer memory, in array, determines that this inquiry needs the row shown;
Circular buffer subelement, needs the array of the row shown for this inquiry of circular buffer, the value of field described in interim form separated with special character in order and be spliced into a character string, from interim form, then inquire corresponding results set;
Splicing subelement, for splicing HTML character string, circulation character string result set, each field after special string fractionation is pressed by <TD> tag combination, wrap up with before and after <TR> label again, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
Beneficial effect: method and the system thereof of row form are not fixed in a kind of displaying provided by the invention, by arranging extra interim form and establishment judges approach, the uncertainty of the quantity of effective solution form row to be presented, the form of unequal number amount row can be exported according to different querying conditions, further facilitated the management in enterprise operation.
Accompanying drawing explanation
Fig. 1 is the method flow diagram that row form is not fixed in a kind of displaying of the specific embodiment of the invention.
Fig. 2 is that carrying out data query and filling the first form of the method for row form is not fixed in a kind of displaying of the specific embodiment of the invention, generates the method flow diagram of final form concrete steps.
Fig. 3 is the process flow diagram that program that the method for row form is not fixed in a kind of displaying of the specific embodiment of the invention realizes.
Fig. 4 is the structured flowchart that the system of row form is not fixed in a kind of displaying of the specific embodiment of the invention.
Fig. 5 a is the schematic diagram of the first concrete form that the method using a kind of displaying provided by the invention not fix row form realizes.
Fig. 5 b is the schematic diagram of the second concrete form that the method using a kind of displaying provided by the invention not fix row form realizes.
Fig. 5 c is the schematic diagram of the 3rd concrete form that the method using a kind of displaying provided by the invention not fix row form realizes.
Embodiment
The invention provides method and system thereof that row form is not fixed in a kind of displaying.For making object of the present invention, technical scheme and effect clearly, clearly, developing simultaneously referring to accompanying drawing, the present invention is described in more detail for embodiment.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
As shown in Figure 1, for the method for row form and the specific embodiment of system thereof are not fixed in a kind of displaying of the present invention.Described method comprises:
S100, foundation querying condition, obtain the data of the row of all relevant forms from database, forms candidate's row.
S200, when do not exist in database to arrange identical interim form with candidate time, arrange establishment first form according to candidate.
S300, carry out data query and fill the first form, generating final form.
Concrete, described step S200 specifically comprises: first, judges that whether candidate's number of columns is equal with the quantity of the row of interim form.Then, when the quantity of the row of candidate's number of columns and described interim form is unequal, this interim form is deleted, establishment first form is arranged according to candidate, and when candidate's number of columns is equal with the quantity of the row of described interim form, delete the data in this interim form, it can be used as the first form.The method of the data in this interim form of above-mentioned deletion, can reduce the data of temporary table, improves efficiency during inquiry as far as possible.
More specifically, described step S300 specifically comprises:
S310, carry out Querying by group by the field comprising candidate's row, obtain the query results of actual row and corresponding data desired value in practical business under current queries condition.
S320, to be filled in corresponding for this query results in described first form.
S330, inquire about from the first form and show the final form of row and the corresponding data meeting querying condition.
More specifically, described step S320 is the data target value of corresponding field in the row title renewal temporary table of the reality that foundation Query Result is concentrated, and completes data stuffing.
It is preferred that described step S330 specifically comprises: first, all in the interim form of cyclic query candidate's row, find in field all values that to exist be not empty field, and this field of buffer memory, in array, determines that this inquiry needs the row shown.Then, this inquiry of circular buffer needs the array of the row shown, the value of field described in interim form is separated with special character in order and is spliced into a character string, then from interim form, inquire corresponding results set, finally, splicing HTML character string, circulation character string result set, each field after special string fractionation is pressed by <TD> tag combination, wrap up with before and after <TR> label again, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
As Fig. 5 a, shown in 5b and 5c, be the concrete form specific embodiment that the method using a kind of displaying provided by the invention not fix row form realizes, respectively illustrate the form of 4,3 or 6 row.
As shown in Figure 3, the specific embodiment of the program realization flow figure of the method for row form is not fixed for a kind of displaying provided by the invention.
Concrete steps are as follows:
1, during each inquiry form, according to the traffic set of reality and the report parameter of input, obtain from background data base and as the data of form row, namely can first limit the range intervals of dynamic column, dynamic column therebetween can be described as candidate's row;
2, judge whether there is a temporary table in database, the row name of this table is arranged by all candidates and forms.If do not have such temporary table, then the title utilizing all candidates to arrange, what splice an establishment temporary table builds table SQL statement.Perform this and build table SQL statement, obtain one with candidate arrange into row temporary table.If or have such temporary table, but in temporary table, the quantity of candidate's row is not equal to the quantity of the candidate's row obtained from first step, then delete this already present temporary table, again creates temporary table with the candidate obtained in first step row.If the quantity of candidate's row equals the quantity of the candidate's row obtained from first step in already present temporary table, then delete the data in temporary table before certain time point, reduce the data of temporary table, improve efficiency during inquiry as far as possible;
3, bring querying condition into and perform query SQL statement, by the field Querying by group comprising dynamic column, obtain the query results of actual row and corresponding data desired value in practical business under current queries condition;
4, cyclic query result set, upgrades the data target value of corresponding field in temporary table by the actual row title in result set;
5, all dynamic columns in circulation temporary table, find in field all values that to exist be not the field of NULL, and this field of buffer memory, in array, determines that this inquiry needs the row shown;
6, this inquiry of circular buffer needs the array of the row shown, the value of these fields in temporary table is separated with special character in order and is spliced into a character string, then from temporary table Temp, inquire result set;
7, HTML character string is spliced, circulation character string result set, press each field after special string fractionation by <TD> tag combination, then wrap up with before and after <TR> label, as the data line in form;
8, export HTML character string to browser, show that the actual index that should show that ad hoc inquiry condition obtains arranges and data.
As shown in Figure 4, present invention also offers the specific embodiment that the system of row form is not fixed in a kind of displaying, described system comprises: enquiry module 100, for foundation querying condition, the data of the row of all relevant forms are obtained from database, form candidate's row, interim Reports module 200, for when do not exist in database to arrange identical interim form with candidate time, establishment first form is arranged according to candidate, fill display module 300, for carrying out data query and filling the first form, generate final form.
Concrete, described interim Reports module specifically comprises: judging unit, for judging that whether candidate's number of columns is equal with the quantity of the row of interim form, creating unit, when the quantity for the row when candidate's number of columns and described interim form is unequal, delete this interim form, establishment first form is arranged, data delete unit, for when candidate's number of columns is equal with the quantity of the row of described interim form according to candidate, delete the data in this interim form, it can be used as the first form.
Preferably, described filling display module specifically comprises: result set obtains unit, for carrying out Querying by group by the field comprising candidate's row, obtain the query results of actual row and corresponding data desired value in practical business under current queries condition, filler cells, be filled in described first form by corresponding for this query results, display unit, for inquiring about from the first form and showing the final form of row and the corresponding data meeting querying condition.
Concrete, described filler cells specifically for, the row title of the reality concentrated according to Query Result upgrades the data target value of corresponding field in temporary table, completes data stuffing.
More specifically, described display unit specifically comprises: cyclic query subelement, and for candidates all in the interim form of cyclic query row, find in field all values that to exist be not empty field, this field of buffer memory, in array, determines that this inquiry needs the row shown; Circular buffer subelement, needs the array of the row shown for this inquiry of circular buffer, the value of field described in interim form separated with special character in order and be spliced into a character string, from interim form, then inquire corresponding results set; Splicing subelement, for splicing HTML character string, circulation character string result set, each field after special string fractionation is pressed by <TD> tag combination, wrap up with before and after <TR> label again, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
In sum, method and the system thereof of row form are not fixed in a kind of displaying provided by the invention, by arranging extra interim form and establishment judges approach, the uncertainty of the quantity of effective solution form row to be presented, the form of unequal number amount row can be exported according to different querying conditions, further facilitated the management in enterprise operation.
Be understandable that, for those of ordinary skills, can be equal to according to technical scheme of the present invention and the present invention's design and replace or change, and all these change or replace the protection domain that all should belong to the claim appended by the present invention.
Claims (10)
1. show a method of not fixing row form, it is characterized in that, described method comprises:
A, foundation querying condition, obtain the data of the row of all relevant forms from database, forms candidate's row;
B, when do not exist in database to arrange identical interim form with candidate time, arrange establishment first form according to candidate;
C, carry out data query and fill the first form, generating final form.
2. the method for row form is not fixed in displaying according to claim 1, it is characterized in that, described step B specifically comprises:
B1, judge that whether candidate's number of columns is equal with the quantity of the row of interim form;
B2, when the quantity of the row of candidate's number of columns and described interim form is unequal, delete this interim form, arrange establishment first form according to candidate;
B3, when candidate's number of columns is equal with the quantity of the row of described interim form, deletes the data in this interim form, it can be used as the first form.
3. the method for row form is not fixed in displaying according to claim 1, it is characterized in that, described step C specifically comprises:
C1, carry out Querying by group by the field comprising candidate's row, obtain the query results of actual row and corresponding data desired value in practical business under current queries condition;
C2, be filled in described first form by corresponding for this query results;
C3, inquire about from the first form and show the final form of row and the corresponding data meeting querying condition.
4. the method for row form is not fixed in displaying according to claim 3, it is characterized in that, described step C2 is specially: the row title of the reality concentrated according to Query Result upgrades the data target value of corresponding field in temporary table, completes data stuffing.
5. the method for row form is not fixed in displaying according to claim 3, it is characterized in that, described step C3 specifically comprises:
All in the interim form of C31, cyclic query candidate's row, find in field all values that to exist be not empty field, and this field of buffer memory, in array, determines that this inquiry needs the row shown;
This inquiry of C32, circular buffer needs the array of the row shown, the value of field described in interim form is separated with special character in order and is spliced into a character string, from interim form, then inquire corresponding results set;
C33, splicing HTML character string, circulation character string result set, press each field after special string fractionation by <TD> tag combination, then wrap up with before and after <TR> label, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
6. show the system of not fixing row form for one kind, it is characterized in that, described system comprises: enquiry module, for foundation querying condition, the data of the row of all relevant forms are obtained from database, form candidate's row, interim Reports module, for when do not exist in database to arrange identical interim form with candidate time, establishment first form is arranged according to candidate, fill display module, for carrying out data query and filling the first form, generate final form.
7. the system of row form is not fixed in displaying according to claim 6, it is characterized in that, described interim Reports module specifically comprises:
Judging unit, for judging that whether candidate's number of columns is equal with the quantity of the row of interim form;
Creating unit, when the quantity for the row when candidate's number of columns and described interim form is unequal, deletes this interim form, arranges establishment first form according to candidate;
Data delete unit, for when candidate's number of columns is equal with the quantity of the row of described interim form, deletes the data in this interim form, it can be used as the first form.
8. the system of row form is not fixed in displaying according to claim 6, it is characterized in that, described filling display module specifically comprises:
Result set obtains unit, for carrying out Querying by group by the field comprising candidate's row, obtains the query results of actual row and corresponding data desired value in practical business under current queries condition;
Filler cells, is filled in described first form by corresponding for this query results;
Display unit, for inquiring about and showing the final form of row and the corresponding data meeting querying condition from the first form.
9. the system of row form is not fixed in displaying according to claim 8, it is characterized in that, described filler cells specifically for, the row title of the reality concentrated according to Query Result upgrades the data target value of corresponding field in temporary table, completes data stuffing.
10. the system of row form is not fixed in displaying according to claim 8, it is characterized in that, described display unit specifically comprises:
Cyclic query subelement, for candidates all in the interim form of cyclic query row, find in field all values that to exist be not empty field, this field of buffer memory, in array, determines that this inquiry needs the row shown;
Circular buffer subelement, needs the array of the row shown for this inquiry of circular buffer, the value of field described in interim form separated with special character in order and be spliced into a character string, from interim form, then inquire corresponding results set;
Splicing subelement, for splicing HTML character string, circulation character string result set, each field after special string fractionation is pressed by <TD> tag combination, wrap up with before and after <TR> label again, as the data line in form; And export HTML character string to display device, show that the actual index that should show that this querying condition obtains arranges and data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410792260.7A CN104699748B (en) | 2014-12-19 | 2014-12-19 | It is a kind of to show the method and its system for being not fixed row report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410792260.7A CN104699748B (en) | 2014-12-19 | 2014-12-19 | It is a kind of to show the method and its system for being not fixed row report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104699748A true CN104699748A (en) | 2015-06-10 |
| CN104699748B CN104699748B (en) | 2018-06-12 |
Family
ID=53346869
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410792260.7A Active CN104699748B (en) | 2014-12-19 | 2014-12-19 | It is a kind of to show the method and its system for being not fixed row report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104699748B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897280A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN108140022A (en) * | 2015-12-24 | 2018-06-08 | 华为技术有限公司 | Data query method and Database Systems |
| CN109063167A (en) * | 2018-08-16 | 2018-12-21 | 深圳迅策科技有限公司 | A kind of unstructured finance data storage method |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN110297833A (en) * | 2019-07-05 | 2019-10-01 | 税安科技(杭州)有限公司 | A kind of bordereau error correction method |
| CN110737642A (en) * | 2019-09-05 | 2020-01-31 | 平安科技（深圳）有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
| CN111221883A (en) * | 2018-11-27 | 2020-06-02 | 浙江宇视科技有限公司 | Data statistical method and system |
| CN113360152A (en) * | 2021-06-11 | 2021-09-07 | 软子数字软件(广州)有限公司 | Method and system for realizing display program of parameterized data query webpage |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080243823A1 (en) * | 2007-03-28 | 2008-10-02 | Elumindata, Inc. | System and method for automatically generating information within an eletronic document |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN102521413A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Data reading device based on network reports and method |
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
-
2014
- 2014-12-19 CN CN201410792260.7A patent/CN104699748B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080243823A1 (en) * | 2007-03-28 | 2008-10-02 | Elumindata, Inc. | System and method for automatically generating information within an eletronic document |
| CN101650712A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Generating management method and system of self-defined report |
| CN102521413A (en) * | 2011-12-28 | 2012-06-27 | 畅捷通信息技术股份有限公司 | Data reading device based on network reports and method |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| CN102937980A (en) * | 2012-10-18 | 2013-02-20 | 亿赞普(北京)科技有限公司 | Method for inquiring data of cluster database |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106897280B (en) * | 2015-12-17 | 2020-07-14 | 菜鸟智能物流控股有限公司 | Data query method and device |
| CN106897280A (en) * | 2015-12-17 | 2017-06-27 | 阿里巴巴集团控股有限公司 | Data query method and device |
| CN108140022A (en) * | 2015-12-24 | 2018-06-08 | 华为技术有限公司 | Data query method and Database Systems |
| CN108140022B (en) * | 2015-12-24 | 2020-09-18 | 华为技术有限公司 | Data query method and database system |
| CN109063167A (en) * | 2018-08-16 | 2018-12-21 | 深圳迅策科技有限公司 | A kind of unstructured finance data storage method |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109408535B (en) * | 2018-09-28 | 2024-04-09 | 中国平安财产保险股份有限公司 | Large data volume matching method, device, computer equipment and storage medium |
| CN111221883A (en) * | 2018-11-27 | 2020-06-02 | 浙江宇视科技有限公司 | Data statistical method and system |
| CN111221883B (en) * | 2018-11-27 | 2024-04-26 | 浙江宇视科技有限公司 | Data statistics method and system |
| CN110297833A (en) * | 2019-07-05 | 2019-10-01 | 税安科技(杭州)有限公司 | A kind of bordereau error correction method |
| CN110737642A (en) * | 2019-09-05 | 2020-01-31 | 平安科技（深圳）有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
| CN110737642B (en) * | 2019-09-05 | 2022-09-02 | 平安科技（深圳）有限公司 | Database information analysis method, database information analysis device, computer device and storage medium |
| CN113360152A (en) * | 2021-06-11 | 2021-09-07 | 软子数字软件(广州)有限公司 | Method and system for realizing display program of parameterized data query webpage |
| CN113360152B (en) * | 2021-06-11 | 2023-11-03 | 软子数字软件(广州)有限公司 | Method and system for realizing parameterized data query webpage display program |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104699748B (en) | 2018-06-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104699748A (en) | Method and system for showing report form with non-fixed column numbers | |
| US8065323B2 (en) | Offline validation of data in a database system for foreign key constraints | |
| CN102341781B (en) | Software test bed generation | |
| CN106951430B (en) | Account table query method and device | |
| US20150026117A1 (en) | Method and system for reconciling meta-data in a data warehouse | |
| US10452517B2 (en) | Framework for testing logic of code based on model elements | |
| US20150324192A1 (en) | System and method for creating, managing, and reusing schema type definitions in services oriented architecture services, grouped in the form of libraries | |
| US9361398B1 (en) | Maintaining a relational database and its schema in response to a stream of XML messages based on one or more arbitrary and evolving XML schemas | |
| CN106528129A (en) | Web application interface generation system and method | |
| CN106293664A (en) | Code generating method and device | |
| US20060253483A1 (en) | Method and mechanism of materialized view mix incremental refresh | |
| US20140244680A1 (en) | Sql query parsing and translation | |
| US20090198727A1 (en) | Trace-based database schema evolution method and system | |
| US11487742B2 (en) | Consistency checks between database systems | |
| WO2007136959A2 (en) | Apparatus and method for recursively rationalizing data source queries | |
| CN103927385A (en) | Unifying method and device of data model | |
| CN114329297A (en) | Content management system, static page management method, device and storage medium | |
| US20130346426A1 (en) | Tracking an ancestry of metadata | |
| CN103176778A (en) | Method and device for webpage development | |
| CN109284469B (en) | Webpage development framework | |
| CN108769103A (en) | A kind of control method and system for checking result displaying based on communication service data | |
| CN115858810A (en) | Method, system, computer device and storage medium for automatically constructing knowledge graph | |
| CN112650526B (en) | Method, device, electronic equipment and medium for detecting version consistency | |
| CN115878589A (en) | Version management method and device of structured data and related equipment | |
| CN111159207B (en) | Information processing method and device |
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 |