Method and apparatus for storing and manipulating objects in a plurality of relational data managers on the web
First Claim
1. In a network of computers over the internet, a multi-tier client/server system comprising of:
- A) Clients with browsers capable of triggering queries written in Structured Query Language (SQL) where these clients are connected to object request brokers in a Common Object Request Broker Architecture so as to make persistent communications with other object request brokers existing with relational database servers at multiple locations on the internet;
B) Relational database servers with schema and business application logic defined in the form of object packages comprising;
a) An user defined type creation for an attribute in a table where the type definition consists of variable definitions along with interface definitions for methods and operators on these variables;
b) An user defined type creation for an attribute in a table where the type definition consists of a variable that points to a local or remote object on the internet;
c) An user defined type creation for an attribute in a table where uniform Resource Locators (URLs) are used as values to locate any object on the web including relational databases;
d) An user defined type creation for an attribute in a table where the type definition consists of a variable that can locate a view definition or any object in a local or remote relational database;
e) Method and operator interfaces defined in user defined types implemented in Java classes,C) Executions of application logic in object packages on local or remote web objects performed by Object Request Broker services in Common Object Request Broker Architecture (CORBA).
0 Assignments
0 Petitions
Accused Products
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.
-
Citations
14 Claims
-
1. In a network of computers over the internet, a multi-tier client/server system comprising of:
-
A) Clients with browsers capable of triggering queries written in Structured Query Language (SQL) where these clients are connected to object request brokers in a Common Object Request Broker Architecture so as to make persistent communications with other object request brokers existing with relational database servers at multiple locations on the internet; B) Relational database servers with schema and business application logic defined in the form of object packages comprising; a) An user defined type creation for an attribute in a table where the type definition consists of variable definitions along with interface definitions for methods and operators on these variables; b) An user defined type creation for an attribute in a table where the type definition consists of a variable that points to a local or remote object on the internet; c) An user defined type creation for an attribute in a table where uniform Resource Locators (URLs) are used as values to locate any object on the web including relational databases; d) An user defined type creation for an attribute in a table where the type definition consists of a variable that can locate a view definition or any object in a local or remote relational database; e) Method and operator interfaces defined in user defined types implemented in Java classes, C) Executions of application logic in object packages on local or remote web objects performed by Object Request Broker services in Common Object Request Broker Architecture (CORBA). - View Dependent Claims (2, 3, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
4. In a network of computers over the intemet, multi-tier client/server system incorporating distributed business application logic with relational data at disparate locations comprising of:
-
A) A logical schema for relational databases with tables, foreign key/primary key relationships, attributes with user defined types, business application logic in object packages; B) Many instances of component physical schema for relational databases distributed over disparate locations where these distributed schema instances are derived from one logical schema; C) A component physical schema with definitions of tables, foreign key/primary key relationships, user defined types with object packages and local or remote object locators consisting of; a) Uniform Resource Locators (URLs) used for locating remote schema or web objects; b) Relations as view caches to maintain relationships over foreign keys inherited from a table in the local component schema and primary keys of a table in a remote schema located by URLs; c) Relations as view caches to enforce referential integrity across component relational databases over the intemet; d) Business logic in the form of object packages implemented in Java classes to incorporate processing logic over a join or other relational operations performed in a local component schema; e) View cache tables maintaining an attribute which is an user defined type with an associated object package implemented as Java class at a remote schema location and URLs as attribute values for locating primary keys in that remote schema; D) A multiple table join in a single logical schema performed as multiple partial joins at disparate component schema with persistent communications through Object Request Brokers maintained at each schema locations; E) Many levels of business logic applications on a complex join in a logical schema executed as cooperative processing of distributed business logic on partial joins in component schema at disparate locations communicating through Object Request Brokers.
-
Specification