Kinaxis - Database, Data Management and Modeling

 

1. Understanding data tables and structures

2. Loading, mapping, and validating data

3. Managing master and transactional data

We built a database!

By Angela Lin

20 Oct 2021

https://www.kinaxis.com/en/blog/we-built-database

We're a simulator, not just a database

For concurrent planning, we don't need just a database – we need a simulator. Our database engine provides a robust and efficient platform for teams of planners to rapidly simulate and share multiple "what-if" scenarios. Planners get safe sandboxes where they can work with real data. They can change planning parameters and get immediate feedback on their impact.

To meet these needs, our database engine has these unique features:

         Data branches

         Analytics integration

         Hybrid data model.

Data branchesDiagram of data branching sequence

Our database engine acts like a version control system for data. It's like Git, but for data instead of code. And just like Git, we can “branch” the database. For example, a "what-if" scenario is a branch. With our database engine, we can create new scenarios (branches) instantly. We can pin a historical view of the data using a scenario. We can compare data across different scenarios. We can sandbox unconfirmed changes using a private scenario. Concurrent data changes can be committed safely using a well-defined procedure for resolving scenario conflicts.

Analytics integration

We integrate analytics algorithms directly into our database. These algorithms have direct memory access to the database data, which enables them to compute at maximum speed without extra data copying costs. Database data is structured in memory for optimal access by algorithms, and we can also work with algorithm output as if it were database data.

Hybrid data model

We use a purpose-built hybrid data model that combines the best of relational, network and graph databases. We can represent all the data and relationships in the supply chain – operations, finance, distribution, etc. – in a cognitive network graph model that allows enterprises of all sizes to replicate their business into multiple digital twins.

https://www.linkedin.com/posts/kamal-dutt-49a6128_rapidresponse-scm-master-data-what-is-rapidresponse-share-7441690170631966722-3IQj/

https://www.linkedin.com/posts/goutham-gunashekar_kinaxis-rapidresponse-concurrentplanning-share-7393889114057658368-QbIe/