ITRI 613 - Assignment 1
DBMS
A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.
Every company, business or organization working under the belt of Information Technology requires Database Management. Therefore, it is imperative that IT students understand database management system and the value it adds to the world today.
PART 1
For the first part of the assignment, you are tasked to provide 7 DBMS Software’s of your own choosing and outline their main advantages and disadvantages, whether closed source or open source, relational or extended-relational. Basically, outline the main characteristics of each DBMS Software and outline how unique it is from others.
PART 2
For second part of the assignment, you are tasked to research and provide a report of five companies of your own choosing and outline the kind of DBMS that they are utilizing on a daily basis. Also, where possible outline the historical DBMS the company used to use and when it scaled what they chose to adopt as their new DBMS
Example: The Coca-Cola Company DBMS
Coca Cola Company used to use Oracle Databases which have SQL capabilities previously but due to its SAP application, they have moved to IBM’s DB2. The act led to reduction of hardware and software cost and a better storage, retrieval and security of data. Databases provide all the information from products to employees hence they play a vital part. IBM DB2 has greater compression which would reduce database size and lower licensing renewals.
Data storage Needs
The coca cola company data center is the nerve center where servers and storage devices ensure the bulk of data is secured for the companies use. With a 10 Gb Ethernet connection by Cisco, costs have dramatically reduced and so has time spent on locating vital information.
