Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Help with complex db design concepts

Re: Help with complex db design concepts

From: Todd Benson <toddb_at_spectralogic.com>
Date: 9 May 2002 10:29:13 -0700
Message-ID: <97b61782.0205090929.4575ece8@posting.google.com>


zaq42_at_yahoo.com (zaq) wrote in message news:<185bc2bb.0205081416.bd80df4_at_posting.google.com>...
>
> Consider a database where my tables represent spatial entities, such
> as buildings, roads, utility poles, bodies of water, etc... This set
> of entities is fixed, but over 1000.
>
> Now consider a database designed to associate documents with one or
> more of these entities. Users will need to search all documents, as
> well as search for documents associated with spatial objects.
>

I have run into a similar situation, but be careful. If you have to ask a question like, what is the general location (i.e. state) of all of the spacial entities associated with a particular document? Then it will be difficult. You will either have to outer join with every spacial entity table and look for non nulls (that's more than 1000 tables you said!), or you will have to go through a procedure:

There are probably many ways to deal with this, but they depend on what type of questions you need to ask about the data.

Todd Received on Thu May 09 2002 - 12:29:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US