CN101866350A - Report generation method and device as well as WEB server - Google Patents

Report generation method and device as well as WEB server Download PDF

Info

Publication number
CN101866350A
CN101866350A CN201010174773A CN201010174773A CN101866350A CN 101866350 A CN101866350 A CN 101866350A CN 201010174773 A CN201010174773 A CN 201010174773A CN 201010174773 A CN201010174773 A CN 201010174773A CN 101866350 A CN101866350 A CN 101866350A
Authority
CN
China
Prior art keywords
data
report
report generation
sql statement
module
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201010174773A
Other languages
Chinese (zh)
Inventor
冯伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE Corp
Original Assignee
ZTE Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ZTE Corp filed Critical ZTE Corp
Priority to CN201010174773A priority Critical patent/CN101866350A/en
Priority to PCT/CN2010/076720 priority patent/WO2011140770A1/en
Publication of CN101866350A publication Critical patent/CN101866350A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Computational Linguistics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses report generation method and device as well as a WEB server. The method comprises the steps of: receiving a query conditional value, replacing a placeholder of a structural query language (SQL) sentence of a database with the query conditional value; acquiring report data to be queried according to the SQL sentence; storing the acquired data into a temporary table of the database when the report data includes a graph or a matrix; and formatting the stored data and calculating an aggregate item to generate a corresponding report. In the report generation method and device as well as the WEB server which are provided by the invention, the placeholder in the SQL sentence is utilized for access once, and the data of the complicated report is stored into the temporary table of the database, thereby accelerating the access speed and data processing speed and realizing rapid report generation.

Description

