Federated Tables versus Views

2010-10-08 Thread Wellington Fan
Hello All, What should I consider when trying to choose between a Federated table and a View when I have one table's data that I'd like to be available in other databases on the same host. My view definition would be something like: CREATE [some options] VIEW [this_db].[this_view] AS

data modeling question

2002-10-31 Thread Wellington Fan
Hello all, I have an 'items' table with 2 'types' of items -- 'foo' & 'bar' Say that items of type 'bar' may be further classified as 'subtypes' 'baz', 'quux', etc. Now I build an online store so that visitors may buy items. Contstraints 1.) I would like to, as much as possible, use the same c