erwin Expert Blog

It’s almost 2018, so there’s a good chance a portion of your business relies on the cloud. You’ve either moved some legacy systems there already, or you’re adopting entirely new, cloud-based systems – or both. But what about enterprise architecture for the cloud? After all, it’s the glue that helps tie all your disparate IT...

Read More

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