Report form generation method, device and WEB server
Technical field
The present invention relates to data processing field, specially refer to a kind of report form generation method, device and WEB server.
Background technology
With reference to Fig. 1, existing reporting system comprises report generation device 2 and Report Form Design device 3, the configuration data that Report Form Design device 3 is used to generate form is the form of form, form configuration data and form business datum are stored in the database 5, report generation device 2 generally operates on the WEB server, when peripheral objects 6 as Enterprise Resources Planning software (Enterprise Resource Planning, ERP) during client call report generation device 2, report generation device 2 calls form configuration data and corresponding form business datum by database connection pool 4 from database 5, and return to peripheral objects 6 after data are handled, finish the generation of form.
The access method of report generation device 2 has multiple, usually use Structured Query Language (SQL) (the Structured Query Language of database, SQL) according to querying condition gradation peek and be stored in the result set of WEB server memory at report generation device 2 places, return peripheral objects 6 to after data are handled in the result set again, this report form generation method needs to send back the WEB server again after repeatedly peek and the each peek, access speed is slow, efficient is low, special in report data amount greatly and during the far call data, travelling speed to reporting system exerts an influence, and reduces report generation speed.
Summary of the invention
One of purpose of the present invention improves access speed for a kind of report form generation method, device and WEB server are provided, and realizes the quick generation of form.
The present invention proposes a kind of method of report generation, comprises step:
After receiving query condition value, with the placeholder of the Structured Query Language (SQL) SQL statement in described query condition value alternate data storehouse;
Obtain the report data of required inquiry according to described SQL statement;
When described report data comprises figure or matrix, with the data storage obtained temporary table to database;
To the storage after data formatting and calculate total entry, generate corresponding form.
Preferably, described report data comprises required form configuration data and the form business datum of generation form.
Preferably, after the described report data that obtains required inquiry according to SQL statement, also comprise step:
When described report data does not comprise figure or matrix, with the data storage obtained to result set.
Preferably, the corresponding form of described generation is specially:
The form business datum and the described form configuration data that will comprise described total entry write collection class, and object returns the collection class data to the periphery.
The present invention also proposes a kind of report generation device, comprising:
Parsing module is used for after receiving query condition value, with the placeholder of the SQL statement in described query condition value alternate data storehouse;
The peek module is used for obtaining according to described SQL statement the report data of required inquiry;
The temporary table access module is used for when described report data comprises figure or matrix, with the data storage the obtained temporary table to database;
The report generation module, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
Preferably, described data comprise required form configuration data and the form business datum of generation form.
Preferably, also comprise the result set access module, be used for when described report data does not comprise figure or matrix, with the data storage obtained to result set.
Preferably, described report generation module comprises:
The data statistics submodule is used for the data formatting of described temporary table or result set and calculates total entry;
The data-interface submodule, the form business datum and the described form configuration data that are used for comprising described total entry write collection class, and object returns the collection class data to the periphery.
The present invention also proposes a kind of WEB server, comprises the report generation device, and described report generation device comprises:
Parsing module is used for after receiving query condition value, with the placeholder of the SQL statement in described query condition value alternate data storehouse;
The peek module is used for obtaining according to described SQL statement the report data of required inquiry;
The temporary table access module is when described report data comprises figure or matrix, with the data storage the obtained temporary table to database;
The report generation module, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
Preferably, described report generation device also comprises the result set access module, be used for when described report data does not comprise figure or matrix, with the data storage obtained to result set.
Report form generation method, device and WEB server that the present invention proposes, use the placeholder in the SQL statement once to peek, and with the data storage of complex report forms in the temporary table of database, quickened access speed and data processing speed, realize report generation fast.
Description of drawings
Fig. 1 is the configuration diagram of existing reporting system application system;
Fig. 2 is the schematic flow sheet of embodiment of the invention report form generation method;
Fig. 3 is the structural representation of embodiment of the invention report generation device;
Fig. 4 is the structural representation of the report generation module of embodiment of the invention report generation device;
Fig. 5 is the structural representation of embodiment of the invention WEB server.
The realization of the object of the invention, functional characteristics and advantage will be in conjunction with the embodiments, are described further with reference to accompanying drawing.
Embodiment
Report form generation method provided by the invention, device and WEB server use the placeholder in the SQL statement, when peek, substitute placeholder and realize the disposable report data that obtains with the query condition value that receives, and with the data storage of complex report forms in the temporary table of database, the data storage of simple form in the result set of WEB server memory, is showed returning to peripheral objects after data are handled in temporary table or the result set.
With reference to Fig. 2, an embodiment of report form generation method of the present invention is proposed, it comprises:
Step 101 is after receiving query condition value, with the placeholder of the SQL statement in query condition value alternate data storehouse;
The querying condition of reporting system can dynamically arrange, corresponding different querying conditions, and the statement form of Report Form Design device configuration is various; Therefore in the form configuration database, disposed the querying condition record of form, querying condition record is a corresponding inquiry initial conditions of form, a form combines many querying condition records; The form configuration database is in the database of reporting system operation place, the WEB server reads the report query conditions record in the form configuration database, the corresponding querying condition of report query conditions record is returned to peripheral objects show, but so that user's input inquiry conditional value is to generate corresponding form.
The WEB server is peeked to database by calling the database script SQL statement, SQL statement can be shape as:
Select operid, opername from system where operid=[PARAMVALUE_operid] wherein, " PARAMVALUE_operid " is placeholder, behind the user input query conditional value, the WEB server substitutes this placeholder with query condition value and peeks, placeholder can be a plurality of, substitutes a plurality of query condition value.
Step 102 is obtained the report data of required inquiry according to SQL statement;
The WEB server carries out disposable peek with after placeholder is replaced into query condition value in the SQL statement to database, and the data of transferring are form configuration data and form business datums of corresponding query condition value.
Step 103, when report data comprises figure or matrix, with the data storage obtained temporary table to database, otherwise execution in step 104;
Step 104, when report data does not comprise figure or matrix, with the data storage obtained to result set;
For fairly simple form such as common table, label list, article one, SQL statement just can be finished peek, and the form of some more complicated such as figure table, matrix table, peek process complexity, article one, SQL statement can't be finished peek, need many SQL statement to obtain data, complicated process according to form, reporting system is provided with the obtained data of dual mode storage SQL statement when exploitation, a kind of is to store result set into, and result set is positioned at the WEB server memory, at common table, simple form such as label list, a kind of is to store temporary table into, and temporary table is positioned at reporting system operation place database, at the figure table, matrix tables etc. are complex report form relatively.
The data that write down in the temporary table comprise: form columns, line number, fixed line number, cell initial row, the initial row of cell, cell data etc., for generating an inquiry form as shown in table 1, required form configuration data and form business datum leave in the temporary table as shown in table 2.For complex report forms, data volume is big, uses the temporary table of reporting system operation place database can improve access speed, returns the WEB server again after waiting to peek and does data processing.
Figure GSA00000121186300051
Table 1
Form ID Initial row End line Initial row End column Content
??1 ??1 ??1 ??1 ??1 ??Value1
??1 ??1 ??1 ??2 ??2 ??Value2
Form ID Initial row End line Initial row End column Content
??1 ??2 ??2 ??1 ??1 ??Value3
??1 ??2 ??2 ??2 ??2 ??Value4
??1 ??3 ??3 ??1 ??2 ??Value5
Table 2
Step 105, to the storage after data formatting and calculate total entry, generate corresponding form.
The data storage of carrying out database script SQL statement gained is behind temporary table or result set, the WEB server need be handled obtained data, this is because the data that obtain comprise form configuration data and form business datum, be not that all form business datums all need occur in the form that generates, some form business datum is only used for calculating the intermediate data of total entry, and the form business datum that need occur in the form that generates also needs format according to the definition of form configuration data, and for example may to have defined the data of a certain row be time categorical data form or monetary data form to the form configuration data.The WEB server is called in the data in temporary table or the result set after interim internal memory formats and calculate total entry, form configuration data and corresponding form business datum are write in the collection class, object returns this collection class data to the periphery after form is explained the interface explanation, show the form that is generated by peripheral objects, empty temporary table or result set simultaneously so that follow-up use.
Report form generation method provided by the invention, use the placeholder in the database SQL statement of reporting system operation place once to peek, and with the data storage of complex report forms in the temporary table of database, quickened access speed and data processing speed, realize report generation fast.
With reference to Fig. 3, an embodiment of report generation device of the present invention is proposed, comprising:
Parsing module 10 is used for after receiving query condition value, with the placeholder of the SQL statement in query condition value alternate data storehouse;
Peek module 20 is used for obtaining according to SQL statement the report data of required inquiry;
Temporary table access module 30 is used for when report data comprises figure or matrix, with the data storage the obtained temporary table to database;
Report generation module 50, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
Above-mentioned report generation device also comprises result set access module 40, be used for when report data does not comprise figure or matrix, with the data storage obtained to result set.
With reference to Fig. 4, report generation module 50 comprises:
Data statistics submodule 52 is to the data formatting of temporary table or result set and calculate total entry;
Data-interface submodule 53 will comprise that the form business datum of described total entry and described form configuration data write collection class, and object returns the collection class data to the periphery.
Reporting system comprises Report Form Design device and report generation device, the application program that peripheral objects is promptly called the report generation device can generate corresponding report according to different query condition value, the report generation device can be by various programming languages such as C++, JAVA language compilation, and call the database script access data at reporting system operation place, describe the principle of work of report generation device of the present invention below in detail:
The querying condition of reporting system can dynamically arrange, corresponding different querying conditions, the statement form of Report Form Design device configuration is various, therefore in the form configuration database, disposed the querying condition record of form, article one, querying condition record is a corresponding inquiry initial conditions of form, a form combines many querying condition records, the form configuration database is in the database of reporting system operation place, the WEB server reads the report query conditions record in the form configuration database, the corresponding querying condition of report query conditions record is returned to peripheral objects show, so that the user input query conditional value is to generate corresponding form.
Parsing module 10 is peeked to database by calling the database script SQL statement, SQL statement can be shape as:
Select operid, opername from system where operid=[PARAMVALUE_operid] wherein, " PARAMVALUE_operid " is placeholder, behind the user input query conditional value, parsing module 10 substitutes this placeholder with query condition value and peeks, placeholder can be a plurality of, substitutes a plurality of query condition value.
Parsing module 10 is with after placeholder is replaced into query condition value in the SQL statement, and 20 pairs of databases of peek module carry out disposable peek, and the data of transferring are form configuration data and form business datums of corresponding query condition value.
For fairly simple form such as common table, label list, article one, SQL statement just can be finished peek, and the form of some more complicated such as figure table, matrix table, peek process complexity, article one, SQL statement can't be finished peek, need many SQL statement to obtain data, complicated process according to form, the report generation device is provided with two obtained data of module access SQL statement when exploitation, one is result set access module 40, at common table, simple form such as label list, the report data that result set access module 40 obtains SQL statement deposits the result set that is positioned at the WEB server memory in; One is temporary table access module 40, compares complex report form at figure table, matrix table etc., and the report data storage that temporary table access module 30 obtains SQL statement is positioned at the temporary table of reporting system operation place database.
The data that write down in the temporary table comprise: form columns, line number, fixed line number, cell initial row, the initial row of cell, cell data etc., for generating an inquiry form as shown in table 3, required form configuration data and form business datum leave in the temporary table as shown in table 4.For complex report forms, data volume is big, uses the temporary table of reporting system operation place database can improve access speed, returns the WEB server again after waiting to peek and does data processing.
Figure GSA00000121186300071
Table 3
Form ID Initial row End line Initial row End column Content
??1 ??1 ??1 ??1 ??1 ??Value1
??1 ??1 ??1 ??2 ??2 ??Value2
??1 ??2 ??2 ??1 ??1 ??Value3
??1 ??2 ??2 ??2 ??2 ??Value4
Form ID Initial row End line Initial row End column Content
??1 ??3 ??3 ??1 ??2 ??Value5
Table 4
The data storage of peek module 20 gained is behind temporary table or result set, 50 pairs of obtained data of report generation module are handled, this is because the data that obtain comprise form configuration data and form business datum, be not that all form business datums all need to appear in the form of generation, some form business datum is only used for calculating the intermediate data of total entry, also need format according to the definition of form configuration data and need appear at the form business datum that generates in the form, for example may to have defined the data of a certain row be time categorical data form or monetary data form to the form configuration data.Data statistics submodule 52 data in temporary table or the result set are called in that interim internal memory formats and the counting statistics item after, data-interface submodule 53 writes form configuration data and corresponding form business datum in the collection class, object returns this collection class data to the periphery, show the form that is generated by peripheral objects, empty temporary table or result set simultaneously so that follow-up use.
Report generation device provided by the invention, use the placeholder in the database SQL statement of reporting system operation place once to peek, and with the data storage of complex report forms in the temporary table of database, quickened access speed and data processing speed, realize report generation fast.
With reference to Fig. 5, WEB server of the present invention is proposed, comprise the report generation device, the report generation device comprises:
Parsing module 11 is used for after receiving query condition value, with the placeholder of the SQL statement in query condition value alternate data storehouse;
Peek module 21 is used for obtaining according to SQL statement the report data of required inquiry;
Temporary table access module 31 is used for when report data comprises figure or matrix, with the data storage the obtained temporary table to database;
Report generation module 51, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
The report generation device also comprises result set access module 41, be used for when report data does not comprise figure or matrix, with the data storage obtained to result set.
The report generation apparatus structure of present embodiment and function repeat no more with report generation device embodiment illustrated in fig. 3.
WEB server provided by the invention, use the placeholder in the database SQL statement of reporting system operation place once to peek, and with the data storage of complex report forms in the temporary table of database, quickened access speed and data processing speed, realize report generation fast.
The above only is the preferred embodiments of the present invention; be not so limit claim of the present invention; every equivalent structure or equivalent flow process conversion that utilizes instructions of the present invention and accompanying drawing content to be done; or directly or indirectly be used in other relevant technical fields, all in like manner be included in the scope of patent protection of the present invention.

