Article Network

All | June | May | April

Mapping in Oracle Warehouse Database

by Bob Griesemer | August 2009 | Oracle

In this article by Bob Griesemer, we will discuss about Mapping, mainly STORE Mapping in Oracle Warehouse Builder 11g. We will build mappings with the additional features of Oracle Warehouse Builder. We will introduce the concept of transformations and operators that are available in OWB, which can be used for transforming and manipulating data between source and target. Along the way, we'll get to build a quick mapping for creating and loading a table that will be used as a lookup table.

Read Mapping in Oracle Warehouse Database in full

Displaying MySQL data on an ASP.NET Web Page

by Dr. Jayram Krishnaswamy | August 2009 | Open Source PHP

Web enabling business data is one of the key devices used to advertise and market products. This can be done with various technologies such as VB, ASP, JSP, ASP.Net and many others. This article shows how you may view data from a table on a MySQL database server on a web page using ASP.NET. The table used in this tutorial was the one described in the first article in this series on Exporting data from MS Access 2003 to MySQL.

This article by Dr. Jay Krishnaswamy explains how to populate a GridView on an ASP.NET web page by data retrieved from a MySQL Server. MySQL.Data.MySqlClient is a connector (provider) provided by MySQL which you can use with the .NET Framework applications whose details may be reviewed here. MySQL is well integrated with Visual Studio (MySQL Visual Studio Tools: MySQL.VisualStudio.dll).

Read Displaying MySQL data on an ASP.NET Web Page in full

Create a Local Ubuntu Repository using Apt-Mirror and Apt-Cacher

by Christer Edwards | August 2009 | Linux Servers

How can a company or organization minimize bandwidth costs when maintaining multiple Ubuntu installations? With bandwidth becoming the currency of the new millennium, being responsible with the bandwidth you have can be a real concern. In this article by Christer Edwards, we will learn how to create, maintain and make available a local Ubuntu repository mirror, allowing you to save bandwidth and improve network efficiency with each machine you add to your network.

Read Create a Local Ubuntu Repository using Apt-Mirror and Apt-Cacher in full

MySQL Linked Server on SQL Server 2008

by Jayaram Krishnaswamy | August 2009 | .NET Microsoft

Linking servers provides an elegant solution when you are faced with running queries against databases on distributed servers or looking at your distributed assets on disparate databases.

This article by Dr. Jay Krishnaswamy explains how to set up a MySQL linked server on SQL Server 2008 Enterprise. Configuring a linked MySQL server as well as querying a table on the MySQL linked server is described. The reader would benefit reviewing the first article on this series on MySQL Servers.

Read MySQL Linked Server on SQL Server 2008 in full

Using Graphs to Manage Networks and Devices with Cacti 0.8

by Dinangkur Kundu S. M. Ibrahim Lavlu | July 2009 | Linux Servers Networking & Telephony

In this article by Dinangkur Kundu and S. M. Ibrahim Lavlu, we will see how to add network-attached devices in the Cacti system and produce graphs to monitor LAN-sized installations to complex networks with hundreds of devices. It is fairly easy to manage devices through the Cacti web front-end. It provides a fast poller, advance graph templating, and multiple data acquisition methods out of the box, wrapped in an easy to use interface that makes sense to the network administrator.

Read Using Graphs to Manage Networks and Devices with Cacti 0.8 in full

Building a Facebook Application: Part 2

by Dr Mark Alexander Bain Hasin Hayder | July 2009 | Open Source PHP

In the previous part of this article by Dr. Mark Alexander Bain and Hasin Hayder, we covered developing a simple Facebook application and the way to write the Facebook profile. In this part, we will cover Mock AJAX and data storage.

Read Building a Facebook Application: Part 2 in full

Building a Facebook Application: Part 1

by Dr Mark Alexander Bain Hasin Hayder | July 2009 | PHP

You'll obviously want to start building applications, and that's just what we'll do in this two-part article. By the end of this two-part article by Dr. Mark Alexander Bain and Hasin Hayder, you'll be able to:

  • Extract Facebook information to be displayed by your application.
  • Store information in the Facebook cache, so that it can be displayed on your users' profile pages.
  • Store your own custom data.

