[DB-SIG] (slightly off topic) Very Large Database recommendations?

[M.-A. Lemburg]

Ken Seehart wrote:
> I have a potential very large database application with these very 
> approximate specs:
> 
> Overall size: 1TB (growing by 1TB every few years or so)
> 1,000,000 new rows per day in the main table (never deleted, so this is 
> also a growth rate)
> 2KB per row
> 1,000 queries per minute
> 
> Very simple table structure.
> 
> I suppose that python is not really relevant to the question since it 
> would be a web database service where the client is python.
> 
> Right now I am interested in getting an idea of how much such a system 
> would cost, and where to look for solutions.
> 
> Any ideas where I could look for information relevant to this question?

The table size doesn't look all that big. Any of Oracle, DB2 or
even PostgreSQL should be able to handle it.

For larger databases you should have a look at special
database systems such as TeraData and Netezza.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Oct 04 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611