PUBLIC MARKS from BlueVoodoo

The Web browser marks the end of a line that begins with the database schema. So how do you create a good database schema? You need more than effective tools; you need a plan. Designing databases is part science and part art, so start honing your skills now. Discover some useful tips for designing a database schema that's fast, efficient, and responsive to change.

Today's Internet no longer functions simply by responding to requests for HTML-coded Web pages. Discover an industrial-grade solution to this age-old problem -- namely, session state. This article demonstrates how Apache Geronimo maintains the state of thousands of simultaneous connections so that IT managers can breathe easier.

Knowing the right way of dealing with full disks, or a crippled system, is nearly as important as having tools in your arsenal to make sure you're prepared to react quickly to missing files or an insecure system. Avoid common pitfalls and traps to help keep your system running smoothly. This article focuses on some of the most common problems and issues facing UNIX administrators and ways to achieve a safe and effective resolution.

In this article, find out how IBM autonomic computing technology, particularly the IBM Autonomic Integrated Development Environment (AIDE) toolkit, may be an effective solution. Learn how you can use this technology with Apache Derby to create the basis of a converged provider environment.

Use Perl and FluidSynth to create a real-time musical composition of your system status. Learn how to integrate various system monitoring data into a harmony-producing, MIDI-controlled audio synthesis. Explore audible information methods and configurations to help you monitor and manage your computing environment.

The vi text editor might seem counterintuitive to new users but, make no mistake, there is a good reason this 30-year old tool is still widely used by many of the best developers in the world. The vi text editor separates operations into insert mode and command mode, which gives you ultrafast access to key commands that can edit, insert, and move text in on-the-fly, user-defined segments.

This article reviews how to modify an SQL query to group related rows together to provide summary statistics database information and introduces the concept of a view, which can be used to simplify database application development by creating a virtual table that represents the results of an SQL query. Also learn about database indexes, which you can use to locate specific table rows. After you've mastered these advanced database concepts, you'll be well positioned to begin developing Java database applications with Apache Derby.

Set up a Kerberized environment to work with Solaris(TM) 10 and learn how to configure a Key Distribution Center (KDC) on AIX(R) Version 5.3. You'll also run through a series of steps for configuring a Kerberos client on Solaris 10 to authenticate users for Telnet, remote shell (rsh), and Secure Shell (SSH) using AIX Version 5.3 as your KDC.

This article, Part 1, introduces the growing need for automated IT management, which is facilitated by the centralization and consolidation of applications, data centers, and front- and back-office functions. Discover how you can use Derby as a managed element, including working with the database's unified utilization and management requirements and how using FCAPS can help you design an IT management solution.

The typical UNIX administrator has a key range of utilities, tricks, and systems he or she uses regularly to aid in the process of administration. Configure your swap space (including adding space in an emergency) to get the most out of your system. In this article, you'll learn how to monitor your system to determine an effective swap space figure as well as examine methods for using swap space for more than just secondary random access memory (RAM).

Mathematics is the King of Science. Commercial uses for mathematical workstations are vast: From basic engineering to designer drugs and from gene therapy to celestial navigation, mathematics rules the world. Many tools are available for use on UNIX that can satisfy your quest for mathematical enlightenment. This article shows you the way to mathematical nirvana on a UXIX workstation.

Learn what new features you can benefit from in AIX 5L Version 5.3. With guaranteed binary compatibility with the previous releases on the one hand and support for advanced technologies such as Virtual SCSI, Virtual Ethernet, Micro-Partitioning, and Simultaneous Multi-Threading (SMT) on the other, AIX 5L continues to empower users and developers with flexible, reliable, and powerful tools to interoperate smoothly across different IT environments.

AIX has a vast array of commands that enable you to do a multitude of tasks. Depending on what you need to accomplish, you use only a certain subset of these commands. There are a few core commands that you commonly use. This article will cover some of the core commands with the intent to provide a list that you can use as a ready reference.

Extend the Apache Geronimo application you created in Part 2 of this six-part tutorial series. In this installment, you'll learn how to let the integrated technologies -- like Spring Java Database Connectivity (JDBC) and Spring Data Access Objects (DAO) APIs -- do the work by reading your application data dynamically from an Apache Derby database. You'll also find out how to integrate Object Relational Mapping (ORM) into your application using iBATIS and appreciate the beauty of dependency injection by modifying the data sources in your application without touching the code.

UNIX provides robust tools and infrastructure so that you can both protect and share information. This article looks at user privileges and, in particular, examines how to manipulate file permissions to restrict or share your directories and files with others. Understanding permissions is crucial if you want to speak UNIX fluently. Learn how to manipulate file permissions to protect your files, or share them with others.

This article describes the setup of a simple SSH client connecting to an AIX- or Linux-based SSH server that allows a typical, technically literate individual the ability to set up, configure, and operate a flexible means of tunneling data and services over the SSH service. Use OpenSource tools, such as Secure Shell (SSH), PuTTY, and Cygwin, to create secure connections to almost any resource you need to access.

Learn the basics of how to partition an IBM System p5 server. Logical partitioning (LPAR) is the ability to logically slice up a single system's CPU, memory, and other resources to create multiple and separate servers. Wouldn't it be nice to consolidate all of those servers onto just a few pieces of hardware to more fully utilize your resources and yet still maintain separate OS environments for each of the applications? With the IBM POWER5-based servers, you can do just that.

Ruby on Rails seems to be a lightning rod for controversy. At the heart of most of the controversy lies amazing productivity claims. Rails proponents boast of incredible productivity, with some claims of 10 to 1 over Java development. This article explores the compromises and design decisions that went into making Rails so productive within its niche and how Ruby on Rails, like a nail gun, saves so much time.

Parsing is one of the CDT's most crucial functions, but because of its complexity, parsing is also one of its least-understood aspects. This article introduces the parsing process used by the Eclipse C/C++ Development Tooling (CDT). This will help you Get a handle on one of the C/C++ Development Tooling's most crucial functions: the parsing process -- for error detection, indexing, and code-completion.

Did you know that blogging and UNIX go hand in hand? The native Web and text-processing tools of UNIX enable you to create your blogs quickly and easily. Discover command-line tools and some handy tips for improving your UNIX blogging skills.

Systems administrators can use a number of programs to maintain files in a UNIX® system from the command line. In this tutorial, you'll experiment with commands, such as cd, cp, and tar, to navigate a UNIX file system from the command line and work with files and directories. You'll also learn how to deal with file permissions and perform simple input/output.

Discover the basic concepts of the AWK text-processing and pattern-scanning language. This tutorial gets you started programming in AWK: You'll learn how AWK reads and sorts its input data, run AWK programs, manipulate data and perform complex pattern matching. When you're finished, you'll also understand GNU AWK (GAWK).

In this tutorial, you'll learn to set up a DB2 9 database and WebSphere Application Server Community Edition on a Windows or Linux environment, then write and deploy a Java application that takes advantage of the pureXML capabilities.