|
Database Implementation, Migration |
Oracle Database 10g is the industry's first database designed for grid computing. Low entry-level pricing makes Oracle the best choice for large enterprises and small to mid-size businesses alike, with a variety of editions to choose from.
Industry-leading scalability, reliability and security Oracle Database Enterprise Edition offers industry-leading scalability and reliability in clustered as well as single-system configurations. It provides comprehensive features for online transaction processing (OLTP) and business intelligence and delivers the lowest total cost of ownership.
Enterprise Edition includes:
- Continuous availability despite system failures, site failures, human errors, and planned maintenance
- State-of-the-art security features that address rapidly emerging requirements in the areas of privacy, regulatory compliance, and data consolidation, including Virtual Private Database, Fine Grained Auditing, and database encryption
- High-performance business intelligence capabilities such as ETL, data warehousing, online analytic processing (OLAP), and data mining
Oracle Database Enterprise Edition delivers record-breaking performance and scalability on systems from small departmental servers running Windows or Linux to the largest UNIX servers and mainframes. And Oracle is the only database to have successfully completed 19 independent security evaluations.
Data Migration
There aren't many medium sized companies these days that don't already have a multitude of existing systems and piles of data. Any new system will invariably require a migration of data from existing systems. This can be purely standing data, such as product migration, or it can include historical data too, such as details of sales transactions. The average data warehouse will have both standing and historical data but further complications will arise over time as a result of changes in standing data.
Therefore we have devised a method for planning, building and running data migrations, encompassing:
- Mapping Specification and Verification
- Data extraction
- Data conversion
- Data mapping, cleansing and transformation
- Data validation and verification
- Bulk and incremental data loading
|
|
|