- Database Issues in Homeland Security
- Aug 2, 2002
- We've learned that government agencies must share information in order to secure our homeland. What technical and social hurdles must be overcome to share data in a workable manner, eventually leading to a more secure USA?
|
- Database Normalization for the Real World
- Feb 27, 2004
- Why is normalization important? Many databases today are still denormalized for many reasons. This article by April Wells addresses some of the reasons and normalizes a claim table through the different normal forms for an insurance company. The changes in the table and the addition of more tables in the process make the database more efficient, less prone to error, and more maintainable.
|
- Database Options for the Mobile Application Developer
- Jul 19, 2001
- Bryan Morgan looks at three popular mobile database products that offer support for multiple operating platforms and programming languages.
|
- Date, Math and Text Functions in SQL Server 2000
- Apr 4, 2003
- In this third article in his series on functions, Baya Pavliashvili continues to explore various types of built-in functions, including the most frequently used math, text, date, and time functions.
|
- DB2 at a Glance: The Big Picture
- Apr 1, 2005
- This chapter provides an overview of the DB2 core concepts using a "big picture" approach. It introduces SQL statements and their classification in Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL).
|
- DB2 Security—The Starting Point
- Oct 12, 2007
- This sample chapter details the creation of a security plan for your DB2 database.
|
- DB2 SQL Procedural Language: Using Flow of Control Statements
- Jun 13, 2003
- Learn how to use flow of control statements to write powerful SQL stored procedures and discover all the necessary commands to accomplish this task. You will also learn how flow of control statements can help control the sequence of statement execution.
|
- DB2 UDB Installation
- May 13, 2004
- In this sample chapter, you'll learn the ins-and-outs of the installation process for DB2 UDB in the Solaris operating environment (with some discussion of other platforms), including distributed installation.
|
- DB2 Universal Data Base V8.1 Certification: Backup and Recovery
- Apr 23, 2004
|
- DB2 Version 8 Certification: Everything You Need to Know
- Apr 2, 2004
- As a DB2 professional, should you certify? Will it increase your abilities or help your career? How can you do it quickly and inexpensively? This article will give you the inside story on DB2 certification.
|
- DBAs vs. Developers: Managing Your Data without Conflict
- Oct 6, 2005
- Is your IT team conducting an internal feud, with team members struggling against each other instead of fighting the real problems of limited time, money, and manpower to support your organization's technology needs? Buck Woody argues that you can't afford to become the Hatfields and McCoys.
|
- Dealing with Database Block Corruption in Oracle
- Nov 6, 2000
- Oracle expert Megh Thakkar discusses how an Oracle DBA can deal with data block corruptions.
|
- Defining and Working with Fields and Tables in FileMaker 9
- Feb 29, 2008
- Learn techniques to make your FileMaker Pro databases meaningful to yourself and others for the long period of time that they may be in use.
|
- Defining and Working with Fields and Tables in FileMaker Pro 10
- Jun 11, 2009
- This chapter describes what kinds of fields exist in FileMaker Pro, how they store information, and how to ensure proper data integrity in your database solutions.
|
- Defining and Working with Fields in FileMaker 7
- Oct 29, 2004
- Fields are the heart of any database. By storing information in properly categorized fields, you impart both function and meaning to what would otherwise be an incomprehensible pile of raw data. This chapter will help you learn the basics of working with fields in FileMaker 7.
|
- Defining and Working with Fields in FileMaker 8
- Aug 11, 2006
- Fields are the heart of any database. By storing information in properly categorized fields, you impart both function and meaning to what would otherwise be an incomprehensible pile of raw data. This chapter describes what kinds of fields exist in FileMaker Pro, how they store information, and how to ensure proper data integrity in your database solutions.
|
- Deploying Forward Proxy Caching in Enterprise and ISP Networks
- Jul 19, 2002
- Dive into proxy deployment through exploring nontransparent deployment, transparent deployment, and security and access control issues.
|
- Deploying Merge Replication Subscribers in SQL Server
- Sep 10, 2009
- Hilary Cotter shows how to decouple your SQL Server snapshot generation from your snapshot application process for the best possible performance - all while letting you keep your sanity.
|
- Designing Database Applications
- Jun 8, 2001
- Once you have prepared a model and understand an application, the next step is to build it. This article looks at architecture and design issues for database applications. We provide guidelines for determining whether a database is appropriate for a ...
|
- Designing Databases for Performance: What's Your Strategy?
- Jun 2, 2009
- John Goodson and Robert A. Steward discuss different strategies for designing your database application and configuring the middleware for optimal performance.
|