Oracle Data Warehouse - Exadata

-->

Company - DW Product	Oracle - Exadata
Company	Oracle has three businesses: database, applications, and consulting. Its database business is the largest by far and currently represents 80 percent of Oracle’s new license revenues.
Product URL	https://www.oracle.com/database/data-warehouse/index.html
STRENGTHS	- Intelligent Storage Grid - Hybrid Columnar Compression - Smart Flash Cache
WEAKNESSES
Deployment Platforms	IBM AIX Hewlett-Packard HP-UX Linux Microsoft Windows Sun Solaris
Server Architecture	Single server platform Distributed database Real Application Cluster (RAC) • Shared, partitioned data • Multiple server platforms • Server interconnect • Any number of readers and writers
Data Type Support	Oracle built-in data types (SQL types): • Numeric • Binary • Character • Date time Large objects (max 2 gigabytes) User-defined types (object-oriented types, object identifier types, arrays, nested tables) Oracle-supplied types • Spatial • Media • Text • XML
Physical Design Recommendation	Neutral on the physical design of data warehouses.
Physical Implementation	Manual Template-based via templates and Database Configuration Assistant (DBCA) tool Automated via Oracle managed files
Custom Transformations	May be written in: SQL PL/SQL
Summary Table Support	Materialized views automate the creation and management of summary tables. A materialized view stores the results of a query in a table
SQL Extensions	CUBE and ROLLUP in SELECT Functions • Ranking • Window aggregate • Reporting aggregate • Lag/lead • Linear regression • Inverse percentile • Hypothetical rank and distribution • First/last • Numeric • Date time User-defined
OLAP	Oracle OLAP is a separatelypackaged and -priced product that provides OLAP functionality
Data Mining	Oracle Data Mining is a separately- priced and -packaged product.