************************************************************
DSS News
by D. J. Power
November 5, 2000 -- No. 14
A Bi-Weekly Publication of DSSResources.COM
************************************************************
Check the Book Store at http://dssresources.com
************************************************************
Featured:
* DSS Wisdom
* Ask Dan! -- What Data Warehouse software and configurations are
used in universities?
* What's New at DSSResources.COM
* DSS News Stories
************************************************************
We have more than 2100 unique visitors each week at DSSResources.COM
and more than 360 subscribers to this newsletter. Please forward this
email to people interested in Decision Support Systems.
************************************************************
DSS Wisdom
"Properly designed for appropriate problems, these [management decision]
systems can have a significant impact on the decision process. This is
of importance because most of management's decisions, the unstructured
decisions, have not been well supported by analysis and information in
the past. There is still a great deal to be learned, but no major
company can afford not to have some active program in this area. The
technology is available and becoming less expensive, the major concepts
and issues are clear; what is lacking is management's understanding of
these concepts and their willingness to become involved. (pp. 152-53)"
from Scott Morton, Michael S., Management Decision Systems:
Computer-Based Support for Decision Making. Boston: Harvard University,
1971.
************************************************************
Ask Dan!
What Data Warehouse software and configurations are used in
universities?
The best source for finding some information on this topic is at
http://www.georgetown.edu/users/allanr/dwconfig/ . Ron Allen maintains
the Web page for the EDUCAUSE Decision Support/Data Warehouse
Constituency group. Some of the information is out-of-date, but the new
policy is to post the date when data is entered.
I'll summarize the data warehouse configurations for 40 U.S.
Universities that are posted at the Georgetown Web site.
Databases: Oracle is the dominant database in use for university
datawarehouses. More than half of the universities reporting had some
version of Oracle. The most recent version in use is Oracle 8i (at only
2 universities). IBM's DB2 was the next most popular database with 5
installations. Sybase, Microsoft SQL Server 7.0 and NCR Teradata are
used at 2 universities each.
Data Modeling Tools: Most universities are not using data modeling
tools. ERWin is used by DW teams at 4 universities.
Query Tool: Brio and the Microsoft products (Access and Excel) are the
most commonly used query and analysis tools. Fifteen universities report
using a Brio product. Only one seems to have implemented Brio Insight
accessed through the Brio Portal. Single universities are using Crystal
Reports, Hyperion, Cognos’ Impromptu, Hummingbird BI/Query,
MicroStrategy, Business Objects, SPSS, and SAS products. A few
universities have plans to migrate to Cognos products.
File Configurations to Users: A Star Schema is the most common file
configuration reported. Some schools more generally indicate they are
using denormalized tables and summary files.
Systems Covered: The most common systems included in the university data
warehouse are financial, human resource, courses and students. Some
schools have other systems in the warehouse like financial aid, student
fees, research, property, alumni development, admissions, and
purchasing. Some schools claim to have integrated the data in the
warehouse.
Ron Allen reported in a recent email (Thu, 26 Oct 2000) that Georgetown
is at the "dawn" of implementing their datawarehouse. He said we are
"just beginning to build our production marts after developing
successful prototypes". He notes Georgetown has one manager, "one
systems analyst, one programmer, ½ data base administrator and we are
recruiting a data administrator" assigned to the DW projects.
So what is the big picture on data warehousing in universities. The 40
universities that reported data are in various stages of warehouse
development and the sophistication of the technology varies enormously.
Universities seem behind U.S. Fortune 2000 companies in implementing
data warehouses/OLAP and especially Web-Based DSS.
P. S. Please send me your comments or post them to the DSSResources.COM
Bulletin Board.
************************************************************
What's New! at DSSResources.COM
11/03/2000 Updated DSSResources.COM Vendor List.
10/31/2000 Posted Chapter 9 DSS Book Slide Show.
10/29/2000 Updated and posted Chapter 10 "Building Knowledge-Driven DSS
and Mining Data" of the DSS Hyperbook.
10/25/2000 Posted Chapter 7 and Chapter 8 DSS Book Slide Shows.
10/25/2000 Added an AIS banner ad to 4 pages at DSSResources.COM
10/24/2000 Updated HTML/Programming Links page.
************************************************************
DSS News Stories - Oct. 21 to Nov. 05, 2000
Note: The full press releases are available at DSSResources.COM.
11/03/2000 Aberdeen Group report argues Collaborative Product Commerce
software may revolutionize product innovation and manufacturing
processes.
11/02/2000 Oracle's E-Business Suite won the Intelligent Enterprise
Readers' Choice Award in 3 categories.
11/01/2000 Bon Appetit chose Instill Purchase Insight to provide data
warehousing and business intelligence services for 160
units.
10/31/2000 DM Review Top 10 business intelligence vendors will be
announced by live Webcast on November 17, 2000.
10/31/2000 Polycom ViaVideo for Desktop and Laptop PCs improves
productivity and teamwork.
10/30/2000 Jim and David Matheson, authors of "The Smart Organization",
are forming a new decision support company
called SmartOrg. Inc.
10/27/2000 Microsoft’s network was hacked and intruders may have stolen
code for software.
10/27/2000 A telework website, ExecutiveWorks.com offers on-line demos
of its virtual office management products.
10/26/2000 AlphaBlox announced a Web-based, non-client/server
spreadsheet that connects to live corporate data sources.
10/25/2000 Informix Software announces Red Brick Decision Server 6.1;
its new features pave the way for improved decision
support.
10/24/2000 Peregrine Systems expands knowledge management capability in
next-generation employee self service suite.
10/24/2000 Virtual Gold provides MLB.com with statistical facts mined
from World Series game data.
10/23/2000 ClearForest announced ClearSight, a Web-based Application
Service that uses semantic, rules-based technology to read and analyze
text.
10/23/2000 AccuSoft announced the new version of its innovative
web-based document management solution - NetVue 3.1.
10/23/2000 John Galt Solutions, Inc. introduced the ForecastX Engine, a
comprehensive Web-based package designed to manage and automate the
demand planning and forecasting processes.
************************************************************
This newsletter is available online at
http://dssresources.com/newsletters/ .
************************************************************
DSS News is copyrighted (c) 2000 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 .
|