🛢DBMS: Base Table (Definitions)

"A table from which a view is derived. Also called an underlying table. A view can have one or more base tables or base views." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A table stored permanently in a database. Base tables are referenced by views, cursors, SQL statements, and stored procedures." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"Base table is a named relation corresponding to an entity in the conceptual schema, whose tuples (rows) are physically stored in the database." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"A relation whose contents are physically and permanently stored in a database." (Jan L Harrington, "SQL Clearly Explained" 3rd Ed., 2010)

"1.In Data Warehousing, the normalized data structures maintained in a Data Warehouse, in contrast to the de-normalized dependent data mart tables sourced from the base tables. 2.Outside of Data Warehousing, a table for an entity that is not dependent on any other entity in the database." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"The table on which a view is based." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed, 2011)

"A table stored permanently in a database. Base tables are referenced by views, cursors, SQL statements, and stored procedures." (Microsoft, "SQL Server 2012 Glossary", 2012)

"A table that is created by the SQL CREATE TABLE statement and that holds persistent data. See also auxiliary table, created temporary table, declared temporary table, result table, table, temporary table, view." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"Relations whose data are physically stored in a database." (Jan L Harrington, "Relational Database Design and Implementation" 3rd Ed., 2009)

"The normalized data structures maintained in the target warehousing database. Also known as the detail data." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)