1 / 6

CSE-417: Relational Database System Programming

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?

capricorn-rosas
Download Presentation

CSE-417: Relational Database System Programming

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

  2. 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)

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

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

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

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

More Related