Slidespace

Sign-In

Course

Saved

ECE141b: Software Foundations

Sign-up for Slidespace now!

In order to access this course, you must first be a registered user of Slidespace. It takes less than a minute.

Sign-Up

Description

In this course we're going to apply the patterns, abstractions, concepts and techniques we learned in ECE141a, to build a working relational database application. You'll work with a partner to design, develop, test, and build a working solution. 

Learning Outcomes

  • Putting design patterns to work
  • Practicing key C++ idioms
  • Applying design principles
  • Learning better development techniques

Lectures

  1. Introduction
    Welcome -- let's get started!
    lecture
  2. Fundamental Components
    In today's presentation, we'll answer your questions about relational databases, start our discussion on managing user data… (and the dreaded STORAGE class), and introduce key view concepts.
    lecture
  3. Database Commands
    This application is about to get real
    lecture
  4. Working with Entities
    A key concept in building tables and managing user data
    lecture
  5. Table Commands
    This is where the fun really begins – as we get ready to create tables and store user data.  But… the fun comes at the cost of a…… more sophisticated application design.
    lecture
  6. System Design Considerations
    More ways to improve our design
    lecture
  7. Insert Rows
    Honestly, this is when things become very real (and so cool)
    lecture
  8. An Early Look at Select
    In this presentation we're going to get an early look at the select statement, and the special… challenges that it represents.
    lecture
  9. Select Rows
    This week we'll focus on the work we need to do to select rows.  We use this logic in several… commands, from “SELECT *”, to……… “UPDATE” and… “DELETE”.  … We'll… also examine some intermediate objects that can make our logic and our API's much easier to use.
    lecture
  10. Filtering Data
    In this presentation, we'll discuss the Filter class, used to handle where-clause expressions in our… queries.  We'll also do some… informal code… reviews – and… see good/not-so-good practices in our code.
    lecture
  11. Select...where
    In this discussion, we're going to implement our filters class to be able to handle more useful queries.
    lecture
  12. On Reuse
    Thinking about reusability
    lecture
  13. Update/Delete
    In this lecture, we'll discuss the processes involved in handling UPDATING and DELETING rows from our database.  There's…… more… to it than you… might first…… expect.
    lecture
  14. Evolving Our Design
    Strategies for change
    lecture
  15. Indexing
    Add your description here...
    lecture
  16. Adapting our Architecture
    Building an architecture to evolve is essential for systems with a moderate-to-long lifespan.  We'll talk about factors that enhance adaptability – and… examine our DB application to gauge adaptability.
    lecture
  17. Joins
    In this presentation, we're going to discuss the use of LEFT and RIGHT joins.  We'll review what they are, how they work, and offer… some… thoughts on how… you might add support fro them in your system.
    lecture
  18. Performance improvements
    Thinking about cache design
    lecture
  19. A Patterned Application
    Just how many patterns did we apply?
    lecture
  20. Summary and Farewell

    Time to say goodbye...

    lecture
  21. Final
    Get access to the two parts of your final exam
    lecture