Data Technologies Definitions

Search Definitions
  • O

    organization resilience

    Organizational resilience is an organization's ability to anticipate issues ahead of time and develop a plan for handling identified problems.

  • What is off-site backup?

    Off-site backup is a method of backing up data to a remote server or to media that's transported to another physical location.

  • What is Oracle?

    Oracle is one of the largest vendors in the enterprise IT market and the shorthand name of its flagship product, a relational database management system (RDBMS) that's formally called Oracle Database.

  • P

    primary key (primary keyword)

    A primary key, also called a primary keyword, is a column in a relational database table that's distinctive for each record.

  • process intelligence (business process intelligence)

    Process intelligence is data that has been systematically collected to analyze the individual steps within a business process or operational workflow.

  • processing in memory (PIM)

    Processing in memory, or PIM (sometimes called processor in memory), refers to the integration of a processor with Random Access Memory (RAM) on a single chip.

  • What is a pandemic plan?

    A pandemic plan is a documented strategy for how an organization plans to provide essential services when there is a widespread outbreak of an infectious disease.

  • What is a pivot table? How to use in Excel and Sheets

    A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report.

  • What is PeopleSoft?

    PeopleSoft is an enterprise resource planning (ERP) software suite owned by Oracle Corporation.

  • What is PL/SQL (Procedural Language/Structured Query Language)?

    In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL).

  • What is predictive analytics? An enterprise guide

    Predictive analytics is a form of advanced analytics that uses current and historical data to forecast activity, behavior and trends.

  • Q

    query

    A query is a question or a request for information expressed in a formal manner.

  • What is Qlik?

    Qlik is a software vendor specializing in data visualization, executive dashboards and self-service business intelligence products.

  • R

    R programming language

    The R programming language is an open source scripting language for predictive analytics and data visualization.

  • raw data (source data or atomic data)

    Raw data is the data originally generated by a system, device or operation, and has not been processed or changed in any way.

  • RDBMS (relational database management system)

    A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database.

  • record

    In computer data processing, a record is a collection of data items arranged for processing by a program.

  • relational database

    A relational database is a type of database that organizes data points with defined relationships for easy access.

  • RFM analysis (recency, frequency, monetary)

    RFM analysis is a marketing technique used to quantitatively rank and group customers based on the recency, frequency and monetary total of their recent transactions to identify the best customers and perform targeted marketing campaigns.

  • What is real-time business intelligence (RTBI)?

    Real-time business intelligence (RTBI) combines data analytics and various data processing tools to enable access to the most relevant, up-to-the-minute data and visualizations.

  • What is risk mitigation?

    Risk mitigation is a strategy that helps businesses prepare for disasters and other issues and decrease the effects of threats they face.

  • S

    schema

    In computer programming, a schema (pronounced SKEE-mah) is the organization or structure for a database, while in artificial intelligence (AI), a schema is a formal expression of an inference rule.

  • self-service analytics

    Self-service analytics is a type of business intelligence (BI) that enables business users to access, manipulate, analyze and visualize data, as well as generate reports based on their discoveries.

  • serverless database

    A serverless database is a type of cloud database that is fully managed for an organization by a cloud service provider and runs on demand as needed to support applications.

  • sharding

    Sharding is a type of database partitioning that separates large databases into smaller, faster, more easily managed parts.

  • snowflaking (snowflake schema)

    In data warehousing, snowflaking is a form of dimensional modeling in which dimensions are stored in multiple related dimension tables.

  • social analysis

    Social analysis is the practice of systematically examining a social problem, issue or trend, often with the aim of prompting changes in the situation being analyzed.

  • spatial data

    Spatial data is any type of data that directly or indirectly references a specific geographical area or location.

  • star schema

    A star schema is a database organizational structure optimized for use in a data warehouse or business intelligence that uses a single large fact table to store transactional or measured data, and one or more smaller dimensional tables that store attributes about the data.

  • synchronous replication

    Synchronous replication is the process of copying data over a network to create multiple current copies of the data.

  • What is a standard operating procedure (SOP)?

    A standard operating procedure is a set of step-by-step instructions for performing a routine activity.

  • What is a stored procedure?

    A stored procedure is a set of Structured Query Language (SQL) statements that multiple programs can reuse and share to perform specific tasks.

  • What is SAS Institute Inc.?

    SAS Institute Inc. is a software vendor that specializes in advanced and predictive analytics software applications, as well as business intelligence and data visualization offerings.

  • What is self-service business intelligence (self-service BI)?

    Self-service business intelligence (BI) is an approach to data analytics that enables nontechnical business users to access and explore data sets.

  • What is sentiment analysis?

    Sentiment analysis, also referred to as 'opinion mining,' is an approach to natural language processing (NLP) that identifies the emotional tone behind a body of text.

  • What is social media analytics?

    Social media analytics is the process of collecting and analyzing audience data shared on social networks to improve an organization's strategic business decisions.

  • What is SQL Server Reporting Services (SSRS)?

    SQL Server Reporting Services (SSRS) is a SQL Server subsystem that enables the creation of graphical, mobile and printed reports using SQL Server and other data sources.

  • What is stream processing? Introduction and overview

    Stream processing is a data management technique that involves ingesting a continuous data stream to quickly analyze, filter, transform or enhance the data in real time.

  • What is Structured Query Language (SQL)?

    Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

  • T

    T-SQL (Transact-SQL)

    T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL), including transaction control, exception and error handling, row processing and declared variables.

  • TensorFlow

    TensorFlow is an open source framework developed by Google researchers to run machine learning, deep learning and other statistical and predictive analytics workloads.

  • text mining (text analytics)

    Text mining is the process of exploring and analyzing large amounts of unstructured text data aided by software that can identify concepts, patterns, topics, keywords and other attributes in the data.

  • transcription error

    A transcription error is a type of data entry error commonly made by human operators or by optical character recognition (OCR) programs.

  • tree structure

    A tree data structure is an algorithm for placing and locating files (called records or keys) in a database.

  • What is a tabletop exercise (TTX)?

    A tabletop exercise (TTX) is a disaster preparedness activity that takes participants through a simulated disaster scenario.

  • U

    What is unstructured data?

    Unstructured data is information, in many different forms, that doesn't follow conventional data models, making it difficult to store and manage in a mainstream relational database.

  • V

    Veritas NetBackup (Symantec NetBackup)

    Veritas NetBackup -- known as Symantec NetBackup from 2005 to 2016 -- is a backup and recovery software suite designed for enterprise users.

  • virtual disaster recovery

    Virtual disaster recovery is a type of DR that typically involves replication and enables a user to fail over to virtualized workloads.

  • What is a vector database?

    A vector database is a type of database technology that's used to store, manage and search vector embeddings, numerical representations of unstructured data that are also referred to simply as vectors.

  • W

    warm site

    A warm site is a type of facility an organization uses to recover its technology infrastructure when its primary data center goes down. A warm site features an equipped data center but no customer data.

  • web analytics

    Web analytics is the process of analyzing the behavior of visitors to a website by tracking, reviewing and reporting the data generated by their use of the site and its components, such as its webpages, images and videos.

  • Windows file share witness (FSW)

    A Windows file share witness is a file share that is available to all nodes in a high-availability cluster.