Dynamically generated HTML formatted reports

Details Dynamically generated HTML formatted reports Dynamically generated HTML formatted reports

1998-11-13

2003-03-25

Homere, Jean R. (Department: 2177)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

06539370

ABSTRACT:

COPYRIGHT NOTICE
A portion of the disclosure of the patent document contains material which is subject to copyright protection. The owner, International Business Machines Corporation, has no objection to the facsimile reproduction by any one of the patent disclosure, as it appears in the Patent and Trademark Office patent files of records of any country, but otherwise reserves all rights whatsoever.
RELATED APPLICATIONS
This application is related to a copending application entitled Navigation Method for Dynamically Generated HTML Pages, filed on even date herewith, which is incorporated herein by reference, in its entirety.
1. Technical Field
The present invention relates to the field of computer data communications and more specifically to a method and system for providing dynamically generated Hyper Text Markup Language (“HTML”) formatted reports from large amounts of data which is extracted from a Standard Query Language (“SQL”) database. The predominant current usage of the present inventive HTML formatted reports generation method is in the customized generation of reports over the internet, or like data communications channels.
2. Background Art
One of the uses to which the internet is applied is the querying of data bases which are available over the internet. The accessing of data bases over the internet presents some problems that are not present when a user accesses a data base directly at a local computer. Primary among these is that connection time must be limited over the internet in order to maximize the available bandwidth of the server, internet service provider (“ISP”) facilities, network communications means, and the like.
One method that has been used in the prior art to use a common gateway interface (“CGI”) program to query the database and to produce a report which is then returned to the requesting user. This method is, however, slow and requires a great deal of processing time. Moreover, once a report is generated it must either be kept in the server's memory (which will require a very great amount of storage space when many such custom reports are generated) or else the entire process will have to be repeated each time such a report is requested.
It would desirable to have a method for generating and providing data base reports over the internet which is both relatively quick and relatively economical of internet and server resources. However, to the inventors' knowledge, no such method or means has existed in the prior art.
DISCLOSURE OF INVENTION
Accordingly, it is an object of the present invention to provide a method for generating data base reports which will minimize repetitive operations each time such reports are requested. It is still another object of the present invention to provide a method for generating data base reports which will require less server storage space as compared to saving such reports after they are first generated.
It is yet another object of the present invention to provide a method for generating data base reports which is easy to use and reliable in operation.
Briefly, the inventive method separates the data extraction/processing step from the report formatting step by adding an intermediate step to write the culled data into what is called a ‘intermediate files’, which use a meta language to describe the data. Then, on demand, a variety of HTML reports can be dynamically generated by parsing the metadata statements and data from the intermediate files. All subsequent requests to view these reports are dynamically generated from the intermediate files. The metadata statements efficiently describe the data, in that multiple reports may be generated from a set of metadata statements. Using a unique file format, unnecessary reprinting of data in the intermediate files is avoided. Such intermediate files require far less storage space in the server than would be required to store pregenerated reports. However, the provision of the intermediate files will greatly enhance performance when a report is requested, since it will not be necessary to query the entire database to obtain the information necessary to generate the report.
An advantage of the present invention is that the amount of server storage capacity that is required in order to quickly provide data base reports is reduced.
A further advantage of the present invention is that the speed of producing reports is increased as compared to culling the required data from the data base upon each request therefor.
Still another advantage of the present invention is that data base information from essentially any type of data base can be made available to essentially any desired user over the internet.
These and other objects and advantages of the present invention will become clear to those skilled in the art in view of the description of the best presently known mode of carrying out the invention and the industrial applicability of the preferred embodiment as described herein and as illustrated in the several figures of the drawing.


REFERENCES:
patent: 5423033 (1995-06-01), Yuen
patent: 5634121 (1997-05-01), Tracz et al.
patent: 5706434 (1998-01-01), Kremen et al.
patent: 5710900 (1998-01-01), Anand et al.
patent: 5710918 (1998-01-01), Lagarde et al.
patent: 5724595 (1998-03-01), Gentner
patent: 5734831 (1998-03-01), Sanders
patent: 5737592 (1998-04-01), Nguyen et al.
patent: 5745889 (1998-04-01), Burrows
patent: 5745890 (1998-04-01), Burrows
patent: 5745898 (1998-04-01), Burrows
patent: 5745899 (1998-04-01), Burrows
patent: 5745900 (1998-04-01), Burrows
patent: 5748188 (1998-05-01), Hu et al.
patent: 5754772 (1998-05-01), Leaf
patent: 5765158 (1998-06-01), Burrows
patent: 5778178 (1998-07-01), Arunachalam
patent: 5778367 (1998-07-01), Wesinger, Jr. et al.
patent: 5784608 (1998-07-01), Meske, Jr. et al.
patent: 5787416 (1998-07-01), Tabb et al.
patent: 5793966 (1998-08-01), Amstein et al.
patent: 5801702 (1998-09-01), Dolan et al.
patent: 5832452 (1998-11-01), Schneider et al.
patent: 5960196 (1999-09-01), Carrier, III et al.
patent: 5974416 (1999-10-01), Anand et al.
patent: 6055541 (2000-04-01), Solecki et al.
patent: 6078924 (2000-06-01), Ainsbury et al.
patent: 6131098 (2000-10-01), Zellweger
patent: 6205440 (2001-03-01), Nusbickel
patent: 2248370 (1992-01-01), None
Microsoft Press, “Computer Dictionary” Third Edition, pp. 305-306, 1997.*
1997 IEEE Data Storage and Query Processing for Structured Document Databases, 0/97,Kyushu University, Fukuoka, Japan pp. 92-97.
1997 IEEE Data Warehousing within Intranet: Prototype of a Web-based Executive Information System, 0/97, Vienna University of Technology, Vienna, Austria pp. 627-632.
1997 IEEE Towards Creating a Knowledge Base for World-Wide Web Documents, 3/97, Linkoping University, Linkoping, Sweden pp. 507-511.
1998 IEEE Global Integration of Visual Databases, 2/98, State University of New York at Buffalo, NY and Xerox Research Center, Webster, NY pp. 542-549.
1998 IEEE Using Metadata to Query Passive Data Sources, Proc. 31st Annual Hawaii International Conference on System Sciences pp. 286-294.

Affiliated with

Also associated with

Rating

Dynamically generated HTML formatted reports does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Dynamically generated HTML formatted reports, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamically generated HTML formatted reports will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3078793