Relational database management system in the context of "SQL"

Play Trivia Questions online!

or

Skip to study material about Relational database management system in the context of "SQL"




⭐ Core Definition: Relational database management system

A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970.

A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured format using rows and columns.

↓ Menu

👉 Relational database management system in the context of SQL

Structured Query Language (SQL) (pronounced /ˌɛsˌkjuˈɛl/ S-Q-L; or alternatively as /ˈskwəl/ "sequel") is a domain-specific language used to manage data, especially in a relational database management system (RDBMS). It is particularly useful in handling structured data, i.e., data incorporating relations among entities and variables.

Introduced in the 1970s, SQL offered two main advantages over older read–write APIs such as ISAM or VSAM. Firstly, it introduced the concept of accessing many records with one single command. Secondly, it eliminates the need to specify how to reach a record, i.e., with or without an index.

↓ Explore More Topics
In this Dossier

Relational database management system in the context of Australian Plant Census

The Australian Plant Census (APC) provides an online interface to currently accepted, published, scientific names of the vascular flora of Australia, as one of the output interfaces of the national government Integrated Biodiversity Information System (IBIS – an Oracle Co. relational database management system). The Australian National Herbarium, Australian National Botanic Gardens, Australian Biological Resources Study and the Council of Heads of Australasian Herbaria coordinate the system.

The Australian Plant Census interface provides the currently accepted scientific names, their synonyms, illegitimate, misapplied and excluded names, as well as state distribution data. Each item of output hyperlinks to other online interfaces of the information system, including the Australian Plant Name Index (APNI) and the Australian Plant Image Index (APII). The outputs of the Australian Plant Census interface provide information on all native and naturalised vascular plant taxa of Australia, including its offshore islands, but excludes taxa only known in Australia from their cultivation and not (yet) naturalised.

↑ Return to Menu