Recent Tutorials

Database System Architectures

What You’ll Learn in this set of notes Database System Architectures Mainframe Architecture Personal Computer – Stand-Alone Database File Sharing Architecture Two-Tier Client/Server Architecture Three-Tier Client/Server Architecture Distributed Database Architecture Open Database Connectivity (ODBC) Triggers and Stored Procedures Textbook Resources Connolly/Begg/Holowczak (BDS) Elmasri/Navathe (3rd ed.) Kroenke (7th ed.) McFadden (5th ed.) Chapter 1 and Chapter 15 […]

Continue Reading →

Consistency, Availability and Partition Tolerance

Review of ACID Properties Consider a centralized (one copy of the data, one instance of the DBMS) DBMS with multiple users. Atomic – A transaction is an indivisible unit of work that either commits or aborts. Consistency Preserving – A transaction will take the database from one consistent state to another consistent state. Isolated – […]

Continue Reading →

Installing Pentaho Business Analytics on the Windows Operating System

Goals of this Tutorial The goal of this tutorial is to outline the major steps involved in installing the Pentaho Business Analytics (PBA) software in the Microsoft Windows operating system environment. The Pentaho Business Analytics suite includes design tools and servers to create analytics data models and schemas along with the ETL processes used to […]

Continue Reading →

Programming Interactive Brokers Java API in a Console Application – Contract Details

Goals of the Tutorial The purpose of this tutorial is to demonstrate the basic functionality of the Interactive Brokers (IB) Java Application Programming Interface (API) used for accessing Contract Details such as Options and Futures chains from within the IB trading platform. For example, by specifying only the underlying stock or index, we can obtain […]

Continue Reading →

Getting Started with Java Programming in Linux

Introduction In this tutorial I will cover the very basics of getting started with Java programming using the Linux operating system. Java is a very popular programming language that is used to develop software for everything form cell phones and cable TV boxes to huge enterprise information systems. While most of the steps are aimed […]

Continue Reading →

Programming Interactive Brokers Java API in a Console Application – Historical Data

Goals of the Tutorial The purpose of this tutorial is to demonstrate the basic functionality of the Interactive Brokers (IB) Java Application Programming Interface (API) used for accessing Historical market data in the IB trading platform. Concepts learned in this tutorial can be applied to larger projects such as building quote screens, capturing live market […]

Continue Reading →

Programming Interactive Brokers Java API in a Console Application – Real Time Data

Goals of the Tutorial The purpose of this tutorial is to demonstrate the basic functionality of the Interactive Brokers (IB) Java Application Programming Interface (API) used for accessing real-time market data in the IB trading platform. Concepts learned in this tutorial can be applied to larger projects such as building quote screens, capturing live market […]

Continue Reading →

Programming Interactive Brokers ActiveX API Using Visual Basic – Historical Data

Goals of the Tutorial The purpose of this tutorial is to demonstrate the basic functionality of the Interactive Brokers (IB) ActiveX Application Programming Interface (API) used for accessing historical market data in the IB trading platform. This tutorial will use Visual Basic as the programming language. Concepts learned in this tutorial can be applied to […]

Continue Reading →

Searching for Companies in FactSet

Introduction The purpose of this brief tutorial is to demonstrate how to search for Companies in FactSet. Start up the main FactSet Application. Go to the Windows Start menu, then All Programs, then FactSet and finally select the FactSet application: FactSet will automatically authenticate the user as it logs in. The FactSet AC Connection window […]

Continue Reading →

Running FactSet and working with the Excel Add-In

Introduction The purpose of this tutorial is to give a very brief introduction to working with FactSet data in Excel. This tutorial assumes you have FactSet installed on your local desktop PC and are working with MS Excel 2010 or MS Excel 2013. Some familiarity with the concept of stocks, foreign exchange and other financial […]

Continue Reading →