Install Sqlite And Query Firefox Log Files Using SQL

September 10, 2014

Firefox saves a lot of log information in RDBMS files that can be queried in sqlite, using standard SQL commands.

SQLite3

SQLite3

 

To query the files, you have to have the right version of sqlite. Turns out that an old version was installed with my Redhat Linux 6.4 installation and I had to upgrade it in order to see the data. Here is how you can install the software and query the logs.

 

When I ran sample sqlite queries I found on the web, I got lots of errors:

sqlite3 ./cookies.sqlite 'select count() from moz_cookies'
Error: file is encrypted or is not a database


Read the rest of this entry »


Four Ways To Install Software On Linux

September 9, 2014

New to Linux?  Here’s some information that might be useful.

Linux is different from Windows in how software is installed. In Windows, starting with a CD, DVD, or an executable file, you run an executable file and install the software, usually via a GUI with prompts.

 

Redhat Desktop

Redhat Desktop

 

However, in Linux, there are at least 3 or 4 different ways to install software:

rpm packages
yum (related to rpm)
Unzip a file into a directory
Run an executable file or script   Read the rest of this entry »


Statistical Analysis on Changing Work Values in the USA

June 18, 2014

Abstract:

Statistical analysis of the USA General Social Survey (GSS) data shows that work values changed radically after the 2008 recession. What used to be the most important value, “Work important and feel accomplishment” became the least important. What used to be the least important values, “Short working hours”, and ” No danger of being fired” became the most important in 2012.

 

Core Values

Core Values

 

 

Background:   Read the rest of this entry »


The Variability of Resumes In The Hiring Process – Irrational Behavior

June 15, 2014

This spring I took an online course from Coursera, Irrational Behavior, as taught by Dr. Dan Ariely. It was a fascinating course, one that I enjoyed immensely.

Irrational Behavior with Dr. Dan Ariely on Coursera

Irrational Behavior with Dr. Dan Ariely on Coursera

See my comments on the course from my previous post on Irrational Behavior and Hoarding.

The other writing assignment in the course, was to “Design An Experiment”.  In this course, “experiment” refers to a psychological experiment.  Not a physics, chemistry, or computer science experiment.

From the guidelines – “Design An Experiment” – Please include the following in your paper:
A brief summary of previous (relevant) research. Be sure to use and cite at least one piece of research or theory that your experiment builds on.
Research question. What do you want to find out?
Your hypothesis. What do you think you will find?
A brief overview of the proposed design including identification of your independent and dependent variables.  For more details, check out this guide.
Implications. If your study turns out the way you expect it to, what does that mean?

 

I’ve often thought of the shortcomings of resumes. As so, in many ways, using resumes is rather irrational.  So, I designed an experiment to test the variability of resumes. Read the rest of this entry »


Hoarding and Irrational Behavior

June 12, 2014

This spring I took an online course from Coursera, Irrational Behavior,  as taught by Dr. Dan Ariely, in conjunction with Duke University.

Dr.Dan Ariely Cartoon

Dr. Dan Ariely Cartoon

 

It was a fascinating course, one that I enjoyed immensely. Different weeks focused on different subjects: Decision Illusions, Money, Cheating and Crime, Work, Self control, how emotions affect decision making. There was always another great insight about human behavior from some experiment that Dr. Ariely or other researchers had conducted.

Part of the class involved some writing assignments. The first assignment was to write a paper to solve a problem, using the principles covered in the Irrational Behavior course.

From the course guidelines, “Solve a Problem”:
There are three parts to this assignment: 1) Describe a problematic behavior 2) Outline existing research 3) Propose a solution. Basically, you will come up with a research-based solution to a problem, applying something that you have learned in this class to a real world problem

I’d seen those shows on television about hoarders, and I decided to apply the Irrational Behavior concepts to hoarding.  When you think of it, it is a most irrational behavior.

Read the rest of this entry »


Tuning The Untunable: When Indexes and Optimizer Don’t Help

June 8, 2014

In 2004, I gave a tuning presentation in the Boston area at NOUG

http://noug.com/

If you haven’t seen it, do take a look. It actually went viral and I received emails from around the world.

The PDF can be found here:

http://rodgersnotes.wordpress.com/2010/09/14/oracle-performance-tuning/

Recently, I gave a tuning presentation at the Manitoba Oracle User’s Group

http://mboug.wordpress.com/

This MBOUG presentation is a follow up. It covered a number of very mysterious tuning scenarios that I’ve encountered since NOUG, and the techniques I used to overcome them. In these cases, using optimizer and indexes usually did not help at all.

The PDF can be found here:   Read the rest of this entry »


Presentation: Graph Databases – Overview and Applications

June 6, 2014

In April 2014, I gave a presentation at my Alma Mater, the University of Winnipeg: Graph Databases – Overview and Applications

It was presented to the faculty and students of the Applied Computer Science Master’s program.

Most had not seen graph databases before. However, I expect that some of them will be using graphs in the near future.  :)

A PDF of the presentation can be found here:

Read the rest of this entry »


%d bloggers like this: