Database Architecture for keep tera byte of data

Hi

we are keeping five yeare of data which can be gone up to terabyte in size . when we are retreaving the data it will take more time to view the report .please send us the database architectur or way of keeping data to speeded up the reporting.

We have indexed the table.

Thanks

Pubudu

I recommend the Fast Terrabyte Database Architecture (patent applied for but declined) methodology. This architecture is known to be the fastest in the world. I have witnessed retrieval times faster than selecting a single record from a row of 5!! Also this method requires no indexing what-so-ever.

Unfortunately, the secret to this architecture died with it's inventor, C.J. Time. So I now recommend the Database Tuning Advisor. As for architecture, if you could provide a few more details, I'll bet some better advice would be forthcoming.

|||

Hi

I can give u a details about the database.

Thats having 25 tables.It uses for Point of Sales (pos) system.Data is comming from more than 100 branches.Therefore there can be

more than 10000 records for a day per outlet.From those all outlets data is comming to the head office database.So we are taking the

reports using centraldata base management desision making purposes.

Thanks

Pubudu

|||

10,000 records per day per outlet x 100 outlets is 1 million records per day x 220 business days per year x 5 years is ~ a billion records.

My approach would be to roll up into a data warehouse daily for analysis.