/// <summary> /// Executes the referencing queries /// </summary> private static void AddReferenceGraph() { Log("Executing AddReferenceGraph()"); Log("Connecting to Movie store..."); var movieStore = new StardogConnector(settings.ServerIp, MoviesDbName, settings.Login, settings.Password); movieStore.Timeout = int.MaxValue; movieStore.DeleteGraph("http://imn.htwk-leipzig.de/pbachman/ontologies/references#"); Log("Inserting film references..."); movieStore.Query(File.ReadAllText(ReferenceFilmsQuery)); Log("Inserting Song references..."); movieStore.Query(File.ReadAllText(ReferenceSongsQuery)); Log("Inserting Artists references..."); movieStore.Query(File.ReadAllText(ReferenceArtistsQuery)); Log("Inserting Chart song references..."); movieStore.Query(File.ReadAllText(ReferenceChartsDe1Query)); }
/// <summary> /// Merges the graphs from IMDb, LastFM and Charts_de into a new database /// </summary> private static void MergeGraphs() { Log("Executing MergeGraphs()"); Log("Connecting to Movie store..."); var movieStore = new StardogConnector(settings.ServerIp, MoviesDbName, settings.Login, settings.Password); movieStore.Timeout = int.MaxValue; #region Tunefind Log("Connecting to Tunefind store..."); var tuneFindStore = new StardogConnector(settings.ServerIp, TuneFindDbName, settings.Login, settings.Password); var tuneFindGraph = new Graph(); tuneFindGraph.BaseUri = new Uri("http://imn.htwk-leipzig.de/pbachman/ontologies/tunefind#"); tuneFindStore.LoadGraph(tuneFindGraph, string.Empty); Log("Uploading Graph..."); movieStore.DeleteGraph("http://imn.htwk-leipzig.de/pbachman/ontologies/tunefind#"); movieStore.SaveGraph(tuneFindGraph); #endregion #region IMDB Log("Connecting to IMDB store..."); var imdbStore = new StardogConnector(settings.ServerIp, ImdbDbName, settings.Login, settings.Password); var imdbGraph = new Graph(); imdbGraph.BaseUri = new Uri("http://imn.htwk-leipzig.de/pbachman/ontologies/imdb#"); imdbStore.LoadGraph(imdbGraph, string.Empty); Log("Uploading Graph..."); movieStore.DeleteGraph("http://imn.htwk-leipzig.de/pbachman/ontologies/imdb#"); movieStore.SaveGraph(imdbGraph); #endregion #region LastFM Log("Connecting to LastFm store..."); var lastFmStore = new StardogConnector(settings.ServerIp, LastFmDbName, settings.Login, settings.Password); var lastFmGraph = new Graph(); lastFmGraph.BaseUri = new Uri("http://imn.htwk-leipzig.de/pbachman/ontologies/lastfm#"); lastFmStore.LoadGraph(lastFmGraph, string.Empty); Log("Uploading Graph..."); movieStore.DeleteGraph("http://imn.htwk-leipzig.de/pbachman/ontologies/lastfm#"); movieStore.SaveGraph(lastFmGraph); #endregion #region Charts_de Log("Connecting to Chart_De store..."); var chartsDeStore = new StardogConnector(settings.ServerIp, ChartsDeDbName, settings.Login, settings.Password); var chartsDeGraph = new Graph(); chartsDeGraph.BaseUri = new Uri("http://imn.htwk-leipzig.de/pbachman/ontologies/charts_de#"); chartsDeStore.LoadGraph(chartsDeGraph, string.Empty); Log("Uploading Graph..."); movieStore.DeleteGraph("http://imn.htwk-leipzig.de/pbachman/ontologies/charts_de#"); movieStore.SaveGraph(chartsDeGraph); #endregion Log("Merging Graphs..."); var movieGraph = SetupMovieGraph(); movieGraph.Merge(tuneFindGraph); movieGraph.Merge(imdbGraph); movieGraph.Merge(lastFmGraph); movieGraph.Merge(chartsDeGraph); Log("Writing Graph..."); var writer = new CompressingTurtleWriter(TurtleSyntax.W3C); writer.Save(movieGraph, @"01_Movies.ttl"); }