Database Issues: Problems and Mitigation Strategies
Added on 2022-11-09
5 Pages870 Words301 Views
|
|
|
Running head: DATABASE ISSUES
DATABASE ISSUES
Name of the Students
Name of the Universities
Author Note
DATABASE ISSUES
Name of the Students
Name of the Universities
Author Note
1
DATABASE ISSUES
Problems faced by organizations due to improper database implementation are as
follows:
a. Improper documentation of database in production sector: It is seen that there are three
major issues that there are causes due to improper and inefficient database management.
These issues are namely incomplete documentation, inaccurate documentation and none at all
documentation (Gulzar et al, 2017). Due to these issues centralization of the data is affected
and is noted that centralization of data is null at few times. In case centralization of data is not
done, understanding of the impact caused due to change inn the system gets difficult. This
creates an issue for the developers to scramble to the first page again.
Mitigation process: This issue can be mitigated with the help of placing the models
in central repository along with spawning the reports automatically which will be taking a
minimal effort. Once this model gets established with passing time the quality metrices will
be improving. Once the governance process increases, it can be stated that the extension of
metadata captured in the models can be made.
b. Another major issue that can be detected inn tis process of having a least efficient database
is improper normalization. Due to lack of normalization of the data the main issue that can be
considered is that the flexibility of the data will be absent. This absence of flexibility of data
is not desired (Connolly & Begg 2015). This will lead to a situation where there will be
several columns left empty and the programmer of the organization has to code for those null
values as well, making the entire process highly complex (Hogan 2018). Repetitive storage of
value is also seen in this case. This leads to the fact that the data that will be stored and used
will not get updated in a regular manner.
Mitigation process: The mitigation strategy that can be implemented in this process
is performing proper normalization of the data. Usage of first form normalization of the data
DATABASE ISSUES
Problems faced by organizations due to improper database implementation are as
follows:
a. Improper documentation of database in production sector: It is seen that there are three
major issues that there are causes due to improper and inefficient database management.
These issues are namely incomplete documentation, inaccurate documentation and none at all
documentation (Gulzar et al, 2017). Due to these issues centralization of the data is affected
and is noted that centralization of data is null at few times. In case centralization of data is not
done, understanding of the impact caused due to change inn the system gets difficult. This
creates an issue for the developers to scramble to the first page again.
Mitigation process: This issue can be mitigated with the help of placing the models
in central repository along with spawning the reports automatically which will be taking a
minimal effort. Once this model gets established with passing time the quality metrices will
be improving. Once the governance process increases, it can be stated that the extension of
metadata captured in the models can be made.
b. Another major issue that can be detected inn tis process of having a least efficient database
is improper normalization. Due to lack of normalization of the data the main issue that can be
considered is that the flexibility of the data will be absent. This absence of flexibility of data
is not desired (Connolly & Begg 2015). This will lead to a situation where there will be
several columns left empty and the programmer of the organization has to code for those null
values as well, making the entire process highly complex (Hogan 2018). Repetitive storage of
value is also seen in this case. This leads to the fact that the data that will be stored and used
will not get updated in a regular manner.
Mitigation process: The mitigation strategy that can be implemented in this process
is performing proper normalization of the data. Usage of first form normalization of the data
End of preview
Want to access all the pages? Upload your documents or become a member.