Dynamic databases.

What
son? Examples
One of the major divisions within the framework of databases is established according to
variability of the information they contain. In this sense, one can speak of
static and dynamic databases. In this article, we talk to you about databases
dynamics, their main characteristics, advantages, and uses.

What is a dynamic database? Definition

Characteristics and aspects to consider
Advantages and disadvantages
Advantages
Disadvantages
Structure
What can be done with dynamic databases?
Dynamic vs static
Examples

What is a dynamic database?

Definition
A dynamic database is one in which data that can vary is stored.
over time. To adapt to this changing data, dynamic databases
allow the editing, updating or deletion of information.

For example, let's imagine an online store that has a database with products and
their respective prices. It will be necessary for it to be a dynamic database, as the
The price of each product is subject to change over time.

Characteristics and aspects to take into account

bill
Given the previous relationship, it can be said that the main characteristics of the bases
dynamic data are the following:

They are relational databases, that is, relationships are established between them.
the records and their fields.
They are oriented towards the storage of information that could change in the
time.
Allow adding, modifying or deleting information present in the fields of
the database.
It is opposed to static databases, which do not allow editing the
information.
Advantages and disadvantages
Taking into account these characteristics, it can also be stated that the foundations of
Dynamic data have a series of advantages and disadvantages.

Advantages
Among the main advantages of dynamic databases are:

Ability to adapt to databases with changing information.

They are more flexible than static databases.
They allow for agile and simple analysis of present data.

Disadvantages
For their part, the main disadvantages of dynamic databases are summarized
in the following:

With this type of database, it is possible to visualize and analyze the data.
presents, but it is difficult to conduct studies on the evolution of the
information. For example, it would not be possible to analyze how they have evolved the
data in 2015, 2016, 2017, 2018 and 2019, since the database would only contain
the most recent data, that is, the ones that appear after the last modification. It is
therefore, for the study of variables over time or for analysis of
Static databases are usually used in business intelligence.
They are more complex to maintain, as they need to be updated regularly.
constantly, which can also lead to erroneous, incomplete or
outdated.

Structure
The structure of a dynamic database can be the same as that of any other.
relational database. That is, the information is organized in tables that in turn
they contain various rows and columns. The rows correspond to each of the records
of the databases, while each column corresponds to a field or attribute of
each record.

The only special feature is that in dynamic databases the fields must
be editable, either manually or through forms, in order to maintain the
always updated information.

For example, a library that contains records of all its books must also
to have a field to know its status. This field must be editable to know at all times.
moment if the book is available, borrowed for internal use or borrowed for external use
from the library.
What can be done with the bases of
dynamic data?
Dynamic databases allow for various functions:

Dynamize tables and organize data matrices.

Create reports based on fully updated information.
Organize and segment data based on different variables.
Perform data mining, searching for information based on different criteria.
Import and export data.
Simplify the way information is queried using icons, bars of
data, cell colors or text formats.
Create interactive dashboards thanks to tools like Excel.

Dynamic vs static
As we have already discussed, there are two main groups of databases according to the
variability of the information they contain. On one hand, there are the databases of
dynamic data, which allows to add, edit or delete information. On the other
On the side, there are the static bases, whose information is fixed and unchanging.

Before we used the example of an online store that needs to modify its database.
data the prices of each product. In this case, it would be a dynamic database.

Now let's think about the population census of a specific place and year. That data
they are unmovable. That is to say, that population is listed as a fixed data point, until the
census of the following year. In this case, it is a static table. These databases
are especially useful for studying the evolution of data; in the case of this example,
to understand how the population evolves year by year in a specific place.

Examples
There are countless examples of dynamic databases:

