Updating linked database c
A key concept of the system is the graph (or edge or relationship), which directly relates data items in the store.
The relationships allow data in the store to be linked together directly, and in many cases retrieved with one operation.
This is called PULLING Data as you are executing the query on destination server and pulling data from source server.
If the phone numbers are indexed, the same search would occur in the smaller index table, gathering the keys of matching records, and then looking in the main data table for the records with those keys.
This allows data elements to be categorized for easy retrieval en masse.
Retrieving data from a graph database requires a query language other than SQL, which was designed for relational databases and does not elegantly handle traversing a graph.
Local queries are executed locally and data for remote queries are collected from the remote servers, scrubbed locally, combined together and presented to end user as single record set.
For OPENQUERY - Executes the specified pass-through query on the specified linked server.
In addition to having query language interfaces, some graph databases are accessed through application programming interfaces (APIs).