The first part will cover the concepts of developing a simple Facebook application and also the way to write the Facebook profile.

Read Building a Facebook Application: Part 1 in full

Troubleshooting and Gotchas in Oracle VM Manager 2.1.2

by Tarry Singh | July 2009 | Oracle

The journey with Oracle VM Manager is not free of troubles and errors. In this article, Tarry Singh will attempt to address the ones that are bound to bother you the most as far as Oracle VM Manager is concerned.

What will we cover in troubleshooting?

While we tackle the following issues in troubleshooting VM Manager. We are assuming that you are using the latest version of Oracle VM Manager and the Oracle VM Server version is 2.1.x:

  • Oracle VM Manager login takes too much time
  • VM guest creation fails
  • Not enough disk space available for ISOs and Templates
  • Cannot login to the VM remotely

 

Read Troubleshooting and Gotchas in Oracle VM Manager 2.1.2 in full

Storing Planning Data in IBM Cognos: D-Cube (Part 1)

by Jason Edwards Ned Riaz Rich Babaran | July 2009 |

In this two-part article by Ned Riaz, Jason Edwards, and Rich Babaran, we will discuss how data is stored in IBM Cognos Planning Analyst. We will begin by defining the D-Cube and explaining the things that you need to think about before creating the D-Cube. We will discuss the importance of the order of dimensions in enforcing calculation and format priorities. We will show you how you can view the multiple slices of the cube and how you can save a selection of the cube as a separate object. We will explain how you can restructure the dimensions of the cube by adding, deleting, substituting, and reordering dimensions. We will cover some of the important functions available with the D-Cube, including global formatting, exporting, and other options that can make it easier for you to work with the program. We will illustrate how you can use data entry commands that will enable you to enter data, execute mathematical operations, or set restrictions for a cell, a range of cells, or the entire cube. Finally, we will cover Breakback—a powerful feature that allows you to cascade changes throughout the cube simply by making the change to a calculated item.

Read Storing Planning Data in IBM Cognos: D-Cube (Part 1) in full

Extending Oracle VM Management

by Tarry Singh | July 2009 | Oracle

In this article by Tarry Singh, we will learn more about Oracle VM Management.
The following topics will be covered in this article:

  • Managing Oracle VM Server repository
  • Backing up or Restoring Oracle VM Manager
  • Enabling security

 

Read Extending Oracle VM Management in full

Debugging the Scheduler in Oracle 11g Databases

by Ronald Rood | July 2009 | Oracle

In this article by Ronald Rood, we consider the fact that when the jobs get more complicated, it gets harder to understand why something works differently than planned. This article gives the reader a fresh look at how to follow and debug Scheduler jobs in Oracle 11g.

Read Debugging the Scheduler in Oracle 11g Databases in full

Adding Interactive Course Material in Moodle 1.9: Part 1

by William Rice | July 2009 | Moodle Open Source

In this three-part article series by William Rice, we will learn how to add Interactive course material in Moodle. Interactive course activities enable students to interact with the instructor, the learning system, or each other. Note that Moodle doesn't categorize activities into 'Interactive' and 'Static'. In Moodle, all activities are added from the Add an activity... menu after turning the editing on. We use the terms 'Interactive' and 'Static' as a convenient way to categorize the activities that Moodle offers.

Read Adding Interactive Course Material in Moodle 1.9: Part 1 in full

Query Performance Tuning in Microsoft Analysis Services: Part 1

by Chris Webb | July 2009 | .NET Microsoft MySQL PHP

In this two-part article by Chris Webb, we will cover query performance tuning, including how to design aggregations and partitions and how to write efficient MDX. The first part will cover performance-specific design features, along with the concepts of partitions and aggregations.

One of the main reasons for building Analysis Services cubes as part of a BI solution is because it should mean you get better query performance than if you were querying your relational database directly. While it's certainly the case that Analysis Services is very fast it would be naive to think that all of our queries, however complex, will return in seconds without any tuning being necessary. This article will describe the steps you'll need to go through in order to ensure your cube is as responsive as possible.

Read Query Performance Tuning in Microsoft Analysis Services: Part 1 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