The Analysis of Relations Between Users on Social Networks Based on the Polish Political Tweets

The article presents a method of acquiring selected topical data from Twitter conversations and storing it in the relational database schema with the use of a scheduled cyclical process. This kind of storage creates the opportunity to analyze the dependencies between users, hashtags, mentions etc. based on SQL or its procedural extension. Additionally, it is possible to construct data views, which facilitates the creation of front end applications leading to efficient generation of cross sections of data based on different features: time of creation, strength of relations etc. Taking all of this into consideration, an application was developed that allows for graphical representation of relations with the use of the two algorithms: a Fruchterman-Reingold and a radial one. This program accepts the visual analysis and additionally it creates the opportunity to manipulate parts of a graph or separate nodes, and obtain descriptions of their features. Some conclusions about the relations between people conversing about Polish political scene were presented.