Few IT applications are truly grass roots. Rather most new applications are intended to replace or complement existing applications. As a result, we often find ourselves working with legacy databases. This article is based on 50 legacy databases that we’ve studied over the years. In our experience about 20% of database designs are clean and […]
When To Use the UML for Databases (And When Not To)
The UML is a popular notation for modeling software artifacts. Even though the UML was mostly developed for programming, it is also relevant for databases. This article takes a critical look at using the UML for databases. What is the UML? The UML (an acronym for Unified Modeling Language) is a general-purpose software notation. The […]
Data Rationalization – The Next Step in Semantic Resolution
With the Web 2.0, ontologies are being used to improve search capabilities and make inferences for improved human or computer reasoning. By relating terms in an ontology, the user doesn’t need to know the exact term actually stored in the document. Data Rationalization is a Managed Meta Data Environment (MME) enabled application which creates/extends an ontology for a domain into the structured data world, based on model objects stored in various models (of varying levels of detail, across model files and modeling tools) and other meta data.