Getting from Open Data to a Knowledge Graph comprising Linked Data, with Virtuoso
Generating a Knowledge Graph using Government Open Data
Why?
Every government is obligated to fuel the betterment of its citizens by providing an economic ecosystem aimed at creating opportunities that drive economic growth.
What?
Open access to data collated by governments is the shortest route to the goal outlined above. Basically, functional governments are curators and administrators of massive databases.
Currently, data Variety (at the documentation level) remains the biggest impediment to achieving and sustaining economic growth that’s a product of the data curation and publication efforts of governments.
How?
- Produce Open Data Documents (CSV)
- Generate 5-Star Linked Data (using preferred RDF document type:
RDF-Ntriples, RDF-Turtle, JSON-LD, RDF-XML, RDF-JSON, etc.) - Publish to Network (public or private)
- Inject Metadata relating Documents to Entities in Linked Data Graph
- Expose SPARQL access, faceted exploration, query endpoints
- Expose ODBC, JDBC, ADO.NET access via Drivers and associated Data Source Names and/or direct Connect String Attributes
Benefits?
- Hyperlinks identify all entities of relevance — so the meaning of anything is a single-click away (i.e., information at your fingertips, literally!)
- Cognitive exploration and navigation of entity relationships (“Data GPS”) — via hypermedia-based deductive database documents
- Semantic SEO for Semantic Search Agents — better search engine results page placements (SERPs)
- Powerful foundation for Artificial Intelligence, Machine Learning, API Economy exploitation
Virtuoso Solution
Adopting Virtuoso as your engine for achieving the goals and reaping the benefits outlined above boils down to the the following steps applied to CSV documents already published as part of an Open Data publication effort:
- Download, install, and start a local Virtuoso instance, or pull a Docker Container, or start a remote instance from the Amazon AWS Cloud Marketplace
- Install the Conductor (HTML-based DB Admin UI), Linked Data Middleware (a/k/a “Sponger”), and Faceted Browser modules from our VAD Archive Download Server
- For additional convenience install browser extensions such as
— OpenLink Data Explorer (ODE)
— OpenLink Structured Data Sniffer (OSDS)
— YouID
— Dokieli - Start Loading Data from disparate data sources by
— visiting Web Pages and simply clicking on ODE or OSDS extension icons in your browser’s toolbar to trigger Extract, Transform, and Load (ETL) operations that create 5-Star Linked Data
— using REST-ful interactions via URIs to trigger ETL operations - Start experiencing power of a Knowledge Graph comprising Linked Data via
— Faceted Browsing Tool
— existing ODBC, JDBC, ADO.NET applications
— SQL and/or SPARQL Query-By-Example Tools (e.g., Interactive SPASQL Query Builder — for demos login using “vdb” and the username and password)
Here are some related examples that include live demo links:
- Market Opportunity Research Knowledge Graph — using a Dynamic Google Spreadsheet
- Mapping Multiple CSV Documents to a Tabular Relation (Table) in Virtuoso
- What is a Virtuoso SPARQL Endpoint, and why is it important?
Conclusion
Following the simple steps outlined above leaves you with a powerful point of presence on public and/or private data networks. Choosing Virtuoso lets you expose the full economic power of open data access, without compromising platform choice, performance, or privacy.
Related
- Virtuoso Home Page
- URIBurner — a Live Extract, Transform, and Load (ETL)Service for generating 5-Star Linked Data from Open Data
- Various Virtuoso Options from the Amazon AWS Cloud
- Virtuoso Evaluation License and Installer Downloads
- OpenLink Structured Data Sniffer Browser Extension
- OpenLink Data Explorer Browser Extension
- YouID Browser Extension
- Five Ways Government can Improve Competitive Advantage with their Open Data
