CS 122 B Projects in Databases and Web

Зарегистрируйтесь, чтобы просмотреть полный документ!

CS 122 B: Projects in Databases and Web Applications Spring 2017 Professor Chen Li Department of Computer Science UC Irvine Notes 01: Introduction 1

Overview • Course introduction • Project Overview CS 122 B Notes 01: Introduction 2

Course General Info • URL: http: //www. ics. uci. edu/~cs 122 b/ – All course info will be posted online CS 122 B Notes 01: Introduction 3

DB courses @ UCI Intro Projects CS 122 A CS 122 B undergrad CS 122 C DB Principles CS 222 grad CS 223 CS 224 Transaction Processing and Distributed Data Management CS 122 B DB Seminar Advanced Topics Notes 01: Introduction 4

Simplified DBMS Architecture Application Queries Schema changes compilers Metadata and data dictionary optimizer Transaction Manager evaluator Query processor Buffer manager File system Storage manager Database and Indices CS 122 B Notes 01: Introduction 5

DBMS Goals • • • Efficient data management (faster than files) Large amount of data High reliability Atomicity, Consistency, Isolation, and Durability. Information sharing (multiple users) DBMS Users: – E-commerce companies, banks, airlines, transportation companies, corporate databases, government agencies, … – Anyone you can think of! CS 122 B Notes 01: Introduction 6

CS 122 A Topics • Database modeling: – E/R model, Relational model, ER to Relational Model • Relational Algebra • Subqueries, Joins, Modifications, Nulls, Constraints and Triggers, Stored Procedures • Embedded SQL • Views • Relational Design – BCNF, 3 NF, 4 NF CS 122 B Notes 01: Introduction 7

CS 122 B Topics • • CS 122 B Programming Projects: 88% In-class quizzes: 11% Participation of EEE class evaluation: 1% For all the graded projects and quizzes, if you disagree with the grading, you can discuss with the grader within two weeks after they are returned. After that, all the grades will be finalized. Notes 01: Introduction 8

Project overview (subject to change) • Develop a real, web-based commercial web site to sell movies • Interfaces for customers: • • • CS 122 B – Browse/search for movie information – Buy movies DBA XML and AJAX Programming on Mobile phones (Android) Performance tuning AWS Notes 01: Introduction 9

Project overview (cont) • Step 1: My. SQL creation, JDBC, Tomcat, AWS. • Step 2: Developing Fablix Web site • Step 3: re. Captcha, HTTPS, Stored Procedure, XML Parsing • Step 4: Ajax, Search, UDF, and Android • Step 5: Performance Tuning: Jmeter, Connection pooling, Prepared statement, Load balancing and mysql replication Students are encouraged to develop projects using a different domain, as well as you can meet the same functionality requirements. CS 122 B Notes 01: Introduction 10

Prerequisites • CS 122 A or equivalent • Programming skills: – Java – Skills to learn other programming languages CS 122 B Notes 01: Introduction 11

Using Cloud Services • We will heavily use Amazon AWS services • You are expected to launch instances on AWS to deploy some of your projects you are developing. • AWS provides free-tier 64 -bit Ubuntu instances! • Welcome to participate in the AWS Educate program (https: //aws. amazon. com/education/awseducate/), which can provide $100 AWS credits per student. • Time permitting, we will also use Google Cloud Platform (GCP) to run the projects. CS 122 B Notes 01: Introduction 12

Policy on Working Together • Working together the projects (only) is strongly encouraged. (The problem sets should be done individually). You can form groups of no more than 3 students. • Students may leave their existing group in the quarter. BUT they cannot join any new group after the end of the second week. • In addition, for each group splitting, the group members should tell the reader at least two weeks before the corresponding project/homework deadline. CS 122 B Notes 01: Introduction 13

Database • My. SQL • Be sure to follow online instructions to do the installations CS 122 B Notes 01: Introduction 14

Web Server • Tom. Cat http: //jakarta. apache. org/tomcat/ CS 122 B Notes 01: Introduction 15

Class Tradition • For each offering of this class, at the end of the quarter, I will announce the top 3 students based on their overall performance in the class (projects and quizzes). • I will host a lunch with these students CS 122 B Notes 01: Introduction 16

Скачать презентацию CS 122 B Projects in Databases and Web

cd1acc38193dcfa9224c23cf59d9bda9.ppt

Количество слайдов: 16