Data Warehousing - Partitioning Strategy - Partitioning is done to enhance performance and facilitate easy management of data. Partitioning also helps in balancing the various requirements of the system.

Amazon Web Services – Strategies for Migrating Oracle Database to AWS December 2014 Page 4 of 38 Data Migration Strategies The migration strategy you choose depends on several factors: — The size of the database — Network connectivity between the source server and AWS — The version and edition of your Oracle Database software Adopting a Software Maintenance Strategy for a DB2 UDB Data Warehouse Overview The purpose of this paper is to discuss software maintenance strategies for the data warehouse. Though composed of multiple technologies, the data warehouse will be referred to as a “system” maintained by skilled professionals.