Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-04-28
2004-08-17
Alam, Shahid (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C715S252000
Reexamination Certificate
active
06778983
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Technical Field
This invention generally relates to computer systems and more specifically relates to an apparatus and method for accessing information stored in a computer system.
2. Background Art
Since the dawn of the computer era, computer systems have evolved into extremely sophisticated devices that may be found in many different settings. Computer systems typically include a combination of hardware (e.g., semiconductors, circuit boards, etc.) and software (e.g., computer programs). As advances in semiconductor processing and computer architecture push the performance of the computer hardware higher, more sophisticated computer software has evolved to take advantage of the higher performance of the hardware, resulting in computer systems today that are much more powerful than just a few years ago.
Many modern computer systems are a complex combination of different hardware and software that are interconnected on a network. One network that has gained in importance and popularity in recent years is the Internet. A user typically accesses information on the Internet using a web browser that receives information in Hypertext Markup Language (HTML). HTML is typically organized into “pages” of information, with various “elements” making up components on each page. When a user-accesses a web page using a browser, a server computer system locates the HTML elements that make up the page and serves up the page to the requesting web browser.
Recent developments have improved the manner for web servers to render web pages. In the past, web pages were rendered by a hybrid mixture of code and HTML elements. However, progress has been made in segregating the code that renders a web page from the HTML elements that make up the web page. For example, Sun Microsystems has developed a Java construct known as a JavaServer Page (JSP). All of the HTML elements on a page are written to a JSP file, which can then be read by code that needs to render the web page. The result is a separation between the code that renders the page and the HTML elements that make up the page, thereby allowing web page designers to design web pages without concern for the code that renders the page, and allowing programmers to render a web page by simply processing a JSP in a predefined manner. In this manner the code that renders a web page is separate from the creative HTML elements that make up the page. Microsoft Corporation has also come up with a similar way to separate code from HTML elements known as ActiveServer Page (ASP). Both JSP and ASP files are examples of “HTML files”.
The Related Application referenced above discloses a way to access HTML elements in an HTML web page using a structured query language (SQL) query. This is useful on the browser, where browsers read HTML pages. However, there is currently no known mechanism or method for using SQL on the server side to access elements in an HTML file, such as a JSP or ASP. Without an apparatus and method for accessing data in an HTML file using SQL, the computer industry will continue to suffer from inefficient ways of accessing HTML files.
DISCLOSURE OF INVENTION
According to the preferred embodiments, an apparatus and method allow accessing data in an HTML file (such as a JSP or ASP file) via an SQL query. A database table is created for each HTML file, and a record is created in each database table that corresponds to each HTML element in the corresponding HTML file. A cross-reference is then created that correlates the HTML file to its corresponding database table. An SQL engine in accordance with the preferred embodiments then processes an SQL query that specifies an HTML file and one or more elements in the HTML file by using the cross-reference information to formulate a new SQL query that accesses the corresponding database table rather than the specified HTML file. When a database table is updated by an SQL query, the corresponding HTML file is re-generated from the data in the database table. In this manner the SQL engine generates a query that accesses a database table from the original query that uses the corresponding HTML file. The preferred embodiments thus disclose apparatus and methods for accessing HTML files using SQL. In this manner, the present invention provides all the power and flexibility of SQL when accessing data in an HTML file.
The foregoing and other features and advantages of the invention will be apparent from the following more particular description of preferred embodiments of the invention, as illustrated in the accompanying drawings.
REFERENCES:
patent: 5623652 (1997-04-01), Vora et al.
patent: 5737739 (1998-04-01), Shirley et al.
patent: 5761656 (1998-06-01), Ben-Shachar
patent: 5778400 (1998-07-01), Tateno
patent: 5826258 (1998-10-01), Gupta et al.
patent: 5864843 (1999-01-01), Carino, Jr. et al.
patent: 5870739 (1999-02-01), Davis, III et al.
patent: 5875441 (1999-02-01), Nakatsuyama
patent: 5913214 (1999-06-01), Madnick et al.
patent: 5940842 (1999-08-01), Sakuta
patent: 6185608 (2001-02-01), Hon et al.
patent: 6247018 (2001-06-01), Rheaume
patent: 6263332 (2001-07-01), Nasr et al.
patent: 6285998 (2001-09-01), Black et al.
patent: 6356889 (2002-03-01), Lohman et al.
patent: 6424980 (2002-07-01), Iizuka et al.
patent: 6529910 (2003-03-01), Fleskes
patent: 6601071 (2003-07-01), Bowker et al.
patent: 6721727 (2004-04-01), Chau et al.
patent: 2002/0116371 (2002-08-01), Dodds et al.
A. Mendelzon et al., “Querying the World Wide Web”, IEEE 1996, 0-8186-7475-X/96, pp. 80-91.*
D. Konopnicki et al., “W3QS—A System for WWW Querying,” IEEE 1997, 1063-6382/97, p. 586.
A. Mendelzon et al., “Querying the World Wide Web,” IEEE 1996, 0-8186-745-X/96, pp. 80-91.
A. Mendelzon et al., “Querying the World Wide Web,” IEEE 1996, 0-8186-7475-x/96, pp. 80-91.
R. Elmasri et al., “Fundamentals of Database Systems,” 1994, Addison-Wesley Publishing Company, pp. 153-154.
“ODBC Error Messages,” SQL Access Group SQL CAE specification (online), 1992 (retrieved Dec. 18, 2002), retrieved from: http://msdn.microsoft.com/library/en-us/trblsql/tr_err_odbc_5stz.asp?frame=true.
Bates Cary Lee
Day Paul Reuben
Santosuosso John Matthew
Alam Shahid
Chen Chongshan
International Business Machines - Corporation
Martin Derek P.
Martin & Associates LLC
LandOfFree
Apparatus and method for accessing HTML files using an SQL... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Apparatus and method for accessing HTML files using an SQL..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for accessing HTML files using an SQL... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3333872