chapter 15 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Chapter 15 PowerPoint Presentation
Download Presentation
Chapter 15

Loading in 2 Seconds...

play fullscreen
1 / 27

Chapter 15 - PowerPoint PPT Presentation


  • 195 Views
  • Uploaded on

Chapter 15. Web Database Development Database Systems: Design, Implementation, and Management, Fifth Edition, Rob and Coronel. In this chapter, you will learn:. How Internet databases are typically used About the architecture of Web-to-database middleware

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

PowerPoint Slideshow about 'Chapter 15' - annissa


Download Now 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
chapter 15

Chapter 15

Web Database Development

Database Systems: Design, Implementation, and Management, Fifth Edition, Rob and Coronel

in this chapter you will learn
In this chapter, you will learn:
  • How Internet databases are typically used
  • About the architecture of Web-to-database middleware
  • How Web-to-database middleware (ColdFusion) is used to integrate databases with the Internet
  • What special considerations govern Web database development

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web database connectivity
Web Database Connectivity
  • Allows rapid response to competitive pressures
    • New services
    • New products
  • Customer support enhanced
  • Fast effective information dissemination
    • Universal access
    • Local
    • Around the globe

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

typical uses of internet
Typical Uses of Internet

Table 15.2

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

characteristics benefits of internet technology
Characteristics/Benefits of Internet Technology
  • Hardware & software independence
    • Cost savings
    • Uses existing equipment
    • Platform independence and portability
    • No need for multiple platform development
  • Common simple user interface
    • Reduced training
    • Reduced support

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

characteristics benefits of internet technology con t
Characteristics/Benefits of Internet Technology (con’t.)
  • Location Independence
    • Global access through Internet
    • Reduced costs for dedicated connections
  • Rapid development at manageable costs
    • Development tools
    • Low entry costs
    • Available software & access tools

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web to database middleware
Web-to-Database Middleware
  • Server-side extension
    • Interacts directly with Web server
    • Handles specific requests
    • Also known as Web-to-database middleware
    • Examples
      • ColdFusion
      • CGI
      • API

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web to database middleware1
Web-to-Database Middleware

Figure 15.1

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web server interfaces
Web Server Interfaces
  • Common Gateway Interface (CGI)
    • Uses script files to connect to database
    • Perl, C++, VB
  • Application Programming Interface (API)
    • Newer and more efficient
    • Uses DLLs
    • Memory resident and faster
    • Well known APIs
      • Netscape (NSAPI)
      • Internet Server API from Microsoft (ISAPI)
      • WebSite API from O’Reilly (WSAPI)

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

api and cgi web server interfaces
API and CGI Web Server Interfaces

Figure 15.2

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web to database middleware connection methods
Web-to-Database Middleware Connection Methods
  • Native SQL access middleware
  • Use services of Open Database Connectivity (ODBC)
  • Use Object Linking and Embedding Database (OLE DB) interface with Windows
  • ODBC most common

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

odbc to access databases
ODBC to Access Databases

Figure 15.3

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web to database middleware uses odbc to access databases
Web-to-Database Middleware Uses ODBC to Access Databases

Figure 15.4

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

web browser
Web Browser
  • Located on the client computer
  • End user Web interface
  • Interprets HTML code received from Web server
  • Presents page components in a standard way
  • Client-side extensions
    • Plug-ins
    • Java and JavaScript
    • ActiveX and VBScript

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

coldfusion
ColdFusion
  • Web application server
  • Uses
    • Connect and query database from Web page
    • Present database data in a Web page
    • Create dynamic Web search pages
    • Create Web pages to insert, update, and delete data
    • Define required and optional relationships
    • Define required and optional form fields
    • Enforce referential integrity in form fields
    • Use simple and nested queries to represent business rules

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

how coldfusion works
How ColdFusion Works

Figure 15.5

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

how coldfusion works1
How ColdFusion Works
  • Server-side markup language
    • HTML extensions
    • ColdFusion Markup Language (CFML)
  • Executed in interpreter mode
  • Contain HTML, CFML
  • May contain Java, JavaScript, or VBScript
  • Client browser requests .cfm page from Web Server
    • ColdFusion application server executes .cfm script
    • Sends resulting output in HTML to Web Server
    • Web server sends to client browser

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

coldfusion tags
ColdFusion Tags
  • CFQuery
    • Queries a database
  • CFOutput
    • Displays data returned by query
  • CFTable
    • Displays data in Tabular format

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

coldfusion dynamic query
ColdFusion Dynamic Query
  • Create script to generate form with criteria used in database search
  • Create script to execute query and display results
    • Uses ColdFusion tags
    • Uses HTML

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

the web as a stateless system
The Web as a Stateless System
  • Web server does not know status of any client at any given time
  • Request-reply model of communication
  • Browser concerned only with current page
  • Data processing requires additional software
    • Java, JavaScript, VBScript

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

inserts and updates with coldfusion
INSERTs and UPDATEs with ColdFusion
  • CFINSERT Tag
    • Adds records to database
    • Parameters
      • DATASOURCE
      • TABLENAME
  • CFUPDATE Tag
    • Updates selected database contents
    • Parameters
      • DATASOURCE
      • TABLENAME

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

deletes with coldfusion
DELETEs with ColdFusion
  • CFQUERY Tag
    • Uses SQL DELETE Statement
    • Parameters
      • DATASOURCE
      • TABLENAME

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

internet database special considerations
Internet Database: Special Considerations
  • Involve more than just database-enabled Web applications
  • Issues important to corporate databases
    • Data security
    • Transaction management
    • Client-side data validation
    • Operational and management challenges
  • Database applications development most affected by Internet

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

supported data types
Supported Data Types
  • Integrated data from multiple sources
    • Word-processor documents
    • Pictures
    • Sounds
    • Movies
  • Methods for storing and extracting data objects
  • Overhead created by storage
  • Client browser support of object being accessed
  • Size of database considering multimedia and other data

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

data security
Data Security
  • Web Server Level
    • Secure transactions using encryption
    • TCP/IP protocol level
    • Firewalls
  • RMDBS Vendors
    • Login authentication
    • Restrict access to particular SQL commands
  • Web-to-database middleware
    • End user restrictions
    • Designer created algorithms
  • Must support e-commerce applications

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

transaction management
Transaction Management
  • Concept is foreign to Web
  • Dilemma created by request-reply model
    • Web cannot maintain open line between client and database
    • Recovery requires client maintain open communications
  • Designers must ensure proper transaction management support at database server level
  • ColdFusion uses CFTRANSACTION tag for transaction management support

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel

denormalization
Denormalization
  • Web forms
    • Cannot use multiple data entry lines
    • 1:M relationships problematic
  • Solutions
    • Web programming languages
    • Java, JavaScript, VBScript

Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel