Database: Difference between revisions
CSV import |
CSV import |
||
| Line 33: | Line 33: | ||
[[Category:Information Technology]] | [[Category:Information Technology]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
<gallery> | |||
File:DVD_Rental_Query.png|DVD Rental Query | |||
File:CodasylB.png|Codasyl Database Model | |||
File:Relational_key_SVG.svg|Relational Key | |||
File:Process_of_database_design_v2.png|Process of Database Design | |||
File:Database_models.jpg|Database Models | |||
File:Traditional_View_of_Data_SVG.svg|Traditional View of Data | |||
</gallery> | |||
Latest revision as of 04:32, 18 February 2025
Database is a structured set of data. So, a computer database is a structured set of data stored in a computer or server. The structure is achieved by organizing the data according to a database model. The model in most common use today is the relational model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships.
Overview[edit]
A database is an organized collection of data stored and accessed electronically. Databases are more complex than spreadsheets as they can handle larger amounts of data and more users. They are designed to manage, store, and retrieve information. They are essential for managing the large amounts of data generated by businesses, governments, and scientific research.
Types of Databases[edit]
There are several types of databases, including:
- Relational database - This type of database defines database relationships in terms of tables. It is also the most widely used database model.
- Object-oriented database - This type of database combines the features of both the relational model and the object-oriented programming paradigm.
- Hierarchical database - This type of database organizes data in a tree-like structure.
- Network database - This type of database allows each record to have multiple parent and child records, which, when visualized, resemble a net-like structure.
Database Management Systems[edit]
A Database Management System (DBMS) is software that interacts with the user, applications, and the database itself to capture and analyze data. A general-purpose DBMS allows the definition, creation, querying, update, and administration of databases.
See Also[edit]
References[edit]
<references />


