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 […]
A Primer to Optimizing Your Apache Cassandra Compaction Strategy
When setting up an Apache Cassandra table schema and anticipating how you’ll use the table, it’s a best practice to simultaneously formulate a thoughtful compaction strategy. While a Cassandra table’s compaction strategy can be adjusted after its creation, doing so invites costly cluster performance penalties because Cassandra will need to rewrite all of that table’s data. Taking […]
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 […]
Primary Data Modeling Techniques
Data Modeling techniques are used to create a map or blueprint showing how an organization gathers and processes data. Data models help to define the logical structure for an organization’s data. Data Modeling techniques are necessary for businesses wanting to maximize and streamline their ability to analyze and understand data. While developing the model, the […]
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, […]
DataEd Slides: Conceptual vs. Logical vs. Physical Data Modeling
Conceptual vs. Logical vs. Physical Data Modeling from DATAVERSITY To view the on-demand recording from this presentation, click HERE>> This webinar is sponsored by: About the Webinar A model is developed for a purpose. Understanding the strengths of each of the three Data Modeling types will prepare you with a more robust analyst toolkit. The program […]
DataEd Webinar: Conceptual vs. Logical vs. Physical Data Modeling
To view just the slides from this presentation, click HERE>> This webinar is sponsored by: About the Webinar A model is developed for a purpose. Understanding the strengths of each of the three Data Modeling types will prepare you with a more robust analyst toolkit. The program will describe modeling characteristics shared by each modeling […]
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 […]