http://www.oracle.com/solutions/business_intelligence/partitioning.html
Partition for Improved Performance
Partitioning enables tables and indexes to be split into smaller, more manageable components and is a key requirement for any large database with high performance and high availability requirements. Oracle Database 11g offers the widest choice of partitioning methods including interval, reference, list, and range in addition to composite partitions of two methods such as order date (range) and region (list) or region (list) and customer type (list). Oracle Partitioning—an option to Oracle Database 11g Enterprise Edition—is also foundation of Oracle's Information Lifecycle Management strategy, which aligns the business value of information to cost-effective storage tiers for large data warehousing and transaction processing applications.
Oracle Information Lifecycle Management (ILM) is a set of automated solutions that work with Oracle Database 11g to enable you to use multi-tier storage to dramatically lower the cost of storing application data. Oracle Partitioning seamlessly moves data to the appropriate storage tier based on its activity level. Oracle Advanced Compression works across all storage tiers to reduce the amount of disk space data requires. Oracle ILM brings these automated solutions together to streamline data management, improve performance for mission-critical systems, and greatly reduce the cost of storage.
No comments:
Post a Comment