SQL has limitations as it is built on relational concepts and relies on binary joins.
The future of databases is shifting towards relational knowledge graphs, allowing the flexibility to work with various data structures beyond tables.
Businesses are moving towards explicitly modeling busi... See more
Nicolay Geroldtwitter.comSQL has limitations as it is built on relational concepts and relies on binary joins. The future of databases is shifting towards relational knowledge graphs, allowing the flexibility to work with various data structures beyond tables. Businesses are moving towards explicitly modeling business semantics and logic, which are often stored in documents, messages, whiteboards, and various applications. For data analysis, SQL's slicing and dicing capabilities excel, but for detailed processing and graph-type operations, SQL databases fall short. Dynamic environments may benefit from alternatives to SQL.
Based on that, it may be easier to have different types of data in different physical tables so that they can be updated independently. It will save system resources by not having the overhead of a lot of extra metrics
Bill Franks • Taming The Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics (Wiley and SAS Business Series)
ad hoc SQL—not basic everyday SQL queries, but highly complex SQL queries that involve combining data sources in complex ways.
Bill Franks • Taming The Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics (Wiley and SAS Business Series)
Without knowing it, they use the wrong approaches to design and develop their DW environments, which results in mistakes that compromise quality and performance.
Steve Williams • The Profit Impact of Business Intelligence
Because of its superior price performance, some companies are even betting on Hadoop as a data warehouse replacement, in some cases also using familiar SQL query languages in order to make big data more consumable for business users.