Information Systems CMPSCI 445
Popular in Course
Popular in ComputerScienence
This 25 page Class Notes was uploaded by Roman McCullough on Friday October 30, 2015. The Class Notes belongs to CMPSCI 445 at University of Massachusetts taught by Yanlei Diao in Fall. Since its upload, it has received 16 views. For similar materials see /class/232250/cmpsci-445-university-of-massachusetts in ComputerScienence at University of Massachusetts.
Reviews for Information Systems
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/30/15
CMPSCI445 Information Systems Prof Yanlei Diao University of Massachusetts Amherst Outline Overview of databases and DBMS Course topics Course requirements Yanei Diao University of Massachusetts Amherst 1292008 Database Database Database a large integrated collection of data Yanei Diao University of Massachusetts Amherst 1292008 Database Management System Define the kind of data stored Add data Query the data Update the data Performance Concurrent users Automatic recovery Query terface Access control DataIntsive pplicatio Database Management System DBMS a software package designed to store and manage a large amount of data Case Study The Internet Shop DBDudes Inc a wellknown database consulting firm Barns and Nobble BampN a large bookstore specializing in books on horse racing BampN decides to go online but needs help Step 0 DBDudes makes BampN agree to pay steep fees and schedule a lunch meeting for requirements analysis The example and all related material was taken from Database Management Systems Edition 3 Yanei Diao University of Massachusetts Amherst 1292008 Step 1 Requirements Analysis I d like my customers to be able to browse my catalog of books and place orders online Books For each book BampN s catalog contains its ISBN number title author price year of publication Customers Most customers are regulars with names and addresses registered with BampN New customers must first call and establish an account On the new website Customers identify themselves before browsing and ordering Each order contains the ISBN of a book and a quantity Shipping For each order BampN ships all copies of a book together once they become available Yanei Diao University of Massachusetts Amherst 1292008 Step 2 Conceptual Design A high level description of the data in terms of the Entity Relationship ER model m shipdate cratersquot Design review What if a customer places two orders of the same book in one day Modification add ordernum to Orders Yanei Diao University of Massachusetts Amherst 1292008 Step 3 Logical Design Mapping the ER diagram to the relational model CREATE TABLE Books isbn CHAR10 title CHAR80 author CHAR80 qtyinstock INTEGER price REAL year INTEGER PRIMARY KEYisbn CREATE TABLE Customers cid INTEGER cname CHAR80 address CHAR200 PRIMARY KEYcid isbn City 7 CREATE ABLE Orders CHAR10 cid INTEGER INTEGER orderdate DATE 39 ATE 39 KEN KEY isbn REFERENCES Bo FOREIGN KEY cid REFERENCES Cu CREATE Orderlnfo isbn cid orderquotdate ship d ateg As SELEch Wis bn Reid Osqtiy 5 I Qordemdate ship ajte FROM Orders 0 Access control use views to restrict the access or certain employees to customer sensitive information Yanei Diao University of Massachusetts Amherst 1292008 Step 4 Schema Refinement Orders ordernum isbn cid cardnum order date date Jan 6 2006 Jan 112006 Jan 26 2006 Redundant Storagei Orders Orderlists ordernum isbn qty shipdate 120 123 40241160 Jan 3 2006 120 00711 2 Jan 6 2006 120 11223 1 Jan 11 2006 120 00724 3 Jan 26 2006 Yanei Diao University of Massachusetts Amherst 1292008 Step 5 Internet Application Development Presentation tier HTML BampN Client C11ent Program Jammy User input Web Browser Cookies Display of output BampN Business logic Appllcatlon loglc t1er H 39 JSP PHP 0196 page Appllcatlon Server Swim Logm page Apache Tomcat XSLT Search page 0 Cart page i Confirm page Data mar1a ement tier BampN Data g Database System XML Books stored Customers MySQL DB2 procedures User login 0 Orders Orderlists Yanei Diao University of Massachusetts Amherst 1292008 An Example Internet Store IE Welcome to the Internet Bookshop Microsoft Internet Explorer i 7 7 El Al Eile Edit ew Favorites Iools elp Back re a at a rd Stop Refresh Home Favorites Agdress IE httpMocalhos bookstore ndexhtml 1 gt60 I Home l Create Account 1 Shopping Basketl I Hel lInformation Checkout I The Internet BookShop Welcome to The Intemet Bookshop We have just recently opened for business We39ve spend a great deal oftime in creating a web site really suited to the desires oftoday39s book buyers We offer fast and convenient service With operators available at all hours ofthe day to process your requests And of course membership is ee of charge Sign up today You may log into your account by clicking here or create a new account by clicking here Eyou want to add items to your yuan and quothLnnol nnnnnn n AAI CLAn 1 a L l7 7 E Local intranet Yanei Diao University of Massachusetts Amherst Example SQL Queries Search Page SELECT isbn title author price FROM Books WHERE author 39ltSearchStringgt39 ORDER BY title SELECT Cid username password FROM Customers WHERE username 39ltSpecifiedUsernamegt Yanei Diao University of Massachusetts Amherst 1292008 Step 6 Physical Design Auxiliary data structures indexes to speed up searches BOOKS Hash Index on Booksisbn isbn title author price 11 2995 2003 isbn number 1 12 Slew DanMearns 2495 2000 2 1695 2001 Yanei Diao University of Massachusetts Amherst 1292008 DBMS Architecture Query Query Parser Processor Query Rewriter Query Optimizer Query Executor W Lock Manager Access MethOdS Log Manager Transactional Buffer Manager I Storage Manager W I Disk Space Manager I Disk Yanei Diao University of Massachusetts Amherst 1292008 Course Topics Fundamentals Data modeling Relational design Query languages SQL Database implementations Storage and indexing Query processing and optimization Transaction management Internet technologies XML XML query languages Web application development Yanei Diao University of Massachusetts Amherst 1292008 Prerequisites CMPSCI 287 Programming Language Paradigms Or consent of the instructor Data structures and algorithms Sufficient programming experience Yanei Diao University of Massachusetts Amherst 1292008 Course Web Site CMPSCl 445 Information Systems Mozilla Firefox file Edit yiew Hi tory ookmarks Iools elp 39 a r Q m lg hH39nllavirl Penman lSSZUOSindexhtml i Yanlei Diao39s web page W CMPSCI 445 Informatio University of Massachus Login CMPSCI 445 Information Systems menlsl schedule ass nmenlsl pr nksl System Support l Course Goals and Topics Database systems are at the core of largescale information management providing the most ef cient mechanism for storing updating and retrievrng structured data This course will provide an introduction to the design and use of database systems as well as the key issues in building such systems The Wond W39de Web is the largest distributed information management system in addition to database topics this course will also provide an Introduction to key technologies for managing and exchanging data on the World Wide Web In presenting the fundamental principles of databases we will cover the relational model conceptual design and query Ia including storage and indexing query processing and optimization transa guages We will also cover core database implementation issues 0 technologies for XML data management and web application development n ction management and recovery in presenting modern Internetrbased data management we will cover a set f Time and Place Tuesday and Thursday 230pme345pm LGRT101 Professor Yanlel Diao Contact yanlei csumassedu once Hours Tuesday 100pm72v20prn or by appointment CMPS 232 Teaching Assistant Ravishankar Rajamony rravi sat csumassvedu Tuesday 5pm Gpni Common Room Computer Science Department Contact O ce Hour Contact insti39uctoHTA csMEhelpsdlabmailtcs umassedu Broadcast Mailing List We have created a course broadcast email address cs445edlabmaii csumass edu for use by course participants The instructor and TA Will send all course related announcements eg clari cations of homework or programming assignments questionsfanswers of general interest etc to this mailing list By default email is sent to your edlab account It is your responsibility to forward the mail to some other account ifyou want it to go somewhere else To forward mail create a le called 39forward39 in your home directory on the edlab machines The only line in the le should contain the alternate email address All mail to your edlab account Will then be forwarded to the alternate ddress Please note that whenever you send email to csM5edlanmail csumassedu your email message Will be broadcast to the entire class so use the address carefully A questioncomment or some information you want to share with the class would be an appropriate email to send to c mail cs umassedu A request or a due date extension would not be appropriate Textbook Database Management Systems 3rd Edition Ramakrishnan and Gehrke Database Management Systems Ramakm shnan 39 Gehrke Lecture notes will be posted on the schedule page before class Yanei Diao University of Massachusetts Amherst 1292008 Grading Homework 25 Course Project 20 Midterm 20 Final 25 Attendance Participation 10 Yanei Diao University of Massachusetts Amherst 1292008 Homework 25 5 assignments throughout the semester Written problem sets Programming exercises with query languages including SQL and XQuery Dates that each assignment is out and due see the schedule page Assignments posted on the assignments page Submission hardcopy before class on due date Policy on late submissions Yanei Diao University of Massachusetts Amherst 1292008 Project 20 General theme build a web application using MySQL backend Groups of 2 3 Project work will include Schema design DB implementation Web site design Multiple milestones amp deliverables See the schedule page See the projects page for details Submission via email before midnight on due date Yanei Diao University of Massachusetts Amherst 1292008 Exams Midterm 20 lnclass closedbook exam At the beginning of the 9th week Final 25 Closedbook exam Waiting to be scheduled in the final exam period Yanei Diao University of Massachusetts Amherst 1292008 Attendance amp Participation 10 Attend every class Ask questions contribute to answers Participate in pop quizzes and inclass exercises Yanei Diao University of Massachusetts Amherst 1292008 Academic Honesty All submitted work must be your own Yanei Diao University of Massachusetts Amherst Although students are encouraged to study together each student is expected to produce his or her own solutions to the homework problems Copying or using sections of someone else s program or assignment even if it has been modified by you or copying a solution from an external source is not acceptable The University guidelines for academic misconduct httpwwwumassedudean studentscode conductacad hone st htm The staff of CS 445 will be vigorous in enforcing them 1292008 Contact Information Instructor Yanlei Diao Email vanlei at csumassedu Office hours Tue 100220 pm or by appointment Room 232 in CS building TA Ravishankar Rajamony Email rravi at csumassedu Office hour Tue 56 pm common room CS building Mailing lists cs445help at edlabmailcsumassedu cs445 at edlabmailcsumassedu All available on the home page Yanlei Diao University of Massachusetts Amherst 1292008