Here’s how to install Sqlite on Linux Redhat 6.4 and query browser history, cookies, downloads, etc.
You probably can’t read all the 252K email messages in the Enron email dataset by yourself.
But with SQL it’s easy to search for keywords, like “Special Purpose Entity”, “Bankrupt”, “Fraud”, “Shutdown”, “Talking Points”, “FERC” and so on. They begin to reveal what really went on inside the minds at Enron.
“I wish we could get caught. We are such a crooked company.” Sherron Watkins – former Vice President of Corporate Development at Enron
What can we discover about Enron’s People Of Interest by analyzing their email using SQL? Among other things, there was some very abusive management at Enron.
What can we discover analyzing Enron emails using SQL? Quite a bit actually.
For a Recommendation Engine, which tool would you use: SQL and RDBMS, or a Graph Database?
NEO4J has provided a very functional web interface to find information on objects returned from queries. The relationships can be turned into a graph instantly.
NEO4J can easily do many things better than a traditional RDBMS could. The graph database looks better suited to some applications than RDBMS, or linked lists. For example: molecules, tree structures, social networks, or paths.
What if some of your objects require parent objects 10 layers deep first? ie: type, table, function, view, synonym, package, procedure, etc. All_Dependencies only goes one layer deep.
Here is a very complex script to find all the successive parents of an object.