All Questions
Tagged with graph-databases arangodb
85 questions
0
votes
0
answers
33
views
Is there a way of optimising following query for better edge case respose times?
Problem specification:
I have been working on pretty large dataset of friends_with graph (3.5m users, 234m friend_with edges).
User collection consist of:
_key,_id,name
friend_with edge collection:
...
- 1
0
votes
1
answer
38
views
How to check a particular attribute is present in any edge of complete traversal in ArangoDB
In below query if i want to check wether the hs_codes mentioned in third condition of Filter is present in any level of traversal from 1st to 6th edge ,query checks for match on every edge
FOR v, e, p ...
- 11
1
vote
0
answers
356
views
How to count the number of subgraphs in a collection?
I have been able to find the number of subgraphs in a collection using the below query, after much trial and error and documentation consultation. It seems to work ok. It's crafted to work in the ...
- 11
0
votes
0
answers
90
views
How to perform graph traversals with multiple collections in ArangoDB
I have a graph consisting of 3 document collections and 2 edge collections. I want to perform filtering from one doc collection but need to show the result from all three doc collections.
Graph: ...
0
votes
0
answers
107
views
ArangoDB: how to optimize FILTER on a subquery on big collections
I have a fairly simple data model (inspired by IMDB data) to link films to their directors or actors.
This includes 3 collections:
document collection Titles
document collection Persons
edge ...
- 1,013
0
votes
0
answers
250
views
Best way to mass-insert Edges into ArangoDB?
I'm writing a python converter for Neo4J to ArangoDB and expect +10k Nodes to be imported.
The converter for the Nodes is somewhat trivial but the creator of that database has a rather custom key-...
- 1,586
1
vote
1
answer
560
views
Unable to get an ArangoSearch view working properly in ArangoDB
I'm having trouble with ArangoSearch.
Here is some dummy data that I have in a collection called things (for simplicity I have removed each of their "_id", "_key" and "_rev&...
- 87
1
vote
1
answer
394
views
arangodb lock file issue
So I downloaded ArangoDB via homebrew yesterday. The documentation said to use the following to get the server started:
/usr/local/Cellar/arangodb/<VERSION>/sbin/arangod &
I ended up using ...
- 87
2
votes
1
answer
291
views
Convert AQL query to Gremlin query
I'm doing a project relate to graph databases, and I'm using ArangoDB to create graph and try some queries with that. I have 2 JSON files below and I have already imported them into ArangoDB and ...
1
vote
2
answers
458
views
Designing and implementing SaaS Application with Muti-tenancy GraphDB (Neo4J / ArangoDB)
I am developing a SaaS Application with the following Technology:
NestJS (Node)
DB (NEO4J, ArangoDB)
Nginx for proxy (Micro-services Approach)
The SaaS Application will be hosting many distinct ...
- 1,616
2
votes
1
answer
1k
views
Multi-tenancy Architecture in a graph DB
I would like to share my thoughts with you and try to get some advice. I would like to define my application with the best architecture as possible. Any comment would be highly appreciated. Here we go....
- 1,616
1
vote
1
answer
295
views
How do I combine the output of two return variables into one in ArangoDB?
Beginner with ArangoDB here:
I have two outputs stored in two variables, say: a and b.
The structure of the items in variable a and b are exactly the same, but with different data. Example as follows:
...
- 474
0
votes
1
answer
269
views
ArangoDB Join Edge collections
I have 1 node and two edge collections. I want to write an AQL query to find the common nodes between the two edge collections. How can I join two edge collections as there is not common field in the ...
- 45
0
votes
1
answer
442
views
How to best model authorization of access to nodes in a graph database for a CMS
I'm trying to figure out how to best model
User -> Role -> Permission -> Content in a graph database for a CMS I'm attempting to build.
My current approach is to have User and Role as nodes ...
- 1,854
1
vote
2
answers
1k
views
how to insert data with variables in arangodb with python-arango
I try to insert data from a variable and can't find a way to do this, can someone help me? something like this:
name = "mark"
surname = "clark"
db.collection('user').insert([{'username': @name, '...
- 11
0
votes
1
answer
355
views
Spring Data integration for ArangoDb gives back empty result list on queries
When I use queries from method names with ArangoDb and Spring Data integration I always get empty lists.
What is the problem in the way I use?
This is an example.
These are the Entities:
...
- 3,107
2
votes
1
answer
263
views
Disjoint subgraphs in ArangoDB AQL
Given a graph database I have an actors vetices collection that has edges connecting it to a scenes vertices collection.
I'm having trouble creating a query where I can select all the disjoint ...
- 2,247
1
vote
1
answer
278
views
Can graph database query "nodes that a given node has no relationship with"?
I am working on a dating app where users can "like" or "dislike" other users and get matched.
As you can imagine the most important query of the app would be:
Give me a stack of nearby user profiles ...
- 957
0
votes
1
answer
153
views
How can I create edges within a collection programmatically in ArangoDB?
Suppose I am creating a collection to store a family tree(only parent relations are important). I have a vertex collection called people and an edge collection called edges.
A document in people ...
- 37
-1
votes
1
answer
710
views
What is the correct way to represent dates in a graph database (ArangoDB)?
Are there any pitfalls in representing dates as nodes (in a separate collection) in a graph database, as opposed to properties?
- 23
1
vote
0
answers
255
views
Graph with 100+ edges per vertex
I'm doing some research on graph databases to see if they would fit my use case. Right now I'm looking at Janusgraph, but have also looked at ArangoDB and Neo4J a little.
I have a tree of nodes, but ...
- 5,680
0
votes
1
answer
133
views
How to store locations in ArangoDB?
I am building a web application where I need to store a large number of unique addresses as nodes in ArangoDB.
One approach would be using a hierarchical graph model: a country node connected to ...
0
votes
0
answers
330
views
Best way to calculate nth degree connections on a graph
I have a graph database on ArangoDB which have a node depth of around 100 levels and around 205k nodes for some users. For normal uses the AQL used to traverse the graph works well. But there are some ...
- 608
2
votes
1
answer
614
views
ArangoDB: order in graph traversal
I have a pretty standard graphql which represent a tree structure:
I would like to make a graph traversal and force the order according to the order I set on each edge:
A -> C
A -> B -> E
A -> B ->...
- 1,013
1
vote
1
answer
86
views
ArangoDB Import: arangoimp file crashes on run (timeout 1200)
New to graph databases and trying to learn a few platforms for my senior project. I'm working on ArangoDB and can't seem to import data correctly.
The manual said to run the arangoimp file to execute ...
- 43
4
votes
1
answer
628
views
ArangoDB Creating counter edge for every directed edge for bidirectional edges
I am very new to graph database. And I have started with Arango. For this project I am not sure about the queries that I will encounter in future. I don't want to create bottlenecks. So I wanted to ...
- 12.9k
1
vote
2
answers
2k
views
ArangoDB - Where database files are stored?
I am using ArangoDB community edition, I have upgraded the ArangoDB and ArangoDB client softwares, hence I can see multiple installations of ArangoDB on my machine.
Well, depending on my activity I ...
- 9,025
0
votes
1
answer
74
views
Modelling GRAPH query with scenario
I have 2 vertexes one is USER and one is PLACE, Any user can review a place and any user can like or comment on that review. In this scenario, there will be two edges one storing review done by any ...
1
vote
1
answer
309
views
How to query for a specific combination of nodes in Arango DB graph
I have a graph containing two vertex collections: Attraction (green) and Hotel (orange).
I want to query for a certain combination of Attractions and Hotels, such as the one given below:
Attraction ...
- 686
1
vote
1
answer
389
views
How to query for a node that is connected to multiple nodes in Arango DB graph
I have a graph containing nodes of two types: Attractions and Hotels.
What I want to do is that query for Hotels that are surrounded by three Attractions. The query I have now (below) gives Hotels ...
- 686
4
votes
1
answer
352
views
How to access embedded ArangoDB from desktop application?
I have copied ArangoDB dlls into my application and loaded them. I have trouble accessing ArangoDB API's to start server from C++ application. Has anybody able to access embed ArangoDB from C++ ...
- 41
1
vote
1
answer
48
views
How do I specify which collections are being queried in AQL?
lets imagine I have this graph
and I want to query for all the partners connected to an user
WITH partner
FOR u IN user
FILTER u._name == @user_name
FOR v IN OUTBOUND user GRAPH '...
- 687
1
vote
1
answer
225
views
Vertex Centric Indexes for sorting
Let's say I have supernodes with many edges and would like to quickly return top N edges for a given node. How can I do it with ArangoDB Vertex Centric Index https://docs.arangodb.com/3.11/index-and-...
- 782
2
votes
1
answer
487
views
ArangoDB AQL FILTER graph for matching edge attributes
I have one words collection and one word_relations edge collection. Words have relationships to other words, like synonym, hasPart, partOf, hasType, typeOf, etc.
I am trying to figure out how to ...
- 153
1
vote
2
answers
402
views
when delete document in another collection How to delete edge collection document together?
I am practicing arangodb in company.
When I want to express the following relation between the user and the user, I want to delete the data of the corresponding following relation when one user is ...
- 11
2
votes
1
answer
626
views
ArangoDB - Graph based recommender system
I am using ArangoDB and I am trying to build a graph-based recommender system with it.
The data model just contains users, items and ratings (edges).
Therefore want to calculate the affinity of a ...
- 21
2
votes
1
answer
86
views
Should Different Nodes Be in Different Arango Collections?
I'm new to graphing databases and am looking at a POC in ArangoDb. What is the best practice when designing a database? Specifically, should different but related node types be in seperate ...
- 687
2
votes
1
answer
93
views
ArangoDB: How to limit/skip results with Javascript graph functions?
I'm new to ArangoDB and I'm working on a Foxx service using the Javascript graph module. I see in AQL that the results of a graph traversal can be limited and offset, but I don't see the equivalent ...
- 141
1
vote
0
answers
119
views
Can graph db solve my graph problems?
I have transactions data (pastebin.com/ZswbyVHM) like this:
{"accountId":3,"recordedAt":"2013-12-01T00:00:00.000Z","region":"South","status":"H"}
{"accountId":3,"recordedAt":"2014-01-01T00:00:00.000Z"...
- 61
1
vote
0
answers
206
views
taxonomy, hierarchical vertices, how do i fetch top parent and selective children?
I really enjoyed the graph traversals of arangodb which allows me to visit any path or nodes with little query sweats. However, i m stacked with a context which is already implemented in neo4j, I ...
- 117
1
vote
2
answers
341
views
How to stop traversal based on inbound edge
I have a graph in ArangoDB with two vertices collections, P and F, and one edge collection with two types of edges: fp and hp.
Note that the image above has been simplified - the "F" nodes connect ...
- 1,161
1
vote
1
answer
236
views
How to follow a cycle only once?
I'm a new ArangoDB user and I'm having a problem that I don't know how to solve it. I have a graph composed by over 340k nodes and over 430k links with cycles and I'm trying to find a path between A ...
- 33
2
votes
1
answer
2k
views
How do I query revision history in ArangoDB?
I see the _rev in every document created in ArangoDB, but I have yet to see any information about using those revisions to access the change history for a document. More specifically, how do I query ...
- 1,121
1
vote
1
answer
1k
views
How to get all Graph Nodes in ArangoDB without Start-Node
Like in OrientDB, for get the All Graph Only use 'Select From v'
So far, I have use AQL in ArangoDB with start node:
for v,e,p IN 2 ANY 'user/188802' graph 'a' return p
And now I want to get all ...
- 23
0
votes
2
answers
88
views
How can I list the users with the most similar entries with ArangoDB
I started new project today. I have users table, tags table and user_tags edge for graph results.
I attached to users some tags on graph. How can I list the users with the most similar entries with ...
- 13
3
votes
1
answer
1k
views
Structuring time-series data in ArangoDB
I have some time-series data (roughly on the order of 1-5 points per day) I need to be able to quickly access in a webapp using ArangoDB. The data is associated with a particular profile, but one ...
- 1,717
0
votes
2
answers
144
views
ArangoDB Java API create database not working in 3.1.RC3
I have installed ArangoDB 3.1 RC3 community edition and created maven project with below code
ArangoDB arangoDB = new ArangoDB.Builder().host("127.0.0.1").port(8529).build();
String dbName = "...
- 169
1
vote
1
answer
136
views
AQL: Flattening document for fulltext queries
I have a somewhat complex use-case for the fulltext features in AQL. I have a large, hierarchical document that is returned as the result of a graph traversal. This constructs something like a social ...
- 1,717
1
vote
0
answers
332
views
ArangoDB edge collections in multiple graphs
Why does ArangoDB only allow a single edge collection definition globally? My teammate noted today that, when creating a graph, we're prompted to add an edge collection and the appropriate _to and ...
- 1,717
2
votes
1
answer
745
views
ArangoDB: Traversals where edges are connected to other edges
I recently read that ArangoDB is capable of connecting edges to other edges in a graph. In this situation, how would querying the path work? For example:
car <-------- part
^
|
...
- 1,717