oracle 11g database architectures
DESCRIPTION
Oracle 11g Database Architectures. Learning Objectives. Understand the client / server system. Understand the DBMS role in that system. Explain the architecture of the modern DBMS. A Simple Client / Server System. Components Client Server Network LAN WAN Internet - PowerPoint PPT PresentationTRANSCRIPT
Advanced Databases
Oracle 11gDatabase Architectures
Advanced Databases
Learning Objectives• Understand the client / server
system.• Understand the DBMS role in that
system.• Explain the architecture of the
modern DBMS.
Advanced Databases
A Simple Client / Server System
Client
Databaseserver
Network
Client
Client
Components• Client• Server• Network
– LAN– WAN– Internet
• Way more clients than servers.
Advanced Databases
Example of C/S Architecture
1. Typing http://www.syr.edu in client web browser sends GET request to web server
2. Web server processes GET request by finding file on server and sending it back to 128.230.11.84 as a stream of HTML
3. Client parses the HTML and draws the web page in the browser window.
Client w/ Web Browser
Server w/ Web Server
TCP/IP Network
GET /index.html
Data Stream: <html><head>….
HTTP protocol implementedby both browser and web server
128.230.11.84 www.syr.edu
Advanced Databases
Client/Server ArchitecturesThe application consists of:2 Tier – client and server3-Tier – client, application, database
N-Tier – client, application(s), database(s)
Advanced Databases
Two-Tier Client/Server
• Client talks directly to server• Eg’s: SQL Management Studio in
IST359
SQL queries
Results
Client Database serverApplication softwareData access API
Database management systemDatabase
Advanced Databases
Middleware• The application layer protocol and its
implementation which facilities communication among client and server.
• Web HTTP / SOAP / REST• Database ODBC / JDBC
Advanced Databases
Three-Tier Client/Server
• Middleware exists between each tier.• More Complex than Two-tier• More Scalable than Two-tier
ClientUser interface
Application serverBusiness components
SQL queries
Response Results
Database serverDBMS
Database
User request
Advanced Databases
Three-Tier Web
• Middleware: – Client – Web Server HTTP– Web Server – Database Server ODBC / Pipes /
JDBC• Web / Db Servers in data center on same
network.
ClientWeb browser
Database serverDBMS
Database
Web serverWeb applications
Web services
User request
Response
SQL queries
Results
Internet
User request
Response
Advanced Databases
N-Tier3 Tier plus• Caching Frameworks• Load Balancers• Multiple Application Tiers• Cryptographic Accelerators• Heterogeneous DBMS’s• Web Scale:
– Varnish, Memcached, Ngnix, Tomcat, AppFabric
Advanced Databases
Sample N-Tier Setup
DBMS 1
DBMS 2
Replication
Web Server 2
Web Server 1
Web Server 3
Reverse Proxy +Cache +
Load Balancer
Internet
Clients
Advanced Databases
Service-Oriented Architecture
• You can do business with a company:– Via their user interface.– Programmatically using their API’s
• Think Twitter, Foursquare, Amazon, Netflix, Google Maps, Twilio, etc…
• Customers and business partners can build applications using the company’s APIs as a “service”
• Allows for a greater level of integration than is otherwise possible
Advanced Databases
DBMS Architecture
Advanced Databases
General Architecture of the Modern DBMS
• SERVER- computer hosting the database service.• INSTANCE – Install of the product. Most products
can install multiple instances.• LISTENER – Background process that manages the
listener.• CATALOG – Unique named set of schemas. This is a
database at the MySQL, SQL Server and Oracle products.
• SCHEMA – Logical Grouping of objects within the CATALOG
• OBJECTS – Tables, Keys, Constraints, Views, Procedures.
Advanced Databases
General Architecture of the Modern DBMS
Server
Instance
Instance
Catalog (db) Catalog (db)
Schema Schema
Objects
Catalog (db) Catalog (db)
Schema Schema
Objects
Advanced Databases
An Oracle Instance
And Database
Advanced Databases
Oracle vs. SQL Server – Architecture Comparison
Oracle• Instances can use
separate listeners.• Oracle designed to work
independently from the OS.
• Oracle uses Tablespaces (storage independent of database)
• Users given access to Tablespace.
SQL Server• All instances use same
listener.• SQL Server designed
to only work on Windows.
• SQL Server does not have tablespaces.
• Users given access to Database to achieve same result.
Advanced Databases
Oracle vs. SQL Server – Cheat SheetSQL Server Concept Oracle Equivalent
ConceptConnect to server Connect to databaseYour database Your SchemaIP / Port for connection ListenerDatabase login Schema loginYou were not the DBA You are the DBAYou had access to ONE database on the SQL server and used ONE login
You have access all the schemas on the database and will use multiple logins.
Advanced Databases 19
Oracle Enterprise Manager
• User account must have DBA role• Oracle Enterprise Manager (OEM)
– Three-tier architecture– Console
• Oracle Management Server (OMS)– Interacts with repository– Makes it easier for DBAs to administer
multiple databases in organization’s network
Advanced Databases 20
OEM Architecture
Advanced Databases
OEM Screenshot
Advanced Databases
Walk-Through 1/21. Connect to ITELL via vSphere Client2. Logon to Virtual Machine
– Administrator / SU2orange3. Takes a while for Oracle to load
(Taskmgr)4. Oracle Enterprise Manager
– SYS / SU2orange (as SYSDBA)
Advanced Databases
Walk-Through 2/2• SQL Plus – Command line utility• Two ways to log in:1. Logon, connect to a database
– [email protected] as SYSDBA
2. Logon, do not connect to a database– SYS as SYSDBA
Logi
n
List
ener
Data
base
Advanced Databases
Database Architectures
Questions? Comments?