Databases
Databases, or DBs, are collections of information or data organized so that computer applications known as database management systems (DBMS) can quickly and efficiently access specific data from the database. The data in traditional databases are organized by fields, records, and files, with a field representing a single item of information, a record being one complete set of fields and a file serving as an entire collection of records.
From the earliest navigational and relational databases to today's object-oriented and NoSQL databases, our databases dictionary offers a glossary of key terms you need to know.
Sub-Categories
Terms
- ACD
- active archiving
- ADO - ActiveX Data Objects
- aggregate function
- Amazon SimpleDB
- Apache CouchDB
- Apache HBase
- Apache Hive
- Apache Pig
- attribute
- audit trail
- BLOB
- built-in function
- business process
- character treatment
- Codd's Rules
- comma-delimited
- connection pool
- CRUD
- DAM - digital asset management
- DAO
- data cleansing (data scrubbing)
- data dictionary
- data entry
- data independence
- data mart
- data migration
- data mining
- data modeling
- data warehouse
- database
- database engine
- database server
- database shard (sharding)
- database software
- Datalog
- DB2 - Database 2
- DBA dashboard
- dBASE
- DBMS - database management system
- DDL
- dirty data
- distributed database
- DML
- domain
- Domo
- drill down
- drill through
- DSN - Data Source Name
- DTS
- dynamic URL
- dynaset
- EDGAR
- Enterprise JavaBeans
- entity-relationship diagram (model)
- ETL - Extract, Transform, Load
- failover
- field
- File Scripting Object
- Firebird
- fixed length
- flat file
- flat-file database
- fourth-generation language
- Googlewhack
- GUID
- Hekaton
- HRIS
- hybrid database
- HyperCard
- iHTML
- in-memory database
- index
- Informix
- Ingres
- ISAM
- J2EE - Java 2 Platform Enterprise Edition
- JDBC - Java Database Connectivity
- Jet
- join
- key
- keyword
- knowledge base
- linked list
- mail merge
- MAX function
- MaxDB
- merge
- Microsoft Access
- multidimensional DBMS
- MX record
- MySQL
- normalization
- NoSQL Database
- nullable
- ODBC - Open DataBase Connectivity
- ODS - operational data store
- OLAP - Online Analytical Processing
- OLE DB
- Oracle
- ORM
- PL/SQL
- PostgreSQL
- Prolog
- query
- query by example
- query language
- query string
- quiesce
- RAIDb
- raw data
- RDBMS - relational database management system
- record
- referential integrity
- replication
- report
- report writer
- repository
- resource locking
- RPG
- SAP DB
- schema
- SQL - structured query language
- SQL injection
- SQL Server
- stored procedure
- System R
- T-SQL - Transaction-SQL
- table
- TOAD - Tools for Oracle Application Development
- trigger
- two-phase commit
- UDA - Universal Data Access
- VSAM
- WDDX
- Xcerpt
WEBOPEDIA NEWS
Stay up to date on the latest developments in Internet terminology with a free newsletter from Webopedia. Join to subscribe now.