search

apache / age

Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
https://age.apache.org
Apache License 2.0
3.04k stars 406 forks source link

OLTP vs OLAP Graph Querying #1874

Closed jnayak1 closed 1 month ago

jnayak1 commented 4 months ago

Searching the AGE documentation, I cannot find how the graph is structured internally. Is it structured similarly to Neo4j or something more like AWS Neptune? How is the data indexed? The reason I ask these questions is because I'm curious as to whether AGE is applicable to OLTP or OLAP or both? AWS Neptune DB for instance is only for OLTP. Neo4j is capable of doing both. OLTP queries for graph DBs are when you start at a node or a collection of nodes and traverse the graph. OLAP on the other hand you are interested in answering questions where you need to scan the whole graph to find the answer. My guess is that AGE is for OLTP queries but would like to know for sure.

HackettJP commented 4 months ago

Well i use it as OLAP , postgres OLTP to a dataware house postgres with fact tables with apache age at the back , how you view your data defines if it is OLTP or OLAP, defination of OLTP is now OLAP later. real time or not.

jnayak1 commented 4 months ago

I guess what i am asking is, is AGE efficient for running OLAP queries?

HackettJP commented 4 months ago

True DB's performance all depends on the tin it sits on, I'm from an Postgres, Oracle 9iR1+, IBM-DB2, Abinitio , KDB+ background so money was not an issue. end of the day.

you will just have to test it with the size of the data set.

There is indexing you have to build into the tables with apache age so you need to read the docs, configure hardware to suite. I'm even starting to go down the route is model it in apache age, then hard coding it into C++, once i have query correct.

shinhanbyeol commented 4 months ago

I'm not a database expert, but I think it might not be bad in oltp as we follow postgresql's transaction strategy, but I think graph database is more suited to olap than oltp.

and AGE is a schemaless structure I thought that it might be possible to design more flexible when building a data mart or designing data like "star schema"

MironAtHome commented 4 months ago

I'm even starting to go down the route is model it in apache age, then hard coding it into C++, once i have query correct.

Any link to an example would be appreciated ( if possible ) :)

github-actions[bot] commented 2 months ago

This issue is stale because it has been open 60 days with no activity. Remove "Abondoned" label or comment or this will be closed in 14 days.

github-actions[bot] commented 1 month ago

This issue was closed because it has been stalled for further 14 days with no activity.