1 / 24

Oracle 11g Database Architectures

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

damon
Download Presentation

Oracle 11g Database Architectures

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle 11gDatabase Architectures

  2. Learning Objectives Understand the client / server system. Understand the DBMS role in that system. Explain the architecture of the modern DBMS.

  3. A Simple Client / Server System Components • Client • Server • Network • LAN • WAN • Internet • Way more clients than servers.

  4. Example of C/S Architecture Server w/ Web Server Client w/ Web Browser • Typing http://www.syr.edu in client web browser sends GET request to web server • Web server processes GET request by finding file on server and sending it back to 128.230.11.84 as a stream of HTML • Client parses the HTML and draws the web page in the browser window. TCP/IP Network GET /index.html Data Stream: <html><head>…. HTTP protocol implementedby both browser and web server www.syr.edu 128.230.11.84

  5. Client/Server Architectures The application consists of: • 2 Tier – client and server • 3-Tier – client, application, database • N-Tier – client, application(s), database(s)

  6. Two-Tier Client/Server Client talks directly to server Eg’s: SQL Management Studio in IST359

  7. Middleware The application layer protocol and its implementation which facilities communication among client and server. Web HTTP / SOAP / REST Database ODBC / JDBC

  8. Three-Tier Client/Server Middleware exists between each tier. More Complex than Two-tier More Scalable than Two-tier

  9. Three-Tier Web • Middleware: • Client – Web Server  HTTP • Web Server – Database Server  ODBC / Pipes / JDBC • Web / Db Servers in data center on same network.

  10. N-Tier 3 Tier plus • Caching Frameworks • Load Balancers • Multiple Application Tiers • Cryptographic Accelerators • Heterogeneous DBMS’s • Web Scale: • Varnish, Memcached, Ngnix, Tomcat, AppFabric

  11. Sample N-Tier Setup Web Server 1 Reverse Proxy +Cache +Load Balancer Web Server 2 Internet Web Server 3 DBMS 2 DBMS 1 Replication Clients

  12. 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

  13. DBMS Architecture

  14. 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.

  15. General Architecture of the Modern DBMS Server Instance Catalog (db) Catalog (db) Schema Schema Objects Instance Catalog (db) Catalog (db) Schema Schema Objects

  16. An Oracle Instance And Database

  17. Oracle vs. SQL Server – Architecture Comparison Oracle 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. • 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.

  18. Oracle vs. SQL Server – Cheat Sheet

  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

  20. OEM Architecture

  21. OEM Screenshot

  22. Walk-Through 1/2 • Connect to ITELL via vSphere Client • Logon to Virtual Machine • Administrator / SU2orange • Takes a while for Oracle to load (Taskmgr) • Oracle Enterprise Manager • SYS / SU2orange (as SYSDBA)

  23. Walk-Through 2/2 Database Login Listener • SQL Plus – Command line utility • Two ways to log in: • Logon, connect to a database • SYS@localhost.orcl as SYSDBA • Logon, do not connect to a database • SYS as SYSDBA

  24. Database Architectures Questions? Comments?

More Related