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

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

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

AWS Big Data

JUNE 21, 2023

Amazon DynamoDB is a fully managed NoSQL service that delivers single-digit millisecond performance at any scale. We discuss data model design for both NoSQL databases and SQL data warehouses. We have used generic attribute names, PK and SK, for our partition key and sort key columns. We use the following table.

Data Warehouse 78

Data Warehouse Data Lake OLAP Cost-Benefit 78

Domino Data Lab

APRIL 3, 2019

Paco Nathan ‘s latest column dives into data governance. I introduced these themes in “ Three surveys of AI adoption reveal key advice from more mature practices ” and explored them in even more detail in “ Episode 7 ” of this column. One other note: some people ask why this includes so much detail about security.

Data Governance 84

Data Governance Machine Learning Metadata Big Data 84