Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein

Wednesday, 4 February 2015

Data Visualization Tools

A couple of Data Visualization tools to help with analysizing structured and unstructured .


This is Elasticsearch’s data visualization engine. It allows native interaction with all  data in Elasticsearch via custom dashboards. It has dynamic dashboard panels displaying changes to queries in real-time. Kibana works with any kind of data — structured and unstructured. It helps understand large volumes of data, easily create bar charts, line and scatter plots, histograms, pie charts, and maps.


Banana is the open source port of Kibana 3 and is available on GitHub at https://github.com/LucidWorks/banana/

Banana is a tool that allows you to create dashboards to visualize data stored in Solr.

The Banana dashboard has several panels that show the data

Saturday, 24 January 2015

Management of Database Systems Research, a précis on Technet

 Graphics by @DeepFat.

I am very pleased to announce that an article introducing my research on A Study into Best Practices and Procedures used in the Management of Database Systems entitled Management of Database Systems Research, a précis is published on the TechNet UK Blog.  http://bit.ly/1yMvzzS

There is a fun cartoon accompanying the article by an amazing illustrator, Andrew Fryer.

Thank you Charlotte Utting @TechNetUK

Saturday, 10 January 2015

Database Research Publication

I have been working on my part time research, at The Open University, for my doctorate for a number of years which is a study into best practices and procedures used in the management of database systems
For the start of any research it is necessary to accurately baseline the field of study. This baseline was created through a worldwide quantitative survey to examine to what extent  best practices and procedures were utilised by the database community for the management of database systems. 453 respondents kindly contributed to the survey. Part of this research from the quantitative stage is now published in the Information Systems journal. 

An Audio Slides presentation is available introducing the paper http://www.sqltoolkit.co.uk/publications.html  

The formal reference:
Holt, V. et al., 2015. The usage of best practices and procedures in the database community. Information Systems, 49, pp.163–181. Available at: http://linkinghub.elsevier.com/retrieve/pii/S0306437914001914
DOI: http://dx.doi.org/10.1016/j.is.2014.12.004

The free link is valid until February 24, 2015 http://bit.ly/1zqTjLo

More information about the research can be found at http://www.sqltoolkit.co.uk/ 

Friday, 2 January 2015

Data and Database Predictions for 2015

There are many predictions of what data and database advancements will transpire throughout 2015. These are my favourite data and database predictions for 2015.

Top 10 2015 Predictions for Microsoft Azure

PAAS will provide a more economical… the case for IAAS based services is being undermined by easier to use PAAS services.

Why 2015 Will Be Year of Big Data: Oracle's Seven Predictions

Data is a new form of capital. Ultimately, information about people, places and things will truly differentiate enterprises.

IDC Reveals Worldwide Big Data and Analytics Predictions for 2015

Growth in applications incorporating advanced and predictive analytics, including machine learning, will accelerate in 2015. These apps will grow 65% faster than apps without predictive functionality.

Database Predictions for 2015

SQL and NoSQL will become best friends

10 Predictions for Data and Analytics in 2015

Hybrid architectures will become the norm for many organizations,

Gartner Identifies the Top 10 Strategic Technology Trends for 2015

Analytics will take center stage as the volume of data generated by embedded systems increases and vast pools of structured and unstructured data inside and outside the enterprise are analyzed.

Your top predictions for Business Analytics in 2015

LinkedIn Data Culture Discussions: Data storytelling will become the next 'big thing' in Analytics!

Thursday, 1 January 2015

Friday, 19 December 2014

Database Research

My first research paper, from my doctoral research, has been published and available online 18 December 2014. It is currently an article in press, uncorrected proof. Articles in Press do not have all bibliographic details available yet. The full type set article will be available soon.

The paper is entitled The Usage of Best Practices and Procedures in the Database Community published on ScienceDirect as part of the Journal Information Systems Read More

There is an audio slides presentation introducing the paper.

V. Holt, et al., The usage of best practices and procedures in the database
community, Information Systems (2014),http://dx.doi.org/10.1016/j.is.2014.12.004

The Information Systems journal aims are

Databases: Their Creation, Management and Utilization

Information systems are the software and hardware systems that support data-intensive applications. The journal Information Systems publishes articles concerning the design and implementation of languages, data models, process models, algorithms, software and hardware for information systems.

Subject areas include data management issues as presented in the principal international database conferences (e.g. ACM SIGMOD, ACM PODS, VLDB, ICDE and ICDT/EDBT) as well as data-related issues from the fields of data mining, information retrieval, internet and cloud data management, web semantics, visual and audio information systems, scientific computing, and organisational behaviour.

Friday, 5 December 2014

Data & the Quest for Understanding Complexity Part 3

Data and his extraordinary adventure forges ahead.

Data's pioneering story continues to bring insight to the data and database world.