Question : Some pre information Postgresql Version 11.2 GCE CPU: 6cores SSD: 250gig RAM: 64gigs We are currently deciding on […]
Graph Database with “non-graph” data
Question : — Update — Thanks for the comments and the help so far. And I apologize for not specifying […]
Visualization of MySQL/PostgreSQL table structure as a graph/UML
Question : Is there any program, source code or API that will take a MySQL or PostgreSQL schema and spit […]
How to aggregate pairs of id values into groups
Question : I have a table with two id columns id1 and id2. Each row shows that 2 id values […]
Can graph databases be easily distributed?
Question : I have never worked with graph databases such as neo4j, I would like to know if they support […]
How to design a graph database in this scenario?
Question : here is my scenario. I have a pre-defined data type structure for books. Just take it as an […]
document and edges in orientdb
Question : I was playing around with OrientDB lately and was create some classes and edges. I was able to […]
Best design for a tree-like structure database
Question : I’m designing a database in MS Access which is used for tracking the locations of a variety of […]
How to create a graph connecting predecessors and successors in time from a timeseries table in PostgreSQL 10?
Question : I have the following table: ╔════╦═══════════╦═════════════════════╦═══════╗ ║ id ║ sensor_id ║ time ║ value ║ ╠════╬═══════════╬═════════════════════╬═══════╣ ║ 1 […]
How to group items by path (graph structure) and leave only those with highest score using t-sql?
Question : I have a table with records and their scores (table ‘Offers’): OfferId OfferScore ———– ———– 1 1 2 […]