Shadow Tables

Multiple uses for the same data

There are times when the same database table has multiple uses. For example a table holding zip codes may be used by the dealer, city, and listing tables holding the automobile dealers, cities and actual listings themselves. A dealer may have a different zip code than the listing so which zip code do we use? Since we are really talking about different paths between tables we need more than one instance of a table. In this case we would use a shadow table. A shadow table is simply another instance in the dGraph definition of a physical database table. With this new instance you can define a unique path to the primary table and as such pull out the data based on that new path.

page_revision: 0, last_edited: 1206307878|%e %b %Y, %H:%M %Z (%O ago)
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License