age icon indicating copy to clipboard operation
age copied to clipboard

Is data duplicated in parent and label/edge tables? What are the internals?

Open deniskilseev opened this issue 1 year ago • 2 comments

When creating a node/edge in a graph it exists in both _ag_label_edge/vertex tables (parent tables) and appropriate label/edge-tables. But I couldn't find any triggers or materialized views, so it begs a question whether data is duplicated in base and class tables? Question rises when I started inserting data directly into underlying tables and can't comprehend how it ends up in parent table

Because if class-tables are just views of main tables, how indexes of label/edge tables are maintained?

deniskilseev avatar Jun 26 '24 17:06 deniskilseev

Nodes exist in their node label table. Edges exist in their edge label table. Each has a unique id, they are not duplicated. Now, can you create 2 or more nodes/edges with the same data but a different id, yes.

jrgemignani avatar Jun 26 '24 18:06 jrgemignani

Then what are parent tables? Are they like views combining all node/edge label tables? @jrgemignani

deniskilseev avatar Jun 26 '24 18:06 deniskilseev

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] avatar Sep 09 '24 00:09 github-actions[bot]

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

github-actions[bot] avatar Sep 23 '24 00:09 github-actions[bot]