submit to reddit

About Ted Hills

As an author, speaker, consultant, and data management executive, Ted Hills helps businesses get the most value out of their data. Both an advanced theorist and a committed pragmatist, with grounding in software and systems development, Ted’s book, NoSQL and SQL Data Modeling, promises to change how we represent data, moving from the rigid, prescriptive world of SQL databases to the more fluid domains of Big Data and NoSQL. Ted’s deep experience with large data projects in multiple industries and knowledge of new and established technologies give him perspective and insight into how an organization can maximize its existing investments while leveraging new technologies.

  • David Jaques-Watson

    Good article, Ted! Can I request a follow-up that details the “various strategies available for designing tables that can store multiple classification hierarchies”. I’m assuming dimensional modelling is at least one, with hiearchies either as snowflake dimensions or collapsed down into a standard star model.

    It becomes more difficult when the dimension itself is part of more than one classification system.

    What are some other solutions?

  • Chris Pehura

    My first discussion in the industry was about using either 2nd normal or 3rd normal form; then providing training to people so they wouldn’t use a CD tray in their computer as a cup holder.

    Relative to those things, everything else seems straight forward and easy to explain.

  • William Evans

    Hi Ted,

    Thank you for the insight.

    I use Ontologies to resolve this problem.

    Many simple hierarchies that are well defined, that an Ontology can then collect from and create accurate, and yet flexible compound definitions.

    The bonus of a good ontology editor is the Reasoner, which helps one see what we may have forgotten to include in our definition.

    Good editors also have the capability to interact with Graph Databases and that becomes a real power-tool as well considered query design becomes really simple.

    Have a good day

We use technologies such as cookies to understand how you use our site and to provide a better user experience. This includes personalizing content, using analytics and improving site operations. We may share your information about your use of our site with third parties in accordance with our Privacy Policy. You can change your cookie settings as described here at any time, but parts of our site may not function correctly without them. By continuing to use our site, you agree that we can save cookies on your device, unless you have disabled cookies.
I Accept