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

Reply via email to