• Find us:
    +1 415 655 1723   |   +91-844-844-8901
  • Free Newsletter

     
     

  • Archive

  • Categories


  • Oracle Exadata- an overview

    Posted by "" in "Exadata" on 2014-07-27

    Nowadays, Exadata is a buzzword in a database world so i decided to put a light on this.

    In simple words Exadata ==> a server with pre-installed and pre-optimized database so i can say that the hardware is designed in such a manner that each component in the hardware is tuned to work with database including memory, CPU.. etc.

    Oracle Exadata is positioned as pre-configured clustered database server Here is i have used a term cluster so lets understand this concept.

    • > While creating RAC database environment a DBA has to work with different team like Hardware, Storage, Networking so a DBA has to ensure that each component should be compatible to each other and finally compatible to Oracle RAC, database software, ASM. So it has became a tedious task for DBA and takes a lot of time to set up a RAC environment.

    > To avoid these problems a product came Exadata which provides bundled hardware and software to customer infact a hardware with intelligence.
    > it is positioned as clustered as it contains bundle of database servers that hosts database software combining together serving a one purpose only and also it consists of storage servers that are having chunks of memory to hold the data from database servers.

    exadata_view

    As you can see the above image it is containing a database servers, a storage servers and infiniband switches which as a whole serving a one purpose.

    Its becoming popular because of its main feature i’e Smart Scan
    Lets understand this via a small example:

    > In RAC env Database is stored at Shared Storage Server and to get output of any query data has to transfer from Shared Storage server to Database Node and then DB node will process data and provide results.
    so if a query has to return 1 million rows and order table contains 100 million rows so all the 100 million rows will come from storage node to database node for processing and then output will be received. This will take a lot of time for DBA.
    > To eliminate this Exadata smart scanning introduced where if a query has to return 1 million rows so only 1 million rows will be transferred to database node and not all the 100 million rows. This is something called as Filtering at Storage Level

    Ofcourse, this is not its only feature but has many which makes it popular.

    I hope you must have got the basic understanding of Exadata via above description.

     

    Leave a Reply

    Your email address will not be published. Required fields are marked *



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    128 Uxbridge Road, Hatchend,,
    London, HA5 4DS

    US: +1 415 655 1723
    India: +91-844-844-8901

  • Copyright 2019, K21 Technologies. All rights reserved
  • TOP
    TOP