css/417 introduction to database management systems workshop 5

CSS/417

Introduction to Database Management Systems

Workshop 5

Network Terminology

Network “a collection of computers that communicate with one another using a standardized protocol”

Public “anyone can utilize the network”

Private “users must be preauthorized to gain access”

Page 273

Internet Terminology TCP/IP “Terminal Control

Program/Internet Protocol” E-mail Newsgroups TelNet FTP

Page 274

World Wide Web Terms

HTTP hypertext transfer protocol

HTML hypertext markup language

URL universal resource locator

Page 275

Intranet

“Private network using TCP/IP, HTML, and related Internet technology”

private May be connected to public network

via a firewall

Page 277

Intranet

OracleDB

Browser

Web Architecture

WebServer

Network Database Apps

Static Report Publishing

DB Query Publishing Application Publishing

Page 277

Three-Tier Architecture

Page 279Figure 11-6 © 2000 Prentice Hall

Functions of Tiers

Page 280Figure 11-7 © 2000 Prentice Hall

Web Server Standards and Languages

Page 281Figure 11-8 © 2000 Prentice Hall

Internet Scripting Languages

JavaScript

VBScript

PERL

Page 283

Programming Languages

JAVA (Internet oriented)

Visual Basic C++ ActiveX (Component,

really)

Page 285

Microsoft Component Specifications

Page 287Figure 11-13 © 2000 Prentice Hall

Markup Languages DHTML dynamic HTML

RDS Remote Data Services (ActiveX controls) allow data to be cached locally

XML Extensible Markup LanguageDTD Document type declaration

Page 288

Example of XML Standards

Page 299Figure 11-22 © 2000 Prentice Hall

Web Server Functions

Page 300Figure 11-23 © 2000 Prentice Hall

Object Oriented Databases

Two types: True Object Oriented Object Relational

Object-Oriented Programming

OOP; a way of designing and coding programs which views programs as sets of data structures that have both data elements and program instructions

Page 483

OOP Terminology Encapsulated complete in itself Encapsulated structure an OOP

object that has both attributes (properties) and methods

Interface external appearance of an object

Page 484

OOP Terminology Implementation “the encapsulated

internals of an object” Inheritance “automatically

assuming the attributes and methods of another object at a higher class”

Polymorphism “situation in which one name can be used to invoke different functions”

Page 484

OOP Terminology Object Class “the logical structure

of an object (name, attributes, methods)”

Object Class Library “a group of object classes”

Objects “instances of objects” Transient vs. Persistent

“volatile vs. permanent”Page 485

Sample Objects, Methods, and Attributes

Page 486Figure 17-2 © 2000 Prentice Hall

Sample Object Data Structures

Page 489Figure 17-4 © 2000 Prentice Hall

Swizzling

“The process of transforming permanent identifiers into in-memory addresses”

Page 489

Tasks for Object Persistence

Page 489Figure 17-5 © 2000 Prentice Hall

Application Development Work for Object Persistence

Page 492Figure 17-8 © 2000 Prentice Hall

ODBMS Advantages and Disadvantages

Page 493Figure 17-9 © 2000 Prentice Hall

ODBMS Standards SQL3 “an extension to SQL92 that

includes support for OODBMS” Abstract data type “ADT; user-

defined structure that is equivalent to an OOP object”

Page 495

ODMG-93

“Object Data Management Group; a consortium of object database vendors and experts that developed a definition of interfaces for object data management products in 1993”

Page 500

Key Elements of the ODMG Object Model

Page 501Figure 17-15 © 2000 Prentice Hall

ODMG Relationship Operations

Page 502Figure 17-16 © 2000 Prentice Hall

Object Oriented Databases

Versant Jasmine Others None are in widespread use

in commercial DP

Object Relational Databases Have some object oriented

features Inheritance – can inherit table

structures, etc. Storage of complex objects (tables

nested in a field, multimedia, etc.) Ex: Newer versions of Oracle