More composite types
were added in Oracle Database 11g including list-hash, list-list, list-range, and rangerange
partitioning. Interval partitioning was also added in Oracle Database 11g,
providing automatic creation of range partitions when needed.
Other Software for the Data Warehouse
A data warehouse isn??™t necessarily built with a single software product, nor is it simply
a database. In addition to the database capabilities we??™ve described, if you??™re
going to build an effective data warehouse topology like the one we??™ve outlined, your
software will provide the following functionality:
Other Software for the Data Warehouse | 237
Extraction of data from operational data sources
The movement of needed data from source systems for the purpose of loading a
data warehouse. This process might involve extracting a large amount of bulk
data or a steady stream of incremental changes.
Transformation and/or cleansing of data
Because the data in a data warehouse can come from many different sources, the
data must frequently be converted into a common format.
Pages:
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522