際際滷

際際滷Share a Scribd company logo

Oracle assignment help

N
Need Assignment Help

This document provides an overview of Oracle database architecture. It defines Oracle as a relational database management system (RDBMS) and discusses its history. It also defines important Oracle terms like schema objects, transactions, and key types. Additionally, it describes the two common database architectures: client/server and multitier. Client/server divides the database into a front-end client and back-end server, while multitier uses multiple application servers between clients and database servers. The document advocates for the advantages of the multitier architecture.

1 of 14
Download to read offline
ORACLE ASSIGNMENT HELP By NEED ASSIGNMENT HELP
TABLE OF CONTENTS 1. WHAT IS ORACLE ? 2. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE 3. OVERVIEW OF ARCHITECTURE 4. CLIENT/SERVER ARCHITECTURE 5. WHAT IS MULTITIER ARCHITECTURE ? 6. ADVANTAGES OF MULTITIER ARCHITECTURE 7. CONTACT US 8. THANK YOU
Oracle Database is a relational database management system (RDBMS). Oracle is defined as the collection of data as a single unit. It is the most and widely used database management system. WHAT IS ORACLE ?
1. Oracle was developed in 1977 by Lawrence Ellison with other developers. 2. Data can be directly accessed by the users through SQL queries (structured query language). WHAT IS ORACLE?
1. RELATIONAL DATABASE 足 RELATIONAL DATABASE IS A COLLECTION OF DATA ITEMS THAT ARE ORGANISED IN THE FORM OF TABLES. 2. SCHEMA OBJECTS 足 SCHEMA IS A COLLECTION OF LOGICAL STRUCTURES OF DATA OR SCHEMA OBJECTS AND HAS THE SAME NAME AS THE USER NAME. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
3. TRANSACTION MANAGEMENT 足 TRANSACTION MANAGEMENT BEGINS WITH THE FIRST EXECUTABLE SQL STATEMENT TO GENERATE CALLS INCLUDING DDL AND DML STATEMENTS 4. PRIMARY KEY 足 PRIMARY KEY IS A KEY WHICH UNIQUELY IDENTIFIES ALL TABLE RECORDS. PRIMARY KEY ALWAYS HAS A UNIQUE VALUE FOR EACH ROW IN A TABLE. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
5. COMPOSITE KEY 足 WHEN A PRIMARY KEY CONSIST OF MULTIPLE FIELDS (MORE THAN ONE FIELD), IT IS CALLED AS A COMPOSITE KEY. 6. FOREIGN KEY 足 A FOREIGN KEY IN ONE TABLE IS A KEY FROM ANOTHER TABLE AND TARGETS A PRIMARY KEY. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
The two common ways to architect a database are: 1. Client/server Architecture 2. Multitier Architecture OVERVIEW OF ARCHITECTURE
CLIENT/SERVER ARCHITECTURE I N C L I E N T / S E R V E R A R C H I T E C T U R E , T H E D A T A B A S E S Y S T E M I S D I V I D E D I N T O T W O P A R T S : F R O N T - E N D O R C L I E N T B A C K - E N D O R S E R V E R
WHAT IS A CLIENT? CLIENT IS A DATABASE APPLICATION THAT INITIATES A REQUEST FOR AN OPERATION ON THE DATABASE SERVER. IT REQUESTS THE DATA MANAGED BY THE SERVER.
WHAT IS SERVER? SERVER RUNS THE SOFTWARE AND RECEIVES THE SQL AND PL/SQL STATEMENTS THAT ARISE FROM CLIENT APPLICATIONS.
WHAT IS MULTITIER ARCHITECTURE? A MULTITIER ARCHITECTURE HAS A CLIENT TO START AN OPERATION. HERE, MULTIPLE APPLICATION SERVER PERFORM PARTS OF AN OPERATION. IT IS AN INTERFACE BETWEEN CLIENTS AND MULTIPLE DATABASE SERVER.
ADVANTAGES OF MULTITIER ARCHITECTURE I T V A L I D A T E S T H E C R E D E N T I A L S O F A C L I E N T , S U C H A S W E B B R O W S E R . C O N N E C T T O A N O R A C L E D A T A B A S E S E R V E R . I T P E R F O R M S T H E R E Q U E S T E D O P E R A T I O N S .
THANK YOU FOR MORE INFORMATION ON ORACLE ASSIGNMENT, CLICK http://www.needassignmenthelp.com/oracle-assignment

