Glossary index

Technology, science and the universe

+57,000terms
19galaxies
2languages
Dailynew terms from the radar
Data and analytics

SQLitePCL

SQLitePCL is a portable class library for SQLite that enables cross-platform database access. This tool stands out for its lightweight and efficient nature, allowing developers to integrate SQLite…

Data and analytics

SQLiteStudio

SQLiteStudio is a free and open-source SQLite database manager with a graphical interface that allows users to interact intuitively with SQLite databases. This tool is particularly valued for its…

Data and analytics

SQL Mode

SQL mode is a configuration that affects the behavior of SQL statements in a database management system. This mode determines how SQL queries are interpreted and executed, influencing aspects such as…

Data and analytics

SQL Script

An SQL script is a file that contains a series of SQL statements, which are instructions used to interact with databases. These statements can include commands to create, modify, or delete data…

Data and analytics

SQL Server Agent

The SQL Server Agent is an essential component of SQL Server that allows for the automation of scheduled administrative tasks. Its main function is to execute jobs, which can include tasks such as…

Data and analytics

SQL Server Analysis Services

SQL Server Analysis Services (SSAS) is a Microsoft technology that provides tools for data analysis and business intelligence. This platform allows organizations to transform large volumes of data…

Data and analytics

SQL Server Management Studio

SQL Server Management Studio (SSMS) is an integrated environment designed to manage the infrastructure of SQL Server, which is a relational database management system developed by Microsoft. SSMS…

Data and analytics

SQL Server Profiler

The SQL Server Profiler is a tool for monitoring and analyzing events in SQL Server. This tool allows database administrators and developers to capture and examine activity on SQL servers, providing…

Data and analytics

SQL Standard

The SQL standard refers to the formal specification of the Structured Query Language (SQL), which is the programming language used to manage and manipulate relational databases. This standard defines…

Data and analytics

SQL Statement

SQL (Structured Query Language) is a set of commands used to perform tasks such as querying, updating, or managing data in a database. SQL allows users to interact with relational databases…

Data and analytics

SQL Statement Execution

The execution of an SQL statement refers to the process of executing an SQL statement against a database. This process is fundamental in interacting with database management systems (DBMS), as it…

Data and analytics

SQL Statement Parsing

The analysis of an SQL statement is the process of examining an SQL statement to verify its syntax and semantics. This process is fundamental in executing queries in relational databases, as it…

Data and analytics

SQL Syntax

SQL syntax refers to the set of rules that define the combinations of symbols that are considered correctly structured SQL statements. SQL, which stands for Structured Query Language, is a…

Data and analytics

SQL Transaction

A SQL transaction is a sequence of operations performed as a single logical unit of work. In the context of databases, a transaction ensures that a set of operations is executed completely and…

Data and analytics

Sqrt

The 'square root' function in Numpy is a fundamental tool that allows calculating the non-negative square root of each element in an array. This operation is essential in various fields of science…

Data and analytics

SSTable

SSTable, or Sorted String Table, is a storage format used in various NoSQL databases, including the Cassandra database engine, that allows for efficient data persistence. It is an ordered and…

Data and analytics

SSTable Loader

The SSTable loader is a fundamental tool in the Apache Cassandra ecosystem, designed to facilitate the loading of SSTables (Sorted String Tables) into a Cassandra cluster. These tables are data…

Data and analytics

Stack

Stacking in Numpy refers to the ability to combine multiple arrays along a new axis, allowing for the creation of more complex and multidimensional data structures. This operation is fundamental in…

Data and analytics

Stacked Bar Chart

A stacked bar chart is a data visualization tool that allows for clear and effective representation of categorical information. In this type of chart, each bar represents a total and is divided into…

Data and analytics

Stack Frame

The stack frame is a fundamental data structure in programming and memory management that contains information about a single execution of a subroutine. Each time a function is invoked, a new stack…

Data and analytics

Stackplot

A stackplot is a visual representation that shows the cumulative totals of several data series, allowing for the observation of both the individual contribution of each series and the overall total…

Data and analytics

Staging Area

The staging area is a crucial component in data management processes, acting as a temporary storage space where data is cleaned and transformed before being loaded into a data warehouse. This…

Data and analytics

Stakeholder Mapping

Stakeholder mapping is a fundamental tool in project management that allows for the identification and visual representation of all parties involved in a project. This process involves creating a…

Data and analytics

Standard Input

Standard input is a stream from which a program reads its input data. This concept is fundamental in programming and scripting, as it allows programs to interact with users or other programs…