SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Oracle 11g Database Architectures

damon avatar
damon
24 diapositives · 511 Views · Jul 12, 2014

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

#oracle 11g database architectures #oracle 11g database architectures ppt #powerpoint #presentation
Oracle 11g Database Architectures - slide 1
01 / 24Oracle 11g Database Architectures
1 / 17

Télécharger la présentation

Oracle 11g Database Architectures
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  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?