Data, data en nog eens data

Category: data warehousing

  • Everything is SQL – the story of OBIEE

    —

    by

    tom
    in

    As one can imagine, SQL is the main engine to start loading a report in OBIEE. In principle, one has two kinds of queries. One query runs against the Oracle DBMS. This is the physical query that we know from any Oracle client. It can be found on the main main. Choose New > Analysis…

  • Using OBIEE spatial reporting

    —

    by

    tom
    in

    Using spatial reporting in OBIEE is not for the faint of heart. However it is also rewarding. The reports look great; it is new and henceforth exciting. It is challenging but the outcome stands out. However on the route to the reports, some obstacles must be overcome. Let me provide some thoughts on the obstacles…

  • Spatial Reporting in OBIEE

    —

    by

    tom
    in

    OBIEE allows you to create spatial reports. The idea is relatively simple. Instead of a tabular reports with rows and columns, we create a reports that are createad as a layer upon a map. So we have a map, with a layer of plotted values. When we have a report with a geographical component, such…

  • Latitudes and longitudes in the Netherlands

    —

    by

    tom
    in

    Getting geographical data on Holland is not a trivial matter. It took me a bit of tenacity to get the data. Hence I thought being a good idea to store my findings. I might need these data in the future. The first file that I found on the internet is a file with longitudes/ latitudes…

  • Oracle OBIEE – My First Report

    —

    by

    tom
    in

    Recently, I created my first OBIEE report. To be honest, my biggest problem was to identify which tools to use. I might overlook the clues, but it took me quite some time before I could identify the important tools that I had to use. Finally, I understood that two important tools must be used: [1]…

  • Oracle OBIEE

    —

    by

    tom
    in

    Recently, I came across OBIEE. This is an Oracle tool that is created to support OLAP – type investigation into a database. I have to confess: I am impressed with it. The first great thing for me as an analyst is that it closely integrated into existing Oracle tool. One may continue to use the…

  • Sqoop

    —

    by

    tom
    in

    Sqoop is a tool that allows you to ship data from a RDBMS to a Hadoop platform. Let us take an example to clarify this. One may have some data in a MySQL table persons, within database thom. This database is stored on server 62.51.51.999. The data can be accessed with the knowledge of the…

  • Avro – getting it work

    —

    by

    tom
    in

    When you read about Hadoop, you come across AVRO. This is a mechanism to exchange data via streams and it is named after the famous British aircraft industry that amongst many other types, delivered the Lancaster that helped to liberate Europe. AVRO can be implemented in many languages, amongst them PHP. Before continuing let us…

  • Map and reduce – what happens?

    —

    by

    tom
    in

    In Big Data, the concept of mapping and reducing plays a huge role. The idea is that a a massive dataset is split over several servers. On each server, a part of the data is investigated. This part is called a mapper. In a subsequent part, these parts are merged into an outcome. This latter…

  • Use Case

    —

    by

    tom
    in

    A Use Case is something that can be written after a context diagramme is written. A context diagramme provides an overview of the whole system with its interfaces to the outside world. The use cases are written on base of each of the individual interactions between the system an one of its external systems. As…