A hotel that has a customer registry, where you can see their
history, add or delete information.
A database of a business in which the stock of each item is updated
product.
A video store that must always know what movies are available
or rented.
A veterinary clinic that keeps information about animals: weight,
received treatments, prescribed medications, performed operations, etc.
A mechanic workshop that stores information about its customers and vehicles.
date of last visit, repairs made, etc.
In summary, dynamic databases are especially useful for cases where
It is necessary to update the information instantly. However, they are not that useful.
as a business intelligence tool since it is not easy to study the
evolution of data over time.

Static databases. What are they?

Examples
There are many types of databases. Some of the most used are the
static database calls. What do they consist of? How do they differ from the
Dynamic databases? In this article, we answer all your questions.

What are static databases? Definition

Features and aspects to consider
Advantages and disadvantages
Advantages
Disadvantages
5 examples of static databases
Difference between static and dynamic databases

What are databases?

static? Definition
A static database is one whose main function is storage and
fixed data record. That is, it stores information that will not be modified or edited
over time.

It is a type of read-only database. Its implementation is usually carried out

with the aim of recording historical data to be able to compare its evolution over time
of time.

For example, a database can be created with the total sales of a category of
products over a series of months, to compare the evolution of sales accordingly
length of time.

Static information bases are widely used in the field of

statistics and are usually oriented towards business decision-making.

In contrast to static bases are dynamic bases, which do allow

the editing, updating, or deletion of data over time.

Characteristics and aspects to consider

account
Given the definition of the previous paragraph, it can be said that the
The main characteristics of static databases are the following:

They are read-only databases. That is, they are designed to add data.
fixed that cannot be modified over time.
They are primarily used to store historical data or facts.
invariables.
Different static databases created in different ways are usually combined.
periods to analyze the evolution of data over time.
Therefore, they are widely used for conducting market studies and research.
statistics and other projects related to Business Intelligence.

Advantages and disadvantages

Next, we see some of the advantages and disadvantages of databases.
static.

Advantages
Among the advantages of static databases, the following can be cited:

They are databases that have total validity over time. That is, the
data remain valid for a long time regardless of how much time passes.
They do not require any maintenance, as the data is not editable.
Queries are usually simple as they are based on fixed data. The relationships
tables are also easy to create.
They can be applied with numerous objectives, but they are especially useful for the
time to compare statistics, or the evolution of any data over time.

Disadvantages
On the other hand, the main disadvantages of static databases are:

They are not suitable for storing data that needs to be modified over time. For
example, the price of a product that is subject to change.
They are not very flexible and are limited to a very specific set of data.

5 examples of static databases

There are numerous examples of static databases. But let's give an example.
example that illustrates them better:

The databases of the INE (National Institute of Statistics) that collect the
annual data on birth rates, employment, average salaries, and more
etcetera.
Databases that record the census of a population over the years.
 A database that collects the monthly income of a store in different
tables throughout the months.
Databases that refer to historical facts or anniversaries.
A database that collects the conversion rates of different strategies.
marketing.

Difference between databases

static and dynamic
In the classification of databases according to the variability of information, there are two.
large groups: static databases and dynamic databases.

The main difference between the two is that, while static databases are
read-only and do not allow modification or addition of data, dynamic databases are
much more flexible and do allow editing, updating, or deleting data.

Therefore, static bases are usually used for information that is unchangeable in the
time, while dynamics are used to create bases with data that are
susceptible to change over time.

This has been all from our side. If there is anything you haven't understood, don't hesitate to
raise your questions in the comments.

VENTAJAS Y DESVENTAJAS DE PAGINAS

DYNAMICS
VENTAJAS Y DESVENTAJAS DE PAGINAS DINAMICAS
ADVANTAGES OF DYNAMIC WEBSITES DISADVANTAGES OF STATIC WEBSITES
Greater interactivity with the user as they can partially alter
the design, content, or presentation of the page to your liking Mayores requerimientos técnicos para su alojamiento en
The update process is extremely simple, with no need for Payment servers.
enter the server Higher accommodation costs.
A large number of functionalities such as databases, forums, In some cases, a higher development cost.
dynamic content, etc.