Article Network

Creating an Analysis Services Cube with Visual Studio 2008 - Part 2

by Jayaram Krishnaswamy | July 2008 | .NET Microsoft

As noted in Part 1, OLAP presents Business Intelligence via what is known as a CUBE. A Cube has many dimensions and it provides a faster method to access the intelligence compared to the structured querying where the overhead of 'Joins' makes it inefficient. Taking the example of a 'Sales' Cube having everything related to sales we can identify the dimensions as the Sales Outlet, The Customers , the Products and the time period over which sales are being audited or looked into. We also notice that there are certain measures that we are interested related to these 'dimensions' like 'Store Sales', 'Cost of Products, 'number of units sold' etc. The Analysis Services analyzes these intricate relationship that exist in a cube. In this part we will see the process of creating a Cube in VS 2008.

Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 2 in full

Testing a HELP System in a Java Application

by Lindsay Peters Tim Lavers | July 2008 | Java Open Source

It is always necessary to have a Help section in our software application. When users do not find a way out from a specific problem in our application, it is the help section they turn to. Hence it is important that the help feature is well maintained and without any errors. In this article by Tim Lavers and Lindsay Peters, we will see the errors that can occur in our help section and how to test the help section.

Read Testing a HELP System in a Java Application in full

Joomla! Installation on a Virtual Server on the Net

by Hagen Graf | July 2008 | Joomla! MySQL Content Management Open Source PHP

The installation of Joomla! is a matter of five minutes. If you have installed it before, you can do it in two minutes. In order to be able to even start the installation, your development environment must include a web server that supports PHP and a database that is supported by Joomla!. Joomla! is one piece of the puzzle in this so-called Client-Server System. This topic is very complex, since there is an unmanageable number of providers and an even more unmanageable combination of installed Apache, PHP, and MySQL versions and Webspace administration tools such as Visas and Plesk.

In this article by Hagen Graf, we focus on the following points:

  • A PHP safe mode, possibly activated in the php.ini
  • Prohibited conversion of URLs with Apache because of the non-activation of the so called rewrite engine
  • Directory rights in Linux that are set differently than in Windows
Read Joomla! Installation on a Virtual Server on the Net in full

JBoss jBPM Concepts and jBPM Process Definition Language (jPDL)

by Matt Cumberlidge | July 2008 | JBoss Java

JBoss jBPM is a free, open-source, business process management solution. It enables users to create business processes that coordinate people, applications, and services. JBoss jBPM is an Integrated Development Environment (IDE) , which is based on another open-source tool, Eclipse, which is widely used for Java development. The JBoss jBPM IDE gives us not only our graphical process modeler, but can also generate the workflow user interface for us. In this article by Matt Cumberlidge, we will explain the concepts or the key terms in JBoss jBPM. We will also look at jBPM Process Definition Language (jPDL).

Read JBoss jBPM Concepts and jBPM Process Definition Language (jPDL) in full

PHP Data Objects: Error Handling

by Dennis Popel | July 2008 | MySQL Open Source PHP

Most web applications have rather simple error handling strategy. When an error occurs, the script terminates and an error page is presented. The error should be logged in the error log, and the developers or maintainers should check the logs periodically. In this article by Dennis Popel, we will look through the most common sources of errors in database-driven web applications.

  • Server software failure or overload such as the famous "too many connections" error
  • Inappropriate configuration of the application, which may happen when we use an incorrect connection string, a rather common mistake when an application is moved from one host to another.
Read PHP Data Objects: Error Handling in full

Backing Up and Restoring TYPO3 Websites

by Michael Peacock | July 2008 | MySQL Content Management Open Source PHP

All web applications and web servers have security vulnerabilities and there is every chance that our website will be compromised. Most web hosts have their own backup procedures in place, but it is not uncommon for a web host to become victim to an attack, and have problems with a small percentage of its customer backups. Because of this it is very important that we keep backups of our website. In this article by Michael Peacock, we will see how to backup our website and restore it back gain from our backup.

Read Backing Up and Restoring TYPO3 Websites in full

Creating an Analysis Services Cube with Visual Studio 2008 - Part 1

by Jayaram Krishnaswamy | July 2008 | .NET Microsoft

A cube in the context of Business Intelligence is a multidimensional representation of business facts that can be accessed quickly to provide specific information. (This can be accomplished by properly written queries in a relational database, but the overhead involved in processing the query, which may involve a large number of 'joins', is simply not efficient). While a relational model is more suited to OLTP, a different model is necessary for OLAP. Whereas highly normalized tables are a norm for OLTP, the model for OLAP does not require normalization. The SQL Server Analysis Services that supersedes the earlier versions is specifically meant for analyzing data in the archives or in OLTP databases to be retrieved and burnished to provide the 'Intelligence' by mining for facts hidden in the data. This two part article by Dr. Jayaram Krishnaswamy describes how a Cube is designed using Visual Studio 2008 and how it may be browsed on the Analysis Server. In Part 1, the necessary items for creating the Cube, namely the Data Source and Data Source Views are described.

