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!!

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

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.

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!!