1 / 12
Télécharger la présentation

2003/4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 2003/4 Education in Data Management at the Carlson School of Management University of Minnesota by Gordon Everest

  2. The School • College of Business Administration established in 1919 • Named Curtis L. Carlson School of Management in 1986 • Moved into new building in January 1998

  3. The School Today • 113 tenured and tenure-track faculty + adjuncts/P&A • 264 staff members • 3,900 students (out of some 45,000 in the University) • 900 undergraduate, ranked 14thby USNews&WR • 250 day (full-time) MBA, ranked 26th in nation by USNews&WR • 1200 evening (part-time MBA), ranked 10thby USNews&WR • Ph.D., Exec MBA (ranked 16th), international, Health Care,… • 42,000 alumni in 50 states and 70 foreign countries • Eight academic departments • 12 degree programs

  4. Our strengths today include • An excellent student body • Strong faculty • World-class facilities • Part of a top-ranked business community • Part of a world-class research University • International Expansion - Warsaw, Vienna, China, Lyon, ...

  5. MIS at Carlson School Information & Decision Sciences Department • World’s first MIS academic program - 1968 • Initial focus on Ph.D. – nearly 100 grads • Undergrad and MBA in MIS • Consistently ranks in top 5 (USN&WR, ‘97) • MIS Research Center

  6. Data - Mapping the Terrain DMOD OBJECTS DATA PROCESSES (DFD’s...) MODELING MANAGEMENT Conceptual  logical  relational (tables) (records) (normal form) machine human OBJECT-ROLE ENTITY-RELATIONSHIP SYSTEMS (DBMS) ADMINISTRATION (DBA) Nijssen Halpin VIsioModeler-> VEA Chen Codd Simsion Definition -- Manipulation (Language) DATABASE

  7. Undergrad MIS Major Intro to Computers & MIS • CORE (3cr)(soph) • Required (16cr)(Junior) • Elective (2 of)(Senior) Intro to Programming Analysis & Modeling IT Infrastructure IS Management Adv. Database Design Financial IS Adv. DBMS & DBAdmin eCommerce Data Warehousing IS Special Topics

  8. The Course(s) 43INTR 3 THREADS: DATA MODELING(to create databases) • Modeling  Schemes  ER  Relational  Normalization • Object Role Modeling (ORM) vs. Record-based • Presentation – levels of abstraction • The Design Process • Design support (CASE) toolsº DBMS(machine component - to manage databases) • for Developers to implement information systems • a Tool for the Data(base) Administrator (DBA) • Types of systems; marketplace • Comprehensive capabilities - SQL++º, OODBMSº, multimedia infoº • Data Warehousing, OLAP, Data Miningº DATA(BASE) ADMINISTRATION(human component) • DBA - role, functions, organization • Data planning • Data integrity, security, privacyº

  9. IDSc 4/6431, 4131 (CCE) 43INTR Advanced Database Design Gordon C. Everest Information and Decision Sciences Carlson School of Management University of Minnesota

  10. NIAM/ORM Teaching Experiences 43INTR • THE COURSE: • Advanced Database Design & Administration • Originally mostly MBA & Ph.D. Students • Taught NIAM modeling since 1975 but inadequate • NEEDED: • Written Teaching Materials • Data Modeling CASE Tool Conceptual Schema and Relational Database Design,Nijssen & Halpin, Prentice-Hall (Australia), 1989; 2e 1995. Information Modeling and Relational Databases,Halpin, 2001, Morgan Kaufman. InfoDesigner from ServerWare, 1993 InfoModelerfrom Asymetrix, 1994; then InfoModelers, Inc. VisioModelerfrom Visio, (Enterprise 5.0) acquired 1998, released 1999 acquired by Microsoft, 1999/11. VisioEA (Enterprise Architect), part of Visual Studio.net EA edition

  11. Software In 5 computer labs, 1 instruction lab, & home install. • Access(Intro IS course) • Visual Basic (VBA) (Mid. Courses) • SQL Server(Mid and Adv. Courses) • VS.net, VisioEA(Adv. DB Design) • Rational Enterprise Suite, Rational Rose

  12. More Information • University of Minnesota: www.umn.edu • Carlson School: www.csom.umn.edu • For courses, click on Resources > ClassNet > Information & Decision Sciences • geverest@csom.umn.edu

More Related