Lecture on Relational Database System Programming www assignmentpoint

Lecture on Relational Database System Programming www. assignmentpoint. com

Relational Database System Programming Required Books: 1) SQL, PL/SQL The programming language of ORACLE 2 nd Edition -Ivan Bayross 2) Commercial Application Development Using Oracle Developer 2000 Forms -Ivan Bayross www. assignmentpoint. com

What is database? To be able to successfully design and maintain database we have to do the following 1) Identify which part of the world’s data is of interest to us. 2) Identify what specific objects in that part of the world’s data are of interest to us. 3) Identify a relationship between the objects. Software houses took up the challenge of designing a system that would help users in managing dada in a database. These systems were called Database Management Systems (DBMS) Some of the DBMS developed by software house were Oracle, Ingress, Sybase, etc. Let us www. assignmentpoint. com look at Oracle as a database management System (DBMS)

Introduction to Oracle and Its Tools The Oracle product is Primarily divided into The Oracle Server takes care of the following: • Oracle server tools • Updating the database. • Oracle Client tools • Retrieving information from the database. The Oracle server is a program installed on the server’s hard disk drive. This • Accepting query language statements. program must be loaded in RAM so that it can process user requests. This Oracle Server product is either called Oracle workgroup Server Or • Enforcing security specifications. • Enforcing data integrity specifications. • Enforcing transaction consistency. • Managing data sharing. Oracle Enterprise server • Optimizing queries. • Managing system catalogs. www. assignmentpoint. com

Who is the Oracle DBA? What about Server manager Tool ? What about Security manager Tool ? Oracle Client Tools: Once the Oracle Engine is loaded into a server’s memory, users would have to log into the engine to get work done. Oracle Corporation has several client-based tools that facilitate this. Oracle Client side tools, that come bundled in a tool kit called Developer 2000, comprises of: a) Oracle SQL*Plus b) Oracle forms Designer c) Oracle Reports Designer d) Oracle Graphics. www. assignmentpoint. com

Before installing the Oracle server Software , an Operating system needs to be installed on the server Computer. Commonly used operating systems are: • Novel Netware • Unix • Windows NT • Windows XP Before installing Oracle Client tools , an appropriate operating system like Windows-95 or Windows NT Workstation needs to be installed on the client computer Why we like to use Oracle for develop a application program? SEQURITY www. assignmentpoint. com

CLIENT SQL*Plus Client’s HDD Oracle Client Tools, Win 95/win NT (workstation) Operating System SQL*NET Client SERVER Oracle Engine SQL*NET Server’s HDD Client O/S Server O/S www. assignmentpoint. com Oracle Engine Tools Users Database on Multi user O/S