CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS DATA WAREHOUSING ENTERPRISE DATA WAREHOUSE DETAILS
    Question :
    Describe the difference between homogeneous and heterogeneous distributed database.
    Category Enterprise Data Warehouse Interview Questions
    Rating (0.3) By 102 users
    Added on 3/19/2012
    Views 279
    Rate it!
    Answers:

    A homogenous database is one that uses the same DBMS at each node. Either each node can work independently or a central DBMS may coordinate database activities. A heterogeneous database is one that may have a different DBMS at each node. It may support some or all of the functionality of one logical database. It may support full Distributed DBMS functionality or partial Distributed DBMS functionality.



    Homogeneous Databases:
    The homogeneous database means that the database technology is the same at each of the locations (or sites) and that the data at various locations are also compatible. In a homogeneous system, all nodes use the same hardware and software for the database system. The homogeneous system is much easier to design and manage.
    The following conditions must be satisfied for homogeneous database.
    * The operating system used, at each location must be same or compatible.
    * The data structures used at each location must be same or compatible.
    * The database application (or DBMS) used at each location must be same or compatible.
    Heterogeneous Databases:

    The heterogeneous database systems are opposite to homogeneous database systems. In a heterogeneous system, different nodes may have different hardware & software and data structures at various nodes or locations are also incompatible.
    Different computers and operating systems, database applications or data models may be used at each of the locations. For example, one location may have the latest relational database management technology, while another location may store data using conventional files or old version of database management system.
    Similarly, one location may have the Windows NT operating system, while another may have the UNIX.

    Heterogeneous systems are usually used when individual sites use their own hardware and software. On heterogeneous system, translations are required to allow communication between different sites (or DBMS). In this system, the users must be able to make requests in a database language at their local sites. Usually the SQL database language is used for this purpose. If the hardware is different, then the translation is straightforward, in which computer codes and word-length is changed. The heterogeneous system is often not technically or economically feasible. In this system, a user at one location may be able to read but not update the data at another location.



    Posted by: Nitesh Khandelwal    

    Contact Nitesh Khandelwal Contact Nitesh Khandelwal

    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    Explain issues for database performance.
    View Answer
    Explain locking.
    View Answer
    Describe concurrency control.
    View Answer
    What are some of the important security features of a DBMS?
    View Answer
    Describe the difference between data and database administration.
    View Answer
    Describe the differences between a data warehouse and data mart.
    View Answer
    Explain why an information gap exists in most organizations.
    View Answer
    Describe a data warehouse.
    View Answer
    Describe why operational and informational systems are separate.
    View Answer
    Explain the role of metadata for the three-layer architecture.
    View Answer
    Describe Website security issues.
    View Answer
    Provide an overview of XML.
    View Answer
    Describe Web Services.
    View Answer
    Describe JavaScript and VBScript.
    View Answer
    Describe middleware applications that ease the connection of databases to Web applications.
    View Answer
    Describe some reasons that someone familiar with Microsoft Access will want to learn VBA.
    View Answer
    Compare a thin and a fat client.
    View Answer
    Describe ODBC
    View Answer
    Describe and contrast SQL and QBE.
    View Answer
    Explain the difference between two and three-tier architectures.
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL Enterprise Data Warehouse Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.015625 Seconds