Thanks to you all..

[Mahalakshmi Narayanan]

Hi!

Thanks for your immediate response!

"A Data Warehouse is a repository of integrated
information, available for queries and analysis. Data
and information are extracted from heterogeneous
sources as they are generated....This makes it much
easier and more efficient to run queries over data
that originally came from different sources."

Big databases as you had rightly put. A data warehouse
for Census datawarehouse would contain, say, data from
1901 upto current census.  It would enable us to
analyse the growth rate of many factors with many
parameters over time scale (different dimensions of
data analysed for facts!).  Data Mining could
correlate different factors which are otherwise taken
for disconnected. (For ex. bread and butter/jam are
many times bought together and so on.. for a decision
maker, keeping these items together would benefit in
making the customer buy both and so on..)  Many
commercial products are available for datawarehouse
building/analysing. For ex. SAS, IBM Business
Intelligence, COGNOS are a few and database services
include Oracle OLAP Service, MS SQL OLAP, etc.. Many
leading datawarehousing products combine GIS for
effective analysis and planning.

Hope that was n't too much!

Also, it would be very helpful if you could let me
know how to add proper indexing support to the OGR
MITAB driver, pls..

With regards,
Mahalakshmi Narayanan




--- Frank Warmerdam <warmerdam at POBOX.COM> wrote:

> Mahalakshmi Narayanan wrote:
> > 1.  Is there any open source tool available for
> > datawarehousing? if so some links would be
> > appreciated.
>
> Hi,
>
> I don't know too much about data warehousing.  In my
> mind it
> is equated with holding all the data in a big
> database.  Perhaps
> you could be more specific about the datawarehousing
> capabilities
> you need for those of us not to "up" on such IT
> terms.
>
> > 3.  Is there any tool to convert shape file to
> indexed
> > tab file? ogr2ogr does convert shapefile
> >
> > to tab file but the resultant tab file requires to
> be
> > indexed on specific fields.  This I don't know how
> to
> > do. If somebody could throw some light on this, it
> > would be of great help to us.
>
> There is support in the MITAB library for indexing
> attribute fields but
> the OGR library doesn't utilize it.  You could
> potentially write a small
> standalone utility using MITAB to index fields, or
> we could work together
> to add proper indexing support to the OGR MITAB
> driver. Ironically, the
> OGR Shapefile driver actually uses the MITAB
> attribute indexing support to
> build .dbf indexes in the mapinfo format.
>
> Best regards,
> --
>
---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank
> Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows |
> http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial
> Programmer for Rent
>

--- Frank Warmerdam <warmerdam at POBOX.COM> wrote:

> Mahalakshmi Narayanan wrote:
> > 1.  Is there any open source tool available for
> > datawarehousing? if so some links would be
> > appreciated.
>
> Hi,
>
> I don't know too much about data warehousing.  In my
> mind it
> is equated with holding all the data in a big
> database.  Perhaps
> you could be more specific about the datawarehousing
> capabilities
> you need for those of us not to "up" on such IT
> terms.
>
> > 3.  Is there any tool to convert shape file to
> indexed
> > tab file? ogr2ogr does convert shapefile
> >
> > to tab file but the resultant tab file requires to
> be
> > indexed on specific fields.  This I don't know how
> to
> > do. If somebody could throw some light on this, it
> > would be of great help to us.
>
> There is support in the MITAB library for indexing
> attribute fields but
> the OGR library doesn't utilize it.  You could
> potentially write a small
> standalone utility using MITAB to index fields, or
> we could work together
> to add proper indexing support to the OGR MITAB
> driver. Ironically, the
> OGR Shapefile driver actually uses the MITAB
> attribute indexing support to
> build .dbf indexes in the mapinfo format.
>
> Best regards,
> --
>
---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank
> Warmerdam, warmerdam at pobox.com
> light and sound - activate the windows |
> http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial
> Programmer for Rent
>




__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail