Database System Development Life Cycle

Running Head: DATABASE MANAGEMENT 1

DATABASE MANAGEMENT 2

Advanced Database Systems(CS352-1901A-01)

Database Management

Charles Williams

1/8/2019

Table of Contents Table of Contents…………………………………………………………………………………………………………………………………….2 The Database Models, Languages, and Architecture 3 Database System Development Life Cycle 5 Database Management Systems 6 Advanced SQL 7 Web and Data Warehousing and Mining in the Business World 8 References 9

Database management

It is important that a formal design methodology is used as it provides a mathematical approach to coming up with a reliable database that consolidates all the environments that use the database. A design methodology helps as it provides a way in which the whole designing and development can be done with minimum errors. The design methodology helps in identifying the requirements, the specifications and design levels of the database and data warehouse up for development. The planning stage of the consolidated data base is very important as it involves the coming up with plans that will guide the development of the database (Mabogunje, 2015). The plans help in managing quality, time, risks and other related issues that might affect the design and development of the database and eventually the data warehouse.

The three layers of the 3-level ANSI-SPARC architecture include; a physical schema which is responsible for defining how data is to be stored, a conceptual schema which is responsible for indexing and relating data, and the external schema which is responsible for showing how information was presented. The 3-level ANSI-SPARC type of architecture is designed to guard and guide data change. The primary function of the first layer is to define how data is stored. It is important to note that there can be changes in the physical schema and the changes will not affect how external applications will interact with the stored data (Pokorný, 2018). The second layer’s primary function is to provide a consolidated view of a database. The third layer’s primary function is to define richer APIs and it can do so without necessarily having to change the underlying storage mechanisms in place. The 3-level ANSI-SPARC architecture helps in promoting data independence which in turn helps save time in the long run through the conceptual schema which emphasizes data mapping.

Data administrator and database administrator

A data administrator is an individual whose function is to gather data requirements, analyze data as well as design data and classify data types. They two primary roles of a data administrator include; coming up with data standards that will be applied in databases, and coming up with policies that will dictate on data security, data access, data usage, dataflow well as data authorization in an organization. Other minor duties of data administrator include; playing an assistance role by coming up with data resources and allowing for the sharing of data across applications as well as across departments (Tenopir et al., 2015). Basically, Data administrators are primary deal with data flows and data needs in an organization.

On the other hand, a database administrator is an IT officer like individual whose primary responsibilities include; configuring and installing databases and database management systems, linking databases to information systems to help in application operations, ensuring that the database management systems in place are running optimally, checking and monitoring the database performance. The minor duties of a database administrator include ensuring data integrity and ensuring that appropriate data backups are made. (Yilmaz, O'Connor & Clarke, 2015). Basically, a database administrator is primarily supposed to oversee running and operations of database management systems.

I would recommend that my company hires two people, one as a data administrator and the other as a database administrator. The role of the data administrator will be to analyse and organize the data while the role of the database administrator will be to oversee the operations and functions of the database.

Database System Development Life Cycle(TBD)

Database Management Systems(TBD)

Advanced SQL(TBD)

Web and Data Warehousing and Mining in the Business World(TBD)

References

Yilmaz, M., O'Connor, R. V., & Clarke, P. (2015). Software development roles: a multi-project empirical investigation. ACM SIGSOFT Software Engineering Notes, 40(1), 1-5.

Tenopir, C., Hughes, D., Allard, S., Frame, M., Birch, B., Baird, L., ... & Lundeen, A. (2015). Research data services in academic libraries: Data intensive roles for the future?. Journal of eScience Librarianship, 4(2), 4.

Pokorný, J. (2018, March). Integration of Relational and NoSQL Databases. In Asian Conference on Intelligent Information and Database Systems (pp. 35-45). Springer, Cham.

Mabogunje, A. (2015). The development process: A spatial perspective. Routledge.