css/417 introduction to database management systems workshop 5
TRANSCRIPT
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