DBMS Database
(Redirected from DBMS database instance)
Jump to navigation
Jump to search
A DBMS Database is a set of database objects managed as an entity by a DBMS.
- Context:
- It can range from being a Relational DBMS Database to being a non-relational DBMS Database, depending on whether it is associated with Foreign Key Relationships.
- It can have one or more DBMS Table.
- It can be backed up.
- It can have security settings.
- Example(s):
- a Hive Database, such as
X. - a MySQL Database, such as
X. - a PostgreSQL Database, such as
X. - a Cassandra Database.
- …
- a Hive Database, such as
- Counter-Example(s):
- See: noSQL Database.
References
2012
- http://www.okstate.edu/sas/v8/sashtml/accdb/z0460382.htm
- A database is a collection of objects that includes tables, views, stored procedures, triggers, and indexes. Each database contains several database system files and data files. Databases are usually created by a database administrator with the SQL command CREATE DATABASE. In most databases, you use the GRANT statement to give users privileges on database objects to users. You can create SAS/ACCESS descriptor files to access the data in the objects, or access the objects directly by using the SAS/ACCESS LIBNAME statement.