DBMS Tutorials 28 Lessons

DBMS Methodology (Conceptual)

In this chapter, you will learn about the methodology for the database design stage of the database system development lifecycle for relational databases. The methodology is depicted as a bit by bit guide to the three main phases of database […]

    DBMS Methodology (Logical)

    You have already come across the basics of what methodologies are and its stages. You have gathered the basic concept of what conceptual methodology is and how it works within the main stages of the database system development life cycle. […]

      DBMS Methodology (Physical)

      This physical methodology is the third and final phase of the database design methodology. Here, the designer must decide how to translate the logical database design (i.e., the entities, attributes, relationships, and constraints) into a physical database design which can […]

        DBMS Transaction

        Earlier you have learned about the functions that a Database Management System (DBMS) should offer database users. Among these there are 3 closely related functions that are intended to ensure that the database is reliable and remains in a steady […]

          DBMS Query

          When the relational model was launched for the first time, one of the chief criticisms often cited was the inadequate presentation of queries. Since then, a significant amount of research has been committed to developing highly proficient algorithms for processing […]

            Distributed DBMS

            Database technology has transformed the database users from a paradigm of data processing where each application described and uphold its data, to one in which data is defined and managed centrally. During recent times, you have seen the fast and […]

              Database Replication

              From the earlier chapter, you have got the idea of what a distributed Database management system is? In this chapter, you will be learning about the opposite of the previous concept and potentially more simplified version of data distribution provided […]

                Mobile Databases

                You might have noticed the ever-increasing demands on mobile computing for providing the types of support required by a growing number of mobile workers and its technology. Such individuals require working as if they are in the office, but in […]

                  Transaction and Concurrency Control

                  DBMS implements a concurrency control technique using a protocol which prevents database accesses from prying with one another.

                  • What is Transaction in DBMS?
                  • What is Concurrency Control in DBMS?

                  Data Recovery in DBMS

                  Data Recovery is the method of restoring the database to its correct state in the event of a failure at the time of the transaction or after the end of a process.

                  • What is Data Recovery?
                  • What is the Need for Recovery of data?
                  • Recovery Facilities.

                  Web-based Database Management System

                  The Web-based database management system is one of the essential parts of DBMS and is used to store web application data. Web-based Database management system is used to handle those databases that are having data regarding E-commerce, E-business, Blog, e-mail and other online applications.