In my previous post, I quickly introduced the concept of Intelligent Information Management. In today’s post, I discuss Information Lifecycle Management (ILM). ILM is one component of IIM best practices, dealing with the management of data from the moment of its creation up to its disposal. Studies have demonstrated that the rate of access for… [read more]
Summer is well underway here in Montreal, bringing with it blue skies and warm temperatures. This is an exciting development, especially since the last winter was very long –- just like the amount of space I could devote to the topic of today’s post from the bus! There are many different aspects of Intelligent Information… [read more]
For some time now, a special technique called columnar deduplication has been implemented by a number of commercially available relational database management systems. In today’s blog post, I discuss the nature and benefits of this technique, which I will refer to as column tokenization for reasons that will become evident. Column tokenization is a process… [read more]
In my last blog post, I explained how Column-oriented Database Management Systems (CDBMS), also known as columnar databases or CBAT, offer a distinct advantage over the traditional row-oriented RDBMS in terms of I/O workload, deriving primarily from basing the granularity of I/O operations on the column rather than the entire row. This technological advantage has… [read more]
Column-oriented Database Management Systems (CDBMS), also referred to as columnar databases and CBAT, have been getting a lot of attention recently in the data warehouse marketplace and trade press. Interestingly, some of the newer companies offering CDBMS-based products give the impression that this is a entirely new development in the RDBMS arena. I don’t know… [read more]
As a new contributor to the SAND blog, a few words of introduction are probably in order. I have been working at SAND Technology for 12 years (already!), predominantly in research & development and implementation of Data Warehouses and Intelligent Information Management systems, and I am currently Vice-President of R&D and Deployment for the company…. [read more]
