Database System Concepts, Implementations and Organizations ? A Detailed Survey

The inclusion of database and database management system in the use of data is of paramount importance. Database design, access and management are equivalent to plumbing. Like plumbing, there are dozens of segments that must be put together before the whole thing works. In fact, database systems are now so common and form such an integral part of our day-to-day life that often we are not aware we are using one. The methodology of this survey covers both industrial and academic environments, and divided into three phases: (i) a conceptual database design phase, in which a model of the data is developed and used in an organization independent of all physical considerations; (ii) a logical database design phase, in which the developed relational model of the data independent of any particular DBMS and other physical considerations is developed; (ii) a physical database design phase, in which the implementation in the target DBMS, such as Microsoft Access, Microsoft SQL Server, Oracle, DB2, or Informix is realized. Also, examined, are what constitutes a database system and how this tool can bring great benefits to any organization that chooses to use one; with a deep look at all the important aspects of database systems design, implementation and management including conceptual database, Schemas, Database Management Systems, Implementation Database, Logical and Physical Database Organizations and structure, with their basics, problems or shortcommings, benefits, requirements, components, types and roles, implementations and organizations.