Data blog RSS



The rise of the graph databases

Relational databases have been with us for a long time. They are not going anywhere, don't worry. There is however a category of problems, for which the relational databases are not best suited. The technology development in recent years allow the graph databases to emerge from academic research and theoretical concepts.

Continue reading




Data migration projects - why and how

Data migration reasons Sooner or later, if you are a database developer or a data architect, you will be faced with a data migration project. Data migrations are executed by organizations due to many different factors. The organizations try to avoid the data migrations, if they can, because in many cases it is a costly and complicated process. Optimally, a data driven application should work for many years without major changes, aside from only patching and updating their data store. Indeed, even upgrading a database version to a newer one can become quite a complicated project, well exceeding the backup-restore approach, so desired by the management and the development teams. Here is a few of many reasons why the migrations take place....

Continue reading



Enum data type in MySQL

While investigating features of MySQL database engine, I came across an interesting concept: the enum data type.   The enum data type allows for defining static data ranges that can be used as values of certain attributes. These ranges typically are quite small - for example marital status consists of 'Married', 'Single', 'Widowed', 'Divorced', 'N/A' . These five values can be encoded as an enum data type column. For example, we can define a table in the following way. create table Person ( FirstName varchar(50) not null, SurName varchar(50) not null, MaritalStatus enum ('Married', 'Single', 'Widowed', 'Divorced', 'N/A') not null ); Please note this is a very simplified code. Enum in MySQL has a certain feature - the values in rows...

Continue reading



Activation of Cherry City Software OLEDB Provider for MySQL

If you read my previous post, How to install MySQL Connection Provider, you know that installation of the provider is just the first step. Yes, you can test the connection, but any attempt to run a query against your MySQL database will result with error saying "MySQL OLE DB provider has not been activated".  I was stuck for a while with this error - it doesn't direct exactly to a resolution of the issue. I analyzed the code of SelectCompare and found nothing wrong with it. I googled for some information pertaining to the error message. I found some old pages that referenced the message, but no solutions.  This made me thinking - after all, if Google doesn't show relevant results, there must...

Continue reading