170 likes | 273 Views
Database Management for Electronic Commerce and EBusiness. Walt Scacchi, Ph.D. GSM 274/FEMBA 274 Spring 2002. Overview. Introductions Course audience and demographics Administrative matters Foundational concepts Course topics Questions Topic 1: Collecting and Managing Data.
E N D
Database Management for Electronic Commerce and EBusiness Walt Scacchi, Ph.D. GSM 274/FEMBA 274 Spring 2002
Overview • Introductions • Course audience and demographics • Administrative matters • Foundational concepts • Course topics • Questions • Topic 1: Collecting and Managing Data
Introductions • Instructor: Dr. Walt Scacchi • Teaching assistant(s): • none • Administrative support: • Natasha Shuqum
Course audience and demographics:what are your career interests? • Executive (Corporate Officer, Vice President, Division Director, etc.)? • Mid-Career Manager (not an IT department manager)? • IT Consultant ? • Entrepreneur? • Academic Scholar? • Other?
Administrative matters • Office, office hours and contact • ICS2-242 • Tuesday 1:00-2:30pm, and by appointment • Office: 949-824-4130 • Email: Wscacchi@uci.edu • Web: http://www.ics.uci.edu/~wscacchi
Administrative matters • Projects and Exams • Team project, final presentation, deliverables • Mid-term exam • Assignments and Discussion • Assigned articles and case studies • DB-Web site case studies • Web-based business intelligence gathering
Administrative matters • Attendance and Participation • Both count!
Administrative matters • Grading policy • Final project: 50% • Mid-term exam: 20% • Assignments and discussion: 20% • Attendance: 10% • Project team formation • Team size: 3-5 people • Start building your team today!
Administrative matters • Communicating course material: • Am I explaining course materials so that you understand? If not, you must let me know. • Course preparation: • All course materials (e.g., lecture notes, readings, assignments) will be posted on the Web • Discussion: • Assignments or team project work each week
Administrative matters • Access: • See my Office hours and TBD hours: contact me! • Progress (Grades): • Scheduled assignments and team project work • Emphasis of conceptual understanding: • 50% lecture and course work on concepts for database management for EC/EB • 50% work on putting these concepts into practice, via the team project.
Administrative matters • Rigor: iterative presentation and exploration • Formal vs. informal • Three iteration cycles • Overall value of course to you: • You will learn fundamental concepts of database management for EC/EB • You define your team project to best address your professional goals • You should ask questions about topical issues
Course matters -- Reading Materials • Required:http://www.ics.uci.edu/~wscacchi/DBM-EC/ • Recommended (or Required) textbooks: • David Kroenke, Database Processing, (Eighth Edition), Prentice-Hall, 2002. • Jim Buyens, Web Database Development : Step by Step, Microsoft Press, 2000. • R.J. Muller, Database Design for Smarties: Using UML for Data Modeling, MK, 2000. • G. Treese and L. Stewart, Designing Systems for Internet Commerce, Addison-Wesley, 1998.
Foundational concepts • Understanding the Value and Consequences of Good/Bad Data • Database-Centric Business Models for EC • Database Management Systems Architecture • Database Administration • Data Assets as a corporate resource requiring management (access control, etc.) • Database Modeling and Transaction Design • Advanced Database Applications: Multi-media, knowledge management, workflow, etc.
Course topics • Collecting and Managing Databases • Database Management Based Business Models for Electronic Commerce • Electronic Commerce Database Applications • Enterprise Database Systems Architecture: Legacy IS to Web-based
Course topics • Data Base Management for Data Base Administrators (DBAs) • Data and Enterprise Modeling • Database Design via Data Models and Meta-Data Models • Query Processing and Transaction Design
Course topics • Data Warehousing (and Spatial Data Warehousing) • Data or Information Discovery • Knowledge Management • Automated Database Content Acquisition or Generation • Workflow, Stored Procedures, Triggers • Information Logistics and Data Syndication
Questions? • What do you want to learn or take away from this course? • What are your criteria of success? • What do you want me to do to help you achieve your success? • What about the team project? • Others?