CN1189835C - Method for realizing intelligent report forms - Google Patents
Method for realizing intelligent report forms Download PDFInfo
- Publication number
- CN1189835C CN1189835C CNB021029822A CN02102982A CN1189835C CN 1189835 C CN1189835 C CN 1189835C CN B021029822 A CNB021029822 A CN B021029822A CN 02102982 A CN02102982 A CN 02102982A CN 1189835 C CN1189835 C CN 1189835C
- Authority
- CN
- China
- Prior art keywords
- database
- report
- user
- data
- report form
- 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.)
- Expired - Lifetime
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000013461 design Methods 0.000 claims abstract description 5
- 238000004891 communication Methods 0.000 claims description 7
- 230000008569 process Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 6
- 230000008901 benefit Effects 0.000 abstract description 3
- 230000005540 biological transmission Effects 0.000 abstract description 2
- 238000013480 data collection Methods 0.000 abstract 1
- 238000012986 modification Methods 0.000 abstract 1
- 230000004048 modification Effects 0.000 abstract 1
- 238000005516 engineering process Methods 0.000 description 9
- 238000011161 development Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 2
- 230000006855 networking Effects 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012856 packing Methods 0.000 description 1
- 239000011347 resin Substances 0.000 description 1
- 229920005989 resin Polymers 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a method for realizing an intelligent report form, which comprises the following steps: 1) after a user report form request is received by a report form client, conditions initialized for inquiring a database for the report form by a user is interactively received to generate a request for accessing a service database, and the request is sent to a report form server; 2) the report form server reads information of the service database from a system database, the service database is accessed according to the information, and data satisfying the initialized conditions is inquired and is fed back to the report form client; 3) the report form client automatically generates the report form according to the data and a format in a report form template, and the report form is displayed for the user. The present invention has the advantages that any service systems which open the service database for the report server or a database agent thereof can be normally used by the user without any modification, and the present invention has versatility for the connection of databases; data collection, transmission, processing and report form generation and issuing operation can be completed by a report form system, and cross-platform report form design can be realized.
Description
Technical field:
The present invention relates to a kind of implementation method of form.
Background technology:
In the former intelligent artifact, when relating to relevant professional of form, each manufacturer uses different technology to realize, and is both uneconomical, cannot use for reference again each other.Another main odjective cause is that the development technique that each manufacturer uses there are differences, and the Service Support Data storehouse also is different simultaneously.Therefore be difficult to form a general product, each reporting system has relative selectivity to the connection of database.
Summary of the invention:
Purpose of the present invention is exactly in order to overcome the above problems, and a kind of implementation method of form is provided, and makes general product of exploitation become possibility.
For achieving the above object, the present invention proposes a kind of implementation method of form, it is characterized in that comprising the steps: 1) after report client end receives the request of user's form, interactively receives the condition that the user is the Query Database of this form setting, and the Intra-request Concurrency that generates an access service database is toward report server; 2) report server reads the information of Service Database and the information of database broker from system database, according to these information request is distributed on the corresponding database broker, by this database broker access service database, inquire and satisfy the data that impose a condition, and data are returned report server, by report server data are returned report client end; 3) report client end is according to the form automatic report generation in these data and the report form template and be shown to the user.
Owing to adopted above scheme, for any report server or its database broker have been opened the operation system of Service Database, do not change and just can normally be used by the user, In the view of the user, the connection of database is had versatility.Data acquisition, transmission, processing and report generation, issue operation are finished by reporting system, can realize cross-platform Report Form Design.
Description of drawings:
Fig. 1 is an architectural schematic of the present invention.
Fig. 2 is concrete networking synoptic diagram of using of the present invention.
Embodiment:
Also the present invention is described in further detail in conjunction with the accompanying drawings below by specific embodiment.
Maturation (correlation technique please refer to Sun Microsystems website http://java.sun.com) along with the Java development technique, utilize (the Universal Database access interface that U.S. SUN company provides of JDBC technology among the Java, based on the JAVA technological development, can cross the access visit of disparate databases under the simple realization different platform by it), feasible difference of crossing over the Service Support Data storehouse of different manufacturers becomes possibility; Web server and ActiveX component technology (the establishment programmatics that U.S. Microsoft company advocates by Java, realize sharing of software object at an easy rate by this technology), can realize B/S (the browser/Server structure of convenience, safety, it is the browser/server architecture, be characterized in making up by client's terminal and web browser, client has and need not to install, and is easy to use, the advantage that is easy to expand) browse and the operational administrative mode.
The development of these technology makes realization of the present invention become possibility.Fig. 1 is exactly the schematic diagram that utilizes the reporting system that the present invention develops.This system is divided into three parts: report client end, report server (can be described as WebServer), database broker (can be described as ProxyServer).The Service Database of this three parts co-ordination access service open system.System database is used for preserving information such as Service Database tabulation that reporting system can visit, user list, template base among Fig. 1, is the repository of reporting system, and itself does not preserve business datum.
The flow process that realizes form is: the user downloads and operation report client end program from report server by network, signs in on the report server by HTML (Hypertext Markup Language) (http agreement) then.The user sends the request of access service database, receives the request back and read Service Database information and date storehouse proxy information from system database, according to these information request is distributed on the database broker.Database broker access service database also returns the result to report server, returns report client end after the report server packing, and client generates form and is shown to the user according to data.
Adopt the communication of http agreement by report server between report client end and the report server; Adopt the communication of socket (Socket) mode between report server and the database broker; Adopt the communication of Socket mode between database broker and Service Database.
Client can adopt the visual development too development under the Windows, operates under the windows platform; Database broker and database broker adopt the JAVA exploitation, and requirement can be debugged under various operating systems and be passed through; The platform of limit service Database Systems operations not.Among Fig. 1, Windows+IE, UNIX/NT are meant the employed operation system example of this part.
Report server allows one in the individual system, and report client end allows a plurality of.Report server is set up licence (License) mechanism, and the client terminal quantity that can be connected to report server simultaneously can not surpass the License quantity of authorizing.Database broker allows a plurality of, and each database broker allows a plurality of Service Databases of visit." N: 1 " among Fig. 1, " 1: N ", " M: N " express this implication, and wherein M, N are natural number.
Also can on one or more report server, can be many parts of reporting systems of same initiation of services simultaneously, to reach the purpose that improves processing power, makes things convenient for rights management.Using fewerly at present, more is single report server.
In the system, client mainly comprises following a few part
A〉supervisory routine, user, data source, database broker, form and report form template that can management system, comprise client login, data source customization etc., wherein the data source customization comprises data source property, table and the storing process of define system, and wherein data source property comprises database-name, port, database user name and database user name password etc.
B〉the report form template designer, design report file for the user.
C〉report query conditions is provided with the interface, and the user is provided with the querying condition of a form; The user is the condition that required form is set Query Database by this interface
D〉the form browser, be used for browsing the form that native system generates, can in same program, realize with last branch.
Report server comprises following a few part:
A〉support programs, as Resin, WebSphere etc., this part need not exploitation.
B〉system management software, be used to handle the order that client-side management program and Report Designer mail to report server: as user's login, revise data source, download report file etc.
C〉data query software, receive report query conditions the data query request that the interface biography is come is set, fetch the result with the database broker communication, and the result is mail to client.This part and last branch are finished in same program.
Database broker only realizes that the access service database fetches result's simple function.
A typical case uses the networking example as shown in Figure 2.Wherein DDN is meant Digital Data Net.
The said system relative merits compared with prior art of utilizing the present invention to develop are as shown in the table:
Prior art | The technology that we implement | The advantage of institute's technical application |
Report client end will be according to the kinds of characters collection of Service Database, and the manual configuration database connects string. | Select different database character collection according to the user, the automatically generated data storehouse connects string, does not need the user to dispose. | Avoid user's configuration database to connect string. |
Normally disposable data of fetching from data base querying. | Extraction in batches to database is provided. | When having reduced big data quantity to the impact of system.Under the certain situation of system configuration, can effectively improve the data access amount. |
The general mode that adopts report server directly to separate accessing database. | By the database broker accessing database | Make the processing power (amount) of total system bigger; Concurrency is better; Be convenient to realize cross-platform. |
The form masterplate is generally data definition, seldom relates to statement form. | Template contains abundant format information. | Can satisfy user's demand from various form and rich data two aspects. |
Illustrate: present most reporting system does not use the report server technology, promptly only adopts double-layer structure: " (client-report server)-database ".We have been applied to the database broker technology in the reporting system first, constituted three-decker: " (client-report server-database broker server)-database " like this, makes the processing power (amount) of total system bigger, concurrency is better, is convenient to realize cross-platform.
The present invention can be applicable to miscellaneous services such as relevant with report form processing wired, wireless, fusion.Form wherein can be the form of any situation of reporting, utilize the present invention can develop GRS, support powerful User Defined report capability, can support financial statement, sales achievement form, promptly one " any form " system at all interior forms." any Service Database that database broker is opened can be suitable for ".Any one business, as long as to reporting system open database access rights, the data dictionary (comprising which this database has show which storing process etc.) that can define these Database Systems in the data source definitions of client just can design corresponding report form template for him.Do not relate to any specific transactions in the whole process, need not operation system yet and do any secondary development.
The present invention has obtained satisfied effect by the checking of pilot net.
Claims (7)
1, a kind of implementation method of form, it is characterized in that comprising the steps: 1) after report client end receives the request of user's form, interactively receives the condition that the user is the Query Database of this form setting, and the Intra-request Concurrency that generates an access service database is toward report server; 2) report server reads the information of Service Database and the information of database broker from system database, according to these information request is distributed on the corresponding database broker, by this database broker access service database, inquire and satisfy the data that impose a condition, and data are returned report server, by report server data are returned report client end; 3) report client end is according to the form automatic report generation in these data and the report form template and be shown to the user.
2, the implementation method of form as claimed in claim 1 is characterized in that: described report form template is that the selection according to the user designs generation automatically by system; The condition in the query traffic data storehouse that the user can set comprises data source property, table and storing process, and wherein data source property comprises database-name, port, database user name and database user name password.
3, the implementation method of form as claimed in claim 1 or 2 is characterized in that: adopt the HTML (Hypertext Markup Language) communication between report client end and the report server; Adopt the communication of socket mode between report server and the database broker; Adopt the communication of socket mode between database broker and Service Database.
4, the implementation method of form as claimed in claim 1 or 2, it is characterized in that: report server or its database broker have obtained the opening of Service Database in advance, be that Service Database is to reporting system open database access rights, permission defines the data dictionary of these Database Systems in the data source definitions of client, comprise this database has which table, which storing process.
5, the implementation method of form as claimed in claim 2 is characterized in that: report server is according to user-defined data source property, and the JDBC that applies mechanically standard connects string format automatically generated data storehouse and connects string.
6, the implementation method of form as claimed in claim 1 or 2 is characterized in that: after report server inquires and satisfies the data that impose a condition, according to its various database character collection of adding up in advance, the character in the data is converted into standard character handles.
7, the implementation method of form as claimed in claim 1 or 2 is characterized in that: preserve Service Database tabulation, user list and the template base that can visit in the reporting system in system database in advance.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB021029822A CN1189835C (en) | 2002-02-10 | 2002-02-10 | Method for realizing intelligent report forms |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB021029822A CN1189835C (en) | 2002-02-10 | 2002-02-10 | Method for realizing intelligent report forms |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1438591A CN1438591A (en) | 2003-08-27 |
CN1189835C true CN1189835C (en) | 2005-02-16 |
Family
ID=27672076
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB021029822A Expired - Lifetime CN1189835C (en) | 2002-02-10 | 2002-02-10 | Method for realizing intelligent report forms |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN1189835C (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100395752C (en) * | 2005-11-08 | 2008-06-18 | 华为技术有限公司 | Report data collection system and method |
CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特(北京)视频技术有限公司 | Report generating method |
Families Citing this family (28)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100403294C (en) * | 2003-09-04 | 2008-07-16 | 华为技术有限公司 | Method for real-time correcting data report of client terminal |
CN100377157C (en) * | 2003-10-25 | 2008-03-26 | 鸿富锦精密工业(深圳)有限公司 | Computer aided design report generating system and method |
CN100412858C (en) * | 2003-11-08 | 2008-08-20 | 鸿富锦精密工业(深圳)有限公司 | Report generating system and method |
CN101281462B (en) * | 2007-04-05 | 2011-09-21 | 中茂电子(深圳)有限公司 | Report forms generating system and method |
CN101183371B (en) * | 2007-12-12 | 2010-06-09 | 中兴通讯股份有限公司 | Method for quickly finishing large data-handling and reporting system |
CN101541021B (en) * | 2008-03-18 | 2010-07-21 | 中国移动通信集团天津有限公司 | Method for automatically generating capacity-warning reports |
CN101308490B (en) * | 2008-04-28 | 2010-06-09 | 北京航空航天大学 | Dynamic report generation method and platform |
DE102009021062A1 (en) * | 2009-05-13 | 2010-11-18 | Abb Technology Ag | Alarm Management System |
CN101650710B (en) * | 2009-08-03 | 2011-12-28 | 金蝶软件(中国)有限公司 | Online software service system as well as method and device for generating report |
CN102096753B (en) * | 2009-12-09 | 2015-04-29 | 新奥特(北京)视频技术有限公司 | Server and client for contest report generation |
CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
US20110295761A1 (en) * | 2010-05-31 | 2011-12-01 | Kabushiki Kaisha Toshiba | Business form management system, method and program |
CN101894149B (en) * | 2010-06-23 | 2012-05-23 | 畅捷通信息技术股份有限公司 | Method and device for tracking and inquiring document |
CN102467494A (en) * | 2010-11-19 | 2012-05-23 | 金蝶软件(中国)有限公司 | Discrete report processing method and device |
CN102129478B (en) * | 2011-04-26 | 2012-10-03 | 广州从兴电子开发有限公司 | Database synchronization method and system thereof |
CN103034905A (en) * | 2011-09-30 | 2013-04-10 | 哈尔滨奇安科技发展有限公司 | Method for analyzing report intelligently |
CN102663024A (en) * | 2012-03-22 | 2012-09-12 | 北京英孚斯迈特信息技术有限公司 | Data portal system for enterprise data unified platform |
CN102739654B (en) * | 2012-06-08 | 2015-03-18 | 北京久其软件股份有限公司 | Method for realizing application program to access database |
CN103020158B (en) * | 2012-11-26 | 2016-09-07 | 中兴通讯股份有限公司 | A kind of report form creation, device and system |
CN103049509B (en) * | 2012-12-16 | 2016-04-27 | 四川久远新方向智能科技有限公司 | Rail traffic ticket automatic selling and checking system station control center bordereaux generation method |
CN104951903A (en) * | 2015-07-08 | 2015-09-30 | 安徽兆尹信息科技有限责任公司 | Custom asset evaluation method based on financial asset management system architecture |
CN105677745B (en) * | 2015-12-28 | 2019-05-21 | 国云科技股份有限公司 | A kind of self-service data query system of Universal efficient and implementation method |
CN105719216B (en) * | 2016-01-04 | 2017-05-31 | 重庆市规划信息服务中心 | E-government Platform information data processing method |
CN107861929A (en) * | 2017-09-30 | 2018-03-30 | 深圳市买买提乐购金融服务有限公司 | Document structure tree method, terminal and computer-readable medium |
CN108984619A (en) * | 2018-06-13 | 2018-12-11 | 东莞市盟大塑化科技有限公司 | A method of the self-defined report based on big data |
CN109918067B (en) * | 2019-01-23 | 2024-05-03 | 中国平安人寿保险股份有限公司 | Report customization method, device, client and storage medium |
CN111898357A (en) * | 2020-07-23 | 2020-11-06 | 海南中金德航科技股份有限公司 | Intelligent report system |
CN112699647A (en) * | 2020-12-31 | 2021-04-23 | 杭州立思辰安科科技有限公司 | Implementation method for supporting custom report |
-
2002
- 2002-02-10 CN CNB021029822A patent/CN1189835C/en not_active Expired - Lifetime
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN100395752C (en) * | 2005-11-08 | 2008-06-18 | 华为技术有限公司 | Report data collection system and method |
CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特(北京)视频技术有限公司 | Report generating method |
CN102096664B (en) * | 2009-12-09 | 2015-06-17 | 新奥特(北京)视频技术有限公司 | Report generating method |
Also Published As
Publication number | Publication date |
---|---|
CN1438591A (en) | 2003-08-27 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN1189835C (en) | Method for realizing intelligent report forms | |
US9454609B2 (en) | Data source-independent search system architecture | |
US8010899B2 (en) | System offering a data-skin based on standard schema and the method | |
US7013306B1 (en) | XML input definition table for transforming XML data to internal format | |
US7653750B2 (en) | Using a directory service for a user registry | |
US20040199636A1 (en) | Automatic generation of database invocation mechanism for external web services | |
US7194683B2 (en) | Representing and managing dynamic data content for web documents | |
US6456308B1 (en) | Embedded web server | |
US7260577B1 (en) | Method and system for providing business intelligence web content with reduced client-side processing | |
US6882996B2 (en) | System, method, and computer program product for reformatting non-XML data for use with internet based systems | |
DE60108158T2 (en) | ONLINE DEVELOPMENT OF APPLICATIONS | |
US20040024812A1 (en) | Content publication system for supporting real-time integration and processing of multimedia content including dynamic data, and method thereof | |
US7480920B2 (en) | Systems and methods for providing an enterprise services description language | |
US20020147745A1 (en) | Method and apparatus for document markup language driven server | |
US20010009016A1 (en) | Computer-based presentation manager and method for individual user-device data representation | |
US20010034771A1 (en) | Network portal system and methods | |
WO2007079424A2 (en) | Method for combining input data with run-time parameters into xml output using xsl/xslt | |
JP2002539547A (en) | How to provide clients with a service to retrieve data from data sources that do not necessarily support the format required by the client | |
CN1604031A (en) | Methods, systems and computer program products for creating user interface to applications using generic user interface templates | |
US7158967B1 (en) | XML output definition table for transferring internal data into XML document | |
CN1808428A (en) | Information searching criteria presentation and editing system and method | |
AU782134B2 (en) | Apparatus, systems and methods for electronic data development, management, control and integration in a global communications network environment | |
US6735594B1 (en) | Transparent parameter marker support for a relational database over a network | |
US7310631B2 (en) | Method and system for facilitating access to external data | |
Herzog et al. | InfoPipes: A flexible framework for M-Commerce applications |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant | ||
CX01 | Expiry of patent term | ||
CX01 | Expiry of patent term |
Granted publication date: 20050216 |
|
DD01 | Delivery of document by public notice | ||
DD01 | Delivery of document by public notice |
Addressee: Yue Ya Document name: Notice of expiration and termination of patent right |