ALL COVERED TOPICS

NoSQL Benchmarks NoSQL use cases NoSQL Videos NoSQL Hybrid Solutions NoSQL Presentations Big Data Hadoop MapReduce Pig Hive Flume Oozie Sqoop HDFS ZooKeeper Cascading Cascalog BigTable Cassandra HBase Hypertable Couchbase CouchDB MongoDB OrientDB RavenDB Jackrabbit Terrastore Amazon DynamoDB Redis Riak Project Voldemort Tokyo Cabinet Kyoto Cabinet memcached Amazon SimpleDB Datomic MemcacheDB M/DB GT.M Amazon Dynamo Dynomite Mnesia Yahoo! PNUTS/Sherpa Neo4j InfoGrid Sones GraphDB InfiniteGraph AllegroGraph MarkLogic Clustrix CouchDB Case Studies MongoDB Case Studies NoSQL at Adobe NoSQL at Facebook NoSQL at Twitter

NAVIGATE MAIN CATEGORIES

Close

Dynamic Columns in MariaDB: a SQL to NoSQL Bridge

Dynamic columns allows you to store a different set of columns for every row in the table. […]

Dynamic columns works by storing the extra columns in a blob and having a small set of functions to manipulate it. The functions exist both in SQL and in the MariaDB client library to allow you to manipulate the data where it suits you best.

Nice addition to MariaDB that will hopefully make it to MySQL in the future. You can select, add, update and filter on a dynamic column (nb: though I couldn’t find if you can define indexes on dynamic columns or filtering will require full table scans). The only drawback I see at the current implementation is that dynamic columns are positional not named.

Original title and link: Dynamic Columns in MariaDB: a SQL to NoSQL Bridge (NoSQL databases © myNoSQL)

via: http://monty-says.blogspot.com/2011/05/dynamic-columns-as-bridge-between-sql.html