Database Architecture Basics, Terms and Definitions
Database architecture is a model describing the logic of distribution of database objects throughout the system. It is usually designed in accordance with the business logic of a particular application that will use the database.
Generally, the architecture takes into account three aspects of the application’s logic:
- What objects are stored in the database
- How the objects are accessed and updated
- How the objects interact with each other
In an ideal situation, information required by an application should be extracted from the database as quickly and with as little consumption of system resources as possible.
The better database architecture is, the faster application can obtain the necessary and sufficient amount of data, and the faster it can help the user.
Database Construction Basics
Databases store information in tables. Each table can have its own storage engine, and different storage engines perform differently. Their performance depends on algorithms handling HDD read-write requests, working with memory, data caching, and other features.
Therefore, the design of database architecture is inseparably connected with development of an application. A practical approach is to divide business objects in groups by their properties, access rates, and types of operations that will be performed upon them.
How an Application Masters the Database Content
When an application works with a database, it addresses database objects through primary and foreign keys. A good database architecture enables applications to take advantage of cascading relationships and retrieve the data in the most effective way.
The less database load created with each query, the more concurring operations you can do simultaneously. As an example, you can not only provide data workflow for some application, but also create database backups in a “hot” mode (without stopping the database engine).
Handy Backup and the Database Architecture
Our software can back up and restore databases independently of the storage engines used. For example, the MySQL Backup plug-in supports MyISAM, InnoDB and all other engines available in the system. Learn more about MySQL Backup...
In Oracle, backing up and restoring databases is operating through the dedicated Oracle backup utility called RMAN. This allows Handy Backup to support any version of Oracle (currently it is a version 12c), providing the utmost efficiency of any backup job.
Recommended Solution
$249 per license
Handy Backup Small Business
We welcome you to try the Small Business edition of our software - it’s a professional backup and recovery tool for Oracle, MySQL, MS SQL and other DBMS. Try free for 30 days!
Handy Backup Small Business
We welcome you to try the Small Business edition of our software - it’s a professional backup and recovery tool for Oracle, MySQL, MS SQL and other DBMS. Try free for 30 days!
See also:
Learn more:
- MySQL Master Server
"MySQL Slave Server is a server configured for MySQL replication. It constantly monitors and replicates all changes made to the database on the Master Server.…" - Database Dump
"Database dump is a text file containing a set of SQL statements that need to be run on an SQL server to create a database with the entire internal structure…" - Physical Backup
"Physical backup is a copy of an application’s binary files that is performed on hard drive level using common file system queries, rather than using the…"