Join Sheeri Cabral for an in-depth discussion in this video Why use a dynamic column?, part of Understanding MariaDB for MySQL Users.
…You may have heard about dynamic columns, but…are unsure of what they mean or how you might use them.…Let's pull the term apart.…A column is a field in a database, and dynamic means it can change, or…it is flexible.…A database field has a database type, like integer or…date, and that is the type of information you have to store in that field.…Sometimes, what you want to store in the database in not completely clear.…For example, if you run a store that sells CDs, DVDs, games, t-shirts and posters,…each item has a price, manufacturer brand, inventory number and title.…
And each of those attributes would be stored in a field.…However, some items might have extra information, and…that extra information might be different depending on the type of item.…For example, a t-shirt has a size and…color, whereas CDs, DVDs and posters do not.…A DVD or game might have an age restriction, but a t-shirt does not.…If you have all your data normalized, you would have one table with the common…attributes of the items, the price, brand, inventory number and title.…
- 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.