Photo by Romain Vignes on Unsplash

Glossary of Terms

Definitions for terms, sayings and commands.

A data warehouse is a central repository of integrated data whose content is derived from the various operational databases and is used to store current and historical data in one place. Data in the data warehouse often goes through a cleansing process referred to as ETL or Extract, Transform and Load. The ETL process is ...


A database is a collection of data that is stored permanently and typically has an interface allowing user interaction.


A Git branch is a line of development in the repository. Branches are used to isolate working on different features, versions or environments. The main branch is called the master branch and is where all other branches merge into.


A Git commit is a snapshot of changes on the current working branch. The commit tracks the changes that were staged and has a message that allows the developer to describe the changes made in that particular commit. A branch can contain many commits. Example code:

git commit -m 'Change background to blue'


Git merge combines two branches together. The git merge command is powerful in that it can recognize and mark any conflicts that it finds so they can be corrected manually.


Git pull updates the local branch with updates from its remote counterpart. This command is particularly useful when working with teams as you can update your local code with any changes that have been made/accepted on the remote branch. Example code:

git pull remote branch name local branch name


Git push updates the remote repository with any commits made in the local branch. Example code:

git push 'remote-branch-name' 'local-branch-name'


A Git repository is a collection of data related to a particular project. It is made up of files that are committed to branches and references to those commitments.


Git status shows the status of changes in the current working tree. The status of a file may be untracked, modified, or staged. (Only staged changes will be committed by the git commit command.)


Information Systems are systems designed to support decision making based on historical point-in-time and prediction data for complex queries or data-mining applications.


The normalization of data refers to the process of cleaning up the structure of the data in order to reduce redundancy and dependency of the data.


A group of related projects managed in a coordinated way to obtain benefits and control not available from managing them separately.


A project is a temporary endeavor to create a unique product, service or result. The key word here is "temporary". Once the result enters maintenance mode, it is no longer a project.


A relational database is a database that represents data as a collection of tables in which all data relationships are represented by common values in related tables. Relational databases are tabular (table-like) and inflexible in their design. Each record contains the same exact fields, whether those fields contain data or not.


A user story is an Agile term that describes how the application will work from the user's point of view.