Software:Hackolade

From HandWiki
Hackolade
Hackolade
Stable release
v4 / April 2020; 4 years ago (April 2020)
Operating systemWindows, Mac, Linux
TypeDatabase modeling tool
License
Websitehackolade.com

Hackolade is a data modeling software tool created in 2016[1] to handle complex data structures such as JSON. Hackolade is used for the schema design of NoSQL databases as well as JSON stored in blobs of relational databases.[2] It can be used also to model for communication protocols, and Big Data storage formats.


Overview

Hackolade presents the data model through entity-relationship diagrams, which helps visualize the otherwise non-existent relationships across schema-less data.[3] The process of creating a diagram helps to understand what the data means and how the data elements relate together.[4]


Users draw extended entity relationship models or graphical visualizations of JSON Schema, which they can compile for a given NoSQL database system.[5]

The Hackolade tool has included functionality to generate code for the Mongoose mapper.[6]

Hackolade reverse-engineers a JSON document into a visual representation to show a structural hierarchy.[7]

It is useful not only in building models from scratch, but also in reverse engineering for SQL to JSON data modeling.[8] Hackolade supports the unique concepts of Cassandra CQL, such as partition keys and clustering columns, as well as data types, including collections and UDTs. It also provides the ability to create Chebotko diagrams.[9][10]

Hackolade supports the data modeling of node labels and relationship types for graph databases.[11]


Hackolade received certification for the Enterprise version of MongoDB[12] and is also technology partner of Amazon DynamoDB[13], Apache Cassandra DataStax[14], Couchbase[15], and Neo4j.[16]


Supported databases and technologies

    • DynamoDB
    • Couchbase
  • Graph databases:
    • Apache TinkerPop
  • Big Data analytics

See also

  • Entity-Relationship model

References

  1. "A Brief History of Data Architecture: Shifting Paradigms". 2017-08-09. https://www.dataversity.net/data-modeling-lends-hand-nosql-databases/. 
  2. Steve Hoberman (2020). The Rosedata Stone, Achieving a common business language using the Business Terms Model. Technics Publications. pp. 91-93. ISBN 978-1634627733. https://books.google.be/books?id=zITUDwAAQBAJ&lpg=PT58&pg=PT58#v=onepage&q&f=false. 
  3. "5 Best Tools for MongoDB Atlas in 2020". 2020-06-08. https://studio3t.com/knowledge-base/articles/best-mongodb-atlas-tools/. 
  4. "A Brief History of Data Modeling". 2017-05-30. https://www.dataversity.net/brief-history-data-modeling/. 
  5. Uta Störl; Meike Klettke; Stefanie Scherzinger (2 April 2020). "NoSQL Schema Evolution and Data Migration: State-of-the-Art and Opportunities". 23rd International Conference on Extending Database Technology. Copenhagen, Denmark. https://openproceedings.org/2020/conf/edbt/paper_T4.pdf. 
  6. Alberto Hernández Chillón; Diego Sevilla Ruiz; Jesus García Molina; Severino Feliciano Morales (2019-04-11). "A Model-Driven Approach to Generate Schemas for Object-Document Mappers". IEEE Access vol. 7: 59126-59142. doi:10.1109/ACCESS.2019.2915201. https://ieeexplore.ieee.org/stamp/stamp.jsp?arnumber=8708919. 
  7. Gavin Powell (2020). Database Modeling Step-by-Step. CRC Press. p. 236. ISBN 978-0367422172. https://books.google.be/books?id=umjIDwAAQBAJ&lpg=SA7-PA23&pg=SA7-PA23&redir_esc=y#v=onepage&q&f=false. 
  8. "SQL to JSON Data Modeling With Hackolade". 2017-04-13. https://blog.couchbase.com/sql-to-json-data-modeling-hackolade/. 
  9. Jeff Carpenter; Eben Hewitt (2020). Cassandra: The Definitve Guide. O'Reilly Media, Inc.. pp. 103-104. ISBN 978-1098115166. https://books.google.be/books?id=UJfnDwAAQBAJ&lpg=PT124&pg=PT124#v=onepage&q&f=false. 
  10. "Cassandra Data Modeling Tools". https://cassandra.apache.org/doc/latest/data_modeling/data_modeling_tools.html. 
  11. "The Graph Data Modeling Hall of Fame". http://graphdatamodeling.com/Graph%20Data%20Modeling/HallOfFame/DMHallOfFame.html#Hackolade. 
  12. "MongoDB Technology Partners". https://www.mongodb.com/partners/hackolade. 
  13. "Dev/Test, Data Modeling, and Visualizing Tools". https://aws.amazon.com/dynamodb/community/#dev-test. 
  14. "DataStax Technology Partners". https://www.datastax.com/partners/directory#technology. 
  15. "Couchbase Technology-ISV Partners". https://www.couchbase.com/partners/find-a-partner. 
  16. "Neo4j Technology Partners". https://neo4j.com/users/hackolade/.