(David Chisnall) Most Free Software users are familiar with the Linux/Apache/MySQL/PHP stack—the LAMP configuration—a widely deployed set of software used for a large number of Internet and intranet applications. Although the LAMP configuration is the most frequently used, it’s not always the best t
Author: SSWUG Research
Working with DataSet Objects and XML
(Sanjit Sil) The DataSet class in .NET plays a major role by providing a disconnected data access model. There are situations when we might not require a database to store data. Rather, we may store the data in an XML file. Microsoft .NET provides support for designing such applications with the
Paying Homage to Exploratory Data Analysis
(Steve Miller) When I first arrived to the work world 30 years ago, I encountered two roadblocks to my enthusiasm for mathematical and statistical optimization techniques in business. The first was a data management problem. Collecting, integrating, organizing and manipulating data was a very thorny
Database Visualization
(VGirish) When handling a project with hundreds of tables, it takes some time to understand the flows within the database. This is especially so if there is no document available. A possible scenario is legacy code up for maintenance or migration. After going through just a few tables, it becomes to
De-duplicate tables using Oracle’s analytic functions
(Bob Watkins) Tables that don’t have a Primary Key constraint protecting them can have duplicate rows inserted into them. The traditional way to locate such duplicates is with a query using the GROUP BY and HAVING keywords. After grouping the data on the key columns and counting the rows in each gro
Database Output from CL
(Ted) I know that IBM added a lot of new programming features to CL in the past two releases. However, one of the features I’ve been hoping for–the ability to do output operations to database files–doesn’t appear to be among them. Please tell me that I’m wrong and that there really is a way to upd
Notes from the Field
(Michael S. Dougherty) When it first emerged in the 1960s and 1970s, business process management (BPM) was all about converting manual, paper-based processes to automated, electronic processes. This shift is still occurring in all industries today and is largely supported by content management syste
Introducing DB2 Viper, Part 3: Self-tuning memory in DB2 Viper
(Rav Ahuja) Database workloads seldom remain static. Workloads and the environments they are run under can change over time due to a number of factors, including more users, change in the pattern of queries, running of maintenance tasks, changes in resources consumed by other applications, and so on
MySQL Database Administration
(Paul Dubois) This chapter covers topics that deal with administering a MySQL installation, such as configuring the server, managing user accounts, and performing backups.
Text File Access in the .NET Framework
(Peter Aitken) Most applications need to be able to read and write files. The .NET Framework provides classes that take most of the pain out of file access, but you still have to write the code that makes use of these classes. While a file is nothing more than a sequence of bytes, the .NET Framework