The main difference between a database and database management system is that the database management system is a piece of software where it contains a piece of code that controls, manipulate and modify how data is stored inside the database. Databases it self is an actual data cluster where the data is been stored inside where it is controlled by the DBMS or another words Database Management System. Database management system is almost refed to the conceptual schema since which is the schema responsible for structuring how data is been manipulated in the database. When developing DBMS, there are few major ideas needs to consider.
· What are the data types, structures and constrains stored in the database and how everything works together as a table?
· Construction or load the database on a secondary storage medium. Loading the database data is curtail according to how different requirement ask for. In the case of amazon like a database. There need to have backups and more on how fast the data flow happens, the scalability of the data base and such more. Getting data from secondary data storage is bit of a time-consuming work to do since it requires more time than primary storage data retrieval. There fore the DBMS is responsible for getting and loading data beforehand and according to a certain plan in order to deliver data efficiently and securely.
· Data manipulation is the what referred as CRUD (create-data, Read-data, Update-data, Delete-data) contents in the database needs a way to handle how data create, read, update and delete. These four things are a requirement to construct when developing DBMS.
· Keeping data consistent and valid while handling and dealing with users.
Databases have many advantages as well as some disadvantages. A database can be more complex than a file processing system. People with special training usually develop larger databases and their associated applications. Databases also require more memory, storage, and processing power than file processing systems.
Data in a database can be more vulnerable than data in file processing systems. A database can store a lot of data in a single file. Many users and programs share and depend on this data. If the database is not operating properly or is damaged or destroyed, users may not be able to perform their jobs. Furthermore, unauthorized users potentially could gain access to a single database file that contains personal and confidential data. To protect their valuable database resource, individuals and companies should establish and follow security procedures. Despite these limitations, many business and home users work with databases because of their tremendous advantages.
Database
The database includes the actual data you save.
The database is any collection of data whether you are writing it on the paper or storing it in the digital format.
There are two types of database
- Online Transaction Processing (OLTP)
- Online Analysis Processing (OLAP)
OLTP stores the current data and it is used for the transaction. Usually, it is stored in Megabyte or Gigabyte of space.
Whereas, OLAP stores historical data which is used for data analysis. Data can be in Terabyte or Petabyte of size.
DBMS
DBMS stands for a database management system.
DBMS is a kind of software that helps you to retrieve, edit and store structured data in the database.
