Posted by SQL Menace on 07/15/07 13:27

On Jul 15, 8:34 am, raylopez99 <raylope...@yahoo.com> wrote:
> On Jul 15, 5:15 am, SQL Menace <denis.g...@gmail.com> wrote:
>
> > Also how will you do one of these queries
> > return all customers who live in LA and have ordered product x between
> > June 2006 and July 2007
>
> > Denis The SQL Menace
>
> You wrote your dB is 300 GB--but how much of this is raw data?
> Perhaps 10%? The other 90% is junk to link the data (I'm guessing).
> If so, you can buy 30 GB of RAM and when x86/Windows supports 64 bit
> better (though I think they already do--Itanium?) you can access this
> 30 GB with no problem. 30 GB RAM costs about $1000. Not expensive.
>
> As for the query: " > return all customers who live in LA and have
> ordered product x between > June 2006 and July 2007"
>
> This is simple using a flat file as I propose: "customers & (order*
> or purchase or buy*) & product x & (DATE T (June 2006 < T < July
> 2007))". Suitable code can be written to make these Boolean operators
> work. Some cleanup might be required to strip out false hits, but
> these false hits are present in regular databases today. Also
> remember right now with RDBMS you expend a tremendous amount of work
> putting data into "orthogonal" databases, via data entry forms. You
> have to pay people to enter the data correctly (even if your program
> rejects bad data entry, you still have to pay people to enter the data
> correctly). You can avoid all of this with a flat file. Just dump
> the raw data into memory and let an inference or search engine index
> the data and make the associations via pointers.
>
> RL

One more thing (I sound like Steve Jobs don't I?)
Let's say your site is Digg.com, Digg has over a million users, they
use about 60 webservers
Right now the webservers talk to the DB and they all see the same data
How would you accomplish that with your memory solution?

You also asked for books here are 3 I recommend

Inside Microsoft SQL Server 2005: T-SQL Querying
http://www.amazon.com/gp/product/0735623139/102-1687136-8876917?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0735623139

Pro SQL Server 2005 Database Design and Optimization
http://www.amazon.com/gp/product/1590595297/102-1687136-8876917?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=1590595297

The Guru's Guide to Transact-SQL (SQL server 2000)
http://www.amazon.com/gp/product/0201615762/102-1687136-8876917?ie=UTF8&tag=sql08-20&linkCode=xm2&camp=1789&creativeASIN=0201615762



Denis The SQL Menace
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx

[Back to original message]