Accessing data from a database over a network

• US 6,901,428 B1
• Filed: 10/11/2000
• Issued: 05/31/2005
• Est. Priority Date: 10/11/2000
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Wewerka, Diane M., Frazier, John D., Reed, Michael L.
• Primary Examiner(s): Etienne, Ario
• Assistant Examiner(s): JACOBS, LASHONDA T
• Application Number:
  US09/686,299
• Time in Patent Office: 1,693 Days
• Field of Search: 709/203, 709217-218, 709224-225, 709227-229, 709/219, 707/3, 707/9, 707/100, 707/102, 707/201, 707/8, 707/10, 707/202
• US Class Current: 709/203
• CPC Class Codes: G06F 16/9577 Optimising the visualization of content, e.g. distillation of HTML documents
• CPC Class Codes: Y10S 707/99939 Privileged access
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99952 Coherency, e.g. same view to multiple users

Abstract

A database system is accessible by a client system over a data network. In one arrangement, a server system is connected to the data network to receive requests from the client system. In response to the request, the server system issues corresponding queries to the database system to retrieve data. The data is then formatted by the server system and sent to the client system, where the formatted data is displayed, such as in a browser screen. The formatted data includes hyperlinks that are user selectable to retrieve further objects from the database system. When selection of the hyperlink is received, the client system sends a request to the server system, which retrieves the requested object or objects from the database system. The objects are communicated back to the client system for presentation.

Claims

1. A system comprising:

an interface to receive a request from a client system for information in a database system; and

a controller to format metadata associated with the requested information into a format for display in the client system, wherein said controller is adapted to map plural data types defined by the database system to corresponding files types to enable presentation in the client system of an object having an associated data type retrieved from the database system,

wherein said controller is adapted to further map plural data types to the corresponding files types based on a table having multiple entries each associating a data type defined by the database system with a file extension corresponding to a respective file type, and

wherein the controller is adapted to create a file name for the object, the file name containing the file extension mapped for the data type of the object, and to send a file having the file name to the client system, the file containing the object.

2. The system of claim 1, wherein the controller comprises a network communications service to receive the request from the client system.

3. The system of claim 2, wherein the network communications service comprises a Hypertext Transport Protocol service.

4. The system of claim 1, the controller to format the metadata into a predetermined format displayable by a browser.

5. The system of claim 4, wherein the predetermined format comprises a format selected from the group consisting of a Hypertext Markup Language format, an Extensible Markup Language format, and a Wireless Markup Language format.

6. The system of claim 1, wherein the database system comprises an object relational database system.

7. The system of claim 1, wherein the plural data types comprise two or more of the following:

audio data, video data, multimedia data, image data, and geospatial data.

8. The system of claim 1, further comprising a storage element containing an object retrieved from the database system, the controller to communicate data in the object as a stream to the client system.

9. The system of claim 8, wherein the controller communicates portions of the object to the client system in the stream so that the entire object need not be communicated to the client system for storage.

10. The system of claim 1, wherein the metadata comprises a hyperlink.

11. The system of claim 10, the interface to receive a second request indicating selection of the hyperlink, the hyperlink corresponding to the object in the database system.

12. The system of claim 1, wherein the metadata contains a description of plural objects in the database system.

13. The system of claim 12, wherein the description comprises hyperlinks corresponding to the plural objects.

14. The system of claim 1, wherein the controller is adapted to further receive presentation information stored in the database system, the presentation information defining a manner in which the requested information is to be presented by the client system.

15. The system of claim 14, wherein the controller is adapted to use the presentation information to map the data types to the file types.

16. A method of accessing an object relation database, comprising:

loading an applet over a network from a server;

executing the applet to present an interactive interface in a browser display screen to receive user queries and to send requests for information from the object relational database in response to the user queries;

receiving metadata relating to requested information from the object relational database;

displaying at least a portion of the metadata as a hyperlink;

in response to selection of the hyperlink, sending a request for an object in the object relational database, the object containing information associated with the selected metadata portion;

associating the object with one of plural presentation routines to present the information in the object;

mapping plural data types stored in the object relational database to corresponding plural file types; and

identifying a file type of the object based on the mapping, wherein mapping the plural data types to corresponding plural file types comprises mapping, based on a mapping table, the plural data types defined by object relational database to the corresponding file types, wherein the mapping table has entries mapping a data type to a corresponding file extension with a respective file type.

