The new ISO 39075 Graph Query Language Standard is to hit the data streets in late 2023 (?). Then what? If graph databases are standardized pretty soon, what will happen to SQL? They will very likely stay around for a long time. Not simply because legacy SQL has a tremendous inertia, but because relational database paradigms […]
A Guide to Time Series Databases
Time series databases (or TSDBs) are databases that have been optimized for processing time series data. Time series data is made up of data records that are indexed using timestamps. The timestamps provide a reference for each of the data records and show how they relate to one another in time. An example of time […]
7 Key Features of Data Management Systems
Data Management is the practice of gathering, organizing, securing, and storing data for an organization so it can be analyzed for business decisions. Data Management helps minimize potential errors by setting processes and policies around its usage and building confidence in the data used for decision-making throughout the company. Businesses implement Data Management systems to ensure that data […]
Data Modeling 101
Data Modeling creates a visual representation of a data system as a whole or as parts of it. The goal is to communicate the kinds of data being used and saved within the system. A data model should also show the data’s relationships, how the data can be organized, and the formats used. A data model can […]
Say Hello to Graph Normal Form (GNF)
You thought you knew all normal forms? (And possibly also some abnormal …) Well, think again: There is also “graph normal form (GNF).” The diagram below is a fifth normal form graph concept model, which is just a few steps from GNF, so hang on: Where GNF comes from GNF is based on serious mathematics, […]
Data Modeling Techniques and Best Practices
Data models play an integral role in the development of effective data architecture for modern businesses. They are key to the conceptualization, planning, and building of an integrated data repository that drives advanced analytics and BI. In this blog post, we’ll provide you with an overview of the most popular data modeling techniques and best practices to […]
Data Modeling and Data Models: Not Just for Database Design
“The main purpose of a data model is actually not to design a database—it’s to describe a business,” said Christopher Bradley, information strategist at DMA Advisors. Bradley spoke at the DATAVERSITY® Data Architecture Online conference about the purpose of Data Modeling and its role in Data Governance and the modern successful business. Big Data: Are […]
Data Modeling Tools
Data Modeling tools assist in creating a data model. Data Modeling was initially the process of creating a framework within a database that allowed data to be stored and researched using the data’s relationships. However, the term “Data Modeling” has expanded to include software engineering. A well-designed database (or app) makes the system more efficient, reduces […]
The Rise of the Semantic Layer
Cloud giants like Google and Snowflake, unicorns like dbt Labs, and a host of venture-backed startups are now talking about a critical new layer in the data and analytics stack. Some call it a “metrics layer,” or a “metrics hub” or “headless BI,” but most call it a “semantic layer.” I prefer to call it a “semantic layer” because it best describes a business-friendly interface […]
A Beginner’s Guide to Data Modeling and Analytics
As more and more companies start to use data-related applications to manage their huge assets of data, the concepts of data modeling and analytics are becoming increasingly important. While they typically rely on one each, they are two very distinct concepts. Companies use data analysis to clean, transform, and model their sets of data, whereas they […]