Live briefing
Everything about Virtual column
In relational databases a virtual column is a table column whose value(s) is automatically computed using other columns values, or another deterministic expression. Virtual columns are defined of SQL:2003 as Generated Column, and are only implemented by some DBMSs, like MariaDB, SQL Server, Oracle, PostgreSQL, SQLite and Firebird. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Virtual columnA 5-minute orientation
- Skim a recent paper: NUMA-Aware Virtual Machine Placement: New MMMK Model and Column Generation-Based Decomposition ApproachInfluential work since 2022
- Pick up a classic book: American FilmThe most-reprinted book on the subject
- Read the landmark paper: Parallel segmented flow chromatography columns: Conventional analytical scale column formats presenting as a ‘virtual’ narrow bore columnCited 54 times
- Go sideways: Comparison of relational database management systemsA closely related topic
- Go sideways: Hierarchical and recursive queries in SQLA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Parallel segmented flow chromatography columns: Conventional analytical scale column formats presenting as a ‘virtual’ narrow bore column
Energy-Injecting Virtual Mass Resonant Column System
Simulation and Optimization of Retention in Ion Chromatography Using Virtual Column 2 Software
A Two-Dimensional FDTD-Based Virtual Visualization Tool for Metamnaterial -Wave Interaction [Education Column]
A novel virtual FDTD-based microstrip circuit design and analysis tool [Education Column]
Anatomical study of anterior column screw tunnels through virtual three-dimensional models of the pelvis
Both-Column Acetabular Fractures: Does Surgical Approach Vary Based on Using Virtual 3D Reconstructions?
Automated Segmentation Method for Spinal Column Based on a Dual Elliptic Column Model and Its Application for Virtual Spinal Straightening
🆕 Influential since 2022
NUMA-Aware Virtual Machine Placement: New MMMK Model and Column Generation-Based Decomposition Approach
Virtual training complex of the ship's main power plant with a helical steering column
MPEG Column: 150th MPEG Meeting (Virtual/Online)
MPEG Column: 145th MPEG Meeting (Virtual/Online)
MPEG Column: 137th MPEG Meeting (Virtual/Online)
📚 Books worth reading
American FilmAmerican Film Institute · 1975
Technical CommunicationJohn M. Lannon · 2000
Apache CookbookKen Coar, Rich Bowen · 2003
The web application hacker's handbookDafydd Stuttard, Marcus Pinto · 2007
The Conspirators HierarchyJohn Coleman · 1992
Imagi-MoviesCinefantastique · 1993
Bitter freedomMaurice Walsh · 2015
Plastic Design of FramesJaques Heyman · 1971
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Comparison of relational database management systems The following tables compare general and technical information for a number of relational database management systems. Please see the individual products'…
- Hierarchical and recursive queries in SQL A hierarchical query is a type of SQL query that handles hierarchical model data. These are useful for working with databases of graph-structured data…
- DUAL table The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single…
- Insert (SQL) An SQL INSERT statement adds one or more records to any single table in a relational database. Insert statements have the following form: INSERT INTO table…
- Merge (SQL) A relational database management system uses SQL MERGE (also called upsert) statements to INSERT new records or UPDATE or DELETE existing records depending…
- Prepared statement In database management systems (DBMS), a prepared statement, parameterized statement, (not to be confused with parameterized query) is a feature where…
- Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
- Embedded database An embedded database system is a database management system (DBMS) that is tightly integrated with application software, and is embedded within the application…