One of the exemplary models of database management systems is the distributed database. Distributed database is the database that is under the command of a central database management system in which certain storage tools are not installed in a single CPU. The distributed database is installed in multiple computers located in the same location or these computers are located in different locations but under interconnected computers. In a distributed database, data are shared through partition fragments, and these fragments can be produced. Moreover, distributed database [...]

Today, we are now evolving into the world of more advanced technology. Many people in the line of business, education, medicine and other fields have taken on a new journey to make their jobs done more effectively and efficiently. The database is, by far, one of the best innovations made by man, but despite these advances in information technology, many users are still insatiable and would look for more ways to improve how things are usually done. That’s why database integration was conceptualized. With the [...]

In simple terms, a database is your electronic data filing system that keeps all the records of your documents and files and helps you organize them as well for future use. A database is important in that it creates an organized system of keeping all your information in a single or multiple file which you can easily access whenever you need them. However, there’s a lot more to consider than just deciding to get a program to manage your database system for you. You database [...]

When we are talking about database transaction, we are referring to a work or operation done within a management system of a database against another database using an understandable and reliable approach. This operation is done on its own without relying on another program. The transactions done in a database has two uses. First, the unit of work provided by the transaction produces accurate recovery of data whenever a failure occurs. It also keeps the information within the database accurate during the failure of the [...]

Database security is a series of processes and systems which are put in place to protect the database from any outside source that has a malicious intent or from anyone inadvertently accessing the database, whether they may be authorized or not. There are other security measures in place such as firewalls and routers, and these are some examples of those handling the external security of the database. Likewise, there are also network security systems in place to detect any malicious activity within the network. There [...]