Claims (10)

1. the method for a report generation is characterized in that, comprises step:
After receiving query condition value, with the placeholder of the Structured Query Language (SQL) SQL statement in described query condition value alternate data storehouse;
Obtain the report data of required inquiry according to described SQL statement;
When described report data comprises figure or matrix, with the data storage obtained temporary table to database;
To the storage after data formatting and calculate total entry, generate corresponding form.
2. the method for report generation as claimed in claim 1 is characterized in that, described report data comprises required form configuration data and the form business datum of generation form.
3. the method for report generation as claimed in claim 1 or 2 is characterized in that, after the described report data that obtains required inquiry according to SQL statement, also comprises step:
When described report data does not comprise figure or matrix, with the data storage obtained to result set.
4. the method for report generation as claimed in claim 2 is characterized in that, the corresponding form of described generation is specially:
The form business datum and the described form configuration data that will comprise described total entry write collection class, and object returns the collection class data to the periphery.
5. a report generation device is characterized in that, comprising:
Parsing module is used for after receiving query condition value, with the placeholder of the SQL statement in described query condition value alternate data storehouse;
The peek module is used for obtaining according to described SQL statement the report data of required inquiry;
The temporary table access module is used for when described report data comprises figure or matrix, with the data storage the obtained temporary table to database;
The report generation module, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
6. report generation device as claimed in claim 5 is characterized in that, described data comprise required form configuration data and the form business datum of generation form.
7. as claim 5 or 6 described report generation devices, it is characterized in that, also comprise the result set access module, be used for when described report data does not comprise figure or matrix, with the data storage obtained to result set.
8. as claim 5 or 6 described report generation devices, it is characterized in that described report generation module comprises:
The data statistics submodule is used for the data formatting of described temporary table or result set and calculates total entry;
The data-interface submodule, the form business datum and the described form configuration data that are used for comprising described total entry write collection class, and object returns the collection class data to the periphery.
9. a WEB server is characterized in that, comprises the report generation device, and described report generation device comprises:
Parsing module is used for after receiving query condition value, with the placeholder of the SQL statement in described query condition value alternate data storehouse;
The peek module is used for obtaining according to described SQL statement the report data of required inquiry;
The temporary table access module is used for when described report data comprises figure or matrix, with the data storage the obtained temporary table to database;
The report generation module, be used for to the storage after data formatting and calculate total entry, generate corresponding form.
10. WEB server as claimed in claim 9 is characterized in that, described report generation device also comprises the result set access module, be used for when described report data does not comprise figure or matrix, with the data storage obtained to result set.
CN201010174773A 2010-05-11 2010-05-11 Report generation method and device as well as WEB server Pending CN101866350A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201010174773A CN101866350A (en) 2010-05-11 2010-05-11 Report generation method and device as well as WEB server
PCT/CN2010/076720 WO2011140770A1 (en) 2010-05-11 2010-09-08 Report processing method, apparatus and web server

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201010174773A CN101866350A (en) 2010-05-11 2010-05-11 Report generation method and device as well as WEB server

