Strange characters
tom
In some cases, you get unexpected weird results being returned from your database like: Testù�Summary. This may be expected as one inserted TestùęSummary. Apparently symbols like ę were not recognised…
Starting vbscript
I recently came across vbscript. I was a bit curious to see how this works. As a first step, I created a small batch file (“tom.bat”) that invokes a vbscript.…
Security certificates
I got interested in security certificates. What are these? How does it work? It is possible to use it on your own website? Those were my questions. The principle is…
Security and compliance
Security and compliance has many different aspects. In the list below, I try to provide an overview on these aspects. We have seen: Authentication. Is the person really the person…
A check list for the assessment of a data warehouse
Yet another checklist Regularly, one comes across an assignment whereby one has to assess a data warehouse. (at least in my type of work). I found a nice checklist that…
Skeleton Functional Design
Quite often, I have to write a functional design. Such a design can be a tedious job. Part of time is spent is spent on how to represent the findings.…
Data Warehouse and allocated cost data
In a previous post, I showed that costs data may be allocated to other departments or levels of granularity to enable cost analysis. The allocated cost data are artificial data:…
Cost Allocation
In most organisations, cost data are collected on a different level of granularity or attached to another dimension as we would like to see the cost data. Two examples. Cost…
XML records in Oracle tables
It is possible to store XML records in an Oracle table. This is one (of the many) way to retrieve XML information from an Oracle environment. It is actually quite…
Product Types
I recently encountered a nice model on product types that I would like to share. A product type can be understood as an concept of a product, much like the…