In a dimensional model, you have a fact table and multiple dimension tables related to the fact table. Slowly Changing Dimension (SCD) is the technique to maintain the history of data in dimension tables.
The basic SCD has three types, called Type 1, 2, and 3. SCD Type 6 combines the three basic techniques. After introducing these three basic types, this article by Djoni Darmawikarta, shows by example what SCD Type 6 is and how it works.Read Slowly Changing Dimension (SCD) Type 6 in full
In this article by Rihards Olups, author of Zabbix 1.8 Network Monitoring, we'll explore usage of proxies that collect the data on behalf of the Zabbix server and then transmit it back to the server, which helps when remote locations can't be accessed directly because of firewall concerns. It also reduces the load on the Zabbix server.Read Using Proxies to Monitor Remote Locations with Zabbix 1.8 in full
This article by George Papadongonas and Yiannis Doxaras, authors of Drupal E-commerce with Ubercart 2.x, helps you to implement more complex marketing techniques. You may wonder why is there a need to invest more time after having already set up your e-shop. But, you have to keep in mind that there are thousands of competitors out there, selling similar or the same products that you're selling. So, being good is not enough, you have to be one of the best. In this article we are going to show you:
- How to implement more complex marketing techniques, such as cross-selling using taxonomy and recommendation systems
- How to create an alternative layout for products using panels
- How to enhance the user interface using views
In this article by Murat Yilmaz, author of OpenX Ad Server: Beginner's Guide, we will start our first campaign and show the first banner as fast as we can by using the minimum settings of OpenX Ad Server.
In this article we shall:
- Define an advertiser
- Create a campaign and banner
- Define a website and zone on this website
- Link the banner to this zone
- Serve this banner on this website zone by using a web page