Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2001-03-19
2003-06-10
Mizrahi, Diane D. (Department: 2175)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06578027
ABSTRACT:
BACKGROUND OF THE INVENTION
The present invention relates to information processing and more particularly to database access systems and methods such as a relational database access system and method.
Relational database systems are well known in the prior art, and include tabular structures and structured query languages used for database queries. To aid in an understanding of the present invention, a glossary of terms is included hereinbelow.
Relational database technology has made possible an independence between the way data is physically stored and the way it can be handled logically. Relational technology has been widely accepted in business, industry and engineering as valuable for storing data.
Heretofore, most of the advances provided by relational databases has been limited to those users who understand the mathematical principles of relational algebra. Querying a relational database implies a good knowledge of Structured Query Language (SQL) and a good understanding of relational data structures.
Numerous information systems that hide the complexity of SQL and relational databases are based on predefined query techniques. Using those solutions, users can specify parameters in order to add some conditions, but they can never change the meaning of the result. The semantic components of the SQL language (joins and group functions) are stored in the body of the predefined query. When an MIS staff builds an infocenter solution they create user-dedicated tables, relational views or predefined SQL queries accessible by menu triggers.
Usually, if end-users want to change the meaning of a query, either they have to ask the MIS staff to program another query or they have to program the SQL commands themselves. If they do so they will encounter many problems:
the syntax of non procedural structured query language (in particular SQL) is complex.
the data structure is not adapted to the users' everyday work. Relational databases store information as well as relational data such as keys.
is the SQL query semantically correct? Although a query is syntaxically correct, results are not always reliable. SQL as a programmer language does not check the semantic of a query. A more concrete example is the SQL language producing totally a meaningless cross product. This represents a major limitation for end-user access to relational data.
Glossary
The following is a glossary of some of the terms used in these technologies.
Data: Raw facts or values which are physically recorded and which can be extracted and objectively verified
Information: Anything learned from data, the “meaning” of the data.
Value: An amount of worth
Database: A computerized collection of data
Relational Database: A database in which all data are stored and organized in tables and in which each field containing a datum is equally accessible.
Relational Database Management System (RDBMS): The software environment supporting a Relational database.
Relational Database Terms:
Record: A collection of fields; the basic accessible element of a file.
Field: An elemental entity of a record.
Relation: An orderly arrangement of data in columns and rows; a table.
Attribute: A column of a relation, a field of a Tuple.
Tuple: A record of a relational database; one line or row of a table or relation.
Relational Structure: Set of Relations definitions
Business Objects specific Terms:
Infocenter: Environment in which the Users, without any technical knowledge, have “self-service” access to the information system, in a manner controlled by MIS staff.
Universe: An easy-to-understand partial or total representation of the database, designed for a particular application or group of users.
Business Objects: Objects corresponding to concepts close to the user's everyday business. They are defined by the Infocenter Manager and are the basic elements of a Universe.
Context: Set of logical equations linking tables (joins) providing a closed graph of table.
SUMMARY OF THE INVENTION
It is an object of the present invention to provide a new data representation and a new query technique which allow information systems end-users to access (query) database systems such as relational databases without knowing the relational structure or the SQL language. The present invention introduces the notion of semantically dynamic objects.
Other objects, features and advantages of the present invention will become apparent from the following detailed description when taken in conjunction with the accompanying drawings.
REFERENCES:
patent: 4445171 (1984-04-01), Neches
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4543630 (1985-09-01), Neches
patent: 4751635 (1988-06-01), Kret
patent: 4769772 (1988-09-01), Dwyer
patent: 4811207 (1989-03-01), Hikita et al.
patent: 4814979 (1989-03-01), Neches
patent: 4905163 (1990-02-01), Garber et al.
patent: 4930071 (1990-05-01), Tou et al.
patent: 4939689 (1990-07-01), Davis et al.
patent: 4965743 (1990-10-01), Malin et al.
patent: 4967337 (1990-10-01), English et al.
patent: 4970658 (1990-11-01), Durbin et al.
patent: 5006978 (1991-04-01), Neches
patent: 5179698 (1993-01-01), Bachman et al.
patent: 5233513 (1993-08-01), Doyle
patent: 5261093 (1993-11-01), Asmuth
patent: 5263167 (1993-11-01), Conner, Jr. et al.
patent: 5291583 (1994-03-01), Bapat
patent: 5295256 (1994-03-01), Bapat
patent: 5297279 (1994-03-01), Bannon et al.
patent: 5317742 (1994-05-01), Bapat
patent: 5386556 (1995-01-01), Hedin et al.
patent: 5418950 (1995-05-01), Li et al.
patent: 5421008 (1995-05-01), Banning et al.
patent: 5426781 (1995-06-01), Kaplan et al.
patent: 5428737 (1995-06-01), Li et al.
patent: 5428776 (1995-06-01), Rothfield
patent: 5454106 (1995-09-01), Burns et al.
patent: 5767848 (1998-06-01), Matsuzaki et al.
patent: 6185553 (2001-02-01), Byrd et al.
patent: 6356903 (2002-03-01), Baxter et al.
patent: 0 120 185 (1984-10-01), None
patent: 0 439 937 (1991-08-01), None
patent: 0 455 447 (1991-11-01), None
“Iris: An Object-Oriented Database Management System,” D.H. Fishman et al., ACM Transactions on Office Information Systems, vol. 5, No. 1, Jan. 1987, pp. 48-69.
Cambot Jean-Michel
Liautaud Bernard
Business Objects, SA
Mizrahi Diane D.
Townsend and Townsend / and Crew LLP
LandOfFree
Relational database access system using semantically dynamic... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Relational database access system using semantically dynamic..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Relational database access system using semantically dynamic... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-3127014