Re: [SQL] [HACKERS] Schema boggle...

2003-11-09 Thread Chris Bowlby
Hi Marc, I was actually leaning towards schema's as a method to partition the data out when I was beginning to plan AMS 2, your suggestions of schema's confirmed this as a good approach for what we were looking for so I started to code the initial layout for the Schema in April/May, but at the

Re: [SQL] [HACKERS] Schema boggle...

2003-11-05 Thread Josh Berkus
Chris, > Monolithic tables have their uses, I don't and wont contest that, however > we've been using a monolithic structure in our current AMS distribution and > dataset. That and I'm more confident working on a 3D level, versus 2D, the > schema levels introduce the third dimension into my str