Difference between prijects with database amd without database
Answers
Answered by
0
Originally Answered: What is the difference between a database and a database management system?
Nowadays both database and database management system are used as synonyms in common terms.
Database means it is a collection of data, generally stored in tables in rows and columns fashion.
Database Management System is nothing but managing the database work. Usually DBA (Database Administrator) will be the key person in managing the data in the form of taking backups,partitioning,segregating,restoring,finetuning the data by deleting long running queries for quite long time etc., But the whole job lies mostly for them is with database.
If DML statements fetching query is correctly written for the given indexes, by reducing query retrieval time, by creating temporary tables in case if it is large set of joining multiple tables, then DBA role will be easier. Otherwise managing the data itself a hectic task to them.
Nowadays both database and database management system are used as synonyms in common terms.
Database means it is a collection of data, generally stored in tables in rows and columns fashion.
Database Management System is nothing but managing the database work. Usually DBA (Database Administrator) will be the key person in managing the data in the form of taking backups,partitioning,segregating,restoring,finetuning the data by deleting long running queries for quite long time etc., But the whole job lies mostly for them is with database.
If DML statements fetching query is correctly written for the given indexes, by reducing query retrieval time, by creating temporary tables in case if it is large set of joining multiple tables, then DBA role will be easier. Otherwise managing the data itself a hectic task to them.
Similar questions