Glossary
Plain-language definitions of the data terms behind iDBQuery — cited answers, federation, the semantic layer, text-to-SQL, schemas, OCR ingest and self-serve BI.
- What is a cited answer?
- What is a one live model?
- What is data federation?
- What is a semantic layer?
- What is text-to-SQL?
- What is an autonomous Analyst agent?
- What is a data source in iDBQuery?
- What is a database schema?
- What is the embedded SDK?
- What is OCR document ingest?
- What is schema introspection?
- What is self-serve BI?
- What is a data warehouse?
- What is ETL (extract, transform, load)?
- What is a data lake?
- What is OLAP (online analytical processing)?
- What is a star schema?
- What is retrieval-augmented generation (RAG)?
- What is a vector embedding?
- What is data lineage?
- What is augmented analytics?
- What is ELT (extract, load, transform)?
- What is a data lakehouse?
- What is OLTP (online transaction processing)?
- What is a snowflake schema?
- What is dimensional modeling?
- What is a fact table?
- What is a dimension table?
- What is a primary key in a database?
- What is a foreign key in a database?
- What is database normalization?
- What is denormalization?
- What is a database index?
- What is a SQL join?
- What is aggregation in a database query?
- What is a window function in SQL?
- What is a CTE (common table expression) in SQL?
- What is a database view?
- What is a stored procedure?
- What is a data pipeline?
- What is data orchestration?
- What is reverse ETL?
- What is data governance?
- What is master data management (MDM)?
- What is data quality?
- What is data profiling?
- What is metadata?
- What is a data dictionary?
- What is a metrics layer?
- What is the difference between a KPI and a metric?
- What is the difference between a measure and a dimension?
- What is cardinality in databases?
- What is granularity or grain in data?
- What is a slowly changing dimension (SCD)?
- What is a vector database?
- What is a prompt in AI?
- What is an AI hallucination?
- What is conversational analytics?
- What is a natural-language query?
- What is data virtualization?
- What is query-in-place (in-place querying)?
- What is columnar storage?
- What is a data mesh?
- What is a data fabric?
- What is an OLAP cube?
- What is drill-down in data analysis?
- What is roll-up in data analysis?
- What is an ad-hoc query?
- What is the difference between a data pipeline and a query?
- What is a data catalog?
- What is a semantic model in analytics?
- What is business intelligence (BI)?
- What is the difference between structured and unstructured data?
- What is semi-structured data?
- What is a data mart?
- What is a materialized view?
- What is referential integrity?
- What is a surrogate key?
- What is data observability?
- What is a single source of truth (SSOT)?
- What is data transformation?
- What is schema-on-read?
- What is a large language model (LLM)?