Core business functions and
enterprise transaction processing:
The related database is the one that administers the
functions of payments, income I rake of the managings
of the company with an interface that possesses the
principal uses of the empreza, principal mind is the
database that guards the information.
Analytics and business intelligence:
It is the option of environment of database that depends on
the type that is realized, most of information that the analyst is
accessible enters it is big information as haddop. this
information is placed in 62 % in a database in the cloud and
another per cent of 61 % it is located in NoSQL.
IT operational data (logs, systems
monitoring
The professionals in the database rapidly can be
in he her was structuring of the database and to
open tests and to add information to the
platform. In Microsoft Excel or database of access
where one guards the information.
Special projects
The projects of the companies become by business managers,
technical personnel and professionals, Microsoft was the one who was
storing principally the database that it stores.Between the directors of
information who answer to the study of dbta, 41 % of users hadoop
mentions special projects as a case of key employment for the
platform followed in 35 % of users of database of cloud.
Security and compliance:
In this area you need a database that is
completely safe, the database manager that is
responsible for this system are relational.
Real-time or sub-second processing
and response requirements:
In this area it databases with low latency,
where the data is sent to a random access
memory of computers, in this case memory
databases used are needed.
Unstructured data analytics:
In this case the relational databases are not
as necessary as Hadoop file systems that
make these files more manageable and
accessible are used.
Developer resources (configuration
information):
In this case you need a fast database
to call and deployment data, in this
case, databases are used in the cloud
or databases quick and simple data.
Web applications:
this case it is better not to use a SQL
database (key-value) data, as they are
simple and quick.
Ecommerce applications:
In this case you can have no previous
SQL data base (key-value) Back-end
databases, are a combination
Testing and pilot projects:
In this area you
need to use
databases with large
capacity cloud.
Peripheral/branch office support:
access via the network to a
central database. As a branch
location is likely to be
transaction-focused, a cloud
database may be needed to
support access.
Embedded devices and applications:
In this case databases that can be run
remotely, requiring little
maintenance, high security is needed.
You can use relational databases.
Mobile applications:
At this level, a relational database in
which to store local data allow to be
stored and managed locally used.