Integration

1
Integration

• Week 7
• LBSC 690
• Information Technology

2
Agenda

• Questions
• The grand plan
• Media synchronization
• Cold Fusion
• Midterm review

3
The Grand Plan
Computers
Web
Networks
Search
XML
Interaction
Integration
Multimedia
Communication
Midterm
Programming
Policy
Databases
Life Cycle
4
Narrated PowerPoint

• Create your slides
• Slide Show -gt Record Narration
• Set microphone level
• Record the narration
• Slide transitions are automatically captured
• Narration plays automatically when displayed

5
Adding Video to PowerPoint

• Insert-gtMovies and Sounds
• Movies from file (a .mpg file)
• Decide whether you want autostart
• If not, it starts when you click on it

6
Illustrating RealAudio

• Create a .ram file
• URL for the RealAudio
• Dimensions of the picture
• URL for the picture
• http//www.glue.umd.edu/oard/teaching/690/fall03/
  notes/690f037/media.html

7
Synchronizing Multiple Media

• Scripting Languages
• Synchronized Multimedia Integration Language
  (SMIL)
• Custom applications
• Macromedia Flash
• Content representation standards
• MPEG 4

8
SMILe

• Standards W3C backup
• Extensions individual player company
• We only show examples for realone player
• Structure like HTML
• ltsmilgt
• ltheadgt lt/headgt
• ltbodygt lt/bodygt
• lt/smilgt

9
Elements in SMIL

• Controls on two-dimension window
• Layout ltregiongt ,ltroot-layoutgt
• Stated in ltheadgt section
• Controls on time line
• Sequence ltseqgt, ltexclgt, ltpargt
• Timing ltbegingt, ltendgt, ltdurgt
• Stated in ltbodygt section
• Content types
• ltaudiogt, ltvideogt, ltimggt, ltrefgt
• Stated in ltbodygt section

10
SMIL Examples

• Implemented in RealOne Player
• Example
• http//www.glue.umd.edu/oard/teaching/690/fall03/
  notes/690f037/media.html
• First, View the executable
• Then, View smil file

11
Hands on Point Add some fun

• Add following to previous example
• First play the original, then the new
• ltpargt
• ltref src"http//glue.umd.edu/rba/MEDIA/audio
  /20th.wav" /gt
• ltseqgt
• ltimg src"http//glue.umd.edu/rba/MEDIA
  /images/thomas.gif" dur"5s" region"pix_region"
  /gt
• ltimg src"http//glue.umd.edu/rba/MEDI
  A/images/clisbtn.gif" dur"5s" region"pix_region"
  /gt
• ltimg src"http//glue.umd.edu/rba/MEDIA
  /images/webglobe.gif" region"pix_region"
  fill"freeze" /gt
• lt/seqgt
• lt/pargt

12
Discussion PointGenerating SMIL with a Program

• File input and output
• Iteration and arrays
• Sequential execution

13
Ways of Generating Web Pages

• Written in a markup language
• HTML, XML
• Generated the HTML using a programs
• Common Gateway Interface (.cgi)
• Active Server Pages (.asp)
• Generate the HTML using a database
• Cold Fusion (.cfm)
• PHP Hypertext Processor (.php)

14
Why Database-Generated Pages?

• Remote access to a database
• Client does not need the database software
• Serve rapidly changing information
• e.g., Airline reservation systems
• Provide multiple access points
• By subject, by date, by author,
• Record user responses in the database

15
Two Ways to Use a Database
media7.umd.edu (128.8.225.222)

Web Browser
Cold Fusion Server
.mdb file
Microsoft Access
Mapping a network drive On Windows
Explorer Tools-gtMap Network Drive-gtBrowse
Your Computer
16
Cold Fusion Markup Language

• lthtmlgt
• ltheadgt
• ltcfinput Name DataSourcegt
• SQL Command
• lt/cfinputgt
• lt/headgt
• ltbodygt
• ltcfoutput Querygt
• Value1 value1
• Value2 value2
• lt/cfoutputgt
• lt/bodygt
• lt/htmlgt

All the files have extension .cfm
17
CFQUERY and CFOUTPUT

• ltHTMLgt ltHEADgt ltTITLEgtShow All Students in Our
  Schoollt/TITLEgt ltCFQUERY NAMEallStudents
  DATASOURCEstudent20gt
