Question

Identify and discuss the importance of different technologies used in operational database systems and in decision support database systems.

Answer 1

Operational Database

=> An operational database is a database that is used to manage and store data in real time.

=> Elements in an operational database can be added and removed on the fly.

=> These databases can be either SQL or NoSQL-based, where the latter is geared toward real-time operations.

=> An operational database is a database that stores data inside of an enterprise. They can contain things like payroll records, customer information and employee data.

=> They are critical to data warehousing and business analytics operations.

=> The key characteristic of operational databases is their orientation toward real-time operations, compared with conventional databases that rely on batch processing.

=> With operational databases, records can be added, removed and modified in real time

=> Operational database management systems can be based on SQL but a growing number are using NoSQL and nonstructured data.

DrawBacks

=> Operational Databases require significant upfront and ongoing financial resources.

=> The complexity is very high for the implementation for Operational Database.

=> Security is not upto the highest standards.

Decision Support Database

=> A database from which data is extracted and analyzed statistically (but not modified) in order to inform business or other decisions.

=>  This is in contrast to an operational database which is being continuously updated.

=> For example, a decision support database might provide data to determine the average salary of different types of workers, whereas an operational database containing the same data would be used to calculate pay check amounts.

=> Decision Support is provided by making the data meaningful. Data in rows only fill the tables but nothing else.

=> So there should be models to convert the collected data into tools which helps to decision making process.

=> The model is depends on the work, sector, purpose of the decision support system.

=> Decision Support System should be able to answer the question what is going on our system.