CSE-417: 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. What is database?
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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
CSE-417: Relational Database System Programming Required Books: 1) SQL,PL/SQL The programming language of ORACLE 2nd Edition -Ivan Bayross 2) Commercial Application Development Using Oracle Developer 2000 Forms -Ivan Bayross
What is database? • To be able to successfully design and maintain database we have to do the following • Identify which part of the world’s data is of interest to us . • Identify what specific objects in that part of the world’s data are of interest to us . • 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 look at Oracle as a database management System (DBMS)
Introduction to Oracle and Its Tools • The Oracle product is Primarily divided into • Oracle server tools • Oracle Client tools • The Oracle server is a program installed on the server’s hard disk drive. This program must be loaded in RAM so that it can process user requests. • This Oracle Server product is either called • Oracle workgroup Server • Or • Oracle Enterprise server • The Oracle Server takes care of the following: • Updating the database. • Retrieving information from the database. • Accepting query language statements. • Enforcing security specifications. • Enforcing data integrity specifications. • Enforcing transaction consistency. • Managing data sharing. • Optimizing queries. • Managing system catalogs.
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: • Oracle SQL*Plus • Oracle forms Designer • Oracle Reports Designer • Oracle Graphics.
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
CLIENT SERVER Oracle Engine SQL*Plus SQL*NET Client SQL*NET Server Client’s HDD Oracle Client Tools, Win 95/win NT (workstation) Operating System Server’s HDD Oracle Engine Tools Users Database on Multi user O/S Server O/S Client O/S