Database_management_system

HyperMorph

Operational Python API for information management and data transformations-analytics on Associative Semiotic Hypergraph Development Framework

50 Years of SQL, can you imagine a truly NoSQL approach ?

Table of Contents Introduction Two programming paradigm approaches for a NoSQL API Functional operations A glimpse from the future Epilogue Cross-References Introduction In a decade of investigating NoSQL systems, I noticed a huge effort from many vendors to create SQL compatible APIs. Yes, there is a pretty good reason behind this tendency to walk-the-line as usual. Everybody has learned to program in SQL, everybody knows how to access a DBMS using SQL.

Helicopter view of Graph Networks in DBMS

Table of Contents Introduction The new brave age of hyperlinked data Technical questions for hyperlinking data Physical Layer Logical Layer Conceptual layer By reference vs. by value Cross-References Introduction Normally IT people including architects, engineers, scientists and developers are forced to think a particular implementation of an application or a business solution in terms of the query language. Generally speaking most often it is the specific technology and infrastructure behind the scene that dictates how things should be done.

TRIACLICK 2nd Release

Second release of TRIACLICK on ClickHouse and MariaDB DBMS

About data granularity

Table of Contents Introduction Information Conceptual, computational semiotics framework Push forward Cross-References Introduction In computer science there are many things we take for granted like the fundamental digital representation of anything with 1s and 0s. It’s often too easy to forget that when you have dived deep into the virtual realm of a computer the only thing you get is a mere representation of abstract concepts. This is our data and because they live in a machine and its peripherals they always have structure no matter how you interpret them.

Where is the gap in data modeling ?

Table of Contents Introduction Business vs Technological Factors Cross-References Introduction I was motivated to write this post from an article of Christian Kaul “Bridging the Knowledge Gap”. He is making questions about how, what is the best way to bridge the knowledge gap between data modeling experts and people from other fields ? But I think an important role that data modeling experts play is exactly that to bridge the gap between pure IT technical people like developers, database administrators, data engineers and people from other fields e.

TRIACLICK 1st Release

First release of TRIACLICK on ClickHouse and MariaDB DBMS

TRIADB

Data Management & Analytics Python API enables users to perform easily integration, correlation, aggregation and hypergraph exploration of multiple data resources

Cache Python ORM

CacheORM module is an enhanced OOP porting of Intersystems Cache-Python binding. Three classes are implemented CacheClient, CacheQuery and CacheClass.

Yet another query language, really ?

Table of Contents Introduction Cross-References Introduction Recently, I have been reading an article for yet another query language, HypergraphQL. But do we really need another query language ? I do agree that it is always good to offer the developer a variety of choices for querying a database, especially if the new query language makes it easier or perhaps better in some sense to fetch or input data.

Back to the roots, Relational Data Model

Important design and implementation principle arising from studying relational data model theory

TRIADB at Connected Data London

TRIADB associative, semiotic, hypergraph technology is an emerging unique and valuable technology in NoSQL database modelling and BI analytics. TRIADB prototype is founded on R3DM/S3DM conceptual model and it was implemented on top of Intersystems …

Are our old data model standards out of shape ?

Both Topic Maps and RDF/OWL exhibit signs of aging. These signs do not indicate maturity levels but on the contrary they signal a re-examination of the data modeling, information representation problem

The three dimensions of AI and a fourth one as the key to unlock them

Although there has been significant progress with first and second generation AI systems in reasoning, learning and perceiving, abstraction has not been part of the game. The mechanism of abstraction can unify these other three processes

Associative Semiotic Hypergraph API in Mathematica for Next-Generation BI Systems

A new data modeling framework R3DM/S3DM that is implemented on top of OrientDB graph database and coded in Wolfram Mathematica

Many-to-Many Relationships

Associative entities are represented differently in various data models

Associative Semiotic Hypergraph based on R3DM/S3DM

The last part (6/6) of a series demonstrating Associative Semiotic Hypergraph technology

Data Modelling Topologies of a Graph Database

The associative data graph database model is still a heavy hitter, stacking up well against property graphs and triples/quadruples. Expect a comeback

A Quick Guide on How to Prevail in the Graph Database Arena

A swift introduction to the key factors that influence the performance and unification character of graph databases

Qlik Associative Model

Part 5/6 of the series Associative Data Modelling Demystified

Association in RDF Data Model

Part 4/6 of the series Associative Data Modelling Demystified

Association in Property Graph Data Model

Part 3/6 of the series Associative Data Modelling Demystified

Association in Topic Map Data Model

Part 2/6 of the series Associative Data Modelling Demystified

Relation, Relationship and Association

Part 1/6 of the series Associative Data Modelling Demystified

Know-How is How you Know

Table of Contents Introduction The Problem About Knowledge The Know-How is how you know The “I know something or someone” phrase The “I know this is true” phrase Epilogue Cross-References Introduction Perhaps there is not a better phrase to start this post than the Socratic paradox, All I know is that I know nothing This is typical of the great gap that exists between Eastern and Western way of thinking about fundamental concepts such as information, knowledge and wisdom.

From Declarative to Functional Database Operations

SQL CRUD RESTful Transformations in Mathematica and OrientDB

RESTful API in Mathematica

Wolfram Language packages that extend functionality for RESTful APIs. It has been fully tested and documented for OrientDB multi-model database.

OrientDB Mathematica Package

Overview The main function of this Mathematica package, ODBapi, is built on top of the URLFetch built-in function. OrientDB RESTful HTTP API commands are ported into Wolfram Language through URLFetch and then ODBapi commands are built with arguments that specify options with rules of the form name -> value. This package has also other utility functions especially implemented for OrientDB. OrientDB Package is part of the Wolfram API application project. Visit the official page of the project for installation and testing instructions.

AtomicDB Mathematica AddOn (ADBM)

AtomicDB API in Mathematica

Why Google shuts down Freebase ?

Freebase, the best collaborative information management system ever built

The number '3' and The Three-Faceted Abstraction Mechanism in R3DM

Part 3/3 - Towards a New Data Modelling Architecture

Atomic Information Resource (AIR)

Part 2/3 - Towards a New Data Modelling Architecture

Relational/ER Constructs in Wolfram Language

Part 1/3 - Towards a New Data Modelling Architecture