As cloud services gain in popularity, Snowflake has grown into one of the premier platforms for data warehouses in the cloud. Data professionals who design and manage Snowflake data warehouses can use ER/Studio to capture organizational requirements, translate requirements into design, and deploy the design to Snowflake. Join IDERA for a demonstration on how ER/Studio’s […]
Generally Accepted Data Modeling Principles
Click to learn more about author Thomas Frisendal. What can data modelers learn from accountants? Accounting is a solidly established practice that the world cannot live without. One of the established guidelines for accountants is called GAAP (Generally Accepted Accounting Principles in the US), and there are similar international setups. You might guess these standards […]
On the Business Value of a Conceptual Data Policy Definition
Click to learn more about author Daniele Gianni. Concerns on the collection, use, and dissemination of data are central to many enterprises that directly deal with customer data to provide information services. These concerns originated from an increasing awareness of the value of privacy as well as recent government regulations, not only aiming to protect […]
How to Overcome the Challenges of Using a Data Vault
Click to learn more about author Eva Murray. What Are the Challenges? From flexibility to scalability and efficiency, using a data vault as your Data Modeling approach has many benefits. But simultaneously there are challenges that you need to be aware of. In this blog I’m going to walk you through the limitations and how […]
Learning from Complex Data Modeling Practices
Click to learn more about author Thomas Frisendal. Now is a good point in time to look at best practices in database design for SQL databases. Are there things that could have been easier to do if the SQL designers had had absolute foresight? Of course, the answer is yes. But what is most important […]
Knowledge Graphs: A Single Source of Truth for the Enterprise
Click to learn more about author Dr. Jans Aasman. The notion of a “single source of truth” for the enterprise has been the proverbial moving goalpost for generations of CIOs, only to be waylaid by brittle technology and unending legacy systems. Truth-seeking visions rebuffed by technological trends have continuously confounded business units trying to achieve growth […]
What Is a Data Modeler?
A data modeler is a person who models data or documents software and business system designs. By doing this, a data modeler translates business needs into technical specifications. Developers and other IT members benefit from this when creating new data systems and troubleshooting and maintaining them. Data models promote consensus among developers, customers, and other […]
Enterprise Data Literacy: Understanding Data Management
To truly understand data-as-an-asset requires Enterprise Data Literacy, an organizational capability to take, analyze, and use data to remain secure and competitive. But achieving a high Enterprise Data Literacy can remain daunting when business and IT interact together. All too often in the middle of a project sprint, IT gets stuck on a minor problem, […]
To Grok or Not to Grok Data Models: A Summer Special
Click to learn more about author Thomas Frisendal. We need something light – yet still important – to ease our minds in the summertime. As a data modeler I have often experienced serious disconnects between not only business people and myself, but also between the real world and the vocabulary and definitions attributed to it. […]
So You Want to Be a Data Modeler?
There is a always a need for data modelers, however, the job description of this career field varies, depending on the needs of the organization. For example, a data modeler working for a startup would coordinate with data scientists and data architects in designing a new system — one that included the goals of the […]