Publications (1)

Publication Number Publication Date
CN101866350A true CN101866350A (en) 2010-10-20

Family

ID=42958078

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201010174773A Pending CN101866350A (en) 2010-05-11 2010-05-11 Report generation method and device as well as WEB server

Country Status (2)

Country Link
CN (1) CN101866350A (en)
WO (1) WO2011140770A1 (en)

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102567539A (en) * 2011-12-31 2012-07-11 北京新媒传信科技有限公司 Intelligent WEB report implementation method and intelligent WEB report implementation system
CN103034681A (en) * 2012-11-22 2013-04-10 用友软件股份有限公司 Report generation device and report generation method
CN103034658A (en) * 2011-09-29 2013-04-10 福建睿能电子有限公司 Method and system for querying data and exporting report
CN104484400A (en) * 2014-12-12 2015-04-01 北京国双科技有限公司 Method and device for data query processing
CN105095453A (en) * 2015-07-27 2015-11-25 浪潮通用软件有限公司 Method and device for obtaining data
WO2016082468A1 (en) * 2014-11-28 2016-06-02 华为技术有限公司 Data graphing method, device and database server
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN110083814A (en) * 2019-04-09 2019-08-02 大唐微电子技术有限公司 A kind of report form generation method and device, computer readable storage medium
CN112434018A (en) * 2020-10-22 2021-03-02 金蝶云科技有限公司 Report generation method and device, computer equipment and storage medium
CN113486066A (en) * 2021-07-15 2021-10-08 福建博思软件股份有限公司 Method and terminal for hierarchically summarizing report forms
US11300841B2 (en) 2007-05-18 2022-04-12 Semiconductor Energy Laboratory Co., Ltd. Liquid crystal display device
CN114548062A (en) * 2022-04-27 2022-05-27 成都瑞华康源科技有限公司 Report arranging method

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108268536A (en) * 2016-12-30 2018-07-10 北京国双科技有限公司 Database aggregation processing method and device
CN108415894B (en) * 2018-03-15 2021-01-05 平安科技（深圳）有限公司 Report data initialization method and device, computer equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1427363A (en) * 2001-12-19 2003-07-02 深圳市中兴通讯股份有限公司上海第二研究所 General report form generation method
CN1482766A (en) * 2002-09-13 2004-03-17 华为技术有限公司 Method for automatic generating of net management report form
CN1556482A (en) * 2003-12-31 2004-12-22 中兴通讯股份有限公司 Data processing method for realizing data base multitable inguiry
US7430562B1 (en) * 2001-06-19 2008-09-30 Microstrategy, Incorporated System and method for efficient date retrieval and processing

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN100504878C (en) * 2007-05-24 2009-06-24 中兴通讯股份有限公司 SQL statement construction method and apparatus for preprocessing special-character
CN101393518A (en) * 2007-09-19 2009-03-25 北京思软科技有限公司 Method for resolving problem of unable outward variable transfer of executive character string under action domain limitation

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7430562B1 (en) * 2001-06-19 2008-09-30 Microstrategy, Incorporated System and method for efficient date retrieval and processing
CN1427363A (en) * 2001-12-19 2003-07-02 深圳市中兴通讯股份有限公司上海第二研究所 General report form generation method
CN1482766A (en) * 2002-09-13 2004-03-17 华为技术有限公司 Method for automatic generating of net management report form
CN1556482A (en) * 2003-12-31 2004-12-22 中兴通讯股份有限公司 Data processing method for realizing data base multitable inguiry