17. The method of claim 16, wherein associating the object with one of plural presentation routines is based on the file type of the object.

18. The method of claim 16, further comprising invoking the one presentation routine as a plug-in to a browser.

19. The method of claim 16, further comprising:

receiving at least one of a Hypertext Markup Language (HTML), Extensible Markup Language (XML), and Wireless Markup Language (WML) file to present the browser display screen.

20. The method of claim 19, wherein the at least one of the HTML, XML, and WML file causes a first frame to be presented in the browser display screen, the method further comprising invoking the applet in response to user selection of an element in the first frame,

wherein the interactive interface is presented in a second frame in the browser display screen.

21. An article comprising at least one storage medium containing instructions that when executed cause a first system to:

receive a request from a client system for data in a database;

retrieve the data from the database type; and

determine a data type of the retrieved data and map the data type to a file type presentable by the client system type, wherein mapping the data type to the file type comprises accessing a table having multiple entries to map plural data types associated with data stored in the database with corresponding plural file types presentable by the client system, each entry of the table associating a data type defined by the database with a file extension corresponding to a respective file type, and

wherein the instructions when executed cause the first system to further create a file name for the retrieved data, the file name containing the file extension mapped for the data type of the retrieved data, and to further send a file having the file name to the client system, the file containing the retrieved data.

22. The article of claim 21, wherein the instructions when executed cause the first system to:

retrieve metadata describing the requested data; and

format the metadata according to a predetermined format displayable by the client system.

23. The article of claim 22, wherein the predetermined format comprises one of a Hypertext Markup Language format, an Extensible Markup Language format, and a Wireless Markup Language format.

24. The article of claim 22, wherein the metadata comprises a hyperlink, the instructions when executed causing the first system to receive activation of the hyperlink and to retrieve the data in response to the activation of the hyperlink.

25. The article of claim 21, wherein the instructions when executed cause the first system to retrieve an object from an object relational database.

26. The article of claim 21, wherein the database stores rules pertaining to presentation of the data in the client system, the instructions when executed causing the first system to access the rules to map the data type to the file type.

27. A system comprising:

one or more storage devices containing an applet and a document;

an interface to a network;

a controller to communicate the document to a client device, the document containing data defining a page displayable in a browser screen, and the applet containing instructions that when executed provide an interactive portion of the browser screen to enable user entry of Structured Query Language (SQL) queries, wherein said applet responsive to SQL queries entered in the interactive portion of the browser screen by sending corresponding requests for accessing data in a database system; and

wherein the controller is adapted to create a file name for the object, the file name containing the file extension mapped for the data type of the object, and to send a file having the file name to the client system, the file containing the object.

28. The system of claim 27, wherein the applet is invoked in response to user selection of an element in a first frame of the browser screen,

the interactive portion being part of a second frame of the browser screen.

29. The system of claim 28, wherein the browser screen comprises a third frame to display a result page in response to a request for data in the database system,

the result page containing at least one hyperlink selectable by a user to retrieve an object from the database system.

30. A system comprising:

an interface to receive a request from a client system for information in a database system; and

a controller to format metadata associated with the requested information into a format for display in the client system;

wherein said controller is adapted to map plural data types in the database system to corresponding files types to enable presentation in the client system of an object having an associated data type retrieved from the database,

wherein the controller is adapted to communicate the requested information and executable code associated with the requested information to the client system, the executable code for presenting the requested information in the client system, and

wherein the controller is adapted to create a file name for the object, the file name containing the file extension mapped for the data type of the object, and to send a file having the file name to the client system, the file containing the object.

31. An article comprising at least one storage medium containing instructions that when executed cause a first system to:

receive a request from a client system for data in a database;

retrieve the data from the database; and

determine a data type of the retrieved data and map the data type to a file type presentable by the client system type;

wherein mapping the data type to the file type comprises accessing a table having multiple entries to map plural data types associated with data stored in the database with corresponding plural file types presentable by the client system;

wherein the instructions when executed cause the first system to communicate executable code stored in the database and associated with the retrieved data to the client system, the executable code for presenting the retrieved data in the client system, and

wherein the instructions when executed cause the first system to further create a file name for the retrieved data, the file name containing the file extension mapped for the data type of the retrieved data, and to further send a file having the file name to the client system, the file containing the retrieved data.