Hello everyone! I'm here again for continue with an articles :), it's been a while since the last post, I ended up getting a bit busy but we came back. Let's go talk about Databases (The beginning of everything).
Understanding database
Basically, Database is an organized collection that help us a manage a large volum of data.
- Helps manage the volum of data and information;
- Allow quickly access to data;
- Easy data recovery;
Collection: grouping of data organized and managed together.
Why use databases?
Databases play a crucial role in the efficient management of information in various sections. It offer a range of benefits.
| Benefit | Description |
|---|---|
| Organization |
Data is stored in a logical way, structure and allows for more efficient management and reduces redundancy |
| Easy Acces | With an efficient query it's possible to retrieve specific information in miliseconds, optimizing time and resources |
| Escability |
Database are designed for handle with crescent volum of information, support from small operations to millions of users simultaneously |
In addition to these benefits, they also promote data integrity and security. In increasingly data-driven world, a more efficient information management capacity is essential for the success of any organization.
📝 Example:
Hospitals use databases for patients' medical records, follow-ups, histories, notes and invoices.Store use databases for products, invoices, amount, categories and others.
Key components of a database
We have some components for some fundamental elements that work in collections to store, organize and manage data, let's continue!
| Name | Description |
|---|---|
| Table |
Tables are the main units in a database, work in a similar way to spreadsheets. They are made up for rows and columns, which organize the data in a structured way |
| Rows | Each row represents a unit of log data. Contain specific information about an entity or item. |
| Column | The columns defines an attribute or property of stored data. Each column in a table represents a specific category of information, such as name, age or address |
We've seen some very important points about Databases and how they work. The next article let's continue talking about databases yet :D.
Next Topics
-
DatabasesTypes- Relational
- Non-Relational
- Differences of Relational vs Non-Relational
- Primary Keys 🔑
- Foreign Keys 😶🌫️
Thank you for reading this far!
Feel free to recommend articles, channels and so on of Back-end, I appreciate it 😎.
Top comments (0)