using inheritance in object oriented database

Posted on 2007-10-02
Last Modified: 2012-06-21
hi all,
my thesis in oodb and specifically in inheritance and its problems
1. which products you preferred to work in, which have full oo featurs (Like slq server, Oracle, DB2, db4o) and why ?
2. how the inheritance work in selected product
3. the internal structue of inheritace (how classes related togother and inheritance done)
4. any related documents, papers, slides discuss this article (new one)

i know how oo works in oopl, and i know in the past full oodb not supported in any one
and its covered in ORDB
i thiks oracle ver 9,10 support oo and db4o ver6.3 ,,, but what about sql server 2005

with bist regards
Question by:Sanad78
    LVL 9

    Accepted Solution

    oracle, sql server and many other known database platforms are typical relational databases. they have some features to support oo programming, but database az whole is not oo. as i know, they sucessfuly support encapsulation, but not any other features of oo.
    object databases should use OQL (Object Query Language) insetead of SQL, which is used in  realtional database. i cannot recommend you any existing object oriented database product, because i don§t know any.
    LVL 27

    Assisted Solution

    1) as konektor points out, the database that you name are not object-oriented, they are relational.

    This is a list of object-oriented database:

    I don't know of any company using object-oriented databases.


    Author Comment

    i found this note from Comparing SQL Server 2005 and DB2 8.2: Focus on Development Productivity
    SQL Server Technical Article, Published: July 2005

    " DB2 UDB structured types can use object-oriented concepts such as inheritance and dynamic method dispatch. You define inheritance hierarchies by using the "UNDER" keyword in the CREATE TYPE statement. Dynamic method dispatch refers to the fact that methods of the base type can be reimplemented in derived types; at runtime, control will be dispatched to the appropriate method implementation depending on which type is used.
    Support of specific functionality above the user-defined type functionality is provided in DB2 UDB 8.2 through an Extender architecture. Extenders may include user-defined types, user-defined functions, special tools, support applications, and APIs.
    While SQL Server UDTs can be structured types or simple types in theory, it is not recommended to use UDTs for data that contains more than a single fact. For example, even though a date can be represented as month, day, and year, a date represents a single fact. SQL Server UDTs are meant to extend the scalar type system, not to implement structured types. SQL Server UDTs do not support inheritance or dynamic method dispatch when invoked from Transact-SQL. You can use UDTs as columns, but SQL Server has no concept of typed tables, typed views, or references to types.
    this mean there is applying for oo featurs like inheritance in oodb ,,, but how ,, i dont kow

    Author Comment

    hi all
    this site have many answers
     i will try db4o database using .Net and then discuss the results

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now