drmopco
asked on
BI and DSS
Dear experts.
I was wondering that how business intelligence and decision support database differ from operational database? I think that the operational database is the data collected on a daily bases and BI and DSS is information gathered for strategic and analytical purpose. Am I hitting the right target??
I was wondering that how business intelligence and decision support database differ from operational database? I think that the operational database is the data collected on a daily bases and BI and DSS is information gathered for strategic and analytical purpose. Am I hitting the right target??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your time. I think that an operational database is used to manage more dynamic bits of data. These types of databases allow you to do more than simply view archived data. Operational databases allow you to modify that data which includes adding, changing or delete in under words manipulation of data Thus making it possible for users to track real-time information. For example, a company might have an operational database used to track quantities of material in stock and out stock. When client purchase materials this database can be used to give an accurate amount of material purchased and sold. On the other hand Business Intelligence is a broad is a broad category of application programs and technologies for gathering, storing, analysing, and providing access to data to help enterprise users make better business decisions. BI applications include the activities of decision support, query and reporting, online analytical processing (OLAP), statistical analysis, forecasting, and data mining. In a short form Operations database give access to manipulate and Business gives an analytical processing.
You are exectly right.
I found basic useful basic definations of data warehousing catagories of DW and OLAP etc on section of www.findabout.net. you can verify it.
Let me know if i can help you out in any area.
ASKER
Thank you for the link. I am getting clear for the defination of data warehousing.
Thanks agian.
Thanks agian.
ASKER
Business intelligence and decision support databases are often times read only and do not require updating. Their tables are optimized for searching, queries, and reports. Often time you will denormalize the database to reduce the number of the tables. This decreases the time required to search the database. I hope I am hitting right target.