Using Databases in Decisions Systems for Businesses
International Journal of Data Science and Analysis
Volume 2, Issue 2, December 2016, Pages: 15-20
Received: Sep. 5, 2016;
Accepted: Oct. 20, 2016;
Published: Nov. 21, 2016
Views 4308 Downloads 136
Dănut-Octavian Simion, Economic Informatics Department, Athenaeum University, Bucharest, Romania
Follow on us
The paper presents the usage of databases that store business data into a warehouse star model that permits to create queries using SQL language and business intelligence tools. This kind of model allow to the decision maker to create complex reports and graphs based on the columns from the dimension tables and measures from fact tables, that can be the base for creating alternatives and scenarious acording to the economical indicators. Building alternatives and scenarious is an elaborate task and must have a background in existing data structured in databases that have a special structure of dimensions and fact tables. This data warehouse star model allow complex analyses such as rollup, drill down, slice and dice through the dimensions and fact tables by using special tools such as online analythical processes and complex queries based on views and snapshots. To create simulation envolves changing strategic economical indicators and keeping restrains on others so they reflect reality and the business environment. The business environments require analyses on large amount of data, big data and necessitate advanced tools to query through numerous criterias and also to create different realistic scenarious that allow choosing one option, so the business manager can use the right tool to gain economic advantage.
Business Intelligence Tools, Datawarehouse Star Model, SQL Queries and Reports, System Support Decisions, Analytical Tools and Management Decision
To cite this article
Using Databases in Decisions Systems for Businesses, International Journal of Data Science and Analysis.
Vol. 2, No. 2,
2016, pp. 15-20.
Copyright © 2016 Authors retain the copyright of this article.
This article is an open access article distributed under the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0/
) which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Daniel J. Power, “Examples of decision support systems (DSS) aiding business decision-making”, http://searchbusinessanalytics.techtarget.com/tutorial/How-decision-support-systems-DSS-can-help-business-decision-making, 2015;
Chang L, “Database Technologies for Decision Support System”, https://blogs.msdn.microsoft.com/csliu/2010/02/05/database-technologies-for-decision-support-system/, 2016;
Gupta, Jatinder N. D., Thomas M. Harris, “Decision Support Systems for Small Business”, Journal of Systems Management, 2015;
Muller-Boling, Detlef, Susanne Kirchhoff, “Expert Systems for Decision Support in Business Start-Ups.”, Journal of Small Business Management, 2015;
Ramon Barquin, “Data warehousing: building the foundation”, http://searchdatamanagement.techtarget.com/, 2014;
Surajit Chaudhuri, Umeshwar Dayal, Venkatesh Ganti, “Database Technology for Decision Support Systems”, IEEE Computer Society Press Los Alamitos, CA, USA, 2014;