Thursday, June 20, 2024

We customize ‘IT’ for you

You are here: Terminology

Terminology
 
Business Development
Business development includes a number of techniques designed to grow an economic enterprise.

Business Intelligence
Business intelligence (BI) is a business management term, which refers to applications and technologies that are used to gather, provide access to, and analyze data and information about company operations.

Cloud Computing
Cloud computing is Internet-based computing, whereby shared servers provide resources, software, and data to computers and other devices on demand, as with the electricity grid.

Data Mart
A data mart (DM) is a specialized version of a data warehouse (DW).

Data Modeling
In computer science, data modeling is the process of creating a data model by applying a data model theory to create a data model instance.

Data Warehouse
A data warehouse is the main repository of an organization's historical data, its corporate memory.

Data Warehouse Appliance
A data warehouse (DW) appliance is an integrated set of servers, storage, OS, DBMS and software specifically pre-installed and pre-optimized for data warehousing.

Database Administrator
A database administrator (DBA) is a person responsible for the design, implementation, maintenance and repair of an organization's database. They are also known by the titles Database Coordinator or Database Programmer, and is closely related to the Database Analyst, Database Modeler, Programmer Analyst, and Systems Manager.

Database Management System
A database management system (DBMS) is computer software designed for the purpose of managing databases.

Database Normalization
In the field of relational database design, normalization is a systematic way of ensuring that a database structure is suitable for general-purpose querying and free of certain undesirable characteristics—insertion, update, and deletion anomalies—that could lead to a loss of data integrity.

Decision Support System
Decision support systems (DSS) are a class of computer-based information systems including knowledge based systems that support decision making activities.

Dimensional Modeling
Dimensional modeling (DM) is the name of a logical design technique often used for data warehouses.

Entity-Relationship Model
Databases are used to store structured data. The structure of this data, together with other constraints, can be designed using a variety of techniques, one of which is called entity-relationship modeling or ERM.

Extract-Transform-Load
Extract, Transform, and Load (ETL) is a process in data warehousing that involves: extracting data from outside sources, transforming it to fit business needs, and ultimately loading it into the data warehouse.

Online Analytical Processing
Online Analytical Processing, or OLAP, is an approach to quickly providing answers to analytical queries that are multidimensional in nature.

Online Transaction Processing
Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.

Open Source
Open source is a development methodology, which offers practical accessibility to a product's source (goods and knowledge).

Relational Database Management System
A short definition of an RDBMS may be a DBMS in which data is stored in the form of tables and the relationship among the data is also stored in the form of tables.

Snowflake Schema
The snowflake schema is a variation of the star schema used in a data warehouse.

Star Schema
The star schema (sometimes referenced as star join schema) is the simplest data warehouse schema, consisting of a single "fact table" with a compound primary key, with one segment for each "dimension" and with additional columns of additive, numeric facts.

Structured Query Language
SQL is a database computer language designed for managing data in relational database management systems (RDBMS), and originally based upon Relational Algebra.

Web 2.0
Web 2.0 refers to a perceived second generation of web-based communities and hosted services — such as social-networking sites, wikis and folksonomies — which aim to facilitate collaboration and sharing between users.

Wiki
A wiki is a collection of web pages designed to enable anyone who accesses it to contribute or modify content, using a simplified markup language.