Databases have tremendous staying power within an enterprise. Once data finds its way into a particular database, it rarely gets taken out or replaced. This can poses challenges down the road. Tech Republic brought this interesting topic to our attention in their article, “Why the future of enterprise data is open source.”
Database migrations can do the job, but companies tend to stick with legacy databases for legacy applications even as developers embrace new databases for new applications. It is never truly a replacement and more of an annex.
Today, many non-relational databases actually support SQL. Although the NoSQL moniker has been redefined to “not only SQL”, it is good to know that SQL does not just apply to relational databases.
It seems like everyone is using an operational relational database, but a SQL interface may be the choice for other solutions, such as analytical, streaming, multi-model or time-series.
Melody K. Smith
Sponsored by Access Innovations, the world leader in thesaurus, ontology, and taxonomy creation and metadata application.