Oracle Partitioning

Oracle Business Intelligence BI Software : Oracle Data Warehousing : Oracle Partitioning

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.

BENEFITS

• Faster Performance—Lowers query times from minutes to seconds
• Increases Availability—24 by 7 access to critical information
• Improves Manageability—Manage smaller 'chunks' of data
• Enables Information Lifecycle Management—Cost-efficient use of storage

Source: For more information, please visit http://www.oracle.com/solutions/business_intelligence/partitioning.html