• SELECT FROM Students
• lt/CFQUERYgt
• lt/HEADgt
• ltBODY BGCOLOR"LIGHTBLUE"gt
• ltH2gt ltBgtAll Students in Our Schoollt/Bgt lt/H2gt
• ltBRgt lthrgt ltpregt studentID FirstName MiddleName
  LastNameltbrgtlt/pregt
• ltCFOUTPUT QUERY"allStudents"gt
• ltPREgt
• studentID FirstName MiddleName LastName
  
• lt/PREgt
• lt/CFOUTPUTgt
• ltFORM ACTION"mainMenu.cfm" Method"post"gt
• ltinput type"submit" value"Main Menu"gt
• lt/FORMgt
• lt/BODYgt lt/HTMLgt

Must be the same name
CF variables
http//128.8.225.222/students/student20/students.c
fm
18
ColdFusion Table

• Show all books http//128.8.225.222/students/stude
  nt20/books.cfm
• ltCFTABLE QUERY"allBooks" startrow"1"
  colspacing"1" htmltable colheadersgt
• ltCFCOL HEADER"ltBgtBookIDlt/Bgt" ALIGN"left"
  WIDTH"8" TEXT"BookID"gt
• ltCFCOL HEADER"ltBgtTitlelt/Bgt" ALIGN"left"
  WIDTH"40" TEXT"Title"gt
• ltCFCOL HEADER"ltBgtAuthorlt/Bgt" ALIGN"left"
  WIDTH"18" TEXT"Author"gt
• ltCFCOL HEADER"ltBgtISBNlt/Bgt" ALIGN"left"
  WIDTH"15" TEXT"ISBN"gt
• lt/CFTABLEgt

19
SQL in ColdFusion

• Show who borrowed which book http//128.8.225.222/
  students/student20/borrow.cfm
• ltCFQUERY name"borrowedBook" dataSource"student20
  "gt
• SELECT Books.Title, Students.FirstName,
  Students.MiddleName, Students.LastName,
  Checkout.DueDate
• FROM Books, Students, Checkout
• WHERE Books.BookIDCheckout.BookID AND
  Students.StudentIDCheckout.StudentID
• lt/CFQUERYgt

20
Hands-On Point Link Databases Using ColdFusion

• Task 1
• Put plane.mdb to your Cold Fusion account using
  FTP
• Download books.cfm page to your class directory
• rename books.html to books.cfm
• Modify the page for the two queries in plane.dbm
• Task 2
• If you find it easy, try to connect your database
  homework to CF
• Download the two cfms in 5
• Modify them to build a search interface

21
A Layered Architecture Topics We Have Covered
High level, abstract
Human
Human
Multimedia Information
Database
Information Exchange
Integration, SMIL
Integration, ColdFusion
Programming
Web Pages HTML
Encoding Information XML
World Wide Web
Computer System
Computer System
Internet
Low level, specific
22
The Midterm

• Quiz/homework should be good preparation
• A variety of question types
• Some questions will require computer use
• Lots of prior exams are available
• Many have solutions available
• Open book/notes/Internet/mind/
• Just dont get help from another person

23
Computer Systems

• Hardware
• Types of hardware
• Storage hierarchy
• Moores law
• Software
• Types of software
• Types of interfaces

24
Networks

• Types of Networks
• LAN, WAN, Internet, Wireless
• Packet Switching
• Ethernet, routers, routing tables
• Layered Architecture and protocols
• TCP/UDP
• IP address/domain name
• Encryption

25
Structured Documents

• The Web
• HTTP, HTML, URL
• XML
• DTD, XSL, XLink

My Browser
26
Multimedia

• Compression, compression, compression
• Image lossy vs loseless
• Video frames are alike
• Speech voice predictable
• Music masking
• Streaming

Media Sever
Buffer
Internet
27
Programming

• Programming links machines human
• Machines require low-level specific instructions
• Humans require high-level abstraction
• Object models represent aspects of reality
• Can create any behavior from 3 control structures
• Sequential execution
• Conditional
• Iteration
• Javascript interpreters are in Web browsers
• Mozilla has javascript debugger

28
Databases

• Structured information
• Filed-gtrecord-gttable-gtdatabase
• Primary key is the key
• Normalized tables (relations)
• Remove redundancy, inconsistency, error
• Easy update, search
• Join links tables together
• Through foreign key
• Access provides visual operations

29
Integration

• Multimedia
• SMIL
• Databases
• Cold Fusion