出版社：Bucharest Academy of Economic Studies Publishing House
摘要：Understanding and analysis data is essential for making decision within a system. Any analytical tasks can be implemented directly by the transactional system but it becomes more difficult as the transactional system grows. Analytical systems and their extension appear as a solution for complex and large datasets. We think that it's time for medium companies to get the benefit from such systems as analytical systems become more variant and in hand for every possible user. In this paper, we propose an architecture of analytical system that can adapt and integrate with existent transactional system of timber export company. The proposed analytical system should have the ability of implementing the tasks required by the decision makers of the system. Also, we try to explore the ability of SQL server of implementing our proposed architecture.
关键词：BI(Business intelligence); DSS(Decision support systems); DW(Data warehouse); OLAP(Online Analytical Processing); ETL(Extract; transform and load); SAS(SQL server services).
