Method and apparatus to make and transmit objects from a...

Details Method and apparatus to make and transmit objects from a... Method and apparatus to make and transmit objects from a...

2000-02-22

2003-07-08

Robinson, Greta (Department: 2177)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

06591272

ABSTRACT:

TECHNICAL FIELD
The present invention relates to translating relations in databases to networked, persistent objects in a manner consistent with an expert, automated process, specifically with nominal computer to human interaction and minimal knowledge and training requirements from the standpoint of the end user. Once created, the present invention efficiently transmits the objects from databases in server computers, and in particular to a method and apparatus for making objects from databases in the classes of objects desired and to transmit the objects made, efficiently to client computers.
This application incorporates by reference the files on a Compact Disc Recordable (CD-R) media, for operating under IBM-PC machine format and MS-Windows operating system. The files are for execution by any machine supporting a lava Virtual Machine (JVM) and are thus platform independent. The list of files contained on the CD-R media, including the names, sizes in bytes and dates of creation is as follows:
FILE NAMES
SIZE
DATE
OSFApplicationTables.java
4,962
02/14/00 12:26p
OSFAttribute.java
1,964
02/14/00 12:26p
OSFBaseObject.java
18,709
02/14/00 12:26p
OSFBaseTable.java
7,991
02/14/00 12:26p
OSFBaseTableIO.java
3,506
02/14/00 12:26p
OSFColumnList.java
5,688
02/14/00 12:26p
OSFComponentObject.java
23,477
02/14/00 12:26p
OSFControlServlet.java
14,741
02/14/00 12:26p
OSFDatabase.java
18,139
02/14/00 12:26p
OSFDataElement.java
1,945
02/14/00 12:26p
OSFDateTime.java
22,519
02/14/00 12:26p
OSFDBIOException.java
2,667
02/14/00 12:26p
OSFDBIOObject.java
18,861
02/14/00 12:26p
OSFDBUpdateValueCompareException.java
6,155
02/14/00 12:26p
OSFGeneralExceptionFormat.java
1,585
02/14/00 12:26p
OSFGenerate.java
281,158
02/14/00 12:26p
OSFGenerateMT.java
248,832
02/14/00 12:26p
OSFIDL.java
10,813
02/14/00 12:26p
OSFKeyField.java
2,248
02/14/00 12:26p
OSFKeyFields.java
3,411
02/14/00 12:26p
OSFMain.java
234,303
02/14/00 12:26p
OSFMember.java
9,143
02/14/00 12:26p
OSFMessageWindow.java
5,064
02/14/00 12:26p
OSFObject.java
5,478
02/14/00 12:26p
OSFObjectCache.java
5,213
02/14/00 12:26p
OSFObjects.java
31,569
02/14/00 12:26p
OSFORBStream.java
59,173
02/14/00 12:26p
OSFORBStreamException.java
1,607
02/14/00 12:26p
OSFORBStreamObject.java
613
02/14/00 12:26p
OSFOwnerList.java
3,731
02/14/00 12:26p
OSFPersistenceObject.java
22,468
02/14/00 12:26p
OSFPickListBuildThread.java
8,746
02/14/00 12:26p
OSFRegistry.java
4,310
02/14/00 12:26p
OSFRelationList.java
6,487
02/14/00 12:26p
OSFRemoteException.java
2,739
02/14/00 12:26p
OSFRulesObject.java
16,548
02/14/00 12:26p
OSFSecurity.java
26,245
02/14/00 12:26p
OSFSecurityException.java
1,595
02/14/00 12:26p
OSFSecurityObject.java
1,974
02/14/00 12:26p
OSFServerObject.java
3,851
02/14/00 12:26p
OSFServletObject.java
107,762
02/14/00 12:26p
OSFServletRunner.java
1,542
02/14/00 12:26p
OSFSystemManagement.java
16,839
02/14/00 12:26p
OSFTableOwner.java
821
02/14/00 12:26p
templates
02/14/00 12:26p
OSFattributecommonrules.java
2,253
02/14/00 12:26p
OSFbuildejserver
1,087
02/14/00 12:26p
OSFcommonrules.java
9,209
02/14/00 12:26p
OSFcontents.html
2,416
02/14/00 12:26p
OSFcontentsDEMO.html
2,675
02/14/00 12:26p
OSFcontentsPROD.html
2,431
02/14/00 12:26p
OSFdbio.java
51,642
02/14/00 12:26p
OSFdeploymentdescriptor.txt
1,628
02/14/00 12:26p
OSFdeploymentdescriptor.xml
1,108
02/14/00 12:26p
OSFedit.html
5,541
02/14/00 12:26p
OSFejhome.java
2,592
02/14/00 12:26p
OSFejmanifest
111
02/14/00 12:26p
OSFejobject.java
8,936
02/14/00 12:26p
OSFejserver.java
21,310
02/14/00 12:26p
OSFhelp.html
4,475
02/14/00 12:26p
OSFinquiry.html
5,718
02/14/00 12:26p
OSFlanguagesedscript.sed
1,079
02/14/00 12:26p
OSFobject.java
86,725
02/14/00 12:26p
OSFpersistence.java
44,242
02/14/00 12:26p
OSFprodbuildNT.cmd
7,119
02/14/00 12:26p
OSFregistry.java
26,452
02/14/00 12:26p
OSFresourcebundle.java
2,362
02/14/00 12:26p
OSFrules.java
8,118
02/14/00 12:26p
OSFsearch.html
4,593
02/14/00 12:26p
OSFserver.java
28,246
02/14/00 12:26p
OSFserverdeploymentdescriptor.xml
613
02/14/00 12:26p
OSFserverrules.java
6,960
02/14/00 12:26p
OSFserverstartup.java
5,129
02/14/00 12:26p
OSFservlet.java
81,345
02/14/00 12:26p
OSFtable.html
5,104
02/14/00 12:26p
OSFtestdbio.java
15,552
02/14/00 12:26p
OSFtestejserver.java
5,949
02/14/00 12:26p
OSFtestobject.java
6,679
02/14/00 12:26p
OSFtestpersistence.java
17,665
02/14/00 12:26p
OSFtestserver.java
18,562
02/14/00 12:26p
BACKGROUND OF THE INVENTION
SQL-based databases and the tables and structures contained therein are well known in the art. Typically, SQL-based tables and associated relations are “flat” structures involving elements in rows and columns with elements in a column “related” to elements in different columns by a relation.
Structured Query Language or “SQL” is used to define database elements, consisting, but not limited to: tables, columns with tables, data types of columns, relationships between tables, constraints of numerous types, and to perform queries upon and to also perform create, update, delete operations upon the aforementioned elements. Although attempts have been made at standardization, in reality the syntax of SQL and operation of relational databases can vary significantly from one database vendor and type to another. It can thus be problematic, within an application, to change from one database type to another.
The process of interrogation of relational database schema or catalogs to obtain information pertaining to the database tables and the interrelationships between database tables is well known.
The use of Internet, or Intranet, or other network to communicate from a database computer to a server computer to a client computer is also well known.
The use of software to manually map database tuples (rows of a table or, more importantly, multiple rows of related tables) into objects for use by object oriented languages such as lava and C++ is also well known.
The use of software to map objects from relations and data in relational database management systems or vice versa to object oriented applications is also well known.
The use of software to transmit information in object form from a server computer to a client computer or vice versa is also well known.
In the prior art, such as that disclosed in U.S. Pat. No.5,857,197, the process of manually mapping database tuples into objects is typically performed through utilization of graphical computer interface. Using a graphical computer interface in a manual manner for this relational to object mapping operation has proven to be time consuming and error prone. An expert-level technician with extensive knowledge of both the internals of relational databases and detailed knowledge and experience with object oriented systems and languages is typically required to use these software products, referred to as “object-relational mapping tools”. These expert-level personnel are usually in practice, both scarce and expensive.
In the prior art, databases have been maintained on server computers and when queried by a client computer the resultant objects have been transmitted to the client computer. There is an inherent mismatch between data stored in relational databases and the format and structure of this relational data in object based systems. The problem faced by the prior art and how such prior art has failed is detailed in “Relational Data Hits the Highway, Making Persistent Objects from Relational Data”, Miller, Julia K. and Kern, Thomas, pgs. 38-42,
Distributed Computing
, Jul. 1998. Further, network efficiency problems faced by the prior art are enumerated in “Reducing Network Traffic in Distributed Java Apps”, Patten, Bon and McCabe, James, pgs. 51-57, Java Report, Sep. 1999. Attempts to solve these problems in the prior art have been addressed by several methods. A common technique is to create an intermediate translation or mapping between the relational database(s) and the object system though interaction with a graphical interface. It is not uncommon to have to manually create or define all of the attributes and methods of the target objects, then manually map the corresponding relat

Affiliated with

Also associated with

Rating

Method and apparatus to make and transmit objects from a... 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 to make and transmit objects from a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and apparatus to make and transmit objects from a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3027009