Свойство | Тип | Описание | |
---|---|---|---|
CheckDatabase | bool | ||
ConvertStringIntoSqlType | object | ||
CreateEdgeViewByDefault | void | ||
CreateEdgeViewWithoutRecord | void | ||
CreateMetadata | void | ||
CreateNodeViewWithoutRecord | void | ||
DropEdgeView | void | ||
GetGraphEdgeColumns | IList |
||
RandomString | string | ||
UpdateEdgeStatistics | void | ||
UpdateEdgeViewMetaData | void | ||
UpdateNodeViewMetatable | void | ||
UpgradeFromV100ToV110 | void | ||
UpgradeFromV110ToV111 | void | ||
UpgradeFromV111ToV200 | void | ||
UpgradeFromV200ToV210 | void | ||
convertSqlType | string |
Метод | Описание | |
---|---|---|
AddNodeTableColumn ( string sqlStr, |
Add properties or edges to a node table in the graph database.
|
|
BeginTransaction ( ) : |
Starts a database transaction.
|
|
BeginTransaction ( System.Data.IsolationLevel level ) : |
Starts a database transaction with the specified isolation level.
|
|
BeginTransaction ( System.Data.IsolationLevel level, string tranName ) : |
Starts a database transaction with the specified isolation level and transaction name.
|
|
BeginTransaction ( string tranName ) : |
Starts a database transaction with the specified transaction name.
|
|
BulkInsertEdge ( string dataFileName, string tableSchema, string sourceTableName, string sourceNodeIdName, string sinkTableName, string sinkNodeIdName, string edgeColumnName, IList |
Bulk insert edge from data file Data file should contain source node id and Sink node id on the first and second columns, then followed by the columns of user-supplied edge attribute.
|
|
BulkInsertNode ( string dataFileName, string tableName, string tableSchema = "dbo", IList |
Bulk insert node from data file into node table.
|
|
ClearData ( |
Clears all node tables in the graph database. Can be used for initialzing an empty graph.
|
|
ClearGraphDatabase ( ) : void |
Clears the GraphView database, including all node table data, meta-data, and system-generated functions.
|
|
Close ( ) : void |
Closes the database connection.
|
|
CreateCommand ( ) : |
||
CreateEdgeView ( string query ) : void |
Creates Edge View using CREATE EDGE VIEW statement
|
|
CreateEdgeView ( string tableSchema, string nodeName, string edgeViewName, string>.List |
Creates view on edges
|
|
CreateNodeTable ( string sqlStr, |
Creates a node table in the graph database.
|
|
CreateNodeView ( string query ) : void | ||
CreateNodeView ( string tableSchema, string nodeViewName, List |
Creates node view. This operation creates view on nodes, mapping native node table propeties into node view and merging all the edge columns relevant to the nodes in the view.
|
|
CreateProcedure ( string sqlStr, |
Creates a stored procedure.
|
|
Dispose ( ) : void |
Releases all resources used by GraphViewConnection.
|
|
DropAssemblyAndMetaUdf ( string>.List |
Drop the global UDFs and assembly
|
|
DropEdgeView ( string tableSchema, string tableName, string edgeView, |
Drop Edge View
|
|
DropNodeTable ( string sqlStr, |
Drops node table and related metadata.
|
|
DropNodeTableColumn ( string sqlStr, |
Drop properties or edges of a node table in the graph database.
|
|
DropNodeTableFunctionAndAssembly ( string tableSchema, string tableName, string>.List |
Drops node table user-defined functions and assembly
|
|
DropNodeTableFunctionV100 ( string tableSchema, string tableName, |
||
DropNodeView ( string nodeViewSchema, string nodeViewName, |
Drops node view with edge view on it
|
|
DropProcedure ( string sqlStr, |
Drops a stored procedure
|
|
ExecuteNonQuery ( string queryString ) : int | ||
ExecuteReader ( string queryString, int timeout ) : System.Data.SqlClient.SqlDataReader | ||
GetNodeTables ( |
Gets all node tables in the graph database.
|
|
GraphViewConnection ( ) : System |
Initializes a new instance of the GraphViewConnection class.
|
|
GraphViewConnection ( string connectionString ) : System |
connectionString Initializes a new connection to a graph database. The database could be a SQL Server instance or Azure SQL Database, as specified by the connection string.
|
|
GraphViewConnection ( string connectionString, System.Data.SqlClient.SqlCredential sqlCredential ) : System |
Initializes a new connection to a graph database. The database could be a SQL Server instance or Azure SQL Database, as specified by the connection string and the SQL credential.
|
|
Import ( IList |
Imports nodes and edges data into GraphView. Runs the following command to enable minimal logging, which will highly enhance the performance of bulk loading: USE master; ALTER DATABASE database_name SET RECOVERY BULK_LOGGED;
|
|
MergeAllDeleteColumn ( string tableSchema, string tableName ) : void |
Merges all "delta" columns in a node table and frees the space.
|
|
MergeDeleteColumn ( string tableSchema, string tableName, string>.IList |
Merges the "delta" of an edge column to the edge's original column and frees the space. When an adjacency list is modified, the modification is not applied to the list directly, but is logged in the list's "delta" column. This method is to merge the delta to the original edge column and free the space.
|
|
Open ( ) : void |
Opens the graph database connection. Creates meta-data and system-reserved functions.
|
|
UpdateEdgeAverageDegree ( string tableSchema, string tableName, string edgeColumn, |
Updates the average degree of an edge column in a node table
|
|
UpdateEdgeSampling ( string tableSchema, string tableName, string>.Tuple |
Updates an edge sample
|
|
UpdateGlobalNodeView ( string schema = "dbo", |
||
UpdateTableStatistics ( string tableSchema, string tableName, |
Updates a node table's statistics
|
|
UpdateTableStatistics ( string tableSchema, string tableName, string edgeColName, |
Updates a specific edge's statistics
|
|
UpdateVersionNumber ( string versionNumber, |
||
UpgradeMetaTableV100 ( SqlTransaction externalTransaction = null ) : void | ||
UpgradeMetaTableV111 ( SqlTransaction externalTransaction = null ) : void | ||
UpgradeNodeTableFunction ( string tableName = null, SqlTransaction externalTransaction = null ) : void | ||
UpgradeNodeTableFunctionV100 ( SqlTransaction externalTransaction = null ) : void |
Метод | Описание | |
---|---|---|
Dispose ( bool disposing ) : void |
Releases the unmanaged resources used by GraphViewConnection and optionally releases the managed resources.
|
Метод | Описание | |
---|---|---|
CheckDatabase ( |
Validates the graph database by checking if metadata tables exist.
|
|
ConvertStringIntoSqlType ( string obj, string sqlDataTypeName ) : object | ||
CreateEdgeViewByDefault ( string tableSchema, string nodeViewName, |
||
CreateEdgeViewWithoutRecord ( string tableSchema, string nodeName, string edgeViewName, string>.List |
Edge View:create edge view decoder function
|
|
CreateMetadata ( |
Initializes a graph database and creates meta-data, including table ID, graph column and edge attribute information.
|
|
CreateNodeViewWithoutRecord ( string tableSchema, string nodeViewName, List |
Creates node view without updating metadatatable.
|
|
DropEdgeView ( string tableSchema, string tableName, string edgeView, bool isRevEdgeView, |
Drop Edge View
|
|
GetGraphEdgeColumns ( string tableSchema, string tableName, |
Gets a list a table's edge columns
|
|
RandomString ( int strLength = 10 ) : string | ||
UpdateEdgeStatistics ( string tableSchema, string tableName, Tuple |
Updates a specific edge statistics
|
|
UpdateEdgeViewMetaData ( string tableSchema, string edgeViewName, string>.Dictionary |
Updates metatable when creating edge view.
|
|
UpdateNodeViewMetatable ( string tableSchema, string nodeViewName, List |
Updates metatable when creating node view.
|
|
UpgradeFromV100ToV110 ( |
||
UpgradeFromV110ToV111 ( |
||
UpgradeFromV111ToV200 ( |
||
UpgradeFromV200ToV210 ( |
||
convertSqlType ( string x ) : string |
public AddNodeTableColumn ( string sqlStr, |
||
sqlStr | string | A ALTER TABLE ADD statement with annotations. |
externalTransaction | An existing SqlTransaction instance under which the create node table will occur. | |
Результат | bool |
public BeginTransaction ( ) : |
||
Результат |
public BeginTransaction ( System.Data.IsolationLevel level ) : |
||
level | System.Data.IsolationLevel | |
Результат |
public BeginTransaction ( System.Data.IsolationLevel level, string tranName ) : |
||
level | System.Data.IsolationLevel | |
tranName | string | |
Результат |
public BeginTransaction ( string tranName ) : |
||
tranName | string | |
Результат |
public BulkInsertEdge ( string dataFileName, string tableSchema, string sourceTableName, string sourceNodeIdName, string sinkTableName, string sinkNodeIdName, string edgeColumnName, IList |
||
dataFileName | string | The name of data file. |
tableSchema | string | The Schema name of node table. Default by "dbo". |
sourceTableName | string | The source node table name of node table. |
sourceNodeIdName | string | The node id name of source node table. |
sinkTableName | string | The Sink node table name of node table. |
sinkNodeIdName | string | The node id name of Sink node table. |
edgeColumnName | string | The edge column name in source node table. |
dataEdgeAttributeName | IList |
User-supplied edge attribute name in data file in order. /// By default(null), data file should exactly contain all the Edge Attribute in creating order. /// Empty stands for that data file doesn't provide edge attribute. |
fieldTerminator | string | The field terminator of data file. Default by "\t". |
rowTerminator | string | The row terminator of data file. Default by "\r\n". |
updateMethod | bool | Choose update method or rebuild table method to implement bulk insert edge. /// True, the data file contains Header |
Header | bool | |
Результат | void |
public BulkInsertNode ( string dataFileName, string tableName, string tableSchema = "dbo", IList |
||
dataFileName | string | The name of data file. |
tableName | string | The table name of node table. |
tableSchema | string | The Schema name of node table. Default by "dbo". |
dataColumnName | IList |
User-supplied column(s) in data file in order. /// By default(null or empty), data file should exactly contain all the columns of property and nodeid in creating order. |
fieldTerminator | string | The field terminator of data file. Default by "\t". |
rowTerminator | string | The row terminator of data file. Default by "\r\n". |
skipHeader | bool | |
Результат | void |
public ClearData ( |
||
externalTransaction | An existing SqlTransaction instance under which clear data will occur. | |
Результат | void |
public CreateCommand ( ) : |
||
Результат |
public CreateEdgeView ( string query ) : void | ||
query | string | |
Результат | void |
public CreateEdgeView ( string tableSchema, string nodeName, string edgeViewName, string>.List |
||
tableSchema | string | The Schema name of node table. Default(null or "") by "dbo". |
nodeName | string | The name of supper node. |
edgeViewName | string | The name of supper edge. |
edges | string>.List | The list of message of edges for merging. /// The message is stored in tuple, containing (node table name, edge column name). |
edgeAttribute | List |
The attributes' names in the supper edge. |
externalTransaction | An existing SqlTransaction instance under which create edge view will occur. | |
attributeMapping | List |
User-supplied attribute-mapping.
/// Type is List |
Результат | void |
public CreateNodeTable ( string sqlStr, |
||
sqlStr | string | A CREATE TABLE statement with annotations. |
externalTransaction | An existing SqlTransaction instance under which the create node table will occur. | |
Результат | bool |
public CreateNodeView ( string query ) : void | ||
query | string | |
Результат | void |
public CreateNodeView ( string tableSchema, string nodeViewName, List |
||
tableSchema | string | The Schema name of node table. Default(null or "") by "dbo". |
nodeViewName | string | The name of supper node. |
nodes | List |
The list of the names of native nodes. |
propertymapping | string>.List |
/// Type is List |
externalTransaction | An existing SqlTransaction instance under which the create node view will occur. | |
Результат | void |
public CreateProcedure ( string sqlStr, |
||
sqlStr | string | A create procedure script |
externalTransaction | A SqlTransaction instance under which the create procedure will occur. | |
Результат | bool |
protected Dispose ( bool disposing ) : void | ||
disposing | bool | true to release both managed and unmanaged resources; false to release only unmanaged resources. |
Результат | void |
public DropAssemblyAndMetaUdf ( string>.List |
||
metaUdfList | string>.List | |
externalTransaction | ||
Результат | void |
public DropEdgeView ( string tableSchema, string tableName, string edgeView, |
||
tableSchema | string | The name of schema. Default(null or "") by "dbo". |
tableName | string | The name of node table. |
edgeView | string | The name of Edge View |
externalTransaction | An existing SqlTransaction instance under which the drop edge view will occur. | |
Результат | void |
public DropNodeTable ( string sqlStr, |
||
sqlStr | string | Name of table to be dropped. |
externalTransaction | An existing SqlTransaction instance under which the drop node table will occur. | |
Результат | bool |
public DropNodeTableColumn ( string sqlStr, |
||
sqlStr | string | A ALTER TABLE ADD statement with annotations. |
externalTransaction | An existing SqlTransaction instance under which the create node table will occur. | |
Результат | bool |
public DropNodeTableFunctionAndAssembly ( string tableSchema, string tableName, string>.List |
||
tableSchema | string | Schema of table to be dropped. |
tableName | string | Name of table to be dropped. |
tableUdfList | string>.List | List of UDF to be dropped. |
externalTransaction | An existing SqlTransaction instance under which the drop node table will occur. | |
Результат | bool |
public DropNodeTableFunctionV100 ( string tableSchema, string tableName, |
||
tableSchema | string | |
tableName | string | |
externalTransaction | ||
Результат | bool |
public DropNodeView ( string nodeViewSchema, string nodeViewName, |
||
nodeViewSchema | string | The name of node view. Default(null or "") by "dbo". |
nodeViewName | string | The name of node view. |
externalTransaction | An existing SqlTransaction instance under which the drop edge view will occur. | |
Результат | void |
public DropProcedure ( string sqlStr, |
||
sqlStr | string | The script that drops the stored procedure |
externalTransaction | A SqlTransaction instance under which the drop procedure will occur. | |
Результат | bool |
public ExecuteNonQuery ( string queryString ) : int | ||
queryString | string | |
Результат | int |
public ExecuteReader ( string queryString, int timeout ) : System.Data.SqlClient.SqlDataReader | ||
queryString | string | |
timeout | int | |
Результат | System.Data.SqlClient.SqlDataReader |
public GetNodeTables ( |
||
externalTransaction | ||
Результат | string>>.IList |
public GraphViewConnection ( string connectionString ) : System | ||
connectionString | string | The connection string of the SQL database. |
Результат | System |
public GraphViewConnection ( string connectionString, System.Data.SqlClient.SqlCredential sqlCredential ) : System | ||
connectionString | string | The connection string of the SQL database |
sqlCredential | System.Data.SqlClient.SqlCredential | A SqlCredential object |
Результат | System |
public Import ( IList |
||
nodesFileName | IList |
The list of node file name(s) |
edgesFileName | IList |
the list of edge file name(s) |
directory | string | The directory of the node and edge data files |
skipScanLabel | bool | True, notifies GraphView that every node file has only one label and /// every edge file has only one type. This will improve the performance of importing. |
fieldTerminator | string | The field terminator of data files |
byDefaultType | string | The default data type. |
Результат | void |
public MergeAllDeleteColumn ( string tableSchema, string tableName ) : void | ||
tableSchema | string | The schema of the table to be updated |
tableName | string | The table name |
Результат | void |
public MergeDeleteColumn ( string tableSchema, string tableName, string>.IList |
||
tableSchema | string | The schema of table to be updated. |
tableName | string | The table name. |
edgeColumns | string>.IList | The edge columns to be merged |
tx | ||
Результат | void |
public UpdateEdgeAverageDegree ( string tableSchema, string tableName, string edgeColumn, |
||
tableSchema | string | The schema of the table |
tableName | string | The table name |
edgeColumn | string | The edge name |
tx | ||
Результат | void |
public UpdateEdgeSampling ( string tableSchema, string tableName, string>.Tuple |
||
tableSchema | string | The schema of the table |
tableName | string | The table name |
edgeColumn | string>.Tuple | The edge name and udf prefix in the table |
tx | ||
Результат | void |
public UpdateGlobalNodeView ( string schema = "dbo", |
||
schema | string | |
externalTransaction | ||
Результат | void |
public UpdateTableStatistics ( string tableSchema, string tableName, |
||
tableSchema | string | The schema of the table to be updated. |
tableName | string | The name of the table to be updated. |
externalTransaction | ||
Результат | void |
public UpdateTableStatistics ( string tableSchema, string tableName, string edgeColName, |
||
tableSchema | string | The schema of the table to be updated. |
tableName | string | The name of the table to be updated. |
edgeColName | string | The name of the edge to be updated |
externalTransaction | ||
Результат | void |
public UpdateVersionNumber ( string versionNumber, |
||
versionNumber | string | |
externalTransaction | ||
Результат | void |
public UpgradeMetaTableV100 ( SqlTransaction externalTransaction = null ) : void | ||
externalTransaction | SqlTransaction | |
Результат | void |
public UpgradeMetaTableV111 ( SqlTransaction externalTransaction = null ) : void | ||
externalTransaction | SqlTransaction | |
Результат | void |
public UpgradeNodeTableFunction ( string tableName = null, SqlTransaction externalTransaction = null ) : void | ||
tableName | string | |
externalTransaction | SqlTransaction | |
Результат | void |
public UpgradeNodeTableFunctionV100 ( SqlTransaction externalTransaction = null ) : void | ||
externalTransaction | SqlTransaction | |
Результат | void |