In many organizations, data gets stored in different databases using different formats. The structure of those databases can differ a little or a lot, as can the language used for queries. And some databases include certain bits of key data, while others do not. The end result is largely the same: though all of the information might be contained within the organization, accessing it can be difficult. Browsing is unreliable, but more specific queries can easily miss important information. Adding, modifying, updating, and displaying this information takes much longer than needed.
So many organizations face these challenges of data organization that it should have a name. Let’s call it the Babel Problem. Here are the five tell-tale signs that your organization has a Babel Problem:
If one or more of these symptoms occurs more than once, or with any regularity, this is evidence that you have a Babel Problem, and that it is having a sustained effect on your productivity. Addressing Babel Problems is where Extract-Tranform-Load (ETL) systems come in handy. ETL helps integrate data across an organization so that it will be useful and timely.