
[ SolEuNet | Library | Education | DSS Resources ]
Decision Suppport resources on the web
A DSS (decision support system) is a computer program application that analyzes business data and presents it so that users can make business decisions more easily. It is an "informational application" (in distinction to an "operational application" that collects the data in the course of normal business operation).Typical information that a decision support application might gather and present would be:
- Comparative sales figures between one week and the next
- Projected revenue figures based on new product sales assumptions
- The consequences of different decision alternatives, given past experience in a context that is described
A decision support system may present information graphically and may include an expert system or artificial intelligence (artificial intelligence). It may be aimed at business executives or some other group of knowledge workers.
Further Information
Related Topics
<Obtained from http://www.sdgcomputing.com/glossary.htm >
Decision Support System (DSS)
A computer system designed to assist an organization in making decisions.
The Decision Support Systems and Enterprise Information Systems of the 1980's and early 1990's were forerunners of today's Business Intelligence Tools.
Business Intelligence Tools
Software that enables business users to see and use large amounts of complex data.
The following three types of tools are referred to as Business Intelligence Tools:
- Multi-Dimensional Analysis Software - Also Known As Multi Software or OLAP (On-Line Analytical Processing) - Software that gives the user the opportunity to look at the data from a variety of different dimensions.
- Query Tools - Software that allows the user to ask questions about patterns or details in the data.
- Data Mining Tools - Software that automatically searches for significant patterns or correlations in the data.
Multi-Dimensional Analysis
Also Known As: OLAP (On-Line Analytical Processing)
A process of analysis that involves organizing and summarizing data in a multiple number of dimensions.
People can comprehend a far greater amount of information if that information is organized into dimensions and into hierarchies. The wide use of spreadsheets and graphs illustrates the need for people to have their information organized.
A spreadsheet is a two-dimensional analysis tool. If a person could comprehend 10 individual facts, they could possibly comprehend 100 facts if they were arranged in a spreadsheet.
If 3 or 4 or 5 dimensions could be displayed, the amount of information that could be comprehended would be increased exponentially - to 1000 facts, 10,000 facts, and 100,000 facts.
We can't directly display more than two dimensions on a flat surface. But a variety of companies are producing multis - multi-dimensional analysis tools - that use a variety of clever ways of displaying multiple dimensions.
These tools also organize the data hierarchically, allowing users to "drill down" for more detailed information, "drill up" to see a broader, more summarized view, and "slice and dice" to dynamically change the dimensions that are being viewed.
OLAP (On-Line Analytical Processing)
The use of computers to analyze an organization's data.
"OLAP" is the most widely used term for multi-dimensional analysis software. The term "On-Line Analytical Processing" was developed to distinguish data warehousing activities from "On-Line Transaction Processing" - the use of computers to run the on-going operation of a business.
In its broadest usage the term "OLAP" is used as a synonym of "data warehousing". In a more narrow usage, the term OLAP is used to refer to the tools used for Multi-Dimensional Analysis.
"Think of an OLAP data structure as a Rubik's Cube of data that users can twist and twirl in different ways to work through what-if and what-happened scenarios." - Lee The, Editor, Datamation (May 1995)
Data Mining
The process of finding hidden patterns and relationships in the data.
Analyzing data involves the recognition of significant patterns. Human analysts can see patterns in small data sets. Specialized data mining tools are able to find patterns in large amounts of data. These tools are also able to analyze significant relationships that exist only when several dimensions are viewed at the same time.
Users can ask data questions using standard queries when they know what they're looking for. Queries can be written for questions like this: "Which of our out-of-town customers have given us the most business in the last year?"
Data mining is needed when the user's questions are more vague or general in nature. Data mining questions would include: "What attributes characterize the customers that gave us the most business in the past year?"
How Do DSS Environments Support Decision-Making?
( http://www.dpapplications.com/content.cfm?p=b0806000 )
DSS environments support the generic decision-making model above in a number of ways:
- In decision preparation, DSS environments provide data required as input to the decision-making process. This is interestingly enough, about all most data mart and data warehousing environments do today.
- In decision structuring, DSS environments provide tools and models for arranging the inputs in ways that make sense to frame the decision. These tools and models are not pivot tables and other aspects of data presentation found in query tools. They are actual decision-making tools, like fault tree analysis, Bayesian logic and model-based decision-making based on things like neural networks.
- In context development, DSS environments again provide tools, and provide the mechanisms for capturing information about a decision's constituencies (who's affected by this decision), outcomes and their probabilities, and other elements of the larger decision-making context.
- In decision-making, DSS environments may automate all or part of the decision-making process and offer evaluations on the optimal decision. Expert systems and artificial intelligence environments purport to do this, but they work only in very limited cases, because of some fundamental flaws in the technology (namely, their inability to deal with non-binary, or fuzzy, choices, like "it's more likely that we'll lose market share than win it," which is a rule that no traditional AI-based system can code).
- In decision propagation, DSS environments take the information gathered about constituencies and dependencies and outcomes and drive elements of the decision into those constituencies for action.
- In decision management, DSS environments inspect outcomes days, weeks and months after decisions to see if (a) the decision was implemented/propagated and (b) if the effects of the decision are as expected.
So, what commercial products do this today? Outside of very limited cases, focused on specific problems in very high-risk areas (like bomb disposal, scheduling airplanes into airports, arranging railroad cars on trains), none do. Most commercial DSS products don't do anything except decision preparation: they dump data on the desktops of decision-makers, saying in effect, "You must know what to do with this."
See Also
( http://dssresources.com/ )
Slides/Notes about DSS
Additional Stuff
< Obtained from SearchEBusiness.com, SearchDatabase.com, and SearchCRM.com >
- Data warehousing with intelligent agents Intelligent Enterprise
"Intelligent agents" can help data processing and data analysis functions that are supplied by your data warehouse. Using artificial intelligence techniques and employing user identity data, inference engines and stored knowledge, the agents can help automate warehouse data gathering or performance monitoring, as well as provide powerful, intuitive, customized user interfaces to the data. (Oct. 28, 2000)
http://www.intelligententerprise.com/db_area/archives/1998/9810/feat1.shtml
- Companies see gold in outside data analysis Planet IT
Internet e-businesses and large CRM applications are causing some corporations to consider outsourcing for their data warehouses, in spite of some lingering concerns about letting someone else manage the 'company jewels'. Users Jewelry.com, Hilton Hotels and NASD describe their own projects to outsource their warehouses, and focus inhouse projects on data analysis and decision support. (March 20, 2000)
http://www.planetit.com/techcenters/docs/database/technology/PIT20000322S0008
- New tool matches buyers, sellers Planet IT
Emptoris' ePass software uses an "optimization engine" to quickly determine buyer and seller requirements and options. The algorithms used allow users to set priorities and create what-if scenarios based on business rules and quality measures. New York-based MoveNet is using the software to service its network of almost 4,000 moving companies in the US. (June 21, 2000)
http://www.planetit.com/techcenters/docs/e-commerce/news/PIT20000621S0013
- Networking / Internetworking Cisco Press
Web site includes synopses of scores of books covering network design, administration and support, security, routing, switching, voice/video/telephony, WANs, remote access and Cisco's IOS. Linked pages include books on Cisco's professional certification programs, its Networking Academy and IOS documentation.
http://www2.ciscopress.com/series.cfm?series=1&news=0
- Logical design of a data warehouse to support reporting, ad hoc query, Executive Information Systems, and Decision Support Systems Dulcian, Inc.
Dr. Paul Dorsey's paper is straightforward, clearly written, and easily understood for DBA's weighing the factors involved in building a data warehouse for use with ad hoc tools. He presents a compelling argument, supported by real-world examples.
http://www.dulcian.com/magazine%20articles/Logical%20Design%20of%20a%20Data%20Warehouse.htm
- 1999 Data warehousing buyer's guide Data Warehousing Institute
Developers and DBA's can search this buyer's guide for information on products and services available for data warehousing, data mining, data marts, decision support, and business intelligence. Also included are articles developed by those in the data warehousing industry and success tips from The Institute’s executive management team.
http://www.dw-institute.com/buyersguide99/
- Using financial data marts to facilitate true understanding DM Review
Tom Phelps' article for DBA's describes the the purpose of a financial data mart (FDM) as being an analytical solution that proactively integrates with the entire enterprise. He insists that success hinges upon having an information strategy already in place to get the most out of your FDM.
http://www.dmreview.com/editorial/dmdirect/dmdirect_article.cfm?EdID=2305&issue=111000&record=2
- Technology and policy in decision support systems Decision Point Applications, Inc.
This white paper addresses the relationship between DSS infrastructure -- data warehouses, data marts, OLAP applications and the like -- and the decision-making processes that, when properly supported by DSS infrastructure, deliver business value to the firm.
http://www.dpapplications.com/content.cfm?p=b0806000
- Traditional Decision Support Systems DM Review
Published in Sept. 1999, this article written for administrators takes a look at traditional decision support systems (DSSs) and the reasons why they have not provided complete, correct, and timely information to the organization.
http://www.dmreview.com/master.cfm?NavID=55&EdID=1365
- DSstar Tabor Griffin Communications
A free weekly online newsletter covering data mining and warehousing, decision support technologies, OLAP, and OLTP. Lots of original content and industry news.
http://www.tgc.com/dsstar/
- Exploration Warehousing White Cross
This white paper by WH Inmon addresses the issue of business exploration in theDSS, data warehouse environment. In order to satisfy the very unstructured needs of this analytical approach, according to the author, a separate architectural structure called an exploration warehouse is required (June, 2000).
http://www.whitecross.com/files/inmon.pdf
- Real World Decision Support newsletter EWS
A free newsletter designed to address decision support issues.
http://www.ewsolutions.com/newsletter.asp
- Building a Decision Support Architecture for Data Warehousing ZD Inc.
Describes how today's increasingly affordable technology makes it possible to access large amounts of data from a variety of sources, analyze it, and derive measurable results. (free registration required)
http://techguide.zdnet.com/titles/decsup.shtml
- Financial DSS environments: requirements and use cases Decision Point Applications Inc.
Overview of the requirements and uses of financial decision support (DSS) environments using real-world case study data and real-world business questions.
http://www.dpapplications.com/content.cfm?p=B0812000
Integrating DecisionPoint into Enterprise-Wide decision support Environments DecisionPoint, Inc.
Organizations that have designed, and are in the early stages if implementing, comprehensive data warehousing infrastructures, are often at a loss to understand how they can leverage the time, cost and functionality advantages of DecisionPoint products within that infrastructure. This company white paper summarizes the deployment options open to organizations considering the use of DecisionPoint products within their enterprise-wide data warehousing environment.
http://www.dpapplications.com/content.cfm?p=b0814000
- An Introduction to Data Mining and Advanced DSS Technology Kurt Thearling
An excellent eighty-eight slide presentation introducing the technology, including its goal, uses, pros and cons.
http://www3.shore.net/~kht/dmintro/dmintro.htm
- Query performance in OLTP and DSS environments Decision Point Applications Inc.
Uses a real-world operational financials environment to demonstrate conclusively that decision support (DSS) environments represent a technically- superior alternative to running complex queries against production databases.
http://www.dpapplications.com/content.cfm?p=b0810000
- Data Legibility in Decision Support Systems DecisionPoint Applications
The classical paper on star schema design, data denormalization, and data legibility in decision support systems (DSS) design, has been updated and enhanced.
http://www.dpapplications.com/content.cfm?p=b0802000
- Knowledge management appears on ERP radar ERP Hub
As companies obtain more and more data through their ERP applications, they need to decide what to do with the information gathered. This article looks at the management of knowledge.
http://www.earthweb.com/dlink.resource-jhtml.72.981.|repository||itmanagement|content|article|2000|06|16|EMraddingknowledge|EMraddingknowledge~xml.0.jhtml?pageNo=1&cda=true
SolEuNet,
Peter.Flach@bristol.ac.uk. Last modified on Thursday 29 November 2001 at 16:19. © 2001 SolEuNet