9/5/2012isc329 isabelle bichindaritz1 web database environment
TRANSCRIPT
![Page 1: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/1.jpg)
ISC329 Isabelle Bichindaritz 19/5/2012
Web Database Environment
![Page 2: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/2.jpg)
ISC329 Isabelle Bichindaritz 29/5/2012
Learning Objectives
• Meaning of client–server architecture and advantages of this type of architecture for a DBMS.
• The difference between two-tier, three-tier and n-tier client–server architectures
• The function of an application server• The meaning of middleware and the different types
of middleware that exist• Function and uses of Transaction Processing
Monitors.
![Page 3: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/3.jpg)
ISC329 Isabelle Bichindaritz 3
Learning Objectives• The purpose of a Web service and the
technological standards used• The meaning of service-oriented
architecture (SOA)• The difference between distributed
DBMSs, and distributed processing
9/5/2012
![Page 4: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/4.jpg)
ISC329 Isabelle Bichindaritz 49/5/2012
Acknowledgments
• Some of these slides have been adapted from Thomas Connolly and Carolyn Begg
![Page 5: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/5.jpg)
ISC329 Isabelle Bichindaritz 5
Multi-user DBMS Architectures
• Teleprocessing– Traditional architecture for multi-user systems– One computer with a single central processing
unit (CPU) and a number of terminals– Put a huge burden on the central computer
• Downsizing– Replacing expensive mainframe computers
with more cost-effective networks of personal computers
9/5/2012
![Page 6: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/6.jpg)
ISC329 Isabelle Bichindaritz 69/5/2012
Teleprocessing Topology
![Page 7: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/7.jpg)
ISC329 Isabelle Bichindaritz 7
Multi-user DBMS Architectures
• File-server architecture– Processing is distributed about the network– Three main disadvantages
• Large amount of network traffic• Full copy of DBMS required on each workstation• Concurrency, recovery, and integrity control are
complex– Multiple DBMSs can access the same files
9/5/2012
![Page 8: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/8.jpg)
ISC329 Isabelle Bichindaritz 89/5/2012
File-Server Architecture
![Page 9: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/9.jpg)
ISC329 Isabelle Bichindaritz 9
Multi-user DBMS Architectures
• Traditional two-tier client–server architecture– Client process requires some resource– Server provides the resource– Basic separation of four main components of
business application– Typical interaction between client and server
9/5/2012
![Page 10: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/10.jpg)
ISC329 Isabelle Bichindaritz 109/5/2012
Client-Server Architecture
![Page 11: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/11.jpg)
ISC329 Isabelle Bichindaritz 119/5/2012
Alternative Client-Server Topologies
![Page 12: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/12.jpg)
ISC329 Isabelle Bichindaritz 12
Summary of client–server functions
9/5/2012
![Page 13: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/13.jpg)
ISC329 Isabelle Bichindaritz 13
Multi-user DBMS Architectures
• Three-tier client–server architecture– User interface layer– Business logic and data processing layer– DBMS– Many advantages over traditional two-tier or
single-tier designs
9/5/2012
![Page 14: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/14.jpg)
ISC329 Isabelle Bichindaritz 14
Multi-user DBMS Architectures
• N-tier architectures– Three-tier architecture can be expanded to n
tiers
• Application servers– Hosts an application programming interface
(API) to expose business logic and business processes for use by other applications
9/5/2012
![Page 15: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/15.jpg)
ISC329 Isabelle Bichindaritz 15
Multi-user DBMS Architectures• Middleware
– Software that mediates with other software – Communication among disparate applications– Six main types
• Asynchronous Remote Procedure Call (RPC)• Synchronous RPC• Publish/Subscribe• Message-Oriented middleware (MOM)• Object-request broker (ORB)• SQL-oriented data access
9/5/2012
![Page 16: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/16.jpg)
ISC329 Isabelle Bichindaritz 16
Multi-user DBMS Architectures
• Transaction processing monitor– Controls data transfer between clients/servers– Provides a consistent environment, particularly
for online transaction processing (OLTP)– Significant advantages
• Transaction routing• Managing distributed transactions• Load balancing• Funneling• Increased reliability9/5/2012
![Page 17: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/17.jpg)
ISC329 Isabelle Bichindaritz 17
Multi-user DBMS ArchitecturesTransaction processing monitor of a three-tier client-server architecture
9/5/2012
![Page 18: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/18.jpg)
ISC329 Isabelle Bichindaritz 18
Web Services and Service-Oriented Architectures
• Web service– Software system that supports interoperable
machine-to-machine interaction over a network– No user interface– Examples of Web services– Uses widely accepted technologies and
standards
9/5/2012
![Page 19: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/19.jpg)
ISC329 Isabelle Bichindaritz 19
Relationship between WSDL, UDDI, and SOAP
9/5/2012
![Page 20: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/20.jpg)
ISC329 Isabelle Bichindaritz 20
Web Services and Service-Oriented Architectures
• Service-Oriented Architectures (SOA)– Architecture for building applications that
implement business processes as sets of services
– Published at a granularity relevant to the service consumer
– Loosely coupled and autonomous services– Web services designed for SOA different from
other Web services9/5/2012
![Page 21: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/21.jpg)
ISC329 Isabelle Bichindaritz 21
Traditional vs. SOA Architecture
9/5/2012
![Page 22: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/22.jpg)
ISC329 Isabelle Bichindaritz 22
Distributed DBMSs
• Distributed database– Logically interrelated collection of shared data
physically distributed over a computer network
• Distributed DBMS– Software system that permits the management
of the distributed database – Makes the distribution transparent to users
9/5/2012
![Page 23: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/23.jpg)
ISC329 Isabelle Bichindaritz 23
Distributed DBMSs• Characteristics of DDBMS
– Collection of logically related shared data– Data split into fragments– Fragments may be replicated– Fragments/replicas are allocated to sites– Sites are linked by a communications network– Data at each site is controlled by DBMS– DMBS handles local apps autonomously– Each DBMS in one or more global app
9/5/2012
![Page 24: 9/5/2012ISC329 Isabelle Bichindaritz1 Web Database Environment](https://reader035.vdocuments.us/reader035/viewer/2022070409/56649e7a5503460f94b7ad35/html5/thumbnails/24.jpg)
ISC329 Isabelle Bichindaritz 24
Distributed DBMSs
• Distributed processing– Centralized database that can be accessed over
a computer network
• System consists of data that is physically distributed across a number of sites in the network
9/5/2012