erwin Expert Blog

There’s debate surrounding the term “logical data warehouse.” Some argue that it is a new concept, while others argue that all well-designed data warehouses are logical and so the term is meaningless. This is a key point I’ll address in this post. I’ll also discuss data warehousing that incorporates some of the technologies and approaches...

Read More

A common question in the modern data management space involves database technology: SQL, NoSQL or NewSQL? But there isn’t a one-size-fits-all answer. What’s “right” must be evaluated on a case-by-case basis and is dependent on data maturity. For example, a large bookstore chain with a big-data initiative would be stifled by a SQL database. The...

Read More

With the volume and velocity of data increasing, in-memory databases provide a way to keep processing speeds low. Traditionally, databases have stored their data on mechanical storage media such as hard disks. While this has contributed to durability, it’s also constrained attainable query speeds. Database and software designers have long realized this limitation and sought...

Read More

There’s no escaping data’s role in the cloud, and so it’s crucial that we analyze the cloud’s impact on data modeling. 

Read More

With GDPR regulations imminent, businesses need to ensure they have a handle on data governance.

Read More

As the amount of data enterprises are tasked with managing increases, making NoSQL technology adoption a priority is a must.

Read More

More and more businesses are adopting managed data lakes. Earlier in this blog series, we established that leading organizations are adopting a variety of approaches to manage data, including data that may be sourced from a wide range of NoSQL, NewSQL, RDBMS and unstructured sources. In this post, we’ll discuss managed data lakes and their...

Read More

NoSQL database technology is gaining a lot of traction across industry. So what is it, and why is it increasing in use? Techopedia defines NoSQL as “a class of database management systems (DBMS) that do not follow all of the rules of a relational DBMS and cannot use traditional SQL to query data.” The rise...

Read More

In the first two posts of this series, we focused on the “volume” and “velocity” of Big Data, respectively.  In this post, we’ll cover “variety,” the third of Big Data’s “three Vs.” In particular, I plan to discuss NoSQL and NewSQL databases and their implications for data modeling. As the volume and velocity of data...

Read More

The multi-tenancy vs. single-tenancy hosting debate has raged for years. Businesses’ differing demands have led to a stalemate, with certain industries more likely to lean one way than the other. But with advancements in cloud computing and storage infrastructure, the stalemate could be at the beginning of its end. To understand why multi-tenancy hosting is...

Read More