Cited By (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11300841B2 (en) 2007-05-18 2022-04-12 Semiconductor Energy Laboratory Co., Ltd. Liquid crystal display device
US11940697B2 (en) 2007-05-18 2024-03-26 Semiconductor Energy Laboratory Co., Ltd. Liquid crystal display device
CN103034658A (en) * 2011-09-29 2013-04-10 福建睿能电子有限公司 Method and system for querying data and exporting report
CN102567539B (en) * 2011-12-31 2014-10-22 北京新媒传信科技有限公司 Intelligent WEB report implementation method and intelligent WEB report implementation system
CN102567539A (en) * 2011-12-31 2012-07-11 北京新媒传信科技有限公司 Intelligent WEB report implementation method and intelligent WEB report implementation system
CN103034681A (en) * 2012-11-22 2013-04-10 用友软件股份有限公司 Report generation device and report generation method
WO2016082468A1 (en) * 2014-11-28 2016-06-02 华为技术有限公司 Data graphing method, device and database server
CN104484400A (en) * 2014-12-12 2015-04-01 北京国双科技有限公司 Method and device for data query processing
CN104484400B (en) * 2014-12-12 2018-02-23 北京国双科技有限公司 Data query processing method and processing device
CN105095453A (en) * 2015-07-27 2015-11-25 浪潮通用软件有限公司 Method and device for obtaining data
CN108984506A (en) * 2018-08-01 2018-12-11 北京中电普华信息技术有限公司 A kind of generation method and device of configurable intelligent report forms
CN110083814A (en) * 2019-04-09 2019-08-02 大唐微电子技术有限公司 A kind of report form generation method and device, computer readable storage medium
CN112434018A (en) * 2020-10-22 2021-03-02 金蝶云科技有限公司 Report generation method and device, computer equipment and storage medium
CN112434018B (en) * 2020-10-22 2024-06-04 金蝶云科技有限公司 Report generation method, report generation device, computer equipment and storage medium
CN113486066A (en) * 2021-07-15 2021-10-08 福建博思软件股份有限公司 Method and terminal for hierarchically summarizing report forms
CN113486066B (en) * 2021-07-15 2023-03-24 福建博思软件股份有限公司 Method and terminal for hierarchically summarizing report forms
CN114548062A (en) * 2022-04-27 2022-05-27 成都瑞华康源科技有限公司 Report arranging method
CN114548062B (en) * 2022-04-27 2022-08-02 成都瑞华康源科技有限公司 Report arranging method

Also Published As

Publication number Publication date
WO2011140770A1 (en) 2011-11-17

Similar Documents

Publication Publication Date Title
CN101866350A (en) Report generation method and device as well as WEB server
CN104123374B (en) The method and device of aggregate query in distributed data base
CN104899295B (en) A kind of heterogeneous data source data relation analysis method
US20160140205A1 (en) Queries involving multiple databases and execution engines
CN103020301B (en) A kind of multidimensional data query and storage means and system
US20210256079A1 (en) Adapting database queries for data virtualization over combined database stores
CN104866599A (en) Production method and system of visual report
CN102822819A (en) Managing data queries
US10872086B2 (en) Selectivity estimation for database query planning
CN110968579B (en) Execution plan generation and execution method, database engine and storage medium
US9600559B2 (en) Data processing for database aggregation operation
CN106649869B (en) Statistical method and device for big data of database
CN110688399A (en) Stream type calculation real-time report system and method
CN113268500B (en) Service processing method and device and electronic equipment
CN111078702A (en) SQL sentence classification management and unified query method and device
CN102426612A (en) Condition object query method and system
CN102750384A (en) Device and method for acquiring data from multidatabase engine
US9031930B2 (en) Data browser for group-by data access
CN110597851B (en) Big data based data processing and report display method
CN108345646B (en) Method for rapidly and automatically constructing multi-dimensional report by applying interception technology
CN101980190A (en) Method and device for quickly putting service data into base
CN110825775B (en) Data exchange system supporting interaction of stream data and batch data in Gaia system
CN100395752C (en) Report data collection system and method
US8290930B2 (en) Query result generation based on query category and data source category
CN106547883B (en) Method and system for processing User Defined Function (UDF) running condition

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20101020