Why would an expensive licence fee for a proprietary dbms

Assignment Help Basic Computer Science

Reference no: EM133536883

Assignment:

Introduction to Database Systems

Database Management Systems (Continued)

There are different ways of organising databases as part of a wider information system. For example, databases may be distributed (where different information is stored at different locations), replicated (or mirrored) (where the same information is stored at different locations), federated (various independent databases work together to provide a wider set of information). However, for most purposes we use a client-server architecture.

In the client-server model, one (or more than one) particular computer (the database server) is responsible for running the DBMS. Often this server will have a high specification such as fast processing, lots of storage, fast network connexions, etc). The client refers to the other computers that access the database server over the network.

Client - Server Model

For example, if you check train times on a mobile application, the client is the app running on your smartphone, and the server is a database managed by the train company. A huge range of information systems are based on this client-server model.

For practical exercises on this module, we will mainly use two MariaDB database servers:

The database server that supports the SQL Zoo website (the client). We use this indirectly, through the website.
An Edinburgh Napier database server used for this module (with various different clients, such as an interactive shell, database GUI, Python programs, etc).

Question:

Why would a company pay an expensive licence fee for a proprietary DBMS when many open-source systems match these in functionality and may be used free of cost?
Would we expect an organisation (say a bank or a university) to store all its data in one database, or in many? What factors would affect this decision?

Reference no: EM133536883

Questions Cloud

Should be runnable on omega server without any configuration : Write a C program to calculate the total size (in bytes, no text or commas, just the integer answer) of all files in the current directory / folder.

Discuss five reasons why muslims finds it difficult : Discuss five reasons why Muslims finds it difficult to accept the mission of Jesus Christ even though they acknowledge his virgin birth.

How can understanding the big picture of the bible help : According to Bickel and Jantz (2003), what is the main theme of the Bible? (Provide cited support from your text for this theme.) How does this theme compare

How did they help you to deepen your understanding : How did they help you to deepen your understanding of calling and purpose? How do the Scripture readings from this week help to flesh out these ideas?

Why would an expensive licence fee for a proprietary dbms : Why would a company pay an expensive licence fee for a proprietary DBMS when many open-source systems match these in functionality.

Evaluate the performance of partners and suppliers : Evaluate the performance of partners and suppliers in ensuring the effective delivery of IT services within organisations

What is the primary responsibility of transition specialist : What is the primary responsibility of a Transition Specialist? What are the qualifications for a student to receive service provided by a Transition Specialist?

Role of business analyst : In your role of Business Analyst, the grocery store has asked if you could help them choose the appropriate replacement system.

How do you feel the observation went : How do you feel the observation went? Did you encounter any issues or situations that you did not know how to handle? If so, explain.

User Account

All Pages