Data processing: database and file management or data structures – Database design – Data structure types
Patent
1998-03-02
2000-01-04
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707 10, 707104, 707201, 709229, 709203, 713201, 713200, 39550024, 39550025, G06F 1730
Patent
active
060120673
ABSTRACT:
The present invention provides a system for the retrieval, construction and manipulation of any kind of objects using Structured Query Language (SQL) over disparate relational storage systems on the web. Uniform Resource Locators (URLs) are used by the present invention to locate objects corresponding to component relational databases on the web and other web objects. URLs locating relational schema components and other web objects are stored as attribute values in tables. Object methods and operators on such web objects are defined as part of user defined type definition for an attribute type in a table. Object request brokers apply such methods or operators on web objects anywhere on the web. Since URLs can point to relational data store under a remote schema definition, a business application logic in the form of object package is executed after constructing proper sets of records by relational operations at the remote schema location. This leads to partitioning of a logical schema into many physical schema components with business objects. Also by this invention, parts of a web object can be intelligently manipulated and access methods through index creation enable range access over web objects. Additionally, this invention suggests possible internet security by authorizations at component schema locations and by further maintaining processing logic for secured transmission over the internet. SQL queries create, retrieve and manipulate disparate web objects with implicit or explicit calls to business application logic as object methods. This invention uniquely incorporates a cooperative method of preparation, execution and resolution of a SQL query manipulating uniform resource locators and object definitions at multiple locations on the web.
REFERENCES:
patent: 5517645 (1996-05-01), Stutz et al.
patent: 5613148 (1997-03-01), Bezviner et al.
patent: 5694598 (1997-12-01), Durand et al.
patent: 5706506 (1998-01-01), Jensen et al.
patent: 5706507 (1998-01-01), Schloss
patent: 5708780 (1998-01-01), Levergood et al.
patent: 5712979 (1998-01-01), Graber et al.
patent: 5715399 (1998-02-01), Bezos
patent: 5717911 (1998-02-01), Madrid et al.
patent: 5717924 (1998-02-01), Kawai
patent: 5815415 (1998-09-01), Bentley et al.
patent: 5857201 (1999-01-01), Wright et al.
patent: 5870544 (1999-02-01), Curtis
patent: 5881230 (1999-03-01), Christensen et al.
patent: 5913061 (1999-06-01), Gupta et al.
patent: 5915085 (1999-06-01), Koved
David Ritter, "The Middleware Muddle", DBMS, May 1998.
Oracle 8 Server SQL Reference (Release 8.0, vol. 1 & 2 ), 1997.
Extending Informix--Universal Server: Data Types, Version 9.1, Mar. 1997.
Extending Informix--Universal Server: User-Defined Routines, Version 9.1, Mar. 1997.
Black Thomas G.
Corrielus Jean M.
LandOfFree
Method and apparatus for storing and manipulating objects in a p does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method and apparatus for storing and manipulating objects in a p, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus for storing and manipulating objects in a p will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-1080546