other · 2023

Database Deployment

Cited by 0Open access

Abstract

Relational databases are complex pieces of software that process and store vast amounts of data.Careful planning is needed to ensure that a database meets the needs of the people who use it and the applications that use it for storing and retrieving data.The ultimate objective is to create a database that satisfies users, meets operational demands, and requires minimal maintenance.As a data systems analyst, you will be a crucial perspective as part of the team that brings a new database to life.In this chapter, we will first explore considerations for database implementation planning.We will then examine some fundamental questions influencing database design, ensuring that the database fits into an organization's strategic architectural direction, and then delve into the artifacts essential for a well-understood database design.With an understanding of how to plan and design a database, we will examine the implementation, testing, and deployment phases that take a database from concept to reality. Planning and DesignThe planning and design phases are vital to creating a dependable, reliable, and operationally viable relational database.Proper planning and design can ensure the database is scalable and secure, in addition to performing well while reducing the risk of data corruption and loss.The planning and design process is iterative, as you might surface a new requirement during planning that influences design.The goal of this phase is a database design consistent with an organization's strategic architectural goals.The design should also align with the organization's overall technology strategy.This phase produces several artifacts, including requirements specifications, a conceptual data model, a logical data model, a physical data model, a data dictionary, and other design documents.These artifacts are vital for database administrators, application developers, and other stakeholders who will end up using the database. Requirements GatheringRequirements gathering is a critical step in the database design process, as it ensures that the database meets the needs of its users and applications.As you start to gather requirements, 10.

Cite this paper

APA 7

(2023). Database Deployment. https://doi.org/10.1002/9781394277094.ch4

MLA 9

“Database Deployment.” 2023, pp. 87–146, https://doi.org/10.1002/9781394277094.ch4.

Chicago

2023. “Database Deployment.” https://doi.org/10.1002/9781394277094.ch4.

Harvard

(2023) ‘Database Deployment’. Available at: https://doi.org/10.1002/9781394277094.ch4.

BibTeX

@misc{anon2023database,
  title = {{Database Deployment}},
  pages = {87--146},
  year = {2023},
  doi = {10.1002/9781394277094.ch4}
}

Made from the index record. Check names, capitalisation and page numbers against the paper. Need another style? AI for Research has over 10,000.