Advertisement

Softcoded Data

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. […]

Erwin’s End Game: Holistic Data Management

Data Management vendor erwin Inc. has been following through on the plans it discussed with DATAVERSITY® last year, shortly after its acquisition from CA Technologies by private equity firm Parallax Capital Partners. Its efforts to bring together Data Modeling, Business Process Management, and Enterprise Architecture domains to support the data-driven enterprise have been in evidence with its acquisitions […]

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

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 […]

LDM Slides: How Data Modeling Fits into an Overall Enterprise Architecture

LDM Slides: How Data Modeling Fits into an Overall Enterprise Architecture from DATAVERSITY To view the On Demand recording of this presentation, click HERE>>   About the Webinar Enterprise Architecture (EA) provides a visual blueprint of the organization, and shows key interrelationships between data, process, applications, and more.  By abstracting these assets in a graphical […]

Debugging Complex SQL Queries

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. […]

SQL versus NoSQL Databases: A Review of Key Themes

Non-relational databases (aka NoSQL), in many different variations, have become a popular database model for handling Big Data. They use two novel concepts, making them different from earlier, “classical” database models. The concepts having so much impact are horizontal scaling, spreading out the storage and work, and eliminating the use of “Structured Query Language” (SQL) […]