Social computing, Computational Social Science and Sociology and Methodology in Computer Science part 2

Yesterday I wrote some conclusion and something of a summary on my thoughts. Today it was time to "kavla upp ärmarna" (roll up the sleeves) and get going - doing - *something*

Well lets call it research, as research in its truest sense, I suppose - literally searching and reading about essentially *everything* yet *nothing* and a sort of "throw something at the wall and see what sticks" type of method (not to be confused with throwing a strand of pasta at the wall and if it sticks it's ready to eat - not the single pasta strand you threw but the whole batch of pasta you presumably made (now that would be funny if you only cooked one strand of pasta)  - you can view it as a SAMPLE representing the WHOLE (population)).

See, research is about statistics, that is my ultimate conclusion perhaps.

Okay, enough with the shenanigans. It was time to work, work on that search query I suppose - so I included all sorts of Booleans and grouping and whatnot; but ultimately needed to go back and just look at individual words and terms. Any long search query is bound to be somewhat cumbersome, if you want to really understand what is going on, I think. But for demarcation|delimitation, it really is what you need.

At one point - I realized that the only 20 hits was actually all there was about this particular topic.

However, lets get back to the topic; I suppose, if I have anything cogent to say about this topic, which has not been said before (of course not): now: qualitative methods are old school - analog and manual. But, there is a way out of the misery, and that is by involving computers, naturally!

However, you still need to know what to do with this godly power of computation: first you can go easy with word frequencies and such... then it's time for: latent semantic analysis and latent dirichlet allocation - you can also stumble into stuff like probabilistic latent semantic analysis and latent semantic indexing.

Then it's time for machine learning, or if it was perhaps already included in the previous (may be the case): Supervised Machine Learning (SML) and get into that sweet Bayesian statistics.

Let the computer do the job, and sit back and enjoy. I guess. Well, you need to prepare the datasets and do the training and install a bunch of software and well, learn some new math and statistics including but not limited to linear algebra *gulp*. But other than that, just sit back and relax; the transistors will do the work from now on.

Well that would have been the case unless I had a manual method lined up for a literary review; which will likely need to obey certain rules. However; this meta study now has its subject or topic, which is all of above. I think it's a massive study but lets hone in on the particulars; which I believe will be related to the method (quantitative) to some extent and the analysis (content|thematic analysis).

Well it's a mixed methodology I suppose; but treating the data, which is qualitative? With a qualitative method (thematic analysis, using content analysis methods?) I guess you can go wrong here. There are divides which needs to be clarified I can *clearly* see. But I think that is what is interesting. Perhaps.

We will see, it looks more philosophical than anything else, but might do for a meta analysis I guess.

Social computing, Computational Social Science and Sociology and Methodology in Computer Science

These recent weeks I have been struggling with defining a field and defining a research topic; which should include research questions and topics. That also included some methodology in Computer Science and the related field Information Systems.

So lets start with what I have concluded so far.

The topic of social computing is a field or part of Computer Science which deals with social aspects of computing. I will not go into the exact definition here but I imagine it reads something like "social aspects of using computers and interacting with computers and computer information networks". I think that might be a decent starting point.

It should be quite "simple", yet as always in academia, there is a tendency to complicate things wherever possible so lets remember that. However, by simple, I mean, just take the words "social" and "computing", and it should entail the intersection of these two broader topics as well as where they intersect.

That would make the topic somewhat interdisciplinary. I think that can be a good thing, that I could delve into topics like social science and sociology, as well as perhaps some implementation of computer technology in for example networks.

Okay, so this leads me to the methodology part. As I have recently learned and pondered is that computer science traditionally could be viewed in the positivist tradition. That would make sense, as computers are quite quantitative in nature and therefore would oblige by a classical scientific approach.

However, when working with social aspects, qualitative aspects also become important. Now, one can go either way: purely quantitative or qualitative but I think a mix might be nice. I'm thinking of a methodology where both aspects are being taken into account. (I will not go deeper into this at this point, but there's a case to make for choosing a mixed methodology in this particular case -- see below for somewhat of an example).

When I researched this and read about it, what crossed my mind was the meta level of this, or rather, the "computer science" angle, rather than just using some computer technology in a qualitative method. I guess it's wishful thinking but if quantitative method could be applied directly to "social data" - perhaps something would come out of it.

