Hi,
regarding the size, I would be more interested on the space in Gbytes
I am use to work with Oracle,Teradata, DB2 ... and they all handle
partitioning in different ways, when it comes to a big datawarehouse ( and I
am talking about Terabytes), there are two key features that need to be
handle by the RDBMS system:
1. Paritioning of data
2. Parallelism (being able to split the workload of a query between several
processes , all accessing at the same time different blocks of data of the
same table located in the same hard-disk or not), this feature can make a
full table scan of a terabyte talbe to be procesed pretty quick), otherwise
it would not be realistic
Regarding partitioning below there is an example of what I mean (this is
basically the way Oracle works in 8.1.x)
extracted from a previous email:
... if I use the MERGE thing, will the sql parser be able to access only the
right partition(table)
ie:
Imagine we partition by month a fact table containing data for two months so
we end up with 2 tables :
fact_april and fact_may
and then we merge them into on fact table called fact_merge
this is the squema design:
lu_month(month_id)
lu_day(day_id,month_id)
fact_may2001(day_id,sales)
fact_april2001(day_id,sales)
fact_merge (day_id,sales) // this one is the result of mergin fact_may
and fact_april
now if I run the following query:
select sum(sales) from fact_merge where day_id='05/05/2001'
or
select sum(sales) from fact_merge where day_id between '05/05/2001' and
'06/05/2001'
or
select sum(sales) from fact_merge where day_id in (select day_id from
lu_month where month_id=200105)
will this queries be redirected by the MySql parser to the fact_may2001
table or will MySql scan the full fact_merge
table (basically all partitions)
This is the way most of the RDBMS systems supporting partitioning work,
otherwise you would have to set the partitioning
logic on the application side.
thanks.
>From: "Gelu" <[EMAIL PROTECTED]>
>To: "Oscar Colino" <[EMAIL PROTECTED]>
>Subject: Re: Datawarehousing
>Date: Fri, 8 Mar 2002 15:48:16 +0200
>
>Hi,
>
> > what is the size of the warehouse?
>The size of the Finish Goods Warehouse are : 40 types and manage cca.
>300.000 pieces.
>
> > how do you handle partitioning logic on the database?
>...IT'S MADNESS.
>From what point of view are you interested ?
>
>
>
>----- Original Message -----
>From: Oscar Colino <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Friday, March 08, 2002 12:37 PM
>Subject: Re: Datawarehousing
>
>
> >
> > what is the size of the warehouse?
> > how do you handle partitioning logic on the database?
> >
> >
> > >From: "Gelu" <[EMAIL PROTECTED]>
> > >To: "Oscar Colino" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
> > >Subject: Re: Datawarehousing
> > >Date: Fri, 8 Mar 2002 14:04:29 +0200
> > >
> > >Yes....
> > >----- Original Message -----
> > >From: Oscar Colino <[EMAIL PROTECTED]>
> > >To: <[EMAIL PROTECTED]>
> > >Sent: Friday, March 08, 2002 11:52 AM
> > >Subject: Datawarehousing
> > >
> > >
> > > > Anybody out there using Mysql as a Datawarehouse?
> > > >
> > > > _________________________________________________________________
> > > > Get your FREE download of MSN Explorer at
> > >http://explorer.msn.com/intl.asp.
> > > >
> > > >
> > > >
>---------------------------------------------------------------------
> > > > Before posting, please check:
> > > > http://www.mysql.com/manual.php (the manual)
> > > > http://lists.mysql.com/ (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > ><[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
>http://lists.mysql.com/php/unsubscribe.php
> > > >
> > > >
> > >
> > >
> > >---------------------------------------------------------------------
> > >Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > >To request this thread, e-mail <[EMAIL PROTECTED]>
> > >To unsubscribe, e-mail
> > ><[EMAIL PROTECTED]>
> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> >
> > _________________________________________________________________
> > Send and receive Hotmail on your mobile device: http://mobile.msn.com
> >
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
