Database Glossary - E
Database Terms Like Entity, Export, and Expression
Find out more about database and data terminology in our extensive database glossary. Looking to learn more about data structure, how to use a database and what all those complicated terms mean? We have a big glossary containing several hundred of the most used database terms and expressions. Demystify the world of database design and developmentEntity
A real-world object, observation, transaction, or person about which data are to be stored in a database.
Entity Integrity
A property of a table that is entirely consistent with the real world object data that
it represents.
See also: Entity.
Entity, Major
Database table(s). Each major entity has a set of associated attributes, which translate into the columns of the table.
Export
An operation that takes data from a database or table and creates an export file,
containing only data, in a simply structured and easily read form that can be
imported by other applications into their native data file format.
See also: Import.
Expression
An SQL statement that returns a value.
Extraction
The process of selecting data from one environment and transporting it to another
environment.
See also: Data Transformation.