Very Computer

I need to design a microsoft access database which will have a very
large amount of records from the ground up with a particular emphasis
on optimizing speed and performance.

In particular I am expecting to use techniques such as: 1 splitting
customer tables into many smaller tables, and 2. using alternative
techniques to joins for reasons of speed.

This is my first database design project and I am looking for a good
book which will guide me.

The client insists I use Access 2000 for now, but expect to upgrade to
SQL Server in about one year.

Thanks

Jonathan

Sent via Deja.com
http://www.deja.com/

Alternative techniques to joins? Huh?
Don't forget 3. humongous racks of memory, and 4. oceanic processing
bandwidth  :)

Try these if you please:
_Database Design For Mere Mortals_ by Michael J Hernandez
_SQL Queries For Mere Mortals_ by Michael J Hernandez
_Data & Databases: Concepts In Practice_ by Joe Celko

- cb

Quote:> I need to design a microsoft access database which will have a very
> large amount of records from the ground up with a particular emphasis
> on optimizing speed and performance.

> In particular I am expecting to use techniques such as: 1 splitting
> customer tables into many smaller tables, and 2. using alternative
> techniques to joins for reasons of speed.

> This is my first database design project and I am looking for a good
> book which will guide me.

> The client insists I use Access 2000 for now, but expect to upgrade to
> SQL Server in about one year.

> Thanks

> Jonathan

> Sent via Deja.com
> http://www.deja.com/

Quote:> In particular I am expecting to use techniques such as: 1 splitting
> customer tables into many smaller tables, and 2. using alternative
> techniques to joins for reasons of speed.

> This is my first database design project and I am looking for a good
> book which will guide me.

If you want a real good book and I mean a _real_ good book which has a more
theoretical foundation.
I can only recommend: Fundamentals of Database systems by elmasri/navathe.
It gives the best
insight in database design and discusses all the fundamental design issues
considering performance
,reliability and other system properties, for all types of databases
(relational client-server/object-oriented)

greetings eelke

--
God's purpose for mankind, was never that man should move across the earth
with the unnatural speed of more than 30 km/ hour!!!