Quick Review to Database Systems
Arry Akhmad Arman
Laboratory for Signal and System Electrical Engineering Department of ITB Email:
[email protected],
[email protected]
Architecture z Centralized (Mainframe to mini computer system) z File Sharing in LAN z Client Server
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
2
Client Server Architecture Client Side Client
Request (SQL)
Request (SQL) Result (data only)
Server side Server (DBMS)
Database
Result (data & format Display) user
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
3
Client Server Architecture Client Side
Server side request
Client
Server
network
Data base
result result
request
user
Client dan Server bisa terpisah jauh melalui network
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
4
Structured Query Language z SQL adalah suatu standar bahasa untuk memberikan Query (request) dalam system database. z SQL digunakan dalam berbagai platform yang berbeda z Adanya SQL membuat para pemakai mudah berhadapan dengan berbagai platform yang berlainan.
Query (SQL) hasil
Database System
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
5
Open DataBase Connector Query (SQL) hasil
Database System #1
Database System #1 SQL hasil
Query (SQL) hasil
Database System #2
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
ODBC Database System #2
6
Multimedia Database Client Side
Server side request
Client
Server
Database
result result
request
user Data Multimedia Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
7
Data Multimedia z z z z z
Image Data Video Data Audio Data Text/Document Data Handwritten data
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
8
Sample Multimedia Scenario Surveillance Surveillance Data Data
Audio/Phone Audio/Phone Data Data
Police Police Application Application
Geographical Geographical Information Information
Relational Relational Data Data Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
Still StillImage Image Data Data
Document Document Data Data 9
Contoh Query : Image Query z Tersedia foto dari orang yang dicurigai. z Query “Retrieve all images from the image library in which the person appearing in the currently displayed photograph appears”
z Kemungkinan } User sudah tahu identitas orang dalam foto, query dapat
dilakukan melalui tekstual } User tidak mengetahui identitasnya, query dilakukan dengan bantuan image processing (recognition) Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
10
Contoh Query : Audio Query z Polisi memiliki rekaman audio percakapan telpon antara orang yang dicurigai dengan seseorang yang lain
z Query “Cari semua bagian percakapan yang mengandung kata ‘uang’ “ } Tentukan identitas orang yang berbicara dengan si-A }
z Proses pertama memerlukan dukungan teknologi “speech recognition” z Proses kedua memerlukan dukungan teknologi “speaker recognition”
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
11
Contoh Query : Video Query
z Polisi memiliki rekaman video yang dipasang di sejumlah tempat pengintaian
z Query } “Cari semua segmen video yang memperlihatkan
penyerahan barang dari seseorang kepada orang lain”
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
12
Contoh Query : Text/Doc Query
z Polisi mengakses news library z Query } “Cari semua artikel yang berhubungan dengan si-
A”
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
13
Contoh Query : Relational Query
z Polisi mengakses database Bank z Query } “Cari semua transaksi transfer uang dari si-A
kepada orang lain yang nilainya lebih dari 100.000.000”
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
14
Aplikasi Multimedia Database z z z z z
Edukasi/Library Industri Perfilman Television/News Broadcaster Travel Industry Documentation Center
Arry Akhmad Arman,
[email protected] © 1999-2001, ARRY AKHMAD ARMAN - Electrical Engineering Dept. of ITB
15
