Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What Data Warehouse software and configurations are used in universities?

April 26, 2017configurations Data Software universities Used warehouse

0

Posted

What Data Warehouse software and configurations are used in universities?

1 Answer

0

Posted

The best source for finding information on this topic is on the Higher Education Data Warehouse Configurations page 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 site policy is to post the date when information was entered.I’ll summarize the data warehouse configurations for 40 U.S. Universities that were posted at the Georgetown Web site in November 2000.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 univers