NBA 518 Spring 2004:
Enterprise Data Modeling and Analysis

This course has two goals. The first goal is to introduce the big picture of modern enterprise information architectures and their components from a manager's point of view. The course will introduce three-tier architectures, modern database management systems, web servers, application servers, and associated concepts such as XML, web services, .NET, and Java Enterprise.

The second goal is to gain hands-on experience in two important topics: Data modeling and data mining. We will learn how to model business scenarios using the entity-relationship model and the relational model using a commercial data modeling tool, DeZign for Databases. We will then dive in-depth into modern data mining technology, covering the knowledge discovery process, data pre-processing, classification, clustering, association analysis, and data mining model evaluation using a commercial data mining tool, SAS Enterprise Miner.

Announcements:

• February 21, 2004. The lectures on Monday, March 1, and Wednesday, March 3, will take place in the lab.

• February 18, 2004. The next lecture on Monday, February 23, will take place in our regular class room, 134 Sage Hall.

• February 9, 2004. We could not get the lab today. Today's class is still in 134 Sage Hall, and we will start with data mining. I have the lab reserved for Feb 11 and all the remaining class days just in case.

• February 4, 2004: Today's class will take place in the regular classroom in 134 Sage Hall. The class on Monday, February 9 will be in the lab. Homework 1 is now online.

• February 3, 2004: The first homework assignment will be online on Wednesday, February 4.

• January 30, 2004: Reading material for Monday's lecture is online.

More Information:

• Syllabus and Readings

• Software packages that we will use:

  • DeZign for Databases

  • SAS Enterprise Miner

• Homework assignments

  • Homework 1. (Due: Wednesday, 2/11 in class.)

  • Homework 2. (Due: Monday, 2/23 in class.)

General Information

• Professor: Johannes Gehrke, http://www.cs.cornell.edu/johannes, johannes@cs.cornell.edu.
• Office hours:
• Tuesdays, 1:30-2:30pm in Upson Hall 4105B.
• Wednesdays, 2pm until class starts in the Sage Atrium.
• Class time and location: MW 2:55-4:10, Sage Hall 134
• Materials: There is no assigned textbook and no prepared course pack. The course will build on readings, most of which can be found on the web. Any required reading not available online will be made available in printed form in class. As this is a new course, the readings will be finalized as the semester progresses; this is why there is no prepared course pack. There are also several books listed below that you may be interested in reading as additional reading material, but these books are not required reading.
• Grading: Class participation: 20%, five homework assignments 80%
• Homework assignments: Two written homework assignments, one hands-on data modeling assignment using Dezign for Databases, and two hands-on data mining assignments using SAS Enterprise Miner.