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 […]
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. […]
erwin Releases New Version of Industry-Leading Data Modeling Solution
by Angela Guess A recent press release reports, “erwin Inc., the data management experts, today announced the availability of a new version of erwin DM™, the company’s market-leading data modeling solution used by more than 50,000 professionals around the world. The new erwin DM solution effectively models and governs any data assets stored anywhere for […]
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) […]
Database Reflections: Ten Things to Consider
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 […]
New Esri ArcGIS Release Transforms Spatial Analytics
by Angela Guess According to a new press release, “Esri, the global leader in spatial analytics technology, today announced the release of Esri ArcGIS 10.5, the next-generation analytics technology for innovative organizations. Esri ArcGIS 10.5 arrives at a time when organizations worldwide are challenged to make sense of real-time digital information. The release helps them […]
Visual Normalization – Use the Power of the Dependencies
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 […]
LDM Webinar: Data Modeling for XML and JSON
To view just the slides from this presentation, click HERE>> About the Webinar Data modeling has traditionally focused on relational database systems. But in the age of the internet, technologies such as XML and JSON have evolved to provide structure and definition to “data in motion”. Have data modeling technologies evolved to support these technologies? […]
LDM Slides: Data Modeling for XML and JSON
LDM Slides: Data Modeling for XML and JSON from DATAVERSITY To view the On Demand recording of this presentation, click HERE>> About the Webinar Data modeling has traditionally focused on relational database systems. But in the age of the internet, technologies such as XML and JSON have evolved to provide structure and definition to “data […]
Jan 26 LDM Webinar: How Data Modeling Fits into an Overall Enterprise Architecture
DATE: January 26, 2017 This webinar has passed. The recording is available On Demand. TIME: 2 PM Eastern / 11 AM Pacific PRICE: Free to all Attendees 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 […]