COP 5725 Database Systems August 29, 2009 - PowerPoint PPT Presentation

Loading...

PPT – COP 5725 Database Systems August 29, 2009 PowerPoint presentation | free to view - id: 9c136-MTdkN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

COP 5725 Database Systems August 29, 2009

Description:

Subscription: 'Inform me whenever more than 10 people are asking about activity on Thunderbirds' ... Subscription: 'Inform me whenever the average temperature ... – PowerPoint PPT presentation

Number of Views:48
Avg rating:3.0/5.0
Slides: 14
Provided by: csF2
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: COP 5725 Database Systems August 29, 2009


1
COP 5725 Database SystemsAugust 29, 2009
  • Greg Riccardi
  • Dept. of Computer Science
  • Florida State University

2
What is Computer Science?
3
Databases are not just Data
  • Suppose you are responsible for a
    mission-critical database system
  • How can you protect it against intrusion?
  • SqlServer failure
  • How can you protect it against failure?
  • Flooding of basements of Flatiron Building (NY)
    in Jan. 1998
  • How can you improve performance?
  • Can you help the IRS? Walmart?
  • What must I know to keep up?
  • XML, see example Web page
  • In this class you will learn what databases must
    do to be acceptable

4
What are instructors responsibilities?
  • Attend class
  • punctual, attentive, prepared, awake, open to
    interaction, respectful
  • Prepare materials
  • Guide discussions
  • Evaluate students
  • Create and sustain an environment conducive to
    learning
  • Bring interesting and relevant external
    information into class

5
What are students responsibilities?
  • Attend class
  • punctual, attentive, prepared, awake, open to
    interaction, respectful, correct section
  • Read book
  • Each week has a reading assignment
  • Each student must read the material before class
  • Consult additional references
  • Read other treatments of the same material
  • Complete assignments
  • on time, individually
  • Ask for help during (or outside) office hours

6
Student View
  • What new skills and knowledge will I develop?
  • How will I demonstrate my competence?

7
What will happen in class
  • Review of material in assigned readings
  • Instructor as mentor, distributed learning
  • Instructor will answer questions, discuss
    difficult points
  • Add to students understanding of material
  • (Add to instructors understanding of material)
  • Discussion of database systems in current events
  • Students will ask questions, introduce current
    events, offer opinions, answer questions

8
Whats up with database systems?
  • Database companies
  • Whos left?
  • Distributed databases and federation
  • Ontologies
  • XML/Relational
  • DB2, Oracle and SqlServer
  • XML databases
  • Xindixe
  • Internet database explosion
  • Database Access and Integration (DAIS)
  • Working group of Global Grid Forum
  • Create standards for data interactions on the Grid

9
Three Topics of Interest
  • Distributed Applications and Databases
  • Objects as application data model
  • Persistence dynamically bound
  • Application transaction management
  • Stream Queries
  • Tracking database changes
  • Representing transaction log as history tables
  • Sensor monitoring
  • Annotations of data
  • Representing opinions about data
  • New-age logbooks

10
Distributed Applications and Databases
  • MVC application model
  • Model-View-Controller
  • Separate functionality
  • Objects as application model
  • Define Java interfaces to describe data
  • Get and set methods
  • Define classes that specify application logic
  • Fields and methods
  • Persistence dynamically bound
  • Deployment descriptor specifies persistence
  • Key binding to field of table (or view)
  • SQL statements for query, update, insert
  • J2EE and EJB
  • Entity beans (classes) defines object model
  • Container-managed persistence (CMP)
  • Deployment of beans by Application Server
  • Application transaction management
  • Application server and containers support
    transaction
  • No transaction model in entity bean

11
Stream Queries
  • Publish-subscribe system
  • Tracking database changes
  • Consider eBay updates
  • Subscription Inform me whenever more than 100
    1964 Thunderbirds are available
  • Subscription Inform me whenever more than 100
    people are bidding on 1964 Thunderbirds
  • Subscription Inform me whenever more than 10
    people are asking about activity on Thunderbirds
  • Representing transaction log as history tables
  • Maintain history table for each schema table
  • Each update is recorded in history table with
    timestamp, userid, etc.
  • Query How many Thunderbirds were available on
    July 4, 2004?
  • Sensor monitoring
  • Consider atmospheric sensor array
  • Subscription Inform me whenever the average
    temperature in any 1 km area is above 40 degrees

12
Annotations of data
  • See annotation lecture notes
  • lectures/riccardiannotation.ppt

13
Benefits
  • State the benefits to your audience for taking
    this action
  • Thorough understanding of database systems
  • Look at the syllabus
  • Personal development
  • Learn and learn to learn
  • Ex(im)ploding job market
  • Jumpstart to lifetime of learning
  • Emphasis on Web information
About PowerShow.com