Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    4

    Unanswered: Covering/Disjointeness on a View

    Hi everybody.

    I am a student and working on a project that works on db schemas.

    My problem is now, that I have to create views on given entities and determine wheter it covers the parent relation or it is disjoint with its siblings.

    All this must be done by just looking at the metadata ..


    Any ideas ?

    Thanks in advance!!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yeah
    my idea is to examine the metadata for what ever SQL engine you are using
    understand that data, understand how that engine defines its structure, tables indexes and so on.
    usually the data you want is in the schema.
    in MySQL its information_schema
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jul 2009
    Posts
    4
    Hey healdem.

    Thank you for your quick response.

    That is exactly what I am doing right now. The JDBC driver for MySQL. Postgres, Oracle (the ones that I am using) gives me the metadata.

    I just don't know how to use that data to make assumptions on the type of view.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so either track down the documentation for that db

    or

    create a series of tables which have the features you want and examine the meta data, spot the differences, analyse what settings your db uses to define relationships, foreign keys datatypes and so on.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jul 2009
    Posts
    4
    Quote Originally Posted by healdem
    so either track down the documentation for that db

    or

    create a series of tables which have the features you want and examine the meta data, spot the differences, analyse what settings your db uses to define relationships, foreign keys datatypes and so on.

    Good idea. I will try.

    Thank you!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •