************************************************************
DSS News
by D. J. Power
August 12, 2001 -- Vol. 2, No. 17
A Bi-Weekly Publication of DSSResources.COM
************************************************************
Check the DSS Career Center at http://dssresources.com
************************************************************
Featured:
* DSS Wisdom
* Ask Dan! -- Does data modeling differ for a Data-Driven DSS?
* DSS News Stories
************************************************************
Each week in the summer, we have about 2700 unique visitors at
DSSResources.COM. Also, this newsletter has almost 600 subscribers from
50 countries. Please forward this newsletter to people interested in
Decision Support Systems or suggest they visit DSSResources.COM and
subscribe.
************************************************************
DSS Wisdom
In 1992, Bill Inmon, a pioneer in the field of data warehousing, defined
a data warehouse as "a collection of integrated, subject-oriented
databases designed to support the DSS (decision support) function, where
each unit of data is non-volatile and relevant to some moment in time.
(p. 5)"
from Inmon, W. H., Building the Data Warehouse, New York: Wiley, 1992.
************************************************************
IFIP WG 8.3 Conference on Decision Support Systems (DSS),
Decision Support in the Internet Age, Cork, Ireland,
July 4-7, 2002. Paper submissions due November 30, 2001.
Check http://afis.ucc.ie/dsiage2002/.
************************************************************
Ask Dan: Does data modeling differ for a Data-Driven DSS?
A conceptual data model shows the overall logical structure of
a database. A data model should be independent of any software or
data storage structure. In general, a data model is any method for
visualizing the information needs of a system (check
http://www.datamodel.org).
Much of the discussion of data modeling uses examples from
transaction processing systems. This makes sense because
much of the formalism of data modeling was developed to reduce data
redundencies and to avoid anomolies or errors from add, update and
delete actions in a Database Management System. These issues of
redundancies and anomalies are not generally relevant when building
Data-Driven DSS with historical data.
So is data modeling still important when building Data-Driven DSS? YES.
Data modeling organizes a database designer's thinking about the
appropriate structure for the decision support data store. It is still
useful to think about entities and relationships in a data model to help
identify data that should be extracted from transaction processing
systems for decision support.
For example, if we want to monitor and improve decision-making
about product sales we need to look at key entities like
the Customer (a person with attributes), Salesperson
(a type of employee with attributes), Product (Inventory SKU's),
and Sale (a transaction with attributes like date, time, quantity).
A number of relations help understand the data in the sales transaction
process:
-- A customer may have zero or many sales transactions.
-- A particular sale belongs to 1 and only 1 customer.
-- A particular sale is prepared by no more than 1 salesperson.
-- A salesperson may have zero or many sales transactions.
-- A particular sale can have 1 or more products sold.
-- A product can be sold in 0, 1, or many sales transactions.
The above relations help a DSS "Data Modeler" understand
what data may be useful to aggregate, what data may benefit
from redundant entries and what data may not be needed for
decision support.
The objective of data modeling is somewhat different when a DSS data
store is being designed, but one is still trying to gain a rigorous
understanding of how data should be stored in a database before
building and implementing a specific system.
The job title "Data Modeler" is used differently depending on
the company and task environment. A search for "Data Modeler" positions
in the DSS Career Center indicates that many companies recognize someone
needs to design and structure a dart mart, data warehouse or DSS data
store.
Please feel free to comment on differences in modeling data for decision
support and transaction processing systems.
************************************************************
The DSSResources.COM DSS Career Center has more than 100 job listings
for "Data Modeler". Check openings at John Deere, EMC Corporation,
Apple Computers, Cap Gemini Ernst & Young, and many other major
companies.
************************************************************
DSS News Stories - July 30 to August 12, 2001
08/12/2001 IBM 5150 PC was introduced on Aug. 12, 1981. Happy 20th
anniversary.
08/10/2001 SAP Portals certifies SAS® software interface to Business
Information Warehouse.
08/08/2001 Leading Japanese computer retailer uses SPSS Clementine to
improve online profits.
08/08/2001 SPSS Enabling Technologies Division and Azerity form
strategic alliance.
08/08/2001 PGA of America increases productivity and lowers costs with
Crystal Decisions reporting.
08/07/2001 MathSoft introduced Web-based Mathcad Client; it enables
workgroup communication.
08/06/2001 Intranets.com added new document management features
including web folders for its web-based intranets.
08/01/2001 SAP portals listed as leader in 2H01 Portal Products Magic
Quadrant.
07/30/2001 Cognos extended Web-Based financial solution with launch of
Cognos Finance 5.1.
************************************************************
This newsletter is available online at
http://dssresources.com/newsletters/ .
************************************************************
DSS News is copyrighted (c) 2001 by D. J. Power. Please send your email to
power@dssresources.com. You have previously subscribed to the DSS News Mailing
List. To unsubcribe, send an email to dssresources-unsubscribe@topica.com .
|