Category
page 1Data modeling
table
arrangement of data in rows and columns
building information modeling
approaches to design, construction and management of built assets
database normalisation
reduction of data redundancy
data model
an abstract model that organizes elements of data and standardizes how they relate to one another and to real world entities.
visualization
set of techniques for creating images, diagrams, or animations to communicate a message
primary key
set of attributes (columns) that uniquely specify a tuple (row) in a relation
foreign key
field or collection of fields in one table that uniquely identifies a row of another table or the same table
database table
set of data elements arranged in rows and columns as part of a database
data modeling
(in software engineering) process of creating a data model for an information system by applying certain formal techniques
Codd's 12 rules
Relational database design
database schema
visual representation of database system relationships
row
single, implicitly structured data item in a table in a relational database; every row in a table has the same structure (set of columns)
data manipulation language
family of syntax elements used for selecting, inserting, deleting and updating data in a database
field
part of a database record
Peter Chen
American computer scientist
data dictionary
set of metadata that contains definitions and representations of data elements
star schema
data warehousing schema
candidate key
set of columns in a relational database
column
sequence of values of a particular type, one value for each row in a database table
functional dependency
in relational database theory, a constraint between two sets of attributes in a relation from a database
data control language
syntax used to control access to data stored in a database
IDEF
thumb|320px|IDEF methods: part of the systems engineer's toolbox
materialized view
database object that contains the results of a query
domain model
conceptual model of the domain in software engineering that incorporates both behaviour and data
unique key
minimal superkey in relational database management systems
information model
representation of concepts and the relationships, constraints, rules, and operations to specify data semantics for a chosen domain of discourse
Meta-Object Facility
Object Management Group standard for model-driven engineering
conceptual schema
high-level description of a business's informational needs
attribute–value pair
data representation method in computing systems

data redundancy
presence of data additional to the actual data that may permit correction of errors in stored or transmitted data
superkey
In the relational data model, a superkey is any set of attributes that uniquely identifies each tuple of a relation. Because superkey values are unique, tuples with the same superkey value must also have the same non-key attribute values. That is, non-key attributes are functionally dependent on the superkey.
surrogate key
unique identifier for either an entity in the modeled world or an object in the database
object–role modeling
programming technique
XML database
data persistence software system that allows data to be specified, and sometimes stored, in XML format
many-to-many
relationship between entities
multivalued dependency
in database theory, a full constraint between two sets of attributes in a relation; requires that certain tuples be present in a relation, in contrast to functional dependency
semi-structured data
form of structured data
natural key
type of unique key in a database formed of attributes that exist and are used in the external world outside the database
IDEF1X
thumb|320px|Example of an IDEF1X diagram.
Armstrong's axioms
set of axioms used to infer all the functional dependencies on a relational database
data domain
values that a data element may contain
Bernhard Thalheim
German computer scientist
Core Data
persistence framework provided by Apple in the macOS and iOS operating systems
entity integrity
when each row in a table has a primary key that is unique and not null, so that each row represents a single instance of the modelled entity
slowly changing dimension
data dimension which contains relatively static data which can change slowly, but unpredictably, rather than according to a regular schedule
single source of truth
information systems good practice for data normalization using one source for a particular data element
wide and narrow data
two different methods for presenting tabular data
one-to-many
type of cardinality that refers to the relationship between two entity types A and B in which an element of A may be linked to many elements of B, but a member of B is linked to only one element of A; the opposite of many-to-one
one-to-one
relationship between two sets of entities
logical data model
representation of an organization's data, organized in terms of entities and relationships
dimensional modeling
set of techniques and concepts used in data warehouse design
event tree analysis
logical modeling technique
business rule management system
business rule management system used by operational systems within an organization or enterprise
cardinality
numerical relationship among rows in different tables
COBie
Construction Operations Building Information Exchange (COBie) is a United States-originated specification relating to managed asset information including space and equipment. It is closely associated with building information modeling (BIM) approaches to design, construction, and management of built assets.
EXPRESS
standard data modeling language for product data
transaction control language
programming language
lossless decomposition
decomposition of a database relation such that a natural join of the resulting relations yields back the original relation
Multilateral Interoperability Programme
NATO-centred military coordination organzation
Current Research Information System