Difference between rdbms and spreadsheet tutorial point
Answers
Answered by
0
There are a lot of more detailed answers than mine, but Ill give you a very simple explanation of high level differences.
A spreadsheet is, at its essence, information that is organized into rows and columns. It was originally designed to be used by one person at a time. Most logic and connectivity is stored in a simple way to the user initially, but often you cannot readily change or ‘move’ that without problems.
A database is information that may store information in rows and columns, or may use other methodologies to store information. Most are designed to be served from a server, that handles security, connectivity and numbers of users. Some logic and connectivity can be stored with a database, but mostly, that information is stored outside of the database and can be extremely complicated.
Many people use spreadsheets as a kind of database, but mostly because they don’t understand why they would use a database instead.
Databases can collect huge amounts of data, which can be stored with better capability for safety and security on a central repository or serverDatabase users can execute extremely large and complex procedures on data and make use of the ‘power’ of the server to execute themDatabase users can use Excel or other spreadsheets as a kind of ‘front end’ to put a pretty face on complex data activity coming from a database, but Excel doesn’t really bring a lot of value to the ‘process’ of working with data
A spreadsheet is, at its essence, information that is organized into rows and columns. It was originally designed to be used by one person at a time. Most logic and connectivity is stored in a simple way to the user initially, but often you cannot readily change or ‘move’ that without problems.
A database is information that may store information in rows and columns, or may use other methodologies to store information. Most are designed to be served from a server, that handles security, connectivity and numbers of users. Some logic and connectivity can be stored with a database, but mostly, that information is stored outside of the database and can be extremely complicated.
Many people use spreadsheets as a kind of database, but mostly because they don’t understand why they would use a database instead.
Databases can collect huge amounts of data, which can be stored with better capability for safety and security on a central repository or serverDatabase users can execute extremely large and complex procedures on data and make use of the ‘power’ of the server to execute themDatabase users can use Excel or other spreadsheets as a kind of ‘front end’ to put a pretty face on complex data activity coming from a database, but Excel doesn’t really bring a lot of value to the ‘process’ of working with data
Similar questions