Transcript Internet and E

INTERNET
DATABASE
Internet and E-commerce



Internet – a worldwide collection of
interconnected computer network
E-commerce – customers can place and pay for
orders via the business’s web site.
Benefits of e-commerce
Worldwide market – buy from anywhere
 Productivity – no wastage of time
 Cost reduction – less time & energy
 Improved customer services – ease the customer

Internet Services





E-mail – to send mail and file attachment
Worldwide web – to browse for information
stored anywhere and do business transaction
File transfer – to download and upload file
News – to join a news group
Chat room – to join a discussion or chat room
Worldwide web





Internet – computers connected using a standard
protocol : TCP/IP
Worldwide web – resources stored on the web
Web browser – software to browse the web
Web server – software to responds to client’s
request
Web page – text written in HTML, static and
dynamic
Worldwide web (cont.)




Hyperlink – linking the web page
Hypertext – refer to different types of
documents
Web site – refer to server and collection of the
web pages
http – protocol used by client and server to
communicate
Client Functions

Can be extended :
Plug-ins – browser can activate automatically when
required (extend a system/application)
 Active-X – Microsoft’s specification for writing
programs that will run inside its browser.
 VBScript – Microsoft product based on Visual Basic
 JavaScript – Netscape product
 Java – runs on top of a web browser/applets

Server Functions

Query processing from browser (client) to
server
Browser send a web page request to the server
 Server receive the page request and validate. Then,
pass to the middleware
 Middleware read the script, validate and execute it.
Send SQL command to the DBMS, retrieves the
info. And send the result back to the middleware
 Server takes and send the page to the browser

Web server interface


Web server provide standard interface to
communicate with external program
Two common interfaces :
Application Programming Interface (API)
 Common Gateway Interface (CGI)

Internet / Intranet and its
Security



Internet - a worldwide collection of interconnected
computer network
Intranet – an internal corporate network, LAN or
WAN
Benefits of intranet :






Ease of use
Open standard
Platform independence: Runs anywhere
Multiple data source
Uniform interface
Shorter development time
Internet / Intranet and its
Security

Firewall – a software / hardware components
that limits and control :
Data traffic to an organization’s database from the
outside world
 Data that are permitted to flow from an organization
the outside world.


END