What is a database?
A database is an electronic file system whose purpose is to maintain information and make it always available. This information is preserved regardless of the time elapsed to go to it later and consult the information stored there.
In short, a database is a collection of information organized within a program, allowing the quick and versatile selection of fragments of the information required by the user, which is why it is considered as fundamental pillars in the educational, banking, and statistical system. , and business.
Having a database offers us multiple advantages, for which we are going to see some of the main characteristics:
- Access through programming languages
- Backup and recovery
- Data integrity
- Optimized complex queries
- Concurrent access by multiple users
- Access security
- Logical and physical data independence
What can be done with databases?
A database facilitates our work for many things in relation to the work we do, for example, enormous amounts of information can be stored organized in specific structures, which allow us to find and use the data quickly. However, for some this can be a bit complex, so we are going to see some of the functions that we can perform with a database.
A table is a collection of information about a person, thing, or event. The tables contain columns, where the columns are the fields and rows, where in turn these are records.
A form is an interface where you interact with the user. In a form you can change, present, introduce or delete information from a table or more.
A query is a request for information to the database. The queries are used to show the data either from a single table or a set of them related to each other.
A report is the presentation of certain contents of our database to be printed. A form is a way to present the significant data that we want to be distributed.
Database Management System
Database Management Systems (DataBase Management System) are a type of software dedicated to serving as an interface between the database, the user and the applications that use it. They consist of a data manipulation language, query language and a data definition language.
Databases generally have one type of field. Some of the most common are the following:
- Dates: as its name says, it allows you to store dates, later facilitating your search in chronological order. It also orders the records by dates or calculates the days between one date and another.
- Alphanumeric: This field allows entering data, figures and letters with a limited length of 255 characters maximum
Boolean: Boolean data is data that only has two options: True and False
- Autoincrementables: This field serves as an identifier and they are of a numeric type, which increase their value in unity for each record that is added.
- Numeric: In this field we can add two types of numbers, the integer type (without decimals) and real numbers (with decimals).
Types of Databases
Next we are going to see the different types of most common and currently used databases
- MySQL: It is an open source relational database management system, based on the structured query language SQL, which is characterized by its speed.
- SQL Server: It is a database developed by Microsoft. This database is generally used to handle large volumes of information unlike MySQL which only allows to host a limited amount of data.
- Oracle and PostgreSql: It is an open source object-oriented database system. These database systems manage large amounts and volumes of data very well, in order to be used in large caliber systems.
- Access: It is a database that must be created under the Access program which is developed by Microsoft. This program is part of Microsoft Office, a suite of applications that allows you to perform office tasks.
Databases are excellent allies of human beings when it comes to storing information. In fact, we could not be reading this blog today if it did not have a database that stores this information. And not only that, they are also ideal for accessing addresses, personal information and images. On the other hand, databases allow you to edit or update information in real time and perform automated calculations on the data stored in it.
In short, the main importance of databases is that it allows users to manage, select and work with a quantity of information in a few seconds, which in a manual way would be impossible even for an army of users.