Data warehouse
Why is building a data warehouse so different from the Relavance software?
For the first time, Relavance is bringing to market a technology that attains the ultimate goal in data management. It is the only truly associative atomic database model where each piece of information is atomic in nature and can be associated with any other piece of information.
There are NO restrictions, NO constraints, NO rows, NO views, and NO cubes.
​
Unlike linear database models, associative databases are in three dimensions by default and technically in (N) dimensions. The advantages are numerous and impressive:
​
-
Speeds over 100 times faster than SQL row/table queries.
-
Single instance storage - no piece of data is ever duplicated.
-
No tables or indexing.
-
Automated data aggregation—use any number of sources.
-
Unprecedented security—with no name-space or storage structure binding, there is nothing to hack into!
-
True agility when developing and maintaining.
Are most data warehouse projects a success?
When ingesting data all data streams are stored once in the system and are automatically associated.
By working with different data models you can create your own set of data, business definitions, and logic. E.g. Common data model, IFRS data model, AML data model, GDPR data model, and versions of previous data models can exist together without moving the data.
​
In Relavance the data and models are separated, but the total data storage is associated (related) to each other.
The end-user will be notified when changes to the database have been made and can decide what to use in the model.
Do data warehouse projects run over budget?
Any data sources can be added to the Relavance associative database. From structured relational databases, text-files to social media data. Converted files like Word, Pdf, and pictures, many ETL products can support you.
Relavance delivers a native connector to import data directly. Datavirtuality as an ETL vendor has +200 standard connectors.
​
How is this possible? Relavance stores and retrieves information much like the human brain.