Hi Michael, On Jun 23, 2011, at 9:36 AM, Starch, Michael D (388L) wrote:
> Brian Foster, Developers, > > This question is regarding the work I am doing to develop the column based > database. > > As I understood it we created views joining the three tables (Metadata, > Reference, XREF) so that accesses to this data was at one central point, and > the db handled the join. > > As of now the code only uses the view to get a list of distinct productid > (which could be done easily with out the view) and where I believed the views > would help, the tables are accessed individually in sequence. > > Is this a result of unfinished migration to using views? or is there some > issue with using the views that I am missing. > > Was the code designed to handle multiple references per product? As I > understand it it is not...but I could be mistaken on this point. If it does > not handle them, it should, correct (for hierarchical types)? +1. The code should work for hierarchical types as well (aka multiple refs per product, and refs heirarchically organized within a particular directory structure). Cheers, Chris ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: [email protected] WWW: http://sunset.usc.edu/~mattmann/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
