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.
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.
Nice post Keep Updating Big Data Hadoop Online Training Bangalore
ReplyDeleteBig Data is lots and lots of data which is important but there is a problem in handling big data. Hadoop was proposed as a solution to it.It is a very good decision to enter in Big Data world. .I personally recommend you one of the Best BigData Hadoop Institute in Gurgaon is iClass Gyansetu; you can get 100% placement. With best faculty members. Gyansetu made their course content as according to current industry requirements.
ReplyDeleteExcellent post, it will be definitely helpful for many people. Keep posting more like this.. oracle training in chennai
ReplyDeleteGreat Article
ReplyDeleteCloud Computing Projects
JavaScript Training in Chennai
JavaScript Training in Chennai
big data projects for students
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
Great Article
ReplyDeleteCloud Computing Projects
JavaScript Training in Chennai
JavaScript Training in Chennai
big data projects for students
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
Great Article… I love to read your articles because your writing style is too good, its is very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
ReplyDeleteDocker Kubernetes training in Gurgaon
AWS cloud training in Gurgaon
FullStack Development Training in Gurgaon