DOC PREVIEW
SJSU CMPE 226 - Syllabus

This preview shows page 1 out of 3 pages.

Save
View full document
View full document
Premium Document
Do you want full access? Go Premium and unlock all 3 pages.
Access to all documents
Download any document
Ad free experience
Premium Document
Do you want full access? Go Premium and unlock all 3 pages.
Access to all documents
Download any document
Ad free experience

Unformatted text preview:

CMPE 226COMPUTER ENGINEERING DEPARTMENTCMPE 226Advanced Database Design – Fall 2007Course Overview: This course develops your understanding of database system CONCEPTS that are independent of any specific database system. As an analogy, if you took a driver’s education class, you learned there driving, which is independent of any specific car. This distinction between concepts and tools is important to keep inmind in this course (especially by students who like to list on their resumes a long list of specific operating systems, programming languages, and database systems).These concepts include: data abstraction levels; data independence; data models, including relational, constraint, spatial, and spatiotemporal data models; query languages, including relational algebra, and SQL; database design concepts, including integrity constraints; and interoperability, including data and query interoperability. Many of these concepts have a remarkable staying power, while the specific systems change all the time. In fact, the more basic the concept the more likely it is to endure. For example, the concept of data abstraction endured even as new data models were invented: hierarchical in the 1950s, network in the 1960s, relational in 1970, and various spatial data models used in GI in more recent years. As another example, the QL language, invented in the early 1970s,is still the primary language of relational database systems today, whether they come from Oracle, IBM, Microsoft, MySQL, ybase, Empress, etc.By understanding well the concepts and not just a specific system on a specific platform, you should be able to adjust better to future changes in the database systems area. In particular, GI is emerging as a very important extension of relational databases, with some estimates putting the word-wide GIS market at about one billion dollars annually, while the relational database market is about six billion dollars annually. Hence we will learn about GIS too in this course. This course will contain two or three projects that are designed toillustrate a variety of uses of database systems (all subject to change).Several emerging technologies will also be covered, such as XML and how it is related to accessing relational databases over the internet, data mining, and data warehousing, distributed databases, etc.Student Learning Objectives:On Successful completion of this course students shall be able to:1. Model and design conceptual databases using Entity-Relationship model, the traditional andstable class diagrams2. Understand and apply the relational algebra and SQL3. Learn and work on database issues, such as normalization and Data/Content Dynamic.4. Explore and examine database current trends, such as Constraints Database, Spatiotemporal Database, Data Visualization, and Data Animation5. Explore and learn database emerging trends, such as web technologies, XML, data warehousing, and data mining BACKGROUND: This course is targeted to those individuals who are interested in database design and would like to learn several database design and systems. REQUIRED & RECOMMENDED TEXTS: Any book is fine. You can count on the information that I provide for you on the website.1 of 3COMPUTER ENGINEERING DEPARTMENTOTHER READING MATERIALS: Supporting Texts:1. Ramez Elmasri and Shamkant Navathe. Fundamentals of Database Systems, 4th Edition, Addison-Wesley, July 2003, ISBN 0321122267Chapters: 1, 3, 7, 8, 11, and 12Chapters’ sections of 2, 4, 19, 21, and 26.** Good notes will be provided for the above chapters.2. Peter Revesz, Introduction to Constraint Databases, Springer, New York, 2002, ISBN 0-387-98729-03. Paul DuBois. MySQL Cookbook, 1st Edition, O’Reilly & Associates, November 2002, ISBN 0596001452This course is design to help students land jobs in Database field:### Existing Database Projects “How-To” in the Course1 Expand Add new entities/Attributes Show how-to do this using: 1. Class diagram2. Normalization3. RA4. SQL5. Transaction Management (Time)6. Security (Time)2 Data Consistency/overcome Data Conflicts3 Adapt the database to new application4 Migrate DB to a new host 5 Redesign the existing database6 Enhance data storage, retrieval, and updates7 Enhance/Add user-accessible catalog and templates8 Mapping user-accessible and non-accessible catalog and templates into theexisting DB9 Transaction support10 Improve Security11 Improve data accessibility and responsiveness### New Database Projects “How-To” in the Course1 Design new DB with:A. Complete Requirements,B. Some kind of RequirementsC. No Requirements1. DB Design using Class Diagram2. Normalization3. Security4. Web Technology & DB5. XML and DB6. Data Warehousing7. Data Mining2 How to start and finish the project3 Security4 Web Technology & DB5 XML & DB6 Data Warehoursing7 Data Mining### Innovative Database Projects “How-To” in the Course2 of 3COMPUTER ENGINEERING DEPARTMENT1 Make the data speak, dance, and help you make excellent decisions1. DB Design using Class Diagrams2. Normalization3. Constraints DB4. Spatiotemporal & Applications5. Visualization & Animation2 New Applications3 Data & Content Dynamic3 of


View Full Document

SJSU CMPE 226 - Syllabus

Documents in this Course
SQL-99

SQL-99

71 pages

XML

XML

52 pages

XML

XML

14 pages

Chapter 9

Chapter 9

45 pages

Load more
Download Syllabus
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Syllabus and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Syllabus 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?