Comparison of Relational Database Management Systems - Tables and Views

Tables and Views

Information about what tables and views (other than basic ones) are supported natively.

Temporary table Materialized view
4th Dimension Yes Planned for inclusion in next major release
ADABAS ? ?
Adaptive Server Enterprise Yes1 No
Advantage Database Server Yes No (only common views)
Altibase Yes No (only common views)
Apache Derby Yes No
CUBRID No No
Drizzle Yes No4
DB2 Yes Yes
Empress Embedded Database Yes Yes
Firebird Yes No (only common views)
HSQLDB Yes No
H2 Yes No
Informix Dynamic Server Yes No2
Ingres Yes Planned for inclusion in next major release
InterBase Yes No
Linter SQL RDBMS Yes Yes
LucidDB No No
MaxDB Yes No
Microsoft Access (JET) No No
Microsoft Visual Foxpro Yes Yes
Microsoft SQL Server Yes Yes3
Microsoft SQL Server Compact (Embedded Database) Yes No
MonetDB/SQL Yes No
MySQL Yes No4
OpenBase SQL Yes Yes
Oracle Yes Yes
Oracle Rdb Yes Yes
OpenLink Virtuoso Yes Yes
Polyhedra DBMS No No (only common views)
PostgreSQL Yes No5
RDM Embedded Yes No
RDM Server Yes No
SQL Anywhere Yes Yes
ScimoreDB No No
SQLite Yes No
Teradata Yes Yes
UniData Yes No
UniVerse Yes No
Xeround Cloud Database Yes No

Note (1): Server provides tempdb, which can be used for public and private (for the session) temp tables.

Note (2): Materialized views are not supported in Informix; the term is used in IBM’s documentation to refer to a temporary table created to run the view’s query when it is too complex, but one cannot for example define the way it is refreshed or build an index on it. The term is defined in the Informix Performance Guide.

Note (3): Query optimizer support only in Developer and Enterprise Editions. In other versions, a direct reference to materialized view and a query hint are required.

Note (4): Materialized views can be emulated using stored procedures and triggers.

Note (5): Materialized views can be emulated with stored procedures and triggers using PL/pgSQL, PL/Perl, PL/Python, or other procedural languages.

Read more about this topic:  Comparison Of Relational Database Management Systems

Famous quotes containing the words tables and, tables and/or views:

    “All my life I have said, “Whatever happens there will always be tables and chairs”—and what a mistake.”
    —Elizabeth Bowen (1899–1973)

    “It breedeth no small offence and scandal to see and consider upon the one part the curiosity and cost bestowed by all sorts of men upon their private houses; and on the other part the unclean and negligent order and spare keeping of the houses of prayer by permitting open decays and ruins of coverings of walls and windows, and by appointing unmeet and unseemly tables with foul cloths for the communion of the sacrament.”
    —Elizabeth I (1533–1603)

    “It is even more grim and wild than you had anticipated, a damp and intricate wilderness, in the spring everywhere wet and miry. The aspect of the country, indeed, is universally stern and savage, excepting the distant views of the forest from hills, and the lake prospects, which are mild and civilizing in a degree.”
    —Henry David Thoreau (1817–1862)