analyse the key issues and application of databases within o

analyse the key issues and application of databases within organisational environments

Solution

the key issues of Databases.

In an organizational environment, there are numerous issues associated with Databases, below are a few key issues among them

1)Data Quality: the quality of data stored on the database is a key parameter that that determines the efficiency and the ability of the database to perform its function. Incorrect and incomplete data in the database makes the database inefficient and unusable for any kind of reporting that needs to be done on top of it and also provides inaccurate data for the upstream systems.

2)Data Quantity: The quantity of the data stored in the database determines the speed of operation of the database. high volumes data cannot be retrieved with less turnaround time. Higher data retrieval times makes the database ineffective in meeting the query requirements for any associated reporting systems. There by creating a bottle neck to the operational activities.

3) Data Access/ Security: this is one of the very key issues associated with databases. With increasing use of digital transactions all kinds of the data is stored in databases in various forms. These data is classified into various means based on their nature like strictly confidential, confidential, business use, public etc. security features in most of the databases are not that effective making them vulnerable to many security threats and there by making the data at very high risk.

4) Data backup/ Version Control: Database systems are huge based on their nature of operations. Such huge databases needs to be backed up periodically to ensure the safety of the data and there by making the making it safe but this adds a huge overhead of data redundancy and also huge memory requirements to perform these backup. These backup servers add additional cost of the hardware required and the version control tools add software costs to this process making it financial burden in maintain a database system.

Key Applications of Databases:

Databases have many applications in organizational environment, below are a few key applications

1)Centralized Repository: Databases are used as centralized repository of any organization. This central repository can be used as all activities in an organization. The activities include HR repository to hold all the organizational information, Sales Inventory to hold the all the sales, outflow and inflow details etc.

2) Banking Sector: Databases have a very wide application in Banking sector. All the transactions associated with the banking needs to be stored and processed which is stored in the database. online banking, ATM and all banking related transactions require database support.

3) Medical Sector: Database has extensive applications in medical sector to store the patient info and their treatment details, maintain a repository of the doctors and their treatments along with all the medical prescription and transcription details

4) Sales & Marketing Sector: Databases have tremendous potential usage in Sales & Marketing as they are the primary gateways to products to the users in ecommerce and online marketing fields. They are used for storing the product info and providing the info when retrieved by users to shop from the product catalogue. Databases are used to store the client information and the various products marketed by various agents their targets and achievement all can be stored and used for further analysis in computation of their allowances etc.