Read Creating an Analysis Services Cube with Visual Studio 2008 - Part 1 in full

Qmail Quickstarter: Virtualization

by Kyle Wheeler | July 2008 | Linux Servers Networking & Telephony

One of the most interesting extensions to the standard mail setup is that of virtualization. In this article by Kyle Wheeler, let's see the many reasons for wanting to virtualize email services, from hosting multiple domains with different users to simply extending the ability to apply policies to different sets of email. There are three basic techniques that are used with a standard qmail system for attaining different forms of virtualization: qmail's control/virtualdomains file, user-definable address extensions, and running multiple qmail instances on the same system.

Read Qmail Quickstarter: Virtualization in full

Blender 3D: Interview with Allan Brito

by Allan Brito | July 2008 | Open Source Web Graphics & Video

Blender is an open source, cross platform suite of tools for 3D creation, capable of modeling, rendering, and animating 3D environments. Since Blender is completely free, everyone can download and use it immediately in commercial projects. It's not a shareware with limited tools, or time constraints; you can use it freely. In the past few years, the Blender user base has grown significantly. One of the positive aspects of Blender is its size—it is only 10 MB and we can even run it directly from a portable drive. Another great aspect of Blender is that we can use various Operating Systems such as Linux, Windows, and Mac OS X, leaving us the choice of which one to use.

Packt spokesperson Meeba Abraham approached Allan Brito at the heart of this movement to understand his take on the future of Blender.

Read Blender 3D: Interview with Allan Brito in full

Themes in e107

by Theodore S Boomer | July 2008 | MySQL Content Management Open Source PHP

The look and feel of any website is a major factor that drives traffic towards the site. A theme is responsible to give a consistent look and feel to a website. In this article by Theodore S Boomer, we will see how to select and delete themes for e107 websites. We will also have a look at the theme layout and build an understanding of it.

Read Themes in e107 in full

Linux Thin Client : Considering the Network

by David Richards | July 2008 | Architecture & Analysis Linux Servers Networking & Telephony Open Source

Much information already exists concerning methods for deploying networks and hardware. In this article by David Richards, we shall try to clarify differences between using a network with personal computers and thin clients with the help of anecdotes. Certain designs have also proven to be very stable and provide the best possible solution.

Read Linux Thin Client : Considering the Network in full

Installing dotProject

by Lee Jordan | July 2008 | MySQL Open Source PHP

If you already have dotProject installed, you probably don't even need to skim this article, unless something has gone horribly wrong. In this article by Lee Jordan, we will cover the key information you need to know to successfully install dotProject, what to do if things are not working right, and how to avoid common pitfalls and hours of frustration.

Read Installing dotProject in full

Data Profiling with IBM Information Analyzer

by Djoni Darmawikarta | July 2008 | Architecture & Analysis

Data profiling is essentially data mining, but for a different purpose. You mine data to understand, to gain better knowledge about the data. While the more common use of data mining is for gaining the data insights for business purpose (e.g. customer buying characteristics), data profiling is for technical purpose. To be more precise, you do data profiling to gather and analyze the technical metadata characteristics of the data. Information Analyzer, data profiling software from IBM, helps you gain insight into such technical metadata characteristics as, for example, column data type and size (length).

This article is based on a case where a database table grew its size unexpectedly and its initial disk space allocation got strained. Looking at the growth pattern of the table, such as the number of new records (which was not that huge), didn’t give us any clue about the cause of the problem. In this article, Djoni Darmawikarta will step through the Information Analyzer process, run one of its functions called Column Analysis on a simple table (a scaled-down version of the real table), and show how the profiling output help solve the problem.

Read Data Profiling with IBM Information Analyzer in full

Using Lists and Tables with MediaWiki

by Mizanur Rahman | July 2008 | MySQL Open Source PHP

MediaWiki is a special software which is used to design Wikis. For any website, formatting is the key to creative and sophisticated designs. In this article by Mizanur Rahman, we will use advanced formatting components like lists and tables in MediaWiki to add content to a sample website.

Read Using Lists and Tables with MediaWiki in full

Module Development in Joomla

by Joseph L. LeBlanc | July 2008 | Joomla! MySQL Content Management Open Source PHP

Modules in Joomla can always help us to add special functionality or special features to our website. In this article by Joseph LeBlanc, we will see how to create and configure a basic module and centralize data access and output using helper classes. We will also have a look at how to select different display options using layouts.

Read Module Development in Joomla in full
Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software