Re: Expect to work with terrabytes.. now what?

In article <377bebaa.0_at_tahiti.alcom.co.uk>,   "Simon Riggs" <sriggs_at_open-mind.co.uk> wrote:
> Why have you chosen the tools before you understand the potential
pitfalls
> of those tools? We recommend an open minded approach to technical
strategy
> and tools selection.
>

Simon:

I'm not the original poster so can't answer for him/her. However, my experience is that these things happen because of decisions higher-up. For example, I worked on a three-tier system last year using Java, CORBA and an RDB. It so happens that the RDB was DB2. The reason this was chosen was not on technical grounds, but beacuse the company has a good relationship with IBM and DB2 is the product of choice for all major developments.

> I think you should look long and hard at NCR Teradata. You may still
decide
> to go with Oracle, but at least you will do so based on informed
choice.

See above.

>
> NCR Teradata sales staff will tell you all the problems associated
with
> running 1-10Tb on Oracle. I'm sure IBM people will provide useful
insight
> into this challenge also.
>
> Please come back to me for a balanced opinion....!
>
> Simon Riggs
> Managing Consultant
> Info Management Practice Group
> OpenMIND Consulting
> Voice: +44-1869 238080
> http://www.open-mind.co.uk
>
> > > Ferdinand Swaters wrote:
> > >
> > > > Hi All,
> > > >
> > > > I am currently on a project where the data in my database is
going
> > to run
> > > > into the 1-10 Terabyte range. I have no experience with these
sizes
> > of data
> > > > in a DBMS, and I am wondering what new pitfalls I might run
into.
> > > >
> > > > The system will do almost no updates on the data, most is
storage
> > and then
> > > > delete after a while. There won't be many queries on the data,
but
> > the
> > > > queries will be large. It is much like a data warehouse
situation.
> > The DBMS
> > > > will be oracle.
> > > >
> > > > I don't have a good idea on what questions to ask first, because
> > I'm mainly
> > > > concerned about the things I might forget now, and run into when
> > the beast
> > > > is operational. One thing that I would like to know is if there
is
> > a way I
> > > > could compress the data while it is in the database. That would
> > reduce
> > > > storage space required by a huge factor.
> > > >
> > > > Anyone has some experience they wish to share?
> > > >
> > > > advTHANKSance,
> > > >
> > > > Ferd.
> > >
>
>

akmal

--
email: akmal(at)bigfoot(dot)com || http://www.bigfoot.com/~akmal/
"I need a job where my immense ego seems normal." - Dogbert
DISCLAIMER: I work for Computer Associates and my opinions are my own.


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.