Pencarian

Rss Posts

 

 

 

Using MariaDB as a column store and Virtual Columns for indexing

Oct 28, 2010

This is a followup to my previous post about Virtual Columns. In this post I will do a more in-depth test on using virtual columns in a use case where MariaDB is used as a document store.
Document oriented DB basics
Relational databases store data in 2-dimensional tables, rows and columns. Document oriented databases do not store Word documents or novels, rather the “documents” are essentially serialized PHP arrays, Java-objects, etc. The most popular document format today is JSON. JSON “documents” have exactly the same syntax as a JavaScript array, originally JavaScript programmers would just eval(“data = ” + jsondocument); to get the data into a variable (unserialize). For more information about JSON and how a JSON database would work, see the Wikipedia article and for instance the MongoDB manual.
Another format that has been used for document stores is XML documents, and many programming languages can serialize objects into XML.
read more

Sindikasi     0 Comments

Mastering the art of indexing

Apr 29, 2010

Check out this SlideShare Presentation: I’d have to say that this is the coolest presentation on Indexing and how it relates to INNODB. I have written on this subject many times in the pass but this presentation covers all the bases and does a great job at explaining WHY you should do certain statements over others.More mastering the art of indexingView more presentations from Yoshinori Matsunobu.

Basisdata, Sindikasi     Comments Off