Wednesday, July 11, 2012

Advantages of relational databases over VSAM, ISAM and hierarchical data stores

When migrating companies from legacy environments to the cloud, invariably you run into older hierarchical, flat file, VSAM, ISAM and other legacy data stores. There are many advantages to moving these databases into a relational database structure. The most important which is that most cloud providers run on relational database models. AWS, for example, supports Oracle, SQL Server, and MySQL. The top three 'other reasons' for moving to a relational database are:
1. Data Access – Thousands of database access tools from query creation to business intelligence.
2. Management and monitoring – Hundreds of tools for management and monitoring of the database.
3. Leverage all the free tools from relational database vendors. Free Oracle database tools include:
-Application Express – WYSIWIG browse based application development and deployment.
-SQL Developer – SQL and PL/SQL development. Database object maintenance.
Adding number four based upon feedback:
4. Data quality, integrity, referential integrity and even business logic is embedded in the database.
What is interesting is that Big Data NoSQL databases and XML databases are taking us back to the days of VSAM (key value databases) with NoSQL and IMS (hierarchical) with XML databases?

1 comment:

  1. Good points. Traditionally, legacy data repositories do not perform data validation, causing a data quality issue. Many of our customers use our data cleansing tools to address these errors. Thanks for posting your thoughts.

    ReplyDelete