In: Computer Science
Using the module discussion forum, work with your fellow students to identify any other database benefits you can think of, as say compared to a spreadsheet or basic file storage.
Dear User,
Database as well as Spreadsheet both stores the data in a tabular
format and designed to store, manipulate, and retrieve
information.
Still the database has several advantages over a spreadsheet.
1. Most databases are relational, so that data between tables can
be linked and cross-referenced using primary key and foreign
key.
2. The spreadsheet is good for numerical as well as textual data,
but the database also can easily incorporate Images and
documents.
3. the spreadsheet has the limitation of 10,00000 row limitation
while database does not have any such limitation so it can handle
huge amount of data efficiently.
4. In the database, it's easy to update the data in bulk.
5. integrity is the most important difference in between
Spreadsheet and database, databases follows standardized integrity
rules, each column has a specific data type which does not allow to
enter value of other data types also we can restrict the value of a
column using constraints like check and unique.
6. Here in a database all the tables are interlinked hence it
avoids the data redundancy while spreadsheet can have multiple
duplicate records.
7. in terms of security and accessibility. the database is far
better than the spreadsheet as multiple users can insert, update,
select and delete the records of the database also access to
database objects can be restricted using the permissions.
8. it is very easy to take a backup and restore the whole
database.
if we compare database with file system, still database has
several advantages.
1. Data of database can be shared easily as it acts like a
centralized system while it's a very complex process in file
systems.
2. In a file system, if more than one user is updating the data
there are chances of data loss while it is not the case with
database.
3. Retrieving the data from database is easy as compare to file
system.
4. There is no comparison in between database and file system in
terms of data integrity.
Thank You !