And it appears that this has been done, especially in the field of computational sociology, where a lot of interesting computer based methods are being used.

It also made me realize that another interest of mine; which I wasn't sure was quantitative, actually was -  text analysis. However, I think it holds, or can hold, some qualitative aspects as well.

Well, this might too simple, or it is exactly what science should be about - connecting different areas which haven't been connected before (well you'll most likely won't be the first, but great minds think alike a what not)...

I could also see that one uses quantitative method for "exploratory" purposes, and then, perhaps defines the research problem and topic a bit further. Then adding a qualitative "measurement", and by combining the two, getting further in the analysis, than just using either of the two.

For instance: get the word count of a certain topic in a certain text or group of texts, or get the top 10 word counts in a certain text  or group of texts. Lets say that word is something crucial to whatever is being studied, then it would make sense to learn more about this word and its meaning in the context, rather than just running the word frequency function and stating that this or these word/s are prevalent.

Well, this is what I've been thinking about and this is the preliminary conclusions I guess. Now I just need to pick a relevant "sub topic" and go ahead with my methodology... Unless it seems to be the case that I will need to use a specific methodology.

However, what I have described here, will be part of my "theory", I suppose. Or what I except to find. This will the be considered somewhat deductive, although I suspect there may have been some moments of "induction", as well. Or rather, my chosen sub topic, may or may not have support for what I have just posited.

The Modded Chassi Project

I had an old Fujitsu Siemens(TM) chassi laying around which I decided to mod a bit. The idea was to just continously work on this chassi making various "improvements". Mostly to learn more on how to do chassi mods and have some fun.

So far what has been done is this: 

1. repainted the front, 
2. made a circular shape on one of the sides, 
3. added some LED lighting, 
4. and finally put a hinge to hold the side a little bit better.

1. repainted the front

The front was grey and had seen its better days, so I repainted it using black aerosol paint and clear lacquer.

Colour matched with the CD/DVD.

 

2. made a circular shape on one of the sides

I got some help from a friend cutting this circular shape since I didn't have much experience with an angle grinder. I did however learn to use an angle grinder, and have used it in a different chassi project. An angle grinder can be difficult to use but is a great tool when modding a chassi, especially thin metal sheets. Be careful and make sure you have the proper training if you decide to use an angle grinder, as it is a very powerful and a potentially dangerous piece of equipment.

 

My first cuts with an angle grinder.

 The circular shape.

 

The final result.

 

3. added some LED lighting

I basically just used a LED stripe which had adhesives attached to it. Then it was connected to the USB-port. The LED is RGB so it can switch to many different colours using a wireless remote control.

For future improvements, it would be cool to be able to program the LED stripe and maybe have it synced to music.

RGB LED + remote control plugged in & working.

 The RGB LED stripe attached to the side of the chassi.

 

In action.

 

 Illuminating the darkness.

 

4. put a hinge to hold the side

 

I always thought the side was difficult to take off, so I wanted a hinge solution. I opted for one hinge which was not enough to hold the side in place. Therefore it is a bit tilted right now. I think I need two hinges for it to be more stable. There was quite the bit of work to get this in place but I hope I will be able to make it more stable in the future - adding another hinge.

 

 Drilling the holes in the side for the hinge.

Cutting out some superfluous material...

 

 The hinge attached to the side.

 

 The hinge attached to both the frame and the side.

 

Adding jar files to a Java Project on the Command Line using Classpath

This is a simple post about how you can add jar files on the command line so that you can incorporate their contents in your own projects. This can be handy if you only want to test a third party library and not work with an IDE.

The idea is that if you want to use a third party library which is contained in a jar-file, what you simply do is that you use the -classpath option in your compile command:

javac -classpath ".:sqlite-jdbc-3.39.3.0.jar" TestClass.java

Where sqlite-jdbc-3.39.3.0.jar is the third party library jar file which you have downloaded. In this case SQLite.

What you must do next is to use the same -classpath option in your run-command:

java -classpath ".:sqlite-jdbc-3.39.3.0.jar" TestClass.java

You can watch an example of this in the video below.

Junction Table in SQLite SQL Database with Cascade on Update and Delete

