Monday, December 26, 2016

Oracle

Oracle:

It is an RDBMS from oracle corporation.
Any RDBMS is used to store and process Business Data.

Database Concept:

------------------------------
1. Data : Collection of Information of one entity is known an Data
ex: any one employee data, any one product data etc

2. Database: collection of Information of all objects with in the business, technically a database is a software to automate business activities.

3. DBMS(database management system): a database, which is providing management system services like:
A. Entity new data or inserting new data.
B. Updating data
C. Deleting unwanted data
D. Authentication or authenticating user
E. Providing security

4. RDBMS(relational database management System): It is a collection of inter-related data of all inter related objects within the business.
Note:
A. generally data is generated from each business object & business transaction.
B. as a database developer, we need to develop database application program(Stored procedures, functions, packages & triggers). each database application program is responsible for at least one business activity.

No comments:

Post a Comment