Friday 6 September 2013

Exadata

Recently worked on a project which involved Exadata DB Machines. It was about moving terabytes of data to exadata. The database machine and its features was a good use for high volume of data.

Introducing an Exadata Database Machine into an existing environment involves, for most IT organizations, adoption of several technologies that may not be familiar.  Some of these technologies include:
Oracle 11gR2
Real Application Clusters
Automatic Storage Management
Exadata storage
Enterprise Linux
InfiniBand networking

Some features which we used :
Hybrid Columnar Compression
Compressing data can provide dramatic reduction in the storage consumed for large databases. Exadata provides a very advanced compression capability called Hybrid Columnar Compression (HCC).
Average storage savings can range from 10x to 15x depending on how HCC is used.  With average savings of 10x IT managers can drastically reduce and often eliminate their need to purchase new storage for several years.

Smart Scan Predicate Filtering :

Exadata enables predicate filtering for table scans. Only the rows requested are returned to the
database server rather than all rows in a table. For example, when the following SQL is issued
only rows where the employees’ hire date is after the specified date are sent from Exadata to the
database instance.
SELECT * FROM employee_table WHERE hire_date > ‘1-Jan-2003’;
This ability to return only relevant rows to the server will greatly improve database performance.
This performance enhancement also applies as queries become more complicated, so the same
benefits also apply to complex queries, including those with subqueries.
  

 Few of the areas I have worked in past are  :                               Big Data                                                       ...