DATAWORKS BLOG
Oracle - Missing Dates Query
Occasionally a situation will arise where data needs to be charted over time. However where there are intervals for which no data exists this can cause a problem. The following looks at an Oracle based solution to writing such queries. Suppose we have a table of events similar to table 1 below. Table 1. Events Table We may wish to calculate the number of events we have each day for the last week. A first pass at such a query…
Read Article
Test Driven Development – Unnecessary Overhead?
At a first glance TDD can seem to be an overhead that developers could do without. The idea of writing more code to verify the code providing the functionality could be viewed as a non-productive or non value added activity for developers. Primarily a developer’s focus should be on writing code and not testing. It is challenging enough to deliver software on time, without focusing on writing…
Intelligence Shouldn’t Be Mistaken For Data
Is MI just another buzzword by the industry to help sell MI or BI software solutions? Or does it really benefit manufacturing facilities and help them reduce costs and increase efficiencies? In the last number of years a lot of companies have focused on increased data collection from the shop floor - be it increased investment in SCADA solutions or Data Historians. Larger organisations have also focused…