Database & AI Glossary
A comprehensive reference of database, AI, analytics, and automation terms. Understand the technology behind modern data-driven organizations.
130 terms found
A/B Testing
A statistical method of comparing two versions of something to determine which performs better.
Read moreDatabaseACID
A set of properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions.
Read moreAI & MLAgentic AI
AI systems that can autonomously plan, execute multi-step tasks, use tools, and adapt based on results.
Read moreAI & MLAgentic AI for Databases
Agentic AI for databases is the application of autonomous, goal-directed AI to database work: answering open-ended questions, maintaining dashboards, and monitoring data for conditions that should trigger action.
Read moreDatabaseAggregation
A SQL operation that computes a single result from a set of values, such as SUM, COUNT, AVG, MIN, or MAX.
Read moreAI & MLAI Data Analyst
An AI data analyst is software that performs the core work of a human data analyst–translating business questions into queries, running them, and explaining the results–using AI.
Read moreSecurityAI Guardrails
AI guardrails are the technical constraints placed around an AI system that limit what it can do regardless of what it is asked–in database tools, controls like read-only execution, query validation, schema-only context, and operation allowlists.
Read moreAI & MLAI SQL Assistant
An AI SQL assistant is a tool that uses a language model to write, explain, fix, or optimize SQL queries from natural language instructions.
Read moreAutomationAlerting
Automated notifications triggered when database metrics or query results meet specified conditions or thresholds.
Read moreAnalyticsAnomaly Detection in Metrics
Anomaly detection in metrics is the automated identification of unusual values in business data–spikes, drops, or drifts that deviate from normal patterns–so problems surface before someone happens to look at a dashboard.
Read moreIntegrationAPI
Application Programming Interface–a set of protocols that allows different software applications to communicate.
Read moreBusinessARR
Annual Recurring Revenue–the yearly value of recurring subscription revenue, typically MRR multiplied by 12.
Read moreAnalyticsBusiness Glossary for AI
A business glossary for AI is a curated set of definitions for company-specific terms–what counts as an "active user", how "revenue" is calculated–provided to an AI system so it interprets questions the way the business does.
Read moreAnalyticsBusiness Intelligence
Technologies, practices, and strategies for collecting, integrating, analyzing, and presenting business data to support decision-making.
Read moreDatabaseChange Data Capture (CDC)
Change data capture (CDC) is a technique for detecting and streaming every insert, update, and delete in a database as it happens, so other systems can react to changes in real time.
Read moreAnalyticsChart Generation from SQL
Chart generation from SQL is the automatic conversion of query results into an appropriate visualization–choosing the right chart type, axes, and formatting without manual configuration.
Read moreAnalyticsChurn Rate
The percentage of customers or subscribers who stop using a product or service during a given time period.
Read moreAnalyticsCohort Analysis
An analytical technique that groups users by a shared characteristic over time to identify behavioral patterns.
Read moreDatabaseColumn Descriptions
Column descriptions are human-readable annotations attached to database columns that explain what each column contains and how its values should be interpreted.
Read moreBusinessCompliance
Adherence to laws, regulations, standards, and internal policies governing how data is collected, stored, and used.
Read moreSecurityConnection Pooling
A technique that reuses database connections across multiple requests to improve performance and resource usage.
Read moreAI & MLContext Window
A context window is the maximum amount of text an AI model can consider at once–and for database tools, the budget that determines how much of your schema the model can see when generating a query.
Read moreAnalyticsConversational Analytics
Conversational analytics is the practice of exploring and analyzing data through natural language dialogue–asking questions, getting answers, and refining with follow-ups–instead of building queries or reports.
Read moreAnalyticsConversational BI
Conversational BI is business intelligence delivered through a natural language interface, where users ask questions in plain language and receive charts, tables, and explanations instead of navigating pre-built dashboards.
Read moreBusinessConversion Rate
The percentage of users who complete a desired action out of the total number who had the opportunity to do so.
Read moreAutomationCron
A time-based job scheduling system that runs commands or scripts at specified times and intervals.
Read moreDatabaseCTE
Common Table Expression–a temporary named result set in SQL that makes complex queries more readable and reusable.
Read moreBusinessCustomer Acquisition Cost
The total cost of acquiring a new customer, including marketing, sales, and onboarding expenses.
Read moreBusinessCustomer Lifetime Value
The total revenue a business can expect from a single customer account over the entire duration of their relationship.
Read moreAutomationDashboard Auto-Refresh
Dashboard auto-refresh is the automatic re-running of a dashboard's underlying queries on a schedule, so the displayed metrics stay current without anyone manually reloading or rebuilding anything.
Read moreBusinessData Democratization
Making data accessible to all stakeholders in an organization regardless of their technical expertise.
Read moreDatabaseData Dictionary
A data dictionary is a centralized reference that documents every table and column in a database–what it contains, what its values mean, and how it should be used.
Read moreBusinessData Governance
The overall management of data availability, usability, integrity, and security within an organization.
Read moreSecurityData Masking
A technique that obscures sensitive data by replacing it with realistic but fake values to protect privacy.
Read moreIntegrationData Pipeline
An automated series of data processing steps that moves and transforms data from sources to destinations.
Read moreAnalyticsData Quality
The measure of data's fitness for its intended purpose in terms of accuracy, completeness, consistency, and timeliness.
Read moreCore ConceptsData Visualization
The graphical representation of data and information using charts, graphs, maps, and other visual formats.
Read moreDatabaseData Warehouse
A centralized repository optimized for analytical queries across large volumes of historical data from multiple sources.
Read moreBusinessData-Driven Decision Making
The practice of basing business decisions on data analysis and interpretation rather than intuition alone.
Read moreAI & MLDatabase Agent
A database agent is an AI system that can autonomously perform multi-step work against a database–planning queries, running them, inspecting results, and refining its approach–rather than answering one prompt at a time.
Read moreAutomationDatabase Automation
The use of software to perform recurring database tasks–backups, monitoring, alerts, and report generation–without manual intervention.
Read moreCore ConceptsDatabase Chat
Database chat is a conversational interface where you ask a database questions in plain language and get answers back as text, tables, or charts.
Read moreIntegrationDatabase Connection String
A database connection string is a single line of text containing everything needed to connect to a database: the host address, port, database name, username, password, and options like SSL settings.
Read moreIntegrationDatabase Connector
A software component that enables applications to connect and communicate with specific database systems.
Read moreAI & MLDatabase Copilot
A database copilot is an AI assistant that works alongside you on database tasks–writing and explaining queries, suggesting analyses, and turning questions into results–while you stay in control.
Read moreCore ConceptsDatabase Dashboard
A visual interface that displays key database metrics and query results in real-time charts, graphs, and tables.
Read moreAutomationDatabase Webhook
A database webhook is an HTTP callback triggered by a database condition–such as a new row, a changed value, or a threshold crossing–that pushes the event to an external system in real time.
Read moreAI & MLEmbedding
A numerical vector representation of text, data, or objects that captures semantic meaning for AI processing.
Read moreAI & MLEmbeddings for Databases
Embeddings for databases are numerical vector representations of schema elements–table names, column names, descriptions–that let AI systems match user questions to the right data by meaning instead of exact wording.
Read moreSecurityEncryption at Rest
The encryption of stored data on disk to protect it from unauthorized physical or logical access.
Read moreDatabaseETL
Extract, Transform, Load–a data integration process that moves data from source systems into a data warehouse.
Read moreDatabaseFederated Query
A federated query is a single query that pulls and combines data from multiple separate databases or data sources as if they were one system.
Read moreAI & MLFew-Shot Learning
An AI technique where a model learns to perform a task from just a few examples provided in the prompt.
Read moreAI & MLFew-Shot SQL Prompting
Few-shot SQL prompting is a technique where example question-and-SQL pairs are included in the AI's prompt to teach it the query patterns and conventions of a specific database.
Read moreAI & MLFine-Tuning
The process of further training a pre-trained AI model on specific data to improve performance on a particular task.
Read moreDatabaseForeign Key
A column in one table that references the primary key of another table, establishing a link between them.
Read moreAI & MLFunction Calling
Function calling is an AI model capability where the model responds with a structured request to invoke a specific tool–such as "run this SQL query"–instead of plain text, letting applications execute the action and return results.
Read moreAnalyticsFunnel Analysis
A method of tracking and analyzing the sequential steps users take toward a desired conversion or goal.
Read moreAnalyticsGenerative BI (GenBI)
Generative BI (GenBI) is business intelligence where AI generates the analytical artifacts themselves–SQL queries, charts, dashboards, and written summaries–directly from natural language requests.
Read moreAI & MLGrounded Answers
Grounded answers are AI responses that are backed by verifiable source data–in database tools, answers computed by running a real query against your actual database rather than generated from the model's memory.
Read moreAI & MLHallucination
When an AI model generates plausible-sounding but factually incorrect or fabricated information.
Read moreSecurityHuman-in-the-Loop Query Review
Human-in-the-loop query review is a workflow where a person can inspect, approve, or correct AI-generated SQL–keeping human judgment in the path between the AI's output and decisions made on it.
Read moreDatabaseIndex
A database structure that speeds up data retrieval by creating an optimized lookup path for specific columns.
Read moreDatabaseJoin
A SQL operation that combines rows from two or more tables based on a related column between them.
Read moreAI & MLJoin Inference
Join inference is the ability of an AI query system to automatically determine which tables to join, and on which keys, to answer a question that spans multiple tables.
Read moreAnalyticsKPI
Key Performance Indicator–a measurable value that demonstrates how effectively an organization is achieving its objectives.
Read moreAI & MLLarge Language Model
An AI model trained on vast text data that can understand and generate human language, powering text-to-SQL and conversational AI.
Read moreIntegrationMCP Server for Databases
An MCP server for databases is a Model Context Protocol service that exposes database capabilities–listing schemas, running queries, fetching results–to AI assistants in a standardized way.
Read moreAnalyticsMetric Definition
A metric definition is the precise, agreed specification of how a business metric is calculated–which tables, filters, and formulas produce numbers like MRR, churn rate, or active users.
Read moreDatabaseMigration
A version-controlled change to a database schema, such as adding tables, columns, or modifying constraints.
Read moreIntegrationModel Context Protocol (MCP)
The Model Context Protocol (MCP) is an open standard that defines how AI applications connect to external tools and data sources, letting any compatible AI assistant use any compatible tool without custom integration code.
Read moreBusinessMRR
Monthly Recurring Revenue–the predictable total revenue generated from all active subscriptions in a month.
Read moreDatabaseMulti-Database Querying
Multi-database querying is the ability to connect to and query several different databases–often different engines entirely–from a single tool or interface.
Read moreBusinessMulti-Tenancy
A software architecture where a single instance serves multiple customers while keeping their data isolated.
Read moreDatabaseMySQL
One of the world's most popular open-source relational databases, widely used for web applications.
Read moreAI & MLNatural Language Processing
A branch of AI focused on enabling computers to understand, interpret, and generate human language.
Read moreCore ConceptsNatural Language Query
A database query expressed in everyday human language rather than a formal query language like SQL.
Read moreBusinessNet Revenue Retention
The percentage of recurring revenue retained from existing customers including expansions, contractions, and churn.
Read moreCore ConceptsNL2SQL
NL2SQL is the task of automatically translating a natural language question into an executable SQL query.
Read moreDatabaseNormalization
The process of organizing database tables to reduce data redundancy and improve data integrity.
Read moreDatabaseNoSQL
A category of databases that store data in non-tabular formats such as documents, key-value pairs, graphs, or wide columns.
Read moreAnalyticsOLAP
Online Analytical Processing–a computing approach optimized for complex analytical queries across large datasets.
Read moreAnalyticsOperational Analytics
Operational analytics is the use of current, granular data to drive day-to-day decisions and actions–monitoring orders, signups, inventory, and queues as they move–rather than reviewing historical summaries.
Read moreDatabaseORM
Object-Relational Mapping–a technique that lets developers interact with databases using programming language objects instead of SQL.
Read moreDatabasePostgreSQL
An advanced open-source relational database known for extensibility, standards compliance, and robust feature set.
Read moreDatabasePrimary Key
A column or set of columns that uniquely identifies each row in a database table.
Read moreAI & MLPrompt Engineering
The practice of crafting effective instructions and context for AI models to produce desired outputs.
Read moreSecurityPrompt Injection
Prompt injection is an attack where malicious instructions are hidden inside content an AI processes–in database tools, inside data values or user inputs–attempting to trick the AI into ignoring its rules and performing unintended actions.
Read moreAnalyticsPush vs Pull Analytics
Push vs pull analytics describes two delivery models for data: pull, where people go look at dashboards and run queries; and push, where the system sends insights and alerts to people when something warrants attention.
Read moreDatabaseQuery Latency
Query latency is the time between submitting a database query and receiving its results.
Read moreDatabaseQuery Optimization
The process of improving a SQL query's execution speed and resource usage without changing the results.
Read moreAnalyticsQuery Result Summarization
Query result summarization is the use of AI to turn raw query output–rows and numbers–into a short plain-language explanation of what the data shows.
Read moreSecurityQuery Sandbox
A query sandbox is a restricted execution environment where queries run under strict limits–on permissions, runtime, and resources–so that no query, however wrong, can damage the database or the data.
Read moreAI & MLQuery Validation
Query validation is the process of checking an AI-generated SQL query for correctness and safety–verifying it references real tables and columns, parses cleanly, and stays within allowed operations–before it runs.
Read moreAI & MLRAG
Retrieval-Augmented Generation–an AI technique that enhances LLM responses by retrieving relevant context from external data sources.
Read moreAI & MLRAG for Databases
RAG for databases is the use of retrieval-augmented generation to fetch the most relevant schema elements, definitions, and examples for a given question before the AI generates SQL.
Read moreDatabaseRead Replica for Analytics
A read replica for analytics is a continuously synced, read-only copy of a production database used to run reports and heavy analytical queries without slowing down the live application.
Read moreSecurityRead-Only Mode
Read-only mode is a safety configuration in which a tool or database connection can run SELECT queries to read data but is blocked from any operation that modifies it–no INSERT, UPDATE, DELETE, or schema changes.
Read moreAnalyticsReal-Time Analytics
The practice of analyzing data immediately as it is created or received, enabling instant insights and actions.
Read moreDatabaseRelational Database
A database that organizes data into structured tables with rows and columns, linked by defined relationships.
Read moreDatabaseReplication
The process of copying and maintaining database data across multiple servers for redundancy and performance.
Read moreIntegrationREST API
A web API design pattern using HTTP methods to perform CRUD operations on resources identified by URLs.
Read moreAnalyticsRetention Analysis
The measurement of how many users continue to use a product or service over time.
Read moreSecurityRole-Based Access Control
A security model that restricts database access based on user roles and permissions within an organization.
Read moreSecurityRow-Level Security
A database feature that restricts which rows a user can access based on policies tied to their identity.
Read moreBusinessSaaS Metrics
A set of key performance indicators specific to subscription-based software businesses.
Read moreAutomationScheduled Query
A database query configured to run automatically at specified times or intervals.
Read moreCore ConceptsSchema
The structural blueprint of a database that defines tables, columns, data types, relationships, and constraints.
Read moreDatabaseSchema Introspection
Schema introspection is the automatic process of reading a database's own metadata to discover its tables, columns, data types, keys, and relationships.
Read moreAI & MLSchema Linking
Schema linking is the step in text-to-SQL where words in a user's question are matched to the specific tables and columns in the database that they refer to.
Read moreAI & MLSchema-Aware AI
Schema-aware AI is an AI system that knows the structure of your specific database–its tables, columns, types, and relationships–and uses that knowledge to generate correct queries.
Read moreBusinessSelf-Service Analytics
An approach where business users can access and analyze data independently without relying on data teams.
Read moreAnalyticsSemantic Layer
An abstraction layer that translates complex database structures into business-friendly terms and metrics.
Read moreAI & MLSemantic Search
Search that understands the meaning and intent behind queries rather than just matching keywords.
Read moreDatabaseSQL
Structured Query Language–the standard programming language for managing and querying relational databases.
Read moreCore ConceptsSQL Generation
SQL generation is the automatic creation of SQL queries by software–typically an AI model–from a user's intent expressed in natural language.
Read moreAI & MLSQL Hallucination
SQL hallucination is when an AI model generates a query that looks correct but references tables or columns that do not exist, or encodes logic that does not match the question asked.
Read moreSecuritySQL Injection
A security vulnerability where malicious SQL code is inserted into queries through user inputs.
Read moreIntegrationSSO
Single Sign-On–an authentication scheme that allows users to log into multiple applications with one set of credentials.
Read moreDatabaseStored Procedure
A precompiled set of SQL statements stored in the database that can be executed as a single unit.
Read moreCore ConceptsText-to-SQL
The process of converting natural language questions into structured SQL queries that can be executed against a database.
Read moreAutomationThreshold Alert
A threshold alert is an automated notification that fires when a monitored metric crosses a defined boundary–revenue below a floor, error counts above a ceiling, inventory under a minimum.
Read moreDatabaseTransaction
A sequence of database operations that are treated as a single logical unit–either all succeed or all are rolled back.
Read moreAI & MLTransformer
A neural network architecture using self-attention mechanisms, forming the foundation of modern LLMs.
Read moreAI & MLVector Database
A database designed to store and efficiently query high-dimensional vector embeddings for similarity search.
Read moreAI & MLVector Search over Schema
Vector search over schema is a technique that finds the database tables and columns most semantically relevant to a user's question by comparing embeddings, rather than matching exact names.
Read moreDatabaseView
A virtual table based on a stored SQL query that presents data from one or more tables in a specific format.
Read moreAutomationWebhook
An HTTP callback that delivers real-time data to other applications when a specified event occurs.
Read moreDatabaseWindow Function
A SQL function that performs calculations across a set of rows related to the current row without collapsing them.
Read moreAutomationWorkflow
A sequence of automated steps triggered by an event or schedule that processes data and takes actions.
Read moreSee these concepts in action
AI for Database turns these concepts into a simple conversation with your data. Try it free.
Free plan available · No credit card required