+

WO1999009494A1 - Coexistence d'une base de donnees relationnelle dans des environnements orientes objets - Google Patents

Coexistence d'une base de donnees relationnelle dans des environnements orientes objets Download PDF

Info

Publication number
WO1999009494A1
WO1999009494A1 PCT/NZ1998/000128 NZ9800128W WO9909494A1 WO 1999009494 A1 WO1999009494 A1 WO 1999009494A1 NZ 9800128 W NZ9800128 W NZ 9800128W WO 9909494 A1 WO9909494 A1 WO 9909494A1
Authority
WO
WIPO (PCT)
Prior art keywords
database
external
class
extemal
collection
Prior art date
Application number
PCT/NZ1998/000128
Other languages
English (en)
Inventor
Hugh Mccoll
Original Assignee
Aoraki Corporation Limited
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Aoraki Corporation Limited filed Critical Aoraki Corporation Limited
Priority to NZ503238A priority Critical patent/NZ503238A/xx
Priority to AU90101/98A priority patent/AU9010198A/en
Priority to EP98941947A priority patent/EP1019851A1/fr
Publication of WO1999009494A1 publication Critical patent/WO1999009494A1/fr

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/289—Object oriented databases

Definitions

  • TECHNICAL FIELD This invention relates to methods and techniques for integrating relational databases effectively with object oriented applications while ensuring co-existence with an object database.
  • Relational databases employed in existing systems represent a significant investment which impedes any more to an object oriented model. It has been difficult to map a relational database to an object oriented model, particularly where it is to co-exist with an object database. This has made it difficult to programmatically access the data of a relational database for an object oriented model.
  • relational database can be defined as part of the development of the object oriented application and the application code can make use of embedded SQL commands. Further in a dedicated object oriented application - relational database combination the database can be accessed directly rather than through the Open Database Connectivity (ODBC) layer provided with most relational databases.
  • ODBC Open Database Connectivity
  • US Patent 5,765,161 discloses a system where data from non-relational, non-object- oriented data stores, such as IBM IMSTM, are encalculated as persistent objects for use in an object oriented application. Such a system does not allow for co-existence with a populated object database.
  • US Patent 5,542,078 discloses a system for accessing and integrating non-object oriented data stores with object applications.
  • An application using an object database management system is provided with an interface to access foreign data stores which include external data that is mapped and converted into objects for use by the application.
  • This system does not allow the mapping of complex relationships between data to manipulate external data with the same degree of effectiveness as data held in the integrated object database.
  • SQL structural query language
  • the invention in one aspect consists in a method of mapping a relational database schema to an object oriented schema to allow co-existence of said relational database with an object database comprising the steps of:
  • mapping columns to attributes (ii) mapping columns to attributes, (iii) defining classes of set, array and dictionary collections based on primary key and index data, (iv) establishing relationships from said primary keys, foreign keys and columns having the same names,
  • step (c) generating structural query language (SQL) code fragments to support collection operations from the information derived in step (b) and storing same for run-time access to said relational database, and (d) storing a description of the classes and collections established in step (b) for use in run-time by an object oriented application whenever access to data in said relational database is required.
  • SQL structural query language
  • the invention consists in a database query engine for an object oriented application which enables access to data in one or more external non-object oriented databases in the same manner as an internal integrated object oriented database to provide data location transparency, said engine comprising: an external class corresponding to each non-object oriented database which determines how a proxy object is populated by instances from the corresponding external database, sub classes which re-implement methods to populate external class instances from said external databases while maintaining an identical interface to internal object classes, a mechanism which produces a representation of the external database schema, and an object identifier to unique key mapping between an external proxy object instance and a row in the external database, said engine carrying out the following processes: assembling SQL statements as determined by the definition of the appropriate external class, appending a JOIN query predicate when accessing a property which is an end point of a bi-directional relationship, binding parameter values obtained from the attribute values of an external proxy instance to parameter markers in said SQL statements, binding parameter values obtained from the operation request which represent dictionary keys binding parameter values obtained from the attribute
  • External classes which have two components -namely, an interface and a query specification.
  • the interfaces defines the properties (attributes and relationships) and methods if any and their domains; the query specification
  • a re-implementation of object manager operations particularly get and set property operations for read or write access to simple attribute values
  • An External Collection class using h) provides the protocol to access individual or multiple instances from a subset of a class extent.
  • the membership of the collection is constrained by attributes of the collection description as defined in the enriched schema.
  • An external Iterator class using h) and/or in collaboration with the External Collection class provides the protocol to iterate 'a collection' of external instances.
  • the said external query engine comprises the steps:
  • the said external query engine allows:
  • the invention therefore provides two complementary areas of functionality: a relational to object schema mapping process, and a query engine that implements in the relational database object oriented access methods.
  • mapping is specified declaratively using a "wizard" style mapping tool.
  • the external schema wizard (ESW) enables mapping of:
  • Tuples (which may be the result of a project/join or a view) to objects.
  • SQL types to object language primitive types.
  • existing relational database schemas are enhanced to map the relational database into an object model.
  • Object concepts and language constructs can then access the data in the external relational database in the same way as data is accessed in the co-existing object database. This then allows a query engine that sits between the object environment and the external databases to implement at runtime the object database access methods.
  • GCS Global Conceptual Schema
  • a partially automated mapping utility is provided to map relational schema into semantically enriched object model schemas.
  • the GCS provides a high-level integrated view of external relational databases as part of an existing object database schema, hiding structural differences between the object model and the relational model. From the application developer's view there appears to be a single unified database.
  • the key to the mapping is to discover the relationships between tables in the relational schema and to map these to bidirectional relationships implemented using inverse references.
  • mapping will be able to map tuples to objects, SQL types to object primitive types and joins to bi-directional relationships as previously outlined.
  • the mapping is declarative, using a 'wizard- style' mapping tool, rather than programmatic. This reduces coding requirements and increases flexibility.
  • Data connectivity is provided by the relational database Open Database Connectivity (ODBC) interface, which will be used during the schema transformation phase to access catalogue information and later at 'runtime' to populate virtual object instances via SQL queries.
  • ODBC relational database Open Database Connectivity
  • ODBC is a widely accepted application-programme interface for database access. It is based on the Call-Level Interface (CLI) specifications from X/Open and ISO/IEC for database APIs and uses Structured Query Logic (SQL) as its database access language. ODBC is designed for maximum interoperability - that is the ability of single application to access different database management systems (DBMSs) with the same source. The query engine will call functions in the ODBC interface which are implemented in database specific modules called drivers.
  • CLI Call-Level Interface
  • ISO/IEC ISO/IEC
  • SQL Structured Query Logic
  • Figure 1 shows diagrammatically the architecture of an object oriented system supporting non-object database co-existence
  • Figure 2 shows functions performed by the external schema mapping "wizzard" according to the present invention
  • Figure 3 shows the architecture of the external query engine of the present invention
  • Figure 4 shows a typical run-time configuration of an object oriented system with external database co-existence.
  • GCS Global Conceptual Schema
  • the proposed GCS architecture is architectured to ensure that it can be readily adapted to support what are commonly referred to as multi-database or federated database systems including non-relational databases such as hierarchical, network or even other OO databases.
  • the actual connectivity may employ mechanisms other than ODBC, such as a native call level interface or other high level abstractions such as OLEDB.
  • JADE will derive certain useful information directly from the relational catalog, such as primary and foreign key specifications. Often, foreign key relationships will also be deduced based on naming conventions. For example, if "dept-id" is the primary key of the department table then it may be deduced that "dept-id" in the employee table is probably a foreign key. Other information, such as relationship implementation, can be deduced heuristically.
  • An 'Object Identifier' to primary key (or special columns) mapping allows the direct mapping of a proxy instance to a row in the relational system.
  • the Object identifier property of the proxy denotes the primary key of the relational entity that the proxy is modelling.
  • the attribute "dept num" provides a unique handle for each tuple (row) in a Department table.
  • the attribute dept_num would play the role of a foreign key in an associated Employee table.
  • the OID to primary key mapping is of significance for updating in certain collection operations. For updating a proxy with a searched update it is necessary to uniquely identify the row in the external database which the proxy represents.
  • the purpose of the proxy classes is to act as a mediator between the OO world and the relational world. These classes will be derived from a common abstract class: ExternalObject a subclass of the Object class.
  • the external proxy classes are instances class type: ExternalClass.
  • the proxy classes that comprise the transformation schema have two components: (a) a interface, and (b) a mapping or query specification.
  • the interface defines the properties (and methods, if any) and the mapping specification, comprising of 'SLQ- like' queries, defines how to populate a proxy with instances from an external database.
  • the tuples or instances retrieved by this query are 'virtual-instances' of the proxy.
  • the user must deal with instances of the external classes defined in the schema.
  • An external class definition can be mapped from any one of the following relational 'entities': a base table, a view defined in the relational schema, a query e.g. a join, or the result set of a stored procedure
  • the properties of an external class may be either: (a) attributes, or (b) external references. Attributes are simple types whose domain is one of the supported JADE primitive types. The type of an external reference can be another external class type or an external collection. External references are used to represent the endpoints of a relationship. External references are always defined as explicit inverses. These references are implemented using mapping methods, which employ either an external object or an external collection method to retrieve an instance or instances.
  • ExternalSet An unordered collection may be Class extend optional filtering expression
  • the following table lists the ANSI SQL data types and shows the JADE primitive to which they are mapped by default.
  • External proxy classes can be organised into an inheritance hierarchy adding further semantics above the relational model.
  • an external proxy class could be made a subclass of another provided it met the following requirements:
  • the properties mapped in the superclass are a subset of the properties of the subclass
  • the 'set of instances' of the subclass are a subset of the 'set of instances' of the superclass
  • Summary Mapping technology is used to enhance relational schemas with object model semantics.
  • Tables (base, derived or predefined views) are mapped to subclasses of External object.
  • Tuples (or rows) map to instances of external classes.
  • Each external database is represented by a subclass of ExternalDatabase and a singleton instance.
  • Object Identifier to 'primary key' mapping allows unique identification of a tuple and map this to a 'proxy' object.
  • Multi-valued properties will be implemented with Dictionary, Set or Array types.
  • Schema Transformation Support Overview In order to support the process of transforming a relational schema into an object model a schema transformation "Wizard" is provided within the development environment.
  • the Wizard accesses catalog information from selected external data bases and generates classes under the direction of the developer. Some data sources or ODBC drivers may not support all the catalog functions used and some catalogs may not contain all the information required for deriving or suggesting potential relationships.
  • the Wizard (1) allows selection of data sources configured on the development machine,
  • (13) provides a mechanism to update a mapped object model when the relational schema changes (without having to start from scratch).
  • the dept_id foreign key is obtained from the virtual department instance, which is the parent of the virtual employees dictionary.
  • the external iterator class will implement the standard iterator protocol i.e. next() and back() methods etc.
  • the external iterator/collection collaboration will allow constructs such as for each to function in a transparent fashion.
  • External collections implement most of the non-updating collection methods e.g. first, last, size etc.
  • External dictionaries provide direct key access to an 'external object instances' i.e. random access to a row or tuple in the relational database.
  • Example: department : E Company. departments [name];
  • Sequential access External iterators implement the standard iterator protocol and may be used directly. Standard JADE for each syntax is fully supported including reversed and where clause. Class: instances to retrieve 'class extent'.
  • An exception class is provided to provide additional information specific to using the ODBC interface. Special consideration is given to detecting and handling changes to the relational schema which may become inconsistent with the schema mapping.
  • JADE In the JADE 'for each' instruction, JADE currently optimise special cases when the predicate following the where consists of a conditional key expression. A similar optimisation will be useful when iterating with a for each over an external proxy collection. A special case occurs when the predicate following the where clause contains operands which are all attributes of the collection member type. In this case, the where predicate from the for each can either become the where predicate in the SQL statement or can be conjoined with an existing where predicate in the query specification associated with the external collection.
  • An External Database class will provide transaction support and direct SQL execution with beginExternalTransaction, commitExternalTransaction, abortExternalTransaction.
  • a class can be defined from one or more base tables. If multiple tables are specified it is equivalent to a JOIN. If a class is defined as a JOIN of two or more tables its unique or primary key columns will be the combination of all the tables unique or primary key columns. By selecting only those attributes which are required for a class a table projection can be effected, ie the class can access a subset only of the columns for the table. This has resource and performance benefits for large tables and joins.
  • Each external class defined must include attributes (possibly hidden) that correspond to the unique or primary key columns of the tables it uses. This is required to give each object uniqueness. This is necessary for random updating and the collection method 'includes'.
  • Attribute Mapping methods are created for all attributes that have a base type of
  • Reference Mapping methods are created for all for single references. This method calls getProxy with feature number of the reference property to allow the returning of the appropriate proxy.
  • Rules for collection candidate creation Create a dictionary for each index of the class if all the columns of the index have corresponding user defined attributes ie not hidden. Create a dictionary based on the primary key of the class if all the columns of the primary key have corresponding user defined attributes ie not hidden. Create an array based on the primary key of the class if all the columns of the primary key have corresponding user defined attributes ie not hidden. Create a set for each class.
  • Relational to Object Oriented Heuristics Cardinality Use the cardinality of the respective tables to indicate the cardinality of the relationship between the corresponding classes.
  • cardinality information is not available then a relationship is based on a primary key/foreign key pair is likely to be a one to many relationship. If no delete rule information is available assume a peer-peer relationships.
  • Orderltems OrderltemArray
  • OrderSet Set of Order
  • OrderltemArray Array of Orderltem ordered by .lineOrder
  • Intermediate tables are tables that are used to allow an M:M relationship to be implemented between two other tables. They can have additional columns beyond those participating in the relationship or they can consist solely of those columns.
  • the ExternalReference.joinPredicate and the ExternalReference.joinPredicatelnfo properties are used for reference querying using the late-binding technique.
  • the keyEqPredicatelnfo consists of an integer for each '?' in the keyEqPredicate. Each integer is the ordinal of the key to be bound as a parameter at runtime. This method must handle both single and multiple key collections.
  • Collection geqKey,gtKey,leqKey,ltKey Determines the key ⁇ CmpOp>Predicate and key ⁇ CmpOp>PredicateInfo required for a key ⁇ CmpOp> operation on an ExternalDictionary, where ⁇ CmpOp> can be Geq, Gtr, Leq, Lss.
  • the key ⁇ CmpOp>Predicate consists of a comparison term for each key of the collection.
  • Each factor consists of a column identifier, a comparison operator and a '?' placeholder for bound parameters.
  • the key ⁇ CmpOp>PredicateInfo consists of an integer for each '?' in the key ⁇ CmpOp>Predicate. Each integer is the ordinal of the key to be bound as a parameter at runtime. This method must handle both single and multiple key collections.
  • geqKey Given a dictionary with keyl, key2 etc corresponding to column 1, column2 the terms for geqKey are :
  • the includesPredicate consists of an equality term for each unique column of the tables that are used by the collections member class. Each term consists of the columns identifier, an '- sign and a '?' placeholder for bound parameters. All these terms are ANDed together and enclosed in braces.
  • the includesPredicatelnfo consists of an integer for each '?' in the includesPredicate. Each integer is the column/attribute ordinal of the parameter to be bound at runtime. This method must handle both single and multiple table classes, and both single and multiple unique column tables.
  • column2 Given a collection with a member class whose table(s) have unique columns column 1, column2 the terms for includes are :
  • This fragment is optionally specified by the user.
  • Table identifies are generated from the table name, and any schema and catalog names specified for the table. These are combined according to the driver information for their usage, prefix/suffix usage and the driver quote character. Instead of using table identifiers directly, correlation names (also known as aliases ) are used, unless the driver does not support this. Table name aliases are defined in the FROM clause and are used instead of table identifiers in SELECT, and WHERE clauses. Table name aliases are generated that are unique across the entire External Database definition and not just for a particular query.
  • Column identifiers are a combination of a column's table identifier ( or alias ) and its name separated by a '.' character.
  • the relational Query engine has two functions as indicated in figures 1 and 3. The first is to implement the behaviour of external proxy classes and collections that provide access to external databases (see also figure 4). The second is to provide catalog Query functions, which import catalog information from an external database populating meta information objects used by the External Schema ESW.
  • the query engine will provide methods on the external schema entities used by the external schema Wizard to import catalog information from a relational schema. These methods will employ the relevant ODBC catalog functions. Some drivers/data sources may not support all the required functions, in which case the external schema Wizard have less information to use for producing a default mapping.
  • the JADE query engine will always query driver capability to determine whether a required function is available before using it.
  • the schema transformation process creates an object model, which can be employed by developers as an abstract O-O view of a relational database.
  • the query engine will implement the required access methods to allow this abstract object model to work.
  • the query engine will also depend on a number of stored SQL queries and mapping methods generated by the external database wizard.
  • ExternalDatabase Each external database is mapped to a subclass of the a class called ExternalDatabase, which has a singleton persistent instance.
  • the external database class provides properties and methods relevant to the external data source and connection.
  • a transient instance is created; this instance can be accessed in user logic to invoke database specific operations.
  • ExternalClass implements behaviour specific to external proxy classes.
  • the class is used by the query engine when creating virtual proxy instances.
  • each external class will contain the SQL query required to populate a 'class extent' or to do a join query for a single valued reference.
  • ExternalCollClass implements behaviour specific to external collection classes. The class is used by the query engine to populate an external virtual collection.
  • the user will access the relational database using the OO language and by navigating relationships via inverse references, e.g. in JADE it will be possible to code the following style of iterative access: foreach emp in dept.employees do emp.displayO; endfo reach;
  • the dept_id foreign key will be obtained from the virtual department instance, which is the parent of the virtual employees dictionary.
  • the external iterator class will implement the standard iterator protocol i.e. next() andback() methods etc.
  • the external iterator/collection collaboration will allow constructs such as foreach to function in a transparent fashion.
  • External collections will implement non-updating collection methods e.g. first, last, size etc.
  • External dictionaries will provide direct key access to an 'external object instances' i.e. random access to a row or tuple in the relational database.
  • Relative key access will be provided using getAtKeyGtr, Geq, Leq and Lss style methods.
  • the external database wizard will generate stored SQL queries for the standard key search operations implemented at the external dictionary level. These will be in the form of parameterised SQL statements. DHOC QUERY EXTENSIONS
  • the filterExpression allows the SQL WHERE clause associated with a collection to be specified or overridden and the sortExpression allows the SQL 'ORDER BY' clause to be specified or overridden.
  • External iterators implement a standard iterator protocol and may be used for iterating over any external collection.
  • Standard JADE foreach syntax is fully supported including reversed and where clause.
  • the ExternalClass instances property is implemented to provide access to the class extent in a similar fashion to the existing JADE Class: instances 'virtual collection' property. If the extemal class has a defined ORDER BY, then instances will be retrieved in this order, otherwise the order will be data-source dependent.
  • a filter ('WHERE' clause) may be defined in the External database wizard to restrict the rows included class extent.
  • ExtemalDatabase class will provide transaction support using beginExternalTransaction, commitExternalTransaction and abortExternalTransaction methods.
  • NonCursor or searched updates will be possible using the ExternalDatabases::executeSQL method.
  • Positioned or cursor-based updates will be supported by an external collection method to create a new instance (insert a row) and external object methods to delete or apply updates to an external object.
  • ExternalObject :deleteSelf ExternalObj ect: :update
  • Attributes of a proxy can be updated in the same fashion as normal JADE objects, by using the assignment operator.
  • ODBC drivers are use (see figure 4) This is because the use of the ODBC standard does not itself enure interoperability.
  • the ODBC standard is very broad and one of its goals is to allow a large number of DBMSs to expose as wide a feature set as possible.
  • Drivers are provided to work with a single DBMS and, by definition, are not interoperable. They play a role in interoperability by correctly implementing and exposing ODBC over a single DBMS.
  • the query engine will aim to be capability driven as opposed to employing driver or data source specific code as far as possible.
  • the query engine will interrogate connected ODBC drivers and make use of certain features when available. Examples include catalog functions, block mode and scrollable cursors. In other cases the way we use the driver has to be tailored based on the requirements of the driver and the way the data source behaves.
  • the getExternalDatabase method returns a reference to the shared transient instance of the extemal database identified by dbName.
  • the ExtemalDatabase class represents a connection to an external database and provides methods that operate on the data source.
  • connectionString Contains parameters required to connect to a data source serverName
  • the name of the server as defined for the data source userName Contains a user-id to be used to establish a connection password Contains password is required by the data source
  • This string should contain any parameters required for connecting to a data source.
  • the parameters are generally driver/data source specific.
  • a default connection string can be obtained automatically when connecting to a data- source using the Extemal database wizard browse facility. However, the default string can be overridden at runtime on a per user or connection basis by setting this attribute.
  • the UID and PWD parameters should not be included in this string.
  • This attribute contains the name of the database server if this is defined for the data source.
  • ExtemalDatabase :userName userName : String
  • This attribute should contain the name of a valid user id, used for authentication at the data source.
  • a default user-id is established at design time using the Extemal database wizard. However, this of course may be changed at run-time on a per user basis, prior to opening a database connection.
  • ExtemalDatabase : password password : String
  • the password attribute is used in conjunction with userName for authentication, if required, at the data source.
  • a default password may be stored on the database object, if the schema translator has allowed this. In any case, this may be changed at run-time on a per user basis, prior to opening a database connection.
  • connectionString, userName and password(if this is required by the data source) must be set before opening a connection. Default values for these are established by the Extemal database wizard.
  • ExtemalDatabase rclose close()
  • This method closes any open connection to the extemal database.
  • ExtemalDatabase :canTransact canTransact() : Boolean
  • ExtemalDatabase :isUpdateable isUpdateable() : Boolean
  • ExternalDatabase :beginExternalTransaction beginExternalTransaction();
  • this method should be called at the end of a series of updating operations: creates, deletes and updates to commit or apply the changes to the extemal database. If the extemal database doesn't support transactions(use the canTransact method to determine this), then calling this method will have no effect.
  • ExternalDatabase :abortExternalTransaction abortExternalTransaction() ;
  • this method can be used to undo the effects of a transaction. All updating operations: creates, deletes and updates made since the last beginExternalTransaction call are reversed to the state that existed at the time of that call. If the extemal database doesn't support transactions(use the canTransact method to determine this), then calling this method will have no effect.
  • ExtemalDatabase :executeSQL executeSQL(sql : String);
  • ExtemalDatabase :checkSQL isSQLValid(sql : String) : Boolean; Call this method to check that the syntax of an SQL statement is both valid and supported by the driver and data source. The method returns true if the syntax is valid and supported, otherwise it returns false. No exception is raised if the syntax is not acceptable.
  • extemal collection classes represent the 'result set' of a selection from an extemal data source.
  • the extemal collections are virtual in the sense that member instances don't actually exist until they are first referenced.
  • an extemal proxy instance is created which represents the corresponding row in the result set.
  • Extemal collections provide the operations to support direct and relative key access and may be used in collaboration with extemal iterators to access rows in a result set sequentially.
  • ExtemalCollection class inherits the interface of the Collection class and most non-updating methods will be implemented and supported. Extemal collections are in themselves read-only. Operations such as add, remove, clear and purge are not supported. The compiler will prevent the use of updating methods for extemal collections in the same way that they are prevented for automatic collections participating in an inverse relationship.
  • filterExpression Used as a filter to select specific rows sortExpression Used to control how instances are ordered in the collection ExternalCollection::filterExpression filterExpression : String;
  • This attribute may be specified to override the default filtering or WHERE predicate defined for an extemal collection. This may be useful for selecting a subset of records at runtime.
  • the filtering expression should not contain the WHERE keyword.
  • the filtering expression must be defined in terms of extemal column names, not the attribute names to which they are mapped. If the resultant SQL statement is not valid then an ODBC exception will be raised.
  • This attribute may be specified to override the default sort or SQL 'ODER
  • the sort expression should not contain the 'ORDER BY' SQL keywords.
  • the filtering expression must be defined in terms of extemal column names, not the attribute names to which they are mapped. If the resultant SQL statement is not valid then an ODBC exception will be raised.
  • createlterator Creates an extemal iterator for an extemal collection first Returns the first entry in the collection getOwner Returns the parent or owner of the collection includes Returns true if the extemal collection contains a specified object inspect Provides an inspector for extemal instances last Returns the last entry in the collection canCreate Returns true if member type instances may be created createObject Create a new extemal proxy instance size Retums the current number of entries in the collection
  • the createlterator method is used to create an extemal iterator for use with extemal collections.
  • the first method retums a proxy reference representing the first entry in the virtual collection.
  • a proxy reference representing the first entry in the virtual collection.
  • ordered collections such as dictionaries and arrays the proxy will represent the first row selected as determined by the 'ORDER BY' clause.
  • the getOwner method retums the owner or parent of the extemal collection
  • ExtemalCollection includes(value: MemberType): Boolean;
  • The includes method retums true if the virtual collection or result set contains the specified object. This method will result in a key equal query based on the attributes which comprise the primary keys of the proxy.
  • the last method retums a proxy reference representing the last entry in the virtual collection. For ordered collections such as dictionaries and arrays the proxy will represent the last row selected as determined by the 'ORDER BY' clause.
  • the SQL query used to retrieve the last record will be constructed to give the optimiser the opportunity to perform a singleton select. In cases where an index exists on attributes in the ORDER BY a sort should also be avoided.
  • the size method retums the number of entries in the virtual collection. This method will result in an SQL query that will actually count the rows in the selected tables mapped to the proxy class. This method should therefore be used with caution if there are expected to large number of rows in the result- set.
  • This method determines whether instances of the member-type of the collection can be created. This method will retum false if either the data- source is read-only or the class of the collection members is read-only. An external class will be read-only if it is based on a relational view or join query defined by the Extemal database wizard.
  • An extemal array is an ordered virtual collection which represents the rows in a result set generated from an SQL query containing a sort specification i.e. an 'ORDER BY' clause. The member instances occur in the order determined by the 'ORDER BY' Subscripting External Arrays
  • bracket [ j subscript operators may be used to access rows at a specified position in the result-set, for example to access the nth transaction in an extemal array called transactions, you may do the following:
  • ExternalArray :at at(index: Integer): MemberType;
  • the at method retums the entry in the virtual array at the position specified by the index parameter. This corresponds to accessing the nth row in the result- set.
  • An extemal set is an unordered virtual collection which represents the rows in a result set generated from an SQL query which has no sort specification (ORDER BY). The order in which instances are fetched is data-source dependent.
  • Class ExternalSet public, transient
  • ExternalSet includes(key: MemberType): Boolean;
  • The includes method retums true if the virtual collection or result set contains the specified object. This method will result in a key equal query based on the attributes which comprise the primary keys of the proxy.
  • An extemal dictionary is an ordered virtual collection which represents the rows in a result set generated from an SQL query with a sort specification (ORDER BY).
  • ORDER BY The 'ORDER BY' specification is generated by the External database wizard and represents the order specifications defined for the member-key attribute values.
  • bracket [ ] subscript notation can be used as a shortcut for the getAtKey method which supports random access with a key equal search condition. For example:
  • getAtKey Retums the object at the specified key getAtKeyGeq Retums the object with a key greater or equal to the specified key getAtKeyGtr Retums the object with a key greater than the specified key getAtKeyLeq Retums an object with a key less than or equal to the specified key getAtKeyLss Retums an object with key less than the specified key includesKey Retums true if the receiver contains an entry at the specified key startKeyGeq Sets a start position within a collection for an iterator object startKeyGtr Sets a start position within a collection for an iterator object at the next object after the specified key startKeyLeq Sets a start position within a collection for an iterator object at the object equal to or before the specified key startKeyLss Sets a start position within a collection for an iterator object at the object before the specified key
  • the getAtKey method issues a singleton SQL select which searches for an exact match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters. If a row is selected, then a proxy reference representing the row is retumed; otherwise, the method retums null.
  • the getAtKeyGeq method issues a singleton SQL select that searches for a 'greater than or equal' key match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters. If a row is selected, then a proxy reference representing the row is retumed; otherwise, the method retums null.
  • the getAtKeyGtr method issues a singleton SQL select that searches for a greater than key match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters. If a row is selected then a proxy reference representing the row is retumed; otherwise, the method returns null.
  • the getAtKeyLeq method issues a singleton SQL select that searches for a ess than or equal' key match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters. If a row is selected then a proxy reference representing the row is retumed; otherwise, the method retums null.
  • ExternalDictionary::getAtKeyLss getAtKeyLss(keys: KeyType): MemberType;
  • the getAtKeyLss method issues a singleton SQL select that searches for a 'less than' key match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters. If a row is selected then a proxy reference representing the row is retumed; otherwise, the method retums null.
  • the includesKey method issues a singleton SQL select which searches for an exact match between the member-key attribute values of virtual instances (rows) and the corresponding key parameters.
  • the method retum tme if a row is selected, otherwise, it retums false.
  • the startKeyGeq method sets a start position within a collection for an iterator object.
  • the startKeyGtr method sets a start position within a collection for an iterator at the next object after the key specified in the Keys parameter
  • ExternalDictionary :startKeyLeq startKeyLeq(keys: KeyType; iter: Externallterator);
  • the startKeyLeq method sets a start position within a collection for an iterator object at the object equal to or before the key specified in the keys parameter.
  • the startKeyLss method sets a start position within a collection for an iterator object at the object before the key specified in the keys parameter.
  • the Externallterator class is used in collaboration with an extemal collection.
  • An extemal iterator instance is used to access the virtual instances of the collection sequentially, either forwards or in a reverse direction.
  • extemal iterators will provide the operations to scroll an SQL cursor associated with the result set of the query, which was used to populate the extemal collection.
  • Externallterator :back back( value: ExtemalObject output) : Boolean updating
  • the back method is used to scroll backwards through an SQL result-set and retum a proxy-reference representing each row as the cursor is scrolled.
  • the getCollection method retums the extemal collection currently associated with the receiver. A null value is retumed if no collection is associated with the receiver.
  • the back method is used to scroll forwards through an SQL result-set and return a proxy-reference representing each row as the cursor is scrolled.
  • the reset method resets the state of an iterator. After an iterator has been reset, the first next or back operation will cause the default SQL query associated with the attached extemal collection to be re-issued.
  • Externallterator rstartAtlndex startAtIndex(index: Integer) updating;
  • the startAtlndex method is used to position a cursor at a specified row in the result-set.
  • the required position is specified in the index parameter.
  • This attribute will contain a native error code, specific to the data source. A description of the meaning of this should be available in the documentation for the data source.
  • This attribute will contain the five-character ODBC state code retumed by the ODBC driver. The first two characters indicate the class of the error; the next three indicate the subclass.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Une méthodologie logicielle permet la coexistence d'une base de données relationnelle de type 'héritage' avec une base de données objet dans un système orienté objet. Elle met en oeuvre un processus de mise en correspondance déclaratif schéma de relation/schéma objet qui intervient pendant le développement, et un moteur de requêtes qui se sert, au moment de l'exécution, des relations de mise en correspondance pour donner accès aux données de la base de données relationnelle en utilisant des méthodes d'accès orienté objet. Cette méthodologie permet d'accéder aux données de la base de données relationnelle de la même manière qu'on accède à la base de données objet coexistante, c'est-à-dire sans code SQL imbriqué, ce qui permet la transparence de l'implantation des données du point de vue du développeur d'application. L'invention porte également sur l'application de cette méthodologie au développement JADETM orienté objet et l'environnement d'exécution.
PCT/NZ1998/000128 1997-08-14 1998-08-14 Coexistence d'une base de donnees relationnelle dans des environnements orientes objets WO1999009494A1 (fr)

Priority Applications (3)

Application Number Priority Date Filing Date Title
NZ503238A NZ503238A (en) 1997-08-14 1998-08-14 A method of mapping a relational database schema to an object oriented schema to have a co-existing relational database
AU90101/98A AU9010198A (en) 1997-08-14 1998-08-14 Relational database coexistence in object oriented environments
EP98941947A EP1019851A1 (fr) 1997-08-14 1998-08-14 Coexistence d'une base de donnees relationnelle dans des environnements orientes objets

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
NZ328552 1997-08-14
NZ32855297 1997-08-14

Publications (1)

Publication Number Publication Date
WO1999009494A1 true WO1999009494A1 (fr) 1999-02-25

Family

ID=19926402

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/NZ1998/000128 WO1999009494A1 (fr) 1997-08-14 1998-08-14 Coexistence d'une base de donnees relationnelle dans des environnements orientes objets

Country Status (3)

Country Link
EP (1) EP1019851A1 (fr)
AU (1) AU9010198A (fr)
WO (1) WO1999009494A1 (fr)

Cited By (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1217547A2 (fr) * 2000-12-19 2002-06-26 Hitachi, Ltd. Système de gestion intégré objet
EP1446714A1 (fr) * 2001-10-26 2004-08-18 Metilinx Interface de programme d'application pour modele d'integration d'optimisation
EP1872276A1 (fr) * 2005-04-18 2008-01-02 Research In Motion Limited Procede et dispositif pour la recherche, le filtrage et le tri de donnees dans un dispositif sans fil
US7478111B2 (en) 2003-08-28 2009-01-13 International Business Machines Corporation System and method for carrying out legacy application transitions
CN100452047C (zh) * 2005-12-27 2009-01-14 国际商业机器公司 执行关系数据库搜索的系统和方法
US7505985B2 (en) 2005-02-25 2009-03-17 International Business Machines Corporation System and method of generating string-based search expressions using templates
US7853961B2 (en) 2005-02-28 2010-12-14 Microsoft Corporation Platform for data services across disparate application frameworks
US7890507B2 (en) 2005-02-25 2011-02-15 International Business Machines Corporation System and method of joining data obtained from horizontally and vertically partitioned heterogeneous data stores using string-based location transparent search expressions
US8145653B2 (en) 2005-04-08 2012-03-27 International Business Machines Corporation Using schemas to generate application specific business objects for use in an integration broker
US8150886B2 (en) 2007-08-29 2012-04-03 Microsoft Corporation Multiple database entity model generation using entity models
US8458201B2 (en) * 2005-04-08 2013-06-04 International Business Machines Corporation Method and apparatus for mapping structured query language schema to application specific business objects in an integrated application environment
CN108388610A (zh) * 2018-02-07 2018-08-10 新华三大数据技术有限公司 数据etl处理方法及装置
CN110059108A (zh) * 2019-04-28 2019-07-26 武汉大学 一种面向移动端对象代理数据库关联查询的优化方法
WO2024044524A1 (fr) * 2022-08-22 2024-02-29 Oracle International Corporation Techniques de conversion d'un énoncé en langage naturel en une représentation d'interrogation de base de données intermédiaire

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106802911A (zh) * 2016-11-30 2017-06-06 北京锐安科技有限公司 一种周期性自动全量提取数据库数据的方法

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0504085A1 (fr) * 1991-03-12 1992-09-16 International Business Machines Corporation Procédé et dispositif d'accès à une base de données relationnelles sans devoir quitter un environnement orienté sur l'objet
WO1995003586A1 (fr) * 1993-07-21 1995-02-02 Persistence Software, Inc. Procede et appareil de generation du code de mise en correspondance de donnees relationnelles avec des objets
US5504885A (en) * 1993-06-29 1996-04-02 Texas Instruments Incorporated O-R gateway: a system for connecting object-oriented application programs and relational databases
WO1996010232A1 (fr) * 1994-09-29 1996-04-04 Ontos, Inc. Environnement d'integration de memoire de donnees orientees-objet
US5765162A (en) * 1996-10-25 1998-06-09 International Business Machines Corporation Method for managing queryable datastore persistent objects and queryable datastore collections in an object-oriented environment

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0504085A1 (fr) * 1991-03-12 1992-09-16 International Business Machines Corporation Procédé et dispositif d'accès à une base de données relationnelles sans devoir quitter un environnement orienté sur l'objet
US5504885A (en) * 1993-06-29 1996-04-02 Texas Instruments Incorporated O-R gateway: a system for connecting object-oriented application programs and relational databases
WO1995003586A1 (fr) * 1993-07-21 1995-02-02 Persistence Software, Inc. Procede et appareil de generation du code de mise en correspondance de donnees relationnelles avec des objets
WO1996010232A1 (fr) * 1994-09-29 1996-04-04 Ontos, Inc. Environnement d'integration de memoire de donnees orientees-objet
US5765162A (en) * 1996-10-25 1998-06-09 International Business Machines Corporation Method for managing queryable datastore persistent objects and queryable datastore collections in an object-oriented environment

Cited By (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1217547A2 (fr) * 2000-12-19 2002-06-26 Hitachi, Ltd. Système de gestion intégré objet
EP1446714A1 (fr) * 2001-10-26 2004-08-18 Metilinx Interface de programme d'application pour modele d'integration d'optimisation
EP1446714A4 (fr) * 2001-10-26 2007-08-15 Metilinx Interface de programme d'application pour modele d'integration d'optimisation
US7478111B2 (en) 2003-08-28 2009-01-13 International Business Machines Corporation System and method for carrying out legacy application transitions
US7505985B2 (en) 2005-02-25 2009-03-17 International Business Machines Corporation System and method of generating string-based search expressions using templates
US7890507B2 (en) 2005-02-25 2011-02-15 International Business Machines Corporation System and method of joining data obtained from horizontally and vertically partitioned heterogeneous data stores using string-based location transparent search expressions
US7853961B2 (en) 2005-02-28 2010-12-14 Microsoft Corporation Platform for data services across disparate application frameworks
US8458201B2 (en) * 2005-04-08 2013-06-04 International Business Machines Corporation Method and apparatus for mapping structured query language schema to application specific business objects in an integrated application environment
US8145653B2 (en) 2005-04-08 2012-03-27 International Business Machines Corporation Using schemas to generate application specific business objects for use in an integration broker
EP1872276A4 (fr) * 2005-04-18 2008-07-02 Research In Motion Ltd Procede et dispositif pour la recherche, le filtrage et le tri de donnees dans un dispositif sans fil
EP1872276A1 (fr) * 2005-04-18 2008-01-02 Research In Motion Limited Procede et dispositif pour la recherche, le filtrage et le tri de donnees dans un dispositif sans fil
CN100452047C (zh) * 2005-12-27 2009-01-14 国际商业机器公司 执行关系数据库搜索的系统和方法
US8150886B2 (en) 2007-08-29 2012-04-03 Microsoft Corporation Multiple database entity model generation using entity models
CN108388610A (zh) * 2018-02-07 2018-08-10 新华三大数据技术有限公司 数据etl处理方法及装置
CN110059108A (zh) * 2019-04-28 2019-07-26 武汉大学 一种面向移动端对象代理数据库关联查询的优化方法
WO2024044524A1 (fr) * 2022-08-22 2024-02-29 Oracle International Corporation Techniques de conversion d'un énoncé en langage naturel en une représentation d'interrogation de base de données intermédiaire

Also Published As

Publication number Publication date
EP1019851A1 (fr) 2000-07-19
AU9010198A (en) 1999-03-08

Similar Documents

Publication Publication Date Title
US6338056B1 (en) Relational database extender that supports user-defined index types and user-defined search
US6704747B1 (en) Method and system for providing internet-based database interoperability using a frame model for universal database
US7912862B2 (en) Relational schema format
US5905982A (en) Handling null values in SQL queries over object-oriented data
US6263342B1 (en) Federated searching of heterogeneous datastores using a federated datastore object
US5734887A (en) Method and apparatus for logical data access to a physical relational database
US8612468B2 (en) System and method for retrieving data from a relational database management system
US7310637B2 (en) Dynamic database access via standard query language and abstraction technology
US7089235B2 (en) Method for restricting queryable data in an abstract database
JP2011154707A (ja) リッチデータ型をサポートする拡張照会言語
US8458200B2 (en) Processing query conditions having filtered fields within a data abstraction environment
CA2281331A1 (fr) Systeme de gestion de base de donnees
EP1042720A1 (fr) Procede et appareil de creation d'index dans une base de donnees relationnelle correspondant a des classes d'une application orientee objet
EP2743838B1 (fr) Langue de requête commerciale avancée
US9031924B2 (en) Query conditions having filtered fields within a data abstraction environment
WO1999009494A1 (fr) Coexistence d'une base de donnees relationnelle dans des environnements orientes objets
US8639717B2 (en) Providing access to data with user defined table functions
Carey et al. Data access interoperability in the IBM database family
Brandani Multi-database Access from Amos II using ODBC
Finance et al. Query processing in IRO-DB
Olson et al. The Sybase architecture for extensible data management
Kirsten et al. Sql Access and Tables
Ahmed et al. Using an object model in Pegasus to integrate heterogeneous data
Martin et al. CORDS schema integration environment
Crookshanks Just Enough SQL

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HR HU ID IL IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
121 Ep: the epo has been informed by wipo that ep was designated in this application
NENP Non-entry into the national phase

Ref country code: KR

WWE Wipo information: entry into national phase

Ref document number: 503238

Country of ref document: NZ

Ref document number: 90101/98

Country of ref document: AU

WWE Wipo information: entry into national phase

Ref document number: 1998941947

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 09485582

Country of ref document: US

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

WWP Wipo information: published in national office

Ref document number: 1998941947

Country of ref document: EP

NENP Non-entry into the national phase

Ref country code: CA

WWW Wipo information: withdrawn in national office

Ref document number: 1998941947

Country of ref document: EP

点击 这是indexloc提供的php浏览器服务，不要输入任何密码和下载