• Database System Technology
    • School of Electronic, Information and Electrical Engineering
    • Credit. 3
    • SE305
    • Enroll
    • WILL BEGIN
    • Fall , 2015
    • 1935
    • Course Description:
    • ( Exchange Programme )
    • This course is a first course in database systems for undergraduates at SJTU/CS. It covers the fundamantal concepts of modern database management including database design, database languages and database system implementation. It assumes only familiarity with basic data structures, computer organization and a high level programming language such as Java or C. The concepts and algorithm presented in this course are based on commercial or experimental database systems. The idea is not to tie these concepts to a particular database system but to present it in a general setting. Most of the assignments and projects are done using Java/C and the open source MySQL, which is widely available. Topics covered in this course include: relational databases, database design, data storage and querying processing, transactions, system architecture, data mining and information retrieval, and optionally, XML and a case study on a particular database system.
    • Course Syllabus:
    • After completing the course, students should be able to:
      1. write database queries in relational algebra and SQL
      2. design a relational database using ER model
      3. understand the design principles in relational database
      4. understand the concept in database system implementation such as transactions, indexing and query processing/optimization.
    • Schedule:
    • Topics / Credit hours / Teaching methodology / Tasks / Intended learning outcomes / Assessment methods

      1. Introduction / 2 / Lecture / Assignment / NA / Assignment
      2. Relational model / 2 / Lecture / Assignment / NA / Assignment
      3. SQL / 6 / Lecture / Assignment / NA / Assignment
      4. ER Model / 4 / Lecture / Assignment / NA / Assignment
      5. Relational DB Design / 4 / Lecture / Assignment / NA / Assignment
      6. Indexing / 4 / Lecture / Assignment / NA / Assignment
      7. Transaction / 2 / Lecture / Assignment / NA / Assignment
      8. Query Processing / 4 / Lecture / Assignment / NA / Assignment
      9. Project / 16 / Tutorial & Lab Practice / Project / NA / Project report and presentation
  • Reading list
  • Other Materials
  • Discussion
  • Homework download/submit
    • Zou Weiwen
    • Read more
    • Male
    • E-mail:
    • wzou@sjtu.edu.cn
    • Profile
    • Kenny Qili Zhu
    • Associate Professor
    • Read more
    • Male
    • E-mail:
    • kenzhu@sjtu.edu.cn
    • Profile
    • Kenny Qili Zhu is an Associate Professor and Distinguished Research Professor at Department of Computer Science and Engineering at Shanghai Jiao Tong University. He graduated with B.Eng (Hons) in Electrical Engineering in 1999 and PhD in Computer Science in 2005 from National University of Singapore. His PhD advisors were Joxan Jaffar and Roland Yap. He was a postdoctoral researcher and lecturer from 2007 to 2009 in the programming language group at Princeton University working on the PADS project with David Walker from Princeton and Kathleen Fisher from AT&T Labs. Prior to that , he was a software design engineer in the Windows Live Identity group of Microsoft in Redmond, WA. From Feb 2010 to Aug 2010, he was a visiting professor at Microsoft Research Asia in Beijing. Kenny was the winner of the 2013 Google Faculty Research Award and DASFAA 2014 Best Paper Award.
  • Prerequisite Course:

    Discrete Math, Data structures, basic programming in Java or C

  • Textbooks:

    1. Database Systems: The Complete Book (2nd Edition) by Hector Garcia-Molina, Jeffrey D. Ullman and Jennifer Widom(Jun 15, 2008).
    2. Advanced Database Systems (The Morgan Kaufmann Series in Data Management Systems) by Carlo Zaniolo, Stefano Ceri, Christos Faloutsos and Richard T. Snodgrass(May 15, 1997).
    3. Data Mining: Concepts and Techniques, Third Edition (The Morgan Kaufmann Series in Data M
  • Grading:

    Assignments + Project + Exam
Other courses
  • Database System Technology
    Database System Technology
    This course is a first course in database systems for undergraduates at SJTU/CS. It covers the fundamantal concepts of modern database management including database design, database languages and data...
    Kenny Qili Zhu
    1935
  • Compiler Principles
    Compiler Principles
    This course considers the principles that underlie a wide variety of compilers, and focuses on the problem of translating programs written in a high-level language into semantically equivalent program...
    Wu Fan
    1370
  • Multicore Architecture and Parallel Computing
    Multicore Architecture and ...
    Multi-core era is here to stay and many programmers will be developing parallel software. But still not everyone is trained in parallel programming. In this course, students will study the state-of-ar...
    Jiang Li
    2049
  • Fiber Broadband Communications Network
    Fiber Broadband Communicati...
    This course focuses on key optical components, optical transmission systems, optical networks, and application of fiber communication technologies, train the students to understand the basic principle...
    Ma Lin
    1781
  • Compiler Principles
    Compiler Principles
    This course considers the principles that underlie a wide variety of compilers, and focuses on the problem of translating programs written in a high-level language into semantically equivalent program...
    Guo Minyi
    1947
  • Digital Electronics Technology
    Digital Electronics Technol...
    This course is designed to teach the students the fundamentals of digital circuits, including basic concepts, principles, and the basic methods for circuit analysis and design. Upon completion of the ...
    Bao Qilian
    1633
  • Software Engineering
    Software Engineering
    Software engineering is the branch of computer science that creates practical, cost-effective solutions to computing and information processing problems, preferentially by applying scientific knowledg...
    Sheng Bin
    1764
  • Electronics LAB
    Electronics LAB
    The course is designed to help students to analysis analog circuit, design digital circuit and develop a system by FPGA. Over the 15 weeks, students will complete 17 Labs. They are divided into 3 part...
    Li Dan
    1815
  • Internet-based Information Extraction Technologies
    Internet-based Information ...
    Internet-based Information extraction is the method of deriving structured information from unstructured text and semi-structured web pages. More succinctly, information extraction is finding names of...
    Li Fang
    1942

Shanghai Jiao Tong University The English Course Catalog | School Counseling:021-34206468-102

沪ICP备05052060 © Shanghai Jiao Tong University all rights reserved. | Address: 800 Dongchuan Road, Shanghai