OLTP vs OLAP Graph Querying

[jnayak1]

OLTP vs OLAP Graph Querying

[HackettJP]

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]

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

[HackettJP]

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]

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]

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 ) :)