Loading...
You are here:  Home  >  Data Education  >  Data Modeling News, Articles, & Education  >  Data Modeling Blogs
Latest

Enterprise Data Modeling

By   /  May 12, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about author Michael Blaha. It’s important to have data models guide the development of individual applications and ensure that they meet business objectives. But it’s not sufficient. Other kinds of data models, such as enterprise data models, are also part of proper Data Governance. What Is an Enterprise Data Model? An […]

Read More →
Latest

Data Cataloging vs. Data Modeling: Reporting from EDW2017

By   /  May 1, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, Conference and Webinar Communities, Data Blogs | Information From Enterprise Leaders, Data Conference Communities - Learn, Share, Review, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education, Enterprise Data World Conference Community, Enterprise Information Management, Information Management Blogs, NoSQL Now! Conference Community  /  No Comments

The Enterprise Data World 2017 Conference in Atlanta in the beginning of April was one of the best I have attended in recent years. At least 50 sessions for a guy like me interested in modeling. I chose to focus on sessions possibly related to Data Modeling in the new worlds of NoSQL, Big Data […]

Read More →
Latest

Identity: Working with Surrogate Keys

By   /  April 14, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  2 Comments

Click to learn more about author Michael Blaha. Identity is the means for denoting individual entities, so that they can be found. Identity is a prominent concern for databases because developers must have some way for referring to things. There are two aspects of identity – how to connect records together (internal identity) and how […]

Read More →
Latest

Surrogate Keys: Paving the Way for Graph / NoSQL Data Models

By   /  April 3, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about video blogger Thomas Frisendal. Since the mid-seventies many SQL-databases have been modeled using the concept of surrogate keys: Non-information bearing primary keys Used for join purposes (inter-table relationships) System generated (integer) values Not to be shown to end-users The advantage of using surrogate keys is guaranteed persistence, even across changes in […]

Read More →
Latest

Softcoded Data

By   /  February 27, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about author Michael Blaha. Database applications typically have a direct representation. Application concepts are represented as tables with their attributes stored as table columns. This direct approach works well for applications with fixed structure. However, it fails for applications with structure that is not fully known as the application is being built. […]

Read More →
Latest

Artificial Intelligence vs. Human Intelligence: Hey Robo Data Modeler!

By   /  February 8, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Smart Data Blogs, Smart Data News, Articles, & Education  /  No Comments

Click to learn more about author Thomas Frisendal. In the data space plenty of new terms are being coined (by marketing?) for handling data modeling, governance and quality issues: “data preparation”, “data wrangling”, “data catalogue” and “machine-based data harmonization” (™ of ClearStory Data). Do we need stuff like this? Definitely so. Today we need to move […]

Read More →
Latest

Six Key Principles to Accelerate Data Preparation in the Data Lake

By   /  January 30, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, Data Architecture Blogs, Data Architecture News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  No Comments

Click to learn more about author Paul Barth. In the digital economy, most companies are looking to significantly increase their use of data and analytics for competitive advantage. Many are making investments in new technologies like Hadoop that promise the speed and flexibility they need, and early pilots look promising.  However, companies are struggling to scale […]

Read More →
Latest

Debugging Complex SQL Queries

By   /  January 25, 2017  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  2 Comments

Click to learn more about author Michael Blaha. We favor the offloading of application logic to SQL queries. Developers can save time, effort, and reduce mistakes by substituting SQL for programming code. This leads to lengthy and complex SQL that must be debugged. It is common to write a SQL query that initially fails to execute. […]

Read More →
Latest

Database Reflections: Ten Things to Consider

By   /  January 9, 2017  /  Big Data Blogs, Big Data News, Articles, & Education, Data Architecture Blogs, Data Architecture News, Articles, & Education, Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Data Strategy Blogs, Data Strategy News, Articles, & Education, Database Blogs, Database News, Articles, & Education, Enterprise Information Management, Information Management Blogs  /  2 Comments

Click here to learn more about author Michael Blaha. I’m going to do something different this month and reflect on some observations of the IT industry. My comments will focus on database-related topics. This is a smattering of ideas that is not intended to be comprehensive. I’m hoping that this article will stimulate dialogue. I […]

Read More →
Latest

Visual Normalization – Use the Power of the Dependencies

By   /  December 14, 2016  /  Data Blogs | Information From Enterprise Leaders, Data Education, Data Modeling Blogs, Data Modeling News, Articles, & Education, Database Blogs, Database News, Articles, & Education  /  1 Comment

Click to learn more about author Thomas Frisendal. One of the major contributions of Dr. Ted Codd’s relational model is the focus on the importance of functional dependencies. In fact, normalization is driven by a modeler’s desire for a relation where strict functional dependency applies across all the binary relations between the designated primary key and […]

Read More →