Tag Archive for data modeling

Primary Key and Foreign Key Errors to Avoid

Michael Blaha

by Michael Blaha 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…

A Closer Look at Multiple Regression Modeling

reg

by Angela Guess Joseph Trevaskis recently wrote for iCrunch Data News, “As a little food for thought, here are a few potential uses of Multiple Regression Models, especially Step-wise Models. Remember that it might be virtually impossible to generate an adequate solution if you are attempting to generate a single stage Multiple Regression Model that…

Modeling Mind and Body with Spark

James Kobielus 2

by James Kobielus What is Apache Spark best for? It’s the right tool for modeling any massively distributed, continually streaming, in-memory connectivity graph that processes sensor data and drives optimized next best actions in a spatio-temporal context. What fits that exceptionally complex use-case description better than the neural network of which one’s brain is the…

NoSQL Shapes Data Modeling

nosql-shapes-data-modeling-x300

by Jelani Harper At an Enterprise Data World 2015 Conference session entitled ”NoSQL Influence to Enterprise Data Modeling,” eBay’s Senior Data Architect Donovan Hsieh addressed some of the differences between non-relational (NoSQL) and relational Data Modeling practices. Some of the more pronounced differences that he discussed include: Roles: In various organizations, Data Modeling for NoSQL…

Embarcadero ER/Studio Data Architect Certified for HortonWorks Data Platform and MongoDB Enterprise

emb

by Angela Guess A new article out of the company reports, “Embarcadero Technologies, a leading provider of software solutions for application and database development, today announced that its data modeling tool, ER/Studio® Data Architect version 10.0, has been certified by HortonWorks for HortonWorks Data Platform (HDP) 2.1 and certified against MongoDB Enterprise for versions 2.4…

Designing Better Data Models for NoSQL Databases

books

by Angela Guess Jack Vaughan recently wrote for Search Data Management, “Typically built for speed and designed for specific purposes, NoSQL databases forgo the rigid database schemas of SQL-based relational software. As a result, they can be deployed quickly and adapted on the fly; in addition, they can handle data sets with diverse structures and…