Database: Difference between revisions

From WikiMD's Wellness Encyclopedia

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.
  • 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 />

This article is a medical stub. You can help WikiMD by expanding it!
PubMed
Wikipedia