erwin

AUGUST 15, 2022

For NoSQL, data lakes, and data lake houses—data modeling of both structured and unstructured data is somewhat novel and thorny. This blog is an introduction to some advanced NoSQL and data lake database design techniques (while avoiding common pitfalls) is noteworthy. But what exactly does NOSQL mean? Look at Figure 1 below.

Data Lake 52

Data Lake Modeling Unstructured Data Data Warehouse 52

erwin

MAY 2, 2022

In fact, many current development efforts are opting for the newer, NoSQL databases (which I’ll cover in a subsequent blog, but are shown below in Figure 2 for context). For example, the NoSQL database MongoDB has documents and collections instead of tables and columns. Figure 2: Popular NoSQL database types.

Modeling 98

Modeling Insurance Cost-Benefit Data Warehouse 98

Cloudera

SEPTEMBER 1, 2022

There are two things to note here when considering flexibility. First, COD provides both NoSQL and SQL approaches to querying data. Developers can choose three different modes of operation: key-value, wide-column, or relational wide-column using either our No-SQL client (Java APIs) or JDBC/ODBC.

Snapshot 80

Snapshot Enterprise Machine Learning Management 80

AWS Big Data

NOVEMBER 17, 2023

Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database designed to run high-performance applications at any scale. Table metadata, such as column names and data types, is stored using the AWS Glue Data Catalog. The scalability and flexible data schema of DynamoDB make it well-suited for a variety of use cases.

Visualization 81

Visualization Metadata Testing Internet of Things 81

Cloudera

DECEMBER 15, 2020

NoSQL databases loosened one or more of these 4 properties to achieve dramatic improvements in scalability — Cloudera Operational Database (Powered by Apache HBase) was one such database. To compensate, we supported very wide tables (with potentially millions of columns). Preliminary performance results.

Snapshot 65

Snapshot Testing Management Measurement 65

erwin

SEPTEMBER 5, 2022

Well, erwin offers a simple way to do that instead as shown below (note that I chose Snowflake this time): Figure 6: Creating a new data model for Redshift in erwin Data Modeler. Look just under the target selection circled in red, note the four check boxes currently disabled. Examples of bad database design choices.

Modeling 52

Modeling Cost-Benefit Testing Data-driven 52

erwin

JULY 2, 2020

This user also noted, “I use the automatic diagramming features a lot. an EDW architect/data modeler who uses erwin DM at Royal Bank of Canada, works on diverse platforms, including Microsoft SQL Server, Oracle, DB2, Teradata and NoSQL. We do conceptual data modeling, which is very high-level and doesn’t have columns and tables.

Enterprise 122

Enterprise Modeling Metadata Data Governance 122