Intelligent Information Management Part 2
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…
Intelligent Information Management Part 1
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…
Columnar Deduplication and Column Tokenization: Improving Database Performance, Security, and Interoperability
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-oriented Part 2: Flexible Data Modeling for a Simplified End User Experience
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…
Column-oriented Part 1: The I/O Advantage
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…
Thoughts on Column-oriented Database Management Systems
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…