I know I promised a follow up on 'Aspects of Data warehousing' but I got side tracked. I have a fond interest in IoT and all those new technologies. Especially technologies like IFTTT and MQTT. The challenge is to bring these in relation to my work field: data warehousing and business intelligence. I just came up with the idea of linking an event in a database to blink a hue-lamp in my house. Crazy or not! But think of it, something happens during the nightly processing of the data warehouse and my hue-lamp at home turns red. Funny and useful. How to crack this challenge ... 1) we need a kind of FIFO in the database to register our events. 2) we want to use IFTTT, because IFTTT can control my hue-lights. 3) we need to create a bridge to link the dequeuing of the FIFO to IFTTT (built in Java) 4) we will use Microsoft SQL server as database (just as example) Lets define a table for our FIFO: CREATE TABLE [ttm].[ADM_TELEMETRY_LOG]( [ID] [numeric](8, 0) IDENTITY(1,1
Opinions around Business Intelligence, Data Analysis and Data Warehousing