This is a complementary blog post to the video I've posted on the topic. In this blog post I will simply provide what to type into the command line of SQLite. The video is about the concept of using a junction table (also called a linking table) which is the "bridge" between two tables. This gives you a layout of three tables which is very useful in many practical applications and conforms to the normalization rules of database design. You will have one table with artists and one table with albums, and through the junction table you can link the artist to the album.

First you will start on a new SQLite database file by typing "sqlite database.db" or "sqlite3 database.db" in the command line of your preferred Linux distro*. This will create the database file in the current directory. The cascading will not work in sqlite3 (and not in previous versions at all, since there was no support for the foreign key) unless you initially type in:

pragma foreign_keys = ON;

This must be done every time SQLite is started (unless you configure the startup settings).

Create the tables:

artist:

create table artist (
artist_id integer PRIMARY KEY AUTOINCREMENT,
artist_name text NOT NULL);

album:

create table album (
album_id integer PRIMARY KEY AUTOINCREMENT,
title text NOT NULL,
year integer NOT NULL,
tracks integer NOT NULL);

artistalbum: <- junction table

create table artistalbum (
artistalbum_id integer PRIMARY KEY AUTOINCREMENT,
artist_id integer NOT NULL,
album_id integer NOT NULL,
CONSTRAINT fk_artist_id
FOREIGN KEY (artist_id)
REFERENCES artist (artist_id) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT fk_album_id
FOREIGN KEY (album_id)
REFERENCES album (album_id) ON UPDATE CASCADE ON DELETE CASCADE
);

Add data:

insert into artist (artist_name) VALUES ('ABC');
insert into album (title,year,tracks) VALUES ('CDE',1999,3);
insert into album (title,year,tracks) VALUES ('DEF',1999,3);

Add data in the junction table so that "ABC" has 2 records (the added albums):

insert into artistalbum (artist_id, album_id) 
VALUES ( (SELECT artist_id FROM artist WHERE artist_name = 'ABC'),
(SELECT album_id FROM album WHERE title = 'CDE') );

insert into artistalbum (artist_id, album_id) 
VALUES ( (SELECT artist_id FROM artist WHERE artist_name = 'ABC'),
(SELECT album_id FROM album WHERE title = 'DEF') );    

Get all tables:

SELECT artist.artist_name, album.title, album.year, album.tracks
FROM artist JOIN artistalbum ON artist.artist_id = artistalbum.artist_id
JOIN album ON album.album_id = artistalbum.album_id;

Get from all tables where the band name is 'ABC':

SELECT artistalbum.artistalbum_id, album.title, artist.artist_name
FROM artist INNER JOIN (album INNER JOIN artistalbum ON album.album_id = artistalbum.album_id)
ON artist.artist_id = artistalbum.artist_id
WHERE artist.artist_name='ABC';

Delete records using cascade from the "associate table", i.e. the album or the artist table:

DELETE FROM album WHERE title = 'DEF';

You can now notice the that data has been removed from both the "associate table" and the junction table. Make a delete from the album table and all the records in the artistalbum table will also be deleted. However, the artist table will not be effected, so an additional delete must be made there as well.

Check out the video for more details on how this works.

* similar syntax should work for SQLite on other OS:es too.

Art Videos with ZGameEditor Visualizer part I

ZGameEditorVisualizer comes with FL Studio in all its versions.

ZGameEditor is also a free open source software: http://www.zgameeditor.org/

Creating videos with ZGameEditor is pretty straight forward and there are several tutorials out there. In a coming post I will write a basic tutorial on how I like to use ZGameEditor.

Starting off, I will simply post my work with ZGameEditor to give you an idea of what you can do with it.

Video 1

nlsound – sky city

Effects used: colours and a glitch effect. That’s it! The rest is just playing with the clips, which were part of an idea where I would film the city from two angles.

Video 2

nlsound – art sky fx

Effects used: colours, glitch and a kaleidoscope effect. Initial work with choosing and trimming clips.

Fruity Formula Controller, which I intend to cover in an upcoming post, was used in the song.

This video is a bit more advanced but hardly so. I find working with a few effects more in depth rather than using too many can be a good approach.

And that’s all and the way I’ve worked with ZGameEditor Visualizer. In the upcoming post I will go through some basics and show some features which are common. Stay tuned.

Disclaimer: I am not affiliated with FL studio or ZGameEditor in any way in this blog post.