multimedia databases eran stilleromer gertel. eran stiller omer gertelmultimedia databases2 in this...
Post on 20-Dec-2015
217 views
TRANSCRIPT
![Page 1: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/1.jpg)
Multimedia Databases
Eran Stiller Omer Gertel
![Page 2: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/2.jpg)
Eran Stiller Omer Gertel Multimedia Databases 2
In this presentation…
Introduction What is a Multimedia Database? Why do we need it?
Modeling Multimedia DatabasesDesign MethodologyModeling the WWW as a Multimedia Database WebSQL Using the Multimedia Design Methodology
Graphical extension to SQL: SQL+D
![Page 3: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/3.jpg)
Eran Stiller Omer Gertel Multimedia Databases 3
What is a Multimedia Database?
Multimedia Data-typesMovies, Pictures, Sound Clips, Documents
etc…
Advanced Querying Possibilities
![Page 4: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/4.jpg)
Eran Stiller Omer Gertel Multimedia Databases 4
Why Do We Need It?
Tremendous Amounts of
Digitized Multimedia ContentVideo servers, Ifilms, IMDB, AllMusic, etc…
Querying for Digitized Information “A Picture is Worth a Thousand Words”
![Page 5: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/5.jpg)
Eran Stiller Omer Gertel Multimedia Databases 5
The Leading Concept
Extracting Information from Multimedia Objects “On the Fly”
Creating a Design MethodologySimple, Intuitive, Upward CompatibleUnbound by Data-type, Application, Usage
![Page 6: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/6.jpg)
Eran Stiller Omer Gertel Multimedia Databases 6
Modeling Multimedia Databases
Using Object Relational Data ModelsData Description Language
![Page 7: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/7.jpg)
Eran Stiller Omer Gertel Multimedia Databases 7
Data Description Language
Example:Movie Database:
MOVIE(Title, Year, Director, Length)What About the Movie?
Add It to the DatabaseCreate Additional Functions
![Page 8: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/8.jpg)
Eran Stiller Omer Gertel Multimedia Databases 8
Data Description Language
First Approach:Complex Type:
Create Type Movie_t(Title varchar(20),Year int,Director varchar(20),Length int,MV blob);
Create Table Movie of type Movie_t;
![Page 9: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/9.jpg)
Eran Stiller Omer Gertel Multimedia Databases 9
Data Description Language
Second Approach:Extended Type:
Create Table Movies(
Title varchar(20),
Year int,
Director varchar(20),
Length int,
MV movie_blob);
![Page 10: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/10.jpg)
Eran Stiller Omer Gertel Multimedia Databases 10
Data Description Language
ConcernsDistinguishing the Digitized Information
ConclusionNaming ConventionThe ‘Core’ Special Attribute
![Page 11: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/11.jpg)
Eran Stiller Omer Gertel Multimedia Databases 11
Data Description Language
Example – Continued:A New Relation:
MOVIE(Title, Year, Director, Length, Core)What About Querying?
“Show the opening sequence of all movies directed by Spielberg in 1993.”
![Page 12: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/12.jpg)
Eran Stiller Omer Gertel Multimedia Databases 12
Data Description Language
SQL-like Language:Select Movie.opening_seq
From Movie
Where Year=1993 AND Director=“Spielberg”;
![Page 13: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/13.jpg)
Eran Stiller Omer Gertel Multimedia Databases 13
Data Description Language
SQL Solution:Declare External opening_seq(movie_blob)
Returns movie_blob
Language C;
Smart Interpreter
![Page 14: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/14.jpg)
Eran Stiller Omer Gertel Multimedia Databases 14
A Design Methodology
Core-ER Diagram
Core-ORDB schema
![Page 15: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/15.jpg)
Eran Stiller Omer Gertel Multimedia Databases 15
EntitiesAbstract EntitiesCore Entities
Core-ER Diagram
![Page 16: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/16.jpg)
Eran Stiller Omer Gertel Multimedia Databases 16
Core-ER Diagram
AttributesConventional AttributesUnconventional Attributes
![Page 17: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/17.jpg)
Eran Stiller Omer Gertel Multimedia Databases 17
Core-ER Diagram
MethodsCore as InputEntity as Input
![Page 18: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/18.jpg)
Eran Stiller Omer Gertel Multimedia Databases 18
Core-ER Diagram
Keys and RelationshipsExactly as in ER Diagrams
![Page 19: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/19.jpg)
Eran Stiller Omer Gertel Multimedia Databases 19
Core-ER Diagram
Example
![Page 20: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/20.jpg)
Eran Stiller Omer Gertel Multimedia Databases 20
CER to Core-ORDB Schema
We Need Rules For: Abstract Entities Core Entities Methods Relationships
Embedded ER Diagram
Keys Core Can Be a Key
Example
![Page 21: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/21.jpg)
Eran Stiller Omer Gertel Multimedia Databases 21
Employee(SSN, name, picture, position, salary, Dept)
![Page 22: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/22.jpg)
Eran Stiller Omer Gertel Multimedia Databases 22
EMail(EMailID, From, To, Date, Date R, Size, RespTo, Core)
![Page 23: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/23.jpg)
Eran Stiller Omer Gertel Multimedia Databases 23
Declare External Keyword(Email, string) Returns BOOLEAN<Function Definition>;
![Page 24: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/24.jpg)
Eran Stiller Omer Gertel Multimedia Databases 24
Has(SSN, EMailID)
![Page 25: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/25.jpg)
Eran Stiller Omer Gertel Multimedia Databases 25
Note: Core Can Be A Key!
![Page 26: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/26.jpg)
Eran Stiller Omer Gertel Multimedia Databases 26
A Design Methodology
ConclusionFull Upward CompatibilityAn Easy to Use Solution
![Page 27: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/27.jpg)
Eran Stiller Omer Gertel Multimedia Databases 27
Modeling the WWW
WebSQL
Using the Multimedia Design Methodology
![Page 28: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/28.jpg)
Eran Stiller Omer Gertel Multimedia Databases 28
WebSQL
SQL-Like Language
Minimal Relational Approach
Queries Based Both On The Content And On The Hypertext Structure Of The Web
![Page 29: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/29.jpg)
Eran Stiller Omer Gertel Multimedia Databases 29
WebSQL
Content Based QueriesDocument(url, title, text, type, length,
lastModify)
![Page 30: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/30.jpg)
Eran Stiller Omer Gertel Multimedia Databases 30
WebSQL
Example:Find All HTML Documents About
“Hypertext”Select D.url, D.title, D.length, D.lastModify
From Document D such that D mentions “Hypertext”
Where D.type = “text/html”;
![Page 31: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/31.jpg)
Eran Stiller Omer Gertel Multimedia Databases 31
WebSQL
Hypertext Structure Based QueriesDocument(url, title, text, type, length,
lastModify)Anchor(base, href, label)
![Page 32: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/32.jpg)
Eran Stiller Omer Gertel Multimedia Databases 32
WebSQL
Example:Find All Links to Applet from Documents
About “Java”Select Y.label, Y.href
From Document X such that X mentions “Java” Anchor Y such that base = X
Where Y.label contains “Applet”;
![Page 33: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/33.jpg)
Eran Stiller Omer Gertel Multimedia Databases 33
WebSQL
Hypertext Link Classification Interior () Local () Global ()
Empty Path (=)Path Regular Expressions Alternation ( | ) Repetition ( * ) Concatenation ( . )
![Page 34: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/34.jpg)
Eran Stiller Omer Gertel Multimedia Databases 34
WebSQL
Example:Select D.url, D.title
From Document D such that “http://www.cs.huji.ac.il” = | | .
D
Where D.title contains “database”
![Page 35: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/35.jpg)
Eran Stiller Omer Gertel Multimedia Databases 35
WebSQL
Example:Select X.url, X.title, Y.url, Y.title
From
Document X such that X mentions “Computer
Science”,
Document Y such that X = | | . Y;
![Page 36: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/36.jpg)
Eran Stiller Omer Gertel Multimedia Databases 36
Modeling the WWW
WebSQLAlready Implemented in JavaSpecific SolutionRefers Only To Documents
Using the Multimedia Design Methodology
![Page 37: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/37.jpg)
Multimedia Databases
We’ll Be Back, Right After The Break…
![Page 38: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/38.jpg)
Eran Stiller Omer Gertel Multimedia Databases 38
Modeling the WWW
WebSQLAlready Implemented in JavaSpecific SolutionRefers Only To Documents
Using the Multimedia Design Methodology
![Page 39: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/39.jpg)
Eran Stiller Omer Gertel Multimedia Databases 39
Multimedia Design Methodology
EntitiesHTMLdoc(h_url, title, type, length,
lastModify, core)Links(l_url, label) Include(h_url, l_url)
![Page 40: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/40.jpg)
Eran Stiller Omer Gertel Multimedia Databases 40
Multimedia Design Methodology
MethodsContains(HTMLdoc.title, string)Reach_by(HTMLdoc.url, url_to, by_n,
l_type)Mentions(HTMLdoc, string)Linktype(HTMLdoc, url)
![Page 41: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/41.jpg)
Eran Stiller Omer Gertel Multimedia Databases 41
Multimedia Design Methodology
Example:Find All HTML Documents About
“Hypertext”Select HTMLdoc.h_url
From HTMLdoc
Where Contains(HTMLdoc.title, “Hypertext”);
![Page 42: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/42.jpg)
Eran Stiller Omer Gertel Multimedia Databases 42
Example:Find All Links to Applet from Documents
About “Java”Select Links.l_url
From HTMLdoc, Links, IncludeWhere mentions(HTMLdoc, “java”) AND
HTMLdoc.h_url = Include.h_url AND
Links.l_url = Include.l_url AND substring(“applet”, Links.label);
Multimedia Design Methodology
![Page 43: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/43.jpg)
Eran Stiller Omer Gertel Multimedia Databases 43
Multimedia Design Methodology
Example: Select Links.l_url
From HTMLdoc, Links, Include
Where substring(“database”, HTMLdoc.title) AND
HTMLdoc.h_url = Include.h_url AND
Links.l_url = Include.l_url AND
reach_by(“http://www.cs.huji.ac.il”, Links.l_url, 2, local);
Hint: We’ve seen it before…
![Page 44: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/44.jpg)
Eran Stiller Omer Gertel Multimedia Databases 44
Multimedia Design Methodology
Example: Select HTMLdoc.h_url, Links.l_url
From HTMLdoc, Links
Where mentions(HTMLdoc, “Computer Science”) AND
reach_by(HTMLdoc.h_url, Links.l_url, 2, local);
![Page 45: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/45.jpg)
Eran Stiller Omer Gertel Multimedia Databases 45
Multimedia Design Methodology
Simplified Model, But…
Complicated Real World
Taking Another Step
![Page 46: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/46.jpg)
Eran Stiller Omer Gertel Multimedia Databases 46
Multimedia Design Methodology
EntitiesHTMLdoc(h_url, title, type, length,
lastModify, core)WebObject(w_url, label, objectType,
interactive, core)Properties(position, size, props) Include(h_url, w_url, position, size, props)
![Page 47: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/47.jpg)
Eran Stiller Omer Gertel Multimedia Databases 47
Multimedia Design Methodology
Methods Contains(HTMLdoc.title, string) Reach_by(HTMLdoc.url, url_to, by_n, l_type) Mentions(HTMLdoc, string) Linktype(HTMLdoc, url)
And Additional Methods DisplayDoc(HTMLdoc) DisplayObj(WebObject, Properties.position,
Properties.size, Properties.props)
![Page 48: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/48.jpg)
Eran Stiller Omer Gertel Multimedia Databases 48
Multimedia Design Methodology
Example: List All Documents That Have a Video-Clip Or a
Picture Labeled “Sharon” Select HTMLdoc.h_url
From HTMLdoc, WebObject, Include
Where HTMLdoc.h_url = Include.h_url AND
WebObject.w_url = Include.w_url AND
(WebObject.objectType = “Image” OR
WebObject.objectType = “Video”) AND
WebObject.label = “Sharon”;
![Page 49: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/49.jpg)
Eran Stiller Omer Gertel Multimedia Databases 49
Multimedia Design Methodology
Still Not Complicated Enough…
The Last Step
![Page 50: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/50.jpg)
Eran Stiller Omer Gertel Multimedia Databases 50
Modeling the WWW
WebSQL Already Implemented in Java Specific Solution Refers Only To Documents
Using the Multimedia Design Methodology General Methodology Used Doesn’t Require a Special Web SQL-Like
Language Easily Expandable
![Page 51: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/51.jpg)
Eran Stiller Omer Gertel Multimedia Databases 51
SQL+D
Graphical Extension to SQL
Answering a Multimedia Database Query
Easier than Creating Specific Display Solutions
Display Specifications Are Included in the Query
![Page 52: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/52.jpg)
Eran Stiller Omer Gertel Multimedia Databases 52
SQL+D
Video Store DatabaseMovie(available, title, director, producer,
date, classification, rating, core, poster)
Movie_Actors(title, name, role)Actors(name, age, biography, picture)
![Page 53: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/53.jpg)
Eran Stiller Omer Gertel Multimedia Databases 53
SQL+D
List All Actors in “Gone With the Wind” with Their Pictures and Biographies Select MA.name, A.biography, A.picture
From Movie_Actors MA, Actors AWhere MA.title = “Gone With the Wind” AND
A.name = MA.nameDisplay Panel main, Panel info On main(east),With MA.name As list On main(west),
A.picture As image On info(north), A.biography As text On info(south);
![Page 54: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/54.jpg)
Eran Stiller Omer Gertel Multimedia Databases 54
![Page 55: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/55.jpg)
Eran Stiller Omer Gertel Multimedia Databases 55
SQL+D
Display All Action Movies and Their Posters, Allowing to Play the movie If Desired Select title, poster, core
From MovieWhere classification = “Action”Display Panel main, Panel b On main(east)With poster As image On main(west),
title As list On b(north), “Play” As button On b(south)
Trigger ‘mpegplay(‘+ core +’)’
![Page 56: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/56.jpg)
Eran Stiller Omer Gertel Multimedia Databases 56
![Page 57: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/57.jpg)
Eran Stiller Omer Gertel Multimedia Databases 57
SQL+D
Campus Map DatabaseCampus(campus_area,area_map)Building(building_name, building_picture,
campus_area, coordinates)Floor(building_name, floor, floor_map)Room(building_name, floor, room_name,
description, homepage, info, coordinates)
![Page 58: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/58.jpg)
Eran Stiller Omer Gertel Multimedia Databases 58
SQL+D
Show a Map of Main Campus With a List of the Buildings in it Select C.area_map, B.building_name
From Campus C, Building B
Where C.campus_area = “Main Campus”
Display Panel main
With B.building_name As list On main(east),
C.area_map As image On main(west);
![Page 59: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/59.jpg)
Eran Stiller Omer Gertel Multimedia Databases 59
![Page 60: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/60.jpg)
Eran Stiller Omer Gertel Multimedia Databases 60
SQL+D
Show a Map of Main Campus With a List of the Buildings in it Select C.area_map, B.building_name,
B.coordinatesFrom Campus C, Building BWhere C.campus_area = “Main Campus”Display Panel mainWith B.building_name As list On main(east),
C.area_map As image On main(west) All B.coordinates As polygon On
main(west);
![Page 61: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/61.jpg)
Eran Stiller Omer Gertel Multimedia Databases 61
![Page 62: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/62.jpg)
Eran Stiller Omer Gertel Multimedia Databases 62
SQL+D
Show a Map of Main Campus With a List of the Buildings in it Select C.area_map, B.building_name
From Campus C, Building BWhere C.campus_area = “Main Campus”Display Panel mainWith B.building_name As list On main(east)
Trigger ‘building_maps(‘+ building_name +’)’
C.area_map As image On main(west);
![Page 63: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/63.jpg)
Eran Stiller Omer Gertel Multimedia Databases 63
SQL+D
Where building_maps(input) is Select B.building_name, B.building_picture, F.floor
From Building B, Floor FWhere B.building_name = + input + AND
F.building_name = B.building_nameDisplay Panel main, Panel b On main(south)
With building_picture As image On main(north), building_name As title On main(north), All floor As button On b(east)
Trigger ‘floor_buildings( ‘+ building_name +’, ‘+ floor +’)’
“Select Floor To Visit” On b(west);
![Page 64: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/64.jpg)
Eran Stiller Omer Gertel Multimedia Databases 64
![Page 65: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/65.jpg)
Eran Stiller Omer Gertel Multimedia Databases 65
SQL+D
And floor_buildings(input1, input2) isSelect F.floor_map, R.floor, R.room_name,
R.info, R.homepage, R.coordinates
From Floor F, Room R
Where F.building_name = +input1+ AND
F.floor = +input2+ AND
R.floor = F.floor
![Page 66: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/66.jpg)
Eran Stiller Omer Gertel Multimedia Databases 66
SQL+D
And floor_buildings(input1, input2) is Display Panel main,
Panel b On main(west), Panel c On main(east),
With floor_map As image On c(north), All coordinates As poly On c(north), room_name As list On b(north), info As text On b(center), All Distinct floor As button On c(south)
Trigger floor_buildings(‘+building_name+’,‘+floor+’)’ homepage As button On b(south);
![Page 67: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/67.jpg)
Eran Stiller Omer Gertel Multimedia Databases 67
![Page 68: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/68.jpg)
Eran Stiller Omer Gertel Multimedia Databases 68
SQL+D
SQL-Like Queries
Application-Like Display Controller
Makes Most of Both WorldsSimple to UseUser Friendly Output
![Page 69: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/69.jpg)
Eran Stiller Omer Gertel Multimedia Databases 69
Conclusion
Multimedia Content Becomes More and More Popular
Correct Generic Models Bring Easy to Use Results
Clean, Simple Solutions Come From Extending the Existing Format
![Page 70: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/70.jpg)
Eran Stiller Omer Gertel Multimedia Databases 70
References
Chitta Baral, Graciela Gonzalez and Tran Son, “Conceptual Modeling and Quering in Multi-media Databases”, Department of CS, UTEP
Alberto O. Mendelzon, George A. Mihaila and Tova Milo, “Quering the World Wide Web”, University of Toronto and Tel-Aviv University, 1996
Chitta Baral, Graciela Gonzalez and Tran Son, “A Multimedia Display Extension to SQL: Language Design and Architecture”, Department of CS, UTEP, 1997
Chitta Baral, Graciela Gonzalez and Tran Son, “Issues in Querying Multimedia Databases”, Department of CS, UTEP
Isabel F. Cruz, Michael Averbuch, Wendy T. Lucas, Mellisa Radzyminski, Kirby Zhang, “Delaunay: a Database Visualization System”, Database Visualization Reaserch Group, Tufts University
![Page 71: Multimedia Databases Eran StillerOmer Gertel. Eran Stiller Omer GertelMultimedia Databases2 In this presentation … Introduction What is a Multimedia Database?](https://reader030.vdocuments.us/reader030/viewer/2022032800/56649d435503460f94a1f2a5/html5/thumbnails/71.jpg)
Eran Stiller Omer Gertel Multimedia Databases 71
Th…Th…That’s All Folks!