CONNECT Table Types
The main feature of CONNECT is to give MariaDB the ability to handle tables from many sources, native files, other DBMS’s tables, or special “virtual” tables. Moreover, for all tables physically represented by data files, CONNECT recognizes many different file formats, described below but not limited in the future to this list, because more can be easily added to it on demand (OEM tables).
Note: You can download a PDF version of the CONNECT documentation (1.7.0003).
-
CONNECT Table Types Overview
CONNECT can handle many table formats. -
Inward and Outward Tables
The two broad categories of CONNECT tables. -
CONNECT Table Types - Data Files
CONNECT plain DOS or UNIX data files. -
CONNECT Zipped File Tables
When the table file or files are compressed in one or several zip files. -
CONNECT DOS and FIX Table Types
CONNECT tables based on text files -
CONNECT DBF Table Type
CONNECT dBASE III or IV tables. -
CONNECT BIN Table Type
CONNECT binary files in which each row is a logical record of fixed length -
CONNECT VEC Table Type
CONNECT binary files organized in vectors -
CONNECT CSV and FMT Table Types
Variable length CONNECT data files. -
CONNECT - NoSQL Table Types
Based on files that do not match the relational format but often represent hierarchical data. -
CONNECT - Files Retrieved Using Rest Queries
JSON, XML and CSV data files can be retrieved as results from REST queries. -
CONNECT JSON Table Type
JSON (JavaScript Object Notation) is a widely-used lightweight data-interchange format. -
CONNECT XML Table Type
CONNECT XML files -
CONNECT INI Table Type
CONNECT INI Windows configuration or initialization files. -
CONNECT - External Table Types
Access tables belonging to the current or another server. -
CONNECT ODBC Table Type: Accessing Tables From Another DBMS
CONNECT Table Types - ODBC Table Type: Accessing Tables from other DBMS -
CONNECT JDBC Table Type: Accessing Tables from Another DBMS
Using JDBC to access other tables. -
CONNECT MONGO Table Type: Accessing Collections from MongoDB
Used to directly access MongoDB collections as tables. -
CONNECT MYSQL Table Type: Accessing MySQL/MariaDB Tables
Accessing a MySQL or MariaDB table or view -
CONNECT PROXY Table Type
Tables that access and read the data of another table or view -
CONNECT XCOL Table Type
Based on another table/view, used when object tables have a column that contains a list of values -
CONNECT OCCUR Table Type
Extension to the PROXY type when referring to a table/view having several c... -
CONNECT PIVOT Table Type
Transform the result of another table into another table along “pivot” and "fact" columns. -
CONNECT TBL Table Type: Table List
Define a table as a list of tables of any engine and type. -
CONNECT - Using the TBL and MYSQL Table Types Together
Used together, the TBL and MYSQL types lift all the limitations of the FEDERATED and MERGE engines -
CONNECT Table Types - Special "Virtual" Tables
VIR, WMI and MAC special table types -
CONNECT Table Types - VIR
VIR virtual type for CONNECT -
CONNECT Table Types - OEM: Implemented in an External LIB
CONNECT OEM table types are implemented in an external library. -
CONNECT Table Types - Catalog Tables
Catalog tables return information about another table or data source
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
