Internet, intranet, and multimedia database processing - PowerPoint PPT Presentation

Internet intranet and multimedia database processing
1 / 19

  • Uploaded on
  • Presentation posted in: General

Internet, intranet, and multimedia database processing. Database processing across local and wide area networks Alternative architectures for distributing application logic to network clients. Databases and networks. Synergy between database and network (Internet, intranets) technologies

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Internet, intranet, and multimedia database processing

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Internet intranet and multimedia database processing

Internet, intranet, and multimedia database processing

Database processing across local and wide area networks

Alternative architectures for distributing application logic to network clients

Databases and networks

Databases and networks

  • Synergy between database and network (Internet, intranets) technologies

  • Examples?

    • Distance learning

    • Online testing

    • Electronic commerce

    • Planning (e.g., travel agents)

    • Banking

    • Voting, polling

    • …?



  • Network: collection of computers communicating via a standard protocol

    • Public (Internet)

    • Private (intranets)

  • Internet: network of public networks (started by military to avoid single point of failure – ARPANET, 1960’s)

  • TCP/IP: Transmission Control Protocol / Internet Protocol

Internet applications services

Internet applications/services

  • Email (messages)

  • FTP (file transfer)

  • Telnet (remote terminals)

  • Usenet (newsgroups)

  • IRC (chat)

  • WAIS (wide area information service)

  • HTTP (hypertext transfer)

  • ...

World wide web

World Wide Web

  • All of the Internet services, with a standard hypertext interface accessible via client browsers from servers (HTTP)

    • HTML: Hypertext Markup Language

    • SGML: Standard Generalized Markup Language

  • Started to organize and exchange Physics data at CERN (Tim Berners-Lee, 1989)

More on the web

More on the Web

  • HTML: text, tags, and anchors

    • <html><head><title>TWI</title></head><body>Welcome to <a href=“logo.gif”> Time-Wasting, Inc.</a></body></html>

  • URL: Uniform Resource Locator

    • protocol://servername[:port]/filepath

  • MIME: Multipurpose Internet Mail code

    • MIME TypeNameFile Extensiontext/htmlHypertext.htm, htmltext/plainText .txtimage/gif Graphics I.F..gif...

Databases and the internet

Databases and the Internet

  • Can extend MIME types with application-specific files

    • Pro or con? Why?

  • Request oriented protocols

    • Pro or con? Why?

  • Stateless transactions

    • Pro or con? Why? True or false?

  • Insecure transactions

    • Pro or con? Why? True or false?



  • Private LAN or WAN

  • Security

    • Disconnected from Internet

    • Firewall

    • Controlled data access, authentication...

  • Speed

    • 100Mbs (versus 28.8kbs)

    • Multimedia applications become feasible

Network database applications

Network database applications

  • Users execute applications on the client via a browser

  • The database resides on the server, together with the web server

  • The DBMS can reside at either end (file-sharing versus client-server)

Database publishing

Database publishing

  • Static report publishing: the report is created off-line, saved in HTML format, and posted on the Web

  • Query publishing: the client uses a form to issue a query as part of an HTTP request, the server creates the report in HTML format and sends it back as a response to the client

  • Application publishing: application code transfers to the client and executes locally

Db query publishing example

DB query publishingexample

ASP Request


Network database applications1

Network database applications

  • The continuum between thin and thick clients

Thin clients





Your email please:

<INPUT TYPE=text NAME=“address”><P>

<INPUT TYPE=submit>

<INPUT TYPE=reset VALUE=“Cancel”>




Thin clients

  • [Client]form.html sends:

    • “execute with argument address”

  • [Server] responds:

    • “<HTML><HEAD><TITLE>Ack</TITLE></HEAD><BODY>You are done for.</BODY></HTML>”

Java database applications

Java database applications

  • Java is an OOPL (developed by Sun)

  • Java is compiled into machine-independent (portable) “bytecode”

  • Java bytecode is loaded from server to client, where it is interpreted and executed as a normal program

  • Java code can access the database via an ODBC interface or DBMS library

Java database applications thin and thick clients

Java database applications: thin and thick clients

Microsoft active platform

Microsoft Active Platform

  • Microsoft’s open architecture to deliver applications over the network

  • Various tools, services, and technologies

    • HTML and extensions

    • Scripting (JScript, VBScript, etc.)

    • Components (Java, ActiveX)

  • ActiveX controls

    • Based on OLE, COM, DCOM (Distributed Component Object Model)

    • Binary-level dynamic interface for Windows application (IUnknown, Query Interface)

    • Can be embedded into HTX documents

Support for network applications

Support for network applications

  • Hyperlink (URL, UNC) data types

  • Application publishing (Java, ActiveX)

  • Tables, queries, and forms publishing

    • Static HTML (reports, too)

    • Dynamic HTML via ActiveX or 3rd-party ODBC “application servers” interacting with Microsoft internet servers

      • Need IDC and HTX or ASP files on server

      • What’s an example of an application server?

Multimedia database applications

Multimedia database applications

  • Not necessarily related to networks

  • Can embed multimedia objects as links in databases:

    • Images

    • Sounds

    • Video

  • Large binary files: network bandwidth becomes a central issue

The future

The future

  • Impact of databases on networks

    • Speed

    • Security

    • Electronic payment schemes

    • Agents to deal with dynamic pages (XML)

  • Impact of networks on databases

    • Huge new markets

    • New impetus for database research

    • Standardize interfaces

    • Simplify development

  • Login