Skip to main content

Posts

Showing posts from 2019

Trial of SPARQL on GraphDB

I used the OWL ontology files from  Allen Brain Atlas (ABA) Adult Mouse Brain Ontology Then used SPARQL Query on GraphDB http://localhost:7200/import#user First you need to Import the file using Import  →  RDF  →  Server Files Then use SPARQL Query & Update - http://localhost:7200/sparql Sample SPARQL query that I used: select distinct ?o where {   ?s ?p ?o .   filter contains(?o,"Cerebral cortex")         #-- the important line } limit 100 Result: 1 Cerebral cortex, layer 5 2 Cerebral cortex 3 Cerebral cortex, layer 2-3 4 Cerebral cortex, layer 6a 5 Cerebral cortex, layers 1-6b 6 Cerebral cortex, layer 1 7 Cerebral cortex, layer 6 8 Cerebral cortex, layer 3 9 Cerebral cortex, layer 2 10 Cerebral cortex, layer 4 Schema.org - has more RDF / triples:  https://schema.org/docs/developers.html Another useful link:  Ontol...

Run MySQL without Administrator privileges

Create a text file containing the password-assignment statement on a single line. Replace the password with the password that you want to use. ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; Save the file. This example assumes that you name the file C:\mysql-init.txt Open a console window to get to the command prompt: From the Start menu, select Run, then enter cmd as the command to be run. Start the MySQL server with the special --init-file option (notice that the backslash in the option value is doubled): cd "C:\Program Files\MySQL\MySQL Server 8.0\bin" mysqld --init-file=C:\\mysql-init.txt