Charles Hillier - Database consultant in Norway with Neo4j interest


(Charles Hillier) #1

I am on a contract in Oslo (commuting from Stavanger region), to document and help rewrite an older SQL Server system (lots of TSQL stored procedures).

System is poorly documented, currently extracting all possible job, job step, executable (stored procedures), table and column information into Neo4j, to find out exactly what is connected with what (documentation).

First intro'ed to Neo4j in a Stavanger contract, extracted Windows Active Directory information and directory information to model security rights for a digitalizing system (quickly finding all accessible documents on subjects, depending on user role, across servers, systems, and countries). Also extracted POSC/Caesar (ISO15923 data model for Oil and Gas) into Neo4j for demo purposes ... powerful stuff.

Found Neo4j to be fascinating.

So there so, otherwise years (and years and years) of database design, implementation, and maintenance, Oracle, SQLServer, SQLite,,Neo4j, and ETL work in Java, JavaScript, Objective-C, TSQL, PL/SQL, and a multitude of ETL tools (Talend is the thing right now...).

mvh Charles


(Michael Hunger) #2

Welcome Charles,

that's a really interesting topic. Which tools did you use for the extraction? Something generic or specific SQL queries? I always wanted to add that kind of analysis to jqassistant.org

You should connect with Joe Chesack if you don't know him yet, he's been using Neo4j for a long time in Norway and in your field too.

http://www.digitalenergyjournal.com/n/Using_graph_databases_in_operations/b7e8cd8c.aspx


(Charles Hillier) #3

Hei Michael -
Yeah, Joe was the main Neo4j dude in the digitalization project.
Not sure what you are referring to on the extract, used JavaScript against the windows directory, and am using everything on earth against the SQL and Talend Servers (Talend, SQL, C# extraction from source code, etc etc....)
mvh Charles


(Michael Hunger) #4

Ok, then nevermind :slight_smile: