Discussion in 'Database' started by kasturi, Jan 20, 2011.
what are the database pacakages available now for DBMS & RDBMS ?
A database is a software application that enables the storage of data. Within database architecture there are different theories and implementations for storing the physical data. A relation database management system (RDBMS) is a database that stores data in tables with relationships to other tables. In comparison, a database management system (DBMS) does not require the definition of relationships between tables. Both DBMS and RDBMS are models for storing information in a physical database.
How does that answer the OP question?
DBMS is the collection of the data in main memory then it is called data base management system. then RDBMS is the collection in the table.
A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.
RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.
Although DBMS and RDBMS both are used to store information in physical database but there are some remarkable differences between them. The main differences between DBMS and RDBMS
RDBMS is a program that lets you create, update, and administer a relational database. Dbms and Rdbms both are used to store information in physical database but they have some differences.
Oracle supplies many PL/SQL packages with the Oracle server to extend functionality of the database and also provide PL/SQL access to SQL features. Most Oracle supplied packages are automatically installed when the database is created. Certain packages are not installed automatically. Some of the DBMS packages:
Programs. A package deal is a gaggle of associated methods and features, together with the cursors and variables they use, saved together within the database for endured use as a unit. Much like standalone approaches and features, packaged strategies and capabilities can also be called explicitly by applications or users.
Separate names with a comma.