Main Features of Database Engines
Uploaded by
ScribdTranslationsMain Features of Database Engines
Uploaded by
ScribdTranslationsMain features of database engines.
Oracle.
Relational model: users view data in tables with the
row/column format.
Intuitive and easy-to-use graphical management tool.
Access control: advanced technologies to monitor the entry to the
data.
Data protection: complete security in the production environment and
tests and backup management.
Very comprehensive database design language (PL/SQL): allows
implement 'active' designs that can adapt to needs
business changes.
High availability: scalability, protection, and high performance for the
business activity.
User management: agility in procedures, cost reduction and
security in controlling the people who access the applications and
the systems.
SQL Server.
Transaction support.
Scalability, stability, and security.
Supports stored procedures.
Also includes a powerful graphical administration environment, which
Allows the use of DDL and DML commands graphically.
It allows working in client-server mode, where the information and data
they are hosted on the server and the terminals or clients of the network only access
the information.
It also allows for the management of information from other data servers.
Main features of database engines.
DB2.
Applications with the highest percentage of failed SQL statements,
classification overflows, blocking wait times
exceeded and dead points, and the lowest proportion of hits of
group of intermediate storages.
Proportion of correct grouping of intermediate storage
by grouping of intermediate storages, hit ratio
of grouping intermediate storage by database,
average reading and writing times, asynchronous I/O activity and
synchronous, expanded warehouse and non-grouping I/O activity
intermediate storages.
Databases with the highest percentage of failed SQL statements,
lowest ratio of storage grouping accuracy
intermediaries and the highest number of connections, waiting times
overblocking and deadlock points.
HADR configuration and runtime information (Database
High Availability and Disaster Recovery.
Applications that are currently awaiting blocks and other details
about the blocking resources.
Key events of the server, the number of connections of the server, the databases
of data with the lowest proportion of grouping hits
intermediate storage and applications with the highest percentage of
failed SQL statements
Use of size and page of table spaces.
Resources of the system where the DB2 Server is running,
including CPU usage, memory usage, and network information.
Registration information, such as the amount of active logging space, the
percentage of secondary registration and the amount of space used by
the archive records.
Diagnostic messages from the db2diag.log file of the database
from DB2, including information about the notification log
administration, event logging, and diagnosis logging.
Custom definitions of the SQL statement, latest states
execution and results.
Main features of database engines.
MySQL.
Use of ACID (Atomic, Consistent, Isolated, Durable) transactions: For
build more secure applications through commit, rollback, crash
recovery and blocking by registration.
Stored Procedures: To improve programming.
Triggers: To improve the business rules.
Views: To make sensitive information more secure.
Information Schema: For easy access to the metadata.
Distributed Transactions (XA): To support transactions between
multiple database environments.
PostgreSQL.
The SQL language it uses is very close to the ISO/IEC standard, thanks to which
it is relatively easy to port queries and scripts from other systems of
databases, and thus learn easily the variants of this language.
It complies with ACID, that is, it provides atomicity, consistency, isolation and
durability for your operations.
It allows creating schemas, inherited tables, and event-driven triggers.
that other engines do not possess.
It allows defining procedures, not only in PostgreSQL but also in
many other languages like Pearl, TCL, or Python. Even if the language that
we want to use is not supported, we can define it with new ones
extensions.
If we need any type of data that is not supported out of the box, we also
we can define them.
We canextend functionality with extensions,provided by the own
PostgreSQL, by third parties or even programming on our own.
It has native master-slave replication support, but it is also
possible to add other types through third-party products, free or from
payment.
It also provides excellent vertical scalability.
Main characteristics of database engines.
Sybase.
Speed – Inquiries up to 100 times faster than asystem of
database management(traditional DBMS)
Lower total cost of ownership – Uses sophisticated algorithms of
compression that reduces storage volume by up to 70
percent, compared to a traditional DBMS.
Ease of use - Easier to maintain than enterprise applications
traditional data warehouse; does not require intensive tuning.
Scalability - Offers almost linear scalability of users and data, for
large volumes of users and data. It also supportsmultiplexing
especially in environmentsGNU/Linuxwhere scalability at level
ofCPUit can be limited.
Flexibility - Sybase IQ comes packaged in different editions,
depending on the query processing needs of the
organization.
Informix.
Uses Windows 2000, 2003 Server, XP and UNIX /AIX, HP-UX platforms.
Linux, Solaris, and TRU64.
Manage multiple remote databases from a single console.
It has graphical tools.
Data relationship capacity from multiple physical locations.
Provides a proven embedded data management platform
for ISVs and OEMs to offer world-class integrated solutions, what
which allows platform independence.
It integrates with Linux, Oracle, and other databases.
Use Java programming language.
Support for Datawarehouse.
Support for datamining.
It has architecture for OLTP (On-Line Transaction Processing) server.
and OLAP (On-Line Analytical Processing).
