Wire-to-address exposure trail.
bank → wire → txn → account → address. Cypher inside, SUM/COUNT outside, live on the wires table.
One grammar for geospatial, social, and property graphs. Topology stored in fixed memory. Traversals restricted by the same SQL you write on the rest of your data — no copy, no sync, no second engine.
Fastest at pure-graph workloads when the graph is static. The cost: topology is a copy, attributes are duplicated or streamed in via hooks, and joins back to relational data live in application code or batch jobs. Single-node engines (DuckPGQ-class) cap at one machine's memory.
Kinetica is GQL-compliant and supports Cypher in full — the patterns your team writes against Neo4j port over unchanged. Wrap any match in GRAPH_TABLE() and it becomes a table-valued function: GROUP BY, window functions, joins, and OLAP aggregates compose with graph traversal in a single SQL statement.
SELECT person, bank, SUM(amount), MAX(risk_score) FROM GRAPH_TABLE( GRAPH expero.banking_graph MATCH (a:bank)-[:performed]->(b:wire_message WHERE b.risk_score > 20) -[:is_for_transaction]->(c:banking_transaction) RETURN g.party_name AS person, a.bank_name AS bank, c.amount, b.risk_score ) GROUP BY person, bank ORDER BY SUM(amount) DESC;
Edge insert and delete are pointer operations, so source-table changes propagate to the graph topology in constant time. Turn on add_table_monitor and the graph stays in sync with your CDC stream, your Kafka feed, your trickle-load — no batch rebuild, no nightly reload, no stale topology.
Batch reload window. Topology lags ingest. Streaming graphs require external rebuild jobs.
Graph queries while you ingest. No rebuild window. No stale topology — the graph follows the tables, the tables follow the stream.
AML wire-tracing · real-time fraud rings · fleet & IoT telemetry · supply-chain visibility · social-network freshness.
Generic solvers (shortest path, PageRank, centrality), purpose-built matchers (supply-demand MILP, HMM map-matching, fraud-ring loops), and label-aware traversals with OLAP filters — four of them patented Kinetica research, all callable in SQL.
Network-agnostic algorithms on any graph: shortest paths, TSP, backhaul routing, PageRank, centrality, all-paths enumeration.
Higher-order solvers for routing, fraud, scheduling, and supply chain. Patented algorithms anchor this family.
Hop-based pattern queries with node and edge labels. Restrictions reference any column on any table — even columns the graph has never seen.
Each runs today against a live Kinetica graph, end-to-end, in a single SQL statement — no sidecar solver, no separate spatial engine, no batch job.
bank → wire → txn → account → address. Cypher inside, SUM/COUNT outside, live on the wires table.
1.5M-edge road graph, inverse many-to-one Dijkstra, animated SVG of every candidate route.
match_supply_demand with multi-modal AIR · SEA · LAND edge labels and partial mid-route drops.
Numbers from production builds and POCs, not marketing slides. Full benchmark refresh in progress.
500K-edge Seattle road network, multi-source / multi-target, distance ÷ speed weights.
4.3 B edges, 2.8 B vertices, source-to-many on a single node with 1 TB RAM + 0.5 TB ZRAM.
Distributed cross-partition shortest path vs random partitioning.
NODE, EDGE,
WEIGHTS, and RESTRICTIONS are annotated column references on existing
tables, so a graph traversal can filter on any column without copying or syncing anything.
SELECT as the
RESTRICTIONS argument to QUERY_GRAPH and the predicate is evaluated by
the distributed OLAP engine for every candidate node during the walk. Failed nodes are pruned
mid-traversal. The filter can reference any column on any table in the database, including columns
the graph has never seen.
shortest_path, multiple_routing/TSP,
backhaul_routing, page_rank, probability_rank,
centrality, closeness, stats_all,
inverse_shortest_path), Match (match_supply_demand,
map_matching, charging_stations, pickup_dropoff,
loops, similarity, clusters via Louvain/RSB,
pattern, batch_solves — four of which are patented), and
Query (label-aware hop-based traversals with OLAP restrictions).
SHORTEST_PATH over five lon/lat
pairs returns in roughly 250 ms. On a single node with 1 TB RAM + 0.5 TB ZRAM, Kinetica has held a
4.3 B-edge / 2.8 B-vertex graph and run 3-hop source-to-many queries in 1.2–1.8 seconds.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions. Cookie Policy