Tag: graph-databases

PyOrient client.command(“SELECT X FROM Protein”) seems to always return the internal ID of the record (Studio returns the property)

I am trying to develop python programs to set up a multi-omics graph database in OrientDB, starting with the gene-transcript-protein relations from Ensembl. A completely unexpected problem I have run into is that the python interface (pyorient/pyorientdb),for queries like client.command(“SELECT uID FROM Protein”) seems to always return the internal ID of the record, not the property (iUD) I am asking

Using the ‘astar’ function of OrientDB: an SQL call in Java

a-star graph-databases java orientdb sql

I’m using OrientDB to represent large city maps and calculate the shortest traversal times between a pair of nodes when the need arises. I have the following method: The getNode(nodeID) method returns the OVertex object present in the database, hence we can identify the @rid. Clearly, this method serves no purpose as is. My issue comes when trying to call

Data model guidance, database choice for aggregations on changing filter criteria

database database-design graph-databases olap sql

Problem: We are looking for some guidance on what database to use and how to model our data to efficiently query for aggregated statistics as well as statistics related to a specific entity. We have different underlying data but this example should showcase the fundamental problem: Let’s say you have data of Facebook friend requests and interactions over time. You