Introduction
A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a DBMS. Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database. Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying data.
What’s the Difference Between a Database and a Spreadsheet?
Databases and spreadsheets (such as Microsoft Excel) are both convenient ways to store information. The primary differences between the two are:
How the data is stored and manipulated?
Who can access the data?
How much data can be stored?
Spreadsheets were originally designed for one user, and their characteristics reflect that. They’re great for a single user or small number of users who don’t need to do a lot of incredibly complicated data manipulation. Databases, on the other hand, are designed to hold much larger collections of organized information—massive amounts, sometimes. Databases allow multiple users at the same time to quickly and securely access and query the data using highly complex logic and language.
Types of Databases
There are many different types of databases. The best database for a specific organization depends on how the organization intends to use the data.
Relational databases. Relational databases became dominant in the 1980s. Items in a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information.
There are many different types of databases. The best database for a specific organization depends on how the organization intends to use the data.
Relational databases. Relational databases became dominant in the 1980s. Items in a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information.
Detailed Reading is available in PDF.
Format: Pdf
Total Files: 4
File Size: 7.2 MB
Post a Comment