Running head: DATABASE 1
DATABASE 4
Database implementation
Student’s name:
Institution:
Date:
Poorly implemented database
A database refers to a correction of information that is organized in a manner that makes it easily accessible, more comfortable to manage, and update. Computer database comprises of critical organizational information such as sales, debts, purchases other transactions. Databases managers offer the user the ability to control, aces, specify the generation of reports analyzing and exploiting the data (Martinez, 2017). Database security alludes to the measures an organization has implemented to safeguard data from both internal and external threats. A poorly implemented database brings many challenges to the users, as was with my experience in the banking institution in which I worked.
Development, deployment, and performance in the production are destined to have minimal troubles in case the database design is made in the right way. A correctly designed database will work as intended, however various errors in the database designing and implementation would lead to subsequent miseries. One of the poorly implemented databases that I have experience is the order management systems database that calls for a client to be assigned one or more addresses with the default salesperson connecting the firm and the client with one or two phone contacts. The database also contains critical information regarding transactions, such as the shipment dates. Numbers of boxes, bill of lading, and other personal data of the clients and suppliers such as freight charges, taxes, etc.
The poorly implemented database for the bank was the leading cause of errors and redundancy of tasks in the bank, coupled with long delays in decision making and execution of tasks. As an accountant, I was facing a significant challenge due to the confusing tables, views, columns, stored processes, functions, and triggers that were taking quite long to make sense. The order management system in the bank was characterized by low efficiency as customers were poorly served and billing addresses would be mixed up ("Example of a poorly implemented database | Online assignment help," 2018)One of the immediate impacts of the poor database implementation was a wrong making shipment as there was irregularly reviewing of the database which often led to the system's code migrating unnecessarily and the information would usually be mixed up leading to illegible data configurations.
I believe that some of the factors that contributed to the challenge were the redundant table, which re often a nightmare to the developers as they have to seek means of keeping diverse versions of the same information up to date, which calls for business logic. The other factor could be bad referential integrity, which is critical in keeping the data quality at its best ("Example of a poorly implemented database | Online assignment help," 2018). The database appeared to have few constraints in the design stages, which made it to overly rely on business logic and prone to human errors. The database managers failed to take advantage of the database engines, which is useful in providing services such as indexes that assist in speeding up the queries in the tables, analyzing information without the need for programming and programs that enable sophisticated calculations and data transformations (Compagnucci, 2019).
Some of the ways the challenges could be mitigated include having only one index on all columns diverse from primary keys used in querying the table and ordering the columns form the frequently applied to the least used can offer enhanced performance. It is also advisable that there should be proper naming conversions with the table name excellently describing what the entity entails ("path to improving database performance," n.d.) it would also be advisable for the developers to offer training to the employees on how to use the database and minimize the errors effectively.
References
Compagnucci, M. C. (2019). undefined. Springer Nature.
Example of a poorly implemented database | Online assignment help. (2018, September 26). Retrieved from https://myhomeworkwriters.com/example-of-a-poorly-implemented-database-online-assignment-help/
Martinez, F. (2017, October 20). Bad practices in database design: Are you making these mistakes? Retrieved from https://www.toptal.com/database/database-design-bad-practices