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??

SOLUTION

giltjr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

drmopco

ASKER

Thank you for your explanation. It helps me a lot to understand. I think that Operational databases support “operation”. Operational databases are optimized for fast updates. By normalizing a database you store complex data that is easy for the database to update. This increases the number of tables in the database. The problem is that it makes running queries and reports slower.
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.

ASKER CERTIFIED SOLUTION

haidersyed

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

drmopco

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.

haidersyed

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.

drmopco

ASKER

Thank you for the link. I am getting clear for the defination of data warehousing.
Thanks agian.