Join Sheeri Cabral for an in-depth discussion in this video Accessing remote database metadata, part of MariaDB for MySQL Users.
…MariaDB's CONNECT Storage Engine can be used to connect to…tables on a remote database even if that database is not a MySQL database.…As MySQL users, we know that we can find metadata, like table names and…column definitions, with show commands and…queries on the INFORMATION_SCHEMA database.…However, if we are querying a remote database that is not MySQL,…we may not know how to get this kind of information.…Luckily, the connect storage engine has a table type to help solve this problem.…
It is called the catalogue data type, because you want to get a catalogue of…metadata, like table names and column definitions.…The information you can get depends on the type of original data source you have.…And the catalog type you specify.…There are four different kinds of catalog types, each showing different information.…The Table catalog type shows table level information and…is specified with CATFUNC or Catalog Function equals tab.…There's also a column catalog type,…specified by CATFUNC equals col, that shows column level information.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.