Metadata Recycling into Graph Data Models
Metadata Recycling into Graph Data Models
The Guide to Data Model Recycling using Neo4j
About the Book
What if the database died some years ago, but you still have an old UML or XML file with the model in it. And you need to model the same domain for graph data bases? This is one of the scenarios this book intends to help you with.
There are 70+ ERD-supporting tools and 50+ UML tools, many of which are also used for data modeling. That translates to a lot of data models. Can they be "recycled", also in agile projects? There must be hundreds of thousands of good, reusable data models! Why waste such a large resource of business metadata?
Much similar to data science we have a need to (call it "Metadata Science") read, transform, scope / reduce / enhance and adapt data models to modern database technologies. Not least graph databases, if you ask me.
This book explains how to do that. Cypher®-scripts are included for Concept Maps (CmapTools®), CSDL, XML Schemas, StarUML v1 and UML® via various XMI® formats. The most recent addition is FileMaker® data models.
The book also explains how to optionallay build a simple graph-based metadata repository, which has full lineage back to the source data model, and it supports identities, uniqueness, mandatory fields and basic datatypes.
Cypher-scripts for repository handling are indeed also part of the book (under a MIT license).
We suggest a choice of two approaches:
- Fast Track Data Models (agile)
- Super Data Models (crafted, using the repository.
Looking for a graph database modeling tool? Now, everything you need for recycling of data models is available inside this book. 50+ scripts (and growing) plus the repository model providing data lineage.
Any inquiries about this book and the scripts can be sent to @VizDataModeler (info at graphdatamodeling dot com).
Table of Contents
- Introduction
- Acknowledgements
-
Overview of the Value Proposition of Recycling Metadata
- Concerns Drive Full Scale Data Modeling
- Full Scale Data Architecture
-
The Atoms and Molecules of Data Models
- Entity-Relationship Modeling
- Relational and SQL
- Object Orientation and UML®
- Graph Data Models
- Object Role Modeling (a.k.a. Fact Modeling)
- The Key Things
- The Universal Constituent Parts of Data Models
-
The Process of Generating Data Models
- The Mechanics
- Designing a Flexible Approach
-
Super Data Models
- Load & Transform
- Subset to get the Solution Model
- Extend the Solution Model
- Transform to get a Physical Model
- Optimize the Database
-
Fast Track Data Models
- Load & Transform
- Auto-generate a Physical Model
- Optimize the Database
-
Build Your Own Metadata Repository
- The Repository on One Page
- Concept Models
- Solution Models
- Physical Models
- Lineage in the repository
- Metadata details
-
Concept Maps (CmapTools®) as Graph Data Models
- About Concept Maps
- Load & Transform Concept Maps
- The Cookbook for Concept Maps
- From Concept Model to Super Data Model or Fast Track?
-
Conceptual Schemas in OData CSDL Format
- About CDSL, Common Schema Definition Language from OASIS
- Looking at the CSDL file
- Building the Concept Model from the CSDL Model
-
FileMaker® Database Report in XML
- About FileMaker® and XML
- Looking at the XML-file
- Final adjustments
-
XML Schemas from the W3C
- About XML Schemas
- Looking at the XSD (XML) file
- Building the Concept Model from the XSD Model
-
StarUML ERD Models
- About StarUML
- Looking at the UML (XML) file
- Building the Concept Model from the UML® ERD Model
-
UML® as XMI® the Eclipse UML 2.0 Way
- About UML® and XMI® and Eclipse UML
- The example: A Github Project about Carparks
- Looking at the XMI®-file
- Building the concept model from the UML® model
-
UML® as XMI® the EA Way
- About UML® and XMI® and EA
- The example: Open, Public Data
- Looking at the XMI®-file
- Building the concept model from the UML® model
-
Addendum: Improving Metadata Quality
- The Business is King
- Data Names Matter
- Finding Standard Data Structures
- Establishing Identity and Uniqueness
- Presenting the Business Flow
- Presenting the Keys
- Presenting State Changes
- Presenting Versions of Data
- Housekeeping Proper
- Scalar Data Types
- Time Zones
- Design is Decisions
- Which Objects and Which Relationships?
- Presenting Relationships and Missing References
- Presenting the Right Level of Detail
- Good Relationships
- Identity, Uniqueness and Keys Revisited
- Missing Information
- Other books by Thomas Frisendal
The Leanpub 60-day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
See full terms
80% Royalties. Earn $16 on a $20 book.
We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earned$12,307,240writing, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
Top Books
OpenIntro Statistics
David Diez, Christopher Barr, Mine Cetinkaya-Rundel, and OpenIntroA complete foundation for Statistics, also serving as a foundation for Data Science.
Leanpub revenue supports OpenIntro (US-based nonprofit) so we can provide free desk copies to teachers interested in using OpenIntro Statistics in the classroom and expand the project to support free textbooks in other subjects.
More resources: openintro.org.
Personal Finance
Jason AndersonThis textbook provides an in-depth analysis on personal finance that is both practical and straightforward in its approach. It has been written in such a way that the readers can gain knowledge without getting overwhelmed by the technical terms. Suitable for both beginners and advanced learners.
Getting to Know IntelliJ IDEA
Trisha Gee and Helen ScottIf we treat our IDE as a text editor, we are doing ourselves a disservice. Using a combination of tutorials and a questions-and-answers approach, Getting to Know IntelliJ IDEA will help you find ways to use IntelliJ IDEA that enable you to work comfortably and productively as a professional developer.
C++20 - The Complete Guide
Nicolai M. JosuttisAll new language and library features of C++20 (for those who know previous C++ versions).
The book presents all new language and library features of C++20. Learn how this impacts day-to-day programming, to benefit in practice, to combine new features, and to avoid all new traps.
Buy early, pay less, free updates.
Other books:
Mastering STM32 - Second Edition
Carmine NovielloWith more than 1200 microcontrollers, STM32 is probably the most complete ARM Cortex-M platform on the market. This book aims to be the most complete guide around introducing the reader to this exciting MCU portfolio from ST Microelectronics and its official CubeHAL and STM32CubeIDE development environment.
R Programming for Data Science
Roger D. PengThis book brings the fundamentals of R programming to you, using the same material developed as part of the industry-leading Johns Hopkins Data Science Specialization. The skills taught in this book will lay the foundation for you to begin your journey learning data science. Printed copies of this book are available through Lulu.
Machine Learning Q and AI
Sebastian Raschka, PhDHave you recently completed a machine learning or deep learning course and wondered what to learn next? With 30 questions and answers on key concepts in machine learning and AI, this book provides bite-sized bits of knowledge for your journey to becoming a machine learning expert.
Stats One
William FooteThe Rails 7 Way
Obie Fernandez, Lucas Dohmen, and Tom Henrik AadlandThe Rails™ 7 Way is the comprehensive, authoritative reference guide for professionals delivering production-quality code using modern Ruby on Rails. It illuminates the entire Rails 7 API, its most powerful idioms, design approaches, and libraries. Building on the previous editions, this edition has been heavily refactored and updated.
Gradual Modularization for Ruby and Rails
Stephan HagemannGet yourself a new tool to manage your Rails application and your growing engineering organization! Prevent the ball-of-mud (and fix it!). Go for microservices or SOA if it makes sense not just because you don't have any other tool. Do all this through a low-overhead tool: packages. Enable better conversations to make practical changes today.
Top Bundles
- #1
Software Architecture
2 Books
"Software Architecture for Developers" is a practical and pragmatic guide to modern, lightweight software architecture, specifically aimed at developers. You'll learn:The essence of software architecture.Why the software architecture role should include coding, coaching and collaboration.The things that you really need to think about before... - #2
CCIE Service Provider Ultimate Study Bundle
2 Books
Piotr Jablonski, Lukasz Bromirski, and Nick Russo have joined forces to deliver the only CCIE Service Provider training resource you'll ever need. This bundle contains a detailed and challenging collection of workbook labs, plus an extensively detailed technical reference guide. All of us have earned the CCIE Service Provider certification... - #3
1500 QUIZ COMMENTATI (3 libri)
3 Books
Tre libri dei QUIZ MMG Commentati al prezzo di DUE! I QUIZ dei concorsi ufficiali di Medicina Generale relativi agli anni: 2000-2001-2003-2012-2013-2014-2015-2016-2017-2018-2019-2020-2021 +100 inediti Raccolti in unico bundle per aiutarvi nello studio e nella preparazione al concorso. All'interno di ogni libro i quiz sono stati suddivisi per... - #4
Pattern-Oriented Memory Forensics and Malware Detection
2 Books
This training bundle for security engineers and researchers, malware and memory forensics analysts includes two accelerated training courses for Windows memory dump analysis using WinDbg. It is also useful for technical support and escalation engineers who analyze memory dumps from complex software environments and need to check for possible... - #5
Practical FP in Scala + Functional event-driven architecture
2 Books
Practical FP in Scala (A hands-on approach) & Functional event-driven architecture, aka FEDA, (Powered by Scala 3), together as a bundle! The content of PFP in Scala is a requirement to understand FEDA so why not take advantage of this bundle!? - #6
Modern C++ Collection
3 Books
Get All about Modern C++C++ Standard Library, including C++20Concurrency with Modern C++, including C++20C++20Each book has about 200 complete code examples. Updates are included. When I update one of the books, you immediately get the updated bundle. You can expect significant updates to each new C++ standard (C++23, C++26, .. ) and also... - #7
Linux Administration Complet
4 Books
Ce lot comprend les quatre volumes du Guide Linux Administration :Linux Administration, Volume 1, Administration fondamentale : Guide pratique de préparation aux examens de certification LPIC 1, Linux Essentials, RHCSA et LFCS. Administration fondamentale. Introduction à Linux. Le Shell. Traitement du texte. Arborescence de fichiers. Sécurité... - #9
Development and Deployment of Multiplayer Online Games, Part ARCH. Architecture (Vol. I-III)
3 Books
What's the Big Idea? The idea behind this book is to summarize the body of knowledge that already exists on multiplayer games but is not available in one single place.And quite a fewof the issues discussed within this series (planned as three nine volumes ~300 pages each), while known in the industry, have not been published at all (except for... - #10
Growing Agile: The Complete Coach's Guide
7 Books
Growing Agile: Coach's Guide Series This bundle provides a collection of training and workshop plans for a variety of agile topics. The series is aimed at agile coaches, trainers and ScrumMasters who often find themselves needing to help teams understand agile concepts. Each book in the series provides the plans, slides, handouts and activity...