Patent ID: 6704747
Filing Date: 2004-03-09
Classification: G06F,Y10S

Abstract:
A system for providing access to a relational database using object-oriented structural query language (â€œOSQLâ€ ) comprising:a relational database; a relational database management system (â€œRDBMSâ€ ) providing access to the relational database via structural query language (â€œSQLâ€ ); an open object database connectivity (â€œOODBCâ€ ) system connected to the RDBMS and configured to receive input from a user, the OODBC system comprising a frame model representation of the relational database; and an object frame model agent (â€œOFMAâ€ ); the OFMA configured to receive an OSQL query from a user; convert the received OSQL query into an SQL query with reference to the frame model; and forward the SQL query to the RDBMS; the relational database having data classes, the classes having attributes, including primary and foreign keys, the database further having procedural rules associated with the classes and constraints placed upon relationships between classes and values which can be assigned to the attributes, the frame model comprising: a plurality of static frameworks including a header class framework for storing class definitions and an attribute class framework for storing attribute definitions for each defined class entity; and a plurality of active frameworks including a method class framework for storing method-based procedures associated with at least one of the classes and attributes defined by the static frameworks and a constraint class framework for storing value and relationship constraints on at least one of the classes and attributes defined by the static frameworks.