More Related Content

Oracle assignment help

  • 1. ORACLE ASSIGNMENT HELP By NEED ASSIGNMENT HELP
  • 2. TABLE OF CONTENTS 1. WHAT IS ORACLE ? 2. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE 3. OVERVIEW OF ARCHITECTURE 4. CLIENT/SERVER ARCHITECTURE 5. WHAT IS MULTITIER ARCHITECTURE ? 6. ADVANTAGES OF MULTITIER ARCHITECTURE 7. CONTACT US 8. THANK YOU
  • 3. Oracle Database is a relational database management system (RDBMS). Oracle is defined as the collection of data as a single unit. It is the most and widely used database management system. WHAT IS ORACLE ?
  • 4. 1. Oracle was developed in 1977 by Lawrence Ellison with other developers. 2. Data can be directly accessed by the users through SQL queries (structured query language). WHAT IS ORACLE?
  • 5. 1. RELATIONAL DATABASE 足 RELATIONAL DATABASE IS A COLLECTION OF DATA ITEMS THAT ARE ORGANISED IN THE FORM OF TABLES. 2. SCHEMA OBJECTS 足 SCHEMA IS A COLLECTION OF LOGICAL STRUCTURES OF DATA OR SCHEMA OBJECTS AND HAS THE SAME NAME AS THE USER NAME. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
  • 6. 3. TRANSACTION MANAGEMENT 足 TRANSACTION MANAGEMENT BEGINS WITH THE FIRST EXECUTABLE SQL STATEMENT TO GENERATE CALLS INCLUDING DDL AND DML STATEMENTS 4. PRIMARY KEY 足 PRIMARY KEY IS A KEY WHICH UNIQUELY IDENTIFIES ALL TABLE RECORDS. PRIMARY KEY ALWAYS HAS A UNIQUE VALUE FOR EACH ROW IN A TABLE. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
  • 7. 5. COMPOSITE KEY 足 WHEN A PRIMARY KEY CONSIST OF MULTIPLE FIELDS (MORE THAN ONE FIELD), IT IS CALLED AS A COMPOSITE KEY. 6. FOREIGN KEY 足 A FOREIGN KEY IN ONE TABLE IS A KEY FROM ANOTHER TABLE AND TARGETS A PRIMARY KEY. SOME IMPORTANT TERMS RELATED TO ORACLE DATABASE
  • 8. The two common ways to architect a database are: 1. Client/server Architecture 2. Multitier Architecture OVERVIEW OF ARCHITECTURE
  • 9. CLIENT/SERVER ARCHITECTURE I N C L I E N T / S E R V E R A R C H I T E C T U R E , T H E D A T A B A S E S Y S T E M I S D I V I D E D I N T O T W O P A R T S : F R O N T - E N D O R C L I E N T B A C K - E N D O R S E R V E R
  • 10. WHAT IS A CLIENT? CLIENT IS A DATABASE APPLICATION THAT INITIATES A REQUEST FOR AN OPERATION ON THE DATABASE SERVER. IT REQUESTS THE DATA MANAGED BY THE SERVER.
  • 11. WHAT IS SERVER? SERVER RUNS THE SOFTWARE AND RECEIVES THE SQL AND PL/SQL STATEMENTS THAT ARISE FROM CLIENT APPLICATIONS.
  • 12. WHAT IS MULTITIER ARCHITECTURE? A MULTITIER ARCHITECTURE HAS A CLIENT TO START AN OPERATION. HERE, MULTIPLE APPLICATION SERVER PERFORM PARTS OF AN OPERATION. IT IS AN INTERFACE BETWEEN CLIENTS AND MULTIPLE DATABASE SERVER.
  • 13. ADVANTAGES OF MULTITIER ARCHITECTURE I T V A L I D A T E S T H E C R E D E N T I A L S O F A C L I E N T , S U C H A S W E B B R O W S E R . C O N N E C T T O A N O R A C L E D A T A B A S E S E R V E R . I T P E R F O R M S T H E R E Q U E S T E D O P E R A T I O N S .
  • 14. THANK YOU FOR MORE INFORMATION ON ORACLE ASSIGNMENT, CLICK http://www.needassignmenthelp.com/oracle-assignment