Instant SQL Formatter (beautify)

I quite often have a need to reformat RDBMS SQL statements into something readable and consistent. The advantage of doing this is the statements are easier on the eye to read.

Two web sites I find useful in this respect are:

http://www.dpriver.com/pp/sqlformat.htm

http://sqlformat.org/

Keywords: sql format beautify

Gnuplot and graphs

Gnuplot is a command-line driven graphing utility for various platforms. I have used this in the past and the product came to mind again as I was learning to create graphs using R. At present I'm I've not gone back to Gnuplot as I'm creating my statistics graphs using R.


See also

http://www.gnuplot.info/

https://en.wikipedia.org/wiki/Gnuplot

R (programming language)
https://en.wikipedia.org/wiki/R_(programming_language)

https://www.r-project.org/about.html

Keywords: r language, gnuplot, software

CERN and ROOT

ROOT is an object-oriented program and library developed by CERN. It was originally designed for particle physics data analysis and contains several features specific to this field, but it is also used in other applications such as astronomy and data mining.

It provides all the functionalities needed to deal with big data processing, statistical analysis, visualisation and storage.

Rene Brun and Fons Rademakers,

ROOT - An Object Oriented Data Analysis Framework,

Proceedings AIHENP'96 Workshop, Lausanne, Sep. 1996, Nucl. Inst. & Meth. in Phys. Res. A 389 (1997) 81-86.

I noted this with interest as I was looking for something else relating to statistics. I don't think I'll be taking this language any further at present as I've other things to learn.

See also

http://root.cern.ch/

https://en.wikipedia.org/wiki/ROOT

Keywords: root cern software

Online Distance Calculator

Distance calculator is a tool for calculating the distance between two cities or places on map.

Distance units available when obtaining the distance are:

• Kilometers
• Miles
• Meters

Upon entering the start location and end location cities, the result is shown as both as the crow flies (great circle distance) and the driving distance if this journey were taken by road.

Really useful and helpful web site if one wants to find distances between two cities.

See also

http://www.distancecalculator.net/

COMP102 for 2015 Tri T1 Course (Java)

Victoria University of Wellington, School Of Engineering and Computer Science hosts the Java course “Introduction to Computer Program Design: COMP102 2015 Trimester T1” (https://ecs.victoria.ac.nz/Courses/COMP102_2015T1/WebHome).

The purpose of the course is:

Quote

This course introduces the fundamentals of programming in a high-level programming language (Java), using an object oriented approach to program design. Students develop their programming skills by constructing computer programs for a variety of applications. The course provides a foundation for all later courses in computer science, and develops programming skills useful for students in many other disciplines.

Unquote

Given that Java assignment files can be downloaded, I felt it's a useful way to practice my Java skills as seen from the perspective of Victoria University of Wellington.

Keywords: java new zealand cs computer science

Oracle ODP.NET and Windows PowerShell

Use Oracle ODP.NET and PowerShell to Simplify Data Access

The above link is an interesting article on the subject of using Oracle ODP.NET and Windows PowerShell to access to Oracle databases.

In order to do this, a complete package called ODAC ( Oracle Data Access Components ) from Oracle can be downloaded to provide the components in order to achieve this.

The site 'Data Provider for .NET Developer's Guide' (http://docs.oracle.com/cd/E51173_01/win.122/e17732/client.htm#ODPNT0008) describes the Oracle Data Provider for .NET classes which will be helpful in developing any Oracle ODP.NET application or script.

The Data Provider for .NET Developer's Guide can be found at http://docs.oracle.com/cd/E51173_01/win.122/e17732/toc.htm

Keywords: oracle powershell odp .net