Advertisment
In this article you'll find out what materialized views are, what they can do and, most importantly, how they work - a lot of the ' magic...
Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as 'Calculate a running total',...
If you have multiple CPUs available you may come up with the idea to set parallel execution on every table. The Oracle Optimizer should decide...
Sometimes multiple users are accessing the same tables at the same time. In these situations, you need to decide when to allow your application to...
B*TREE Indexes improve the performance of queries that select a small percentage of rows from a table. As a general guideline, we should create...
The SQL-92 standard requires that all values in a primary key be unique and that the column not allow null values. Both Oracle and Microsoft SQL...
Online Web Design Tutorial that shows you how to create a great web site with clear, concise organization, timely, original, well-edited content...
This tutorial presents a brief overview of the process of creating a Web site, introduces you to important design principles to consider as you...
By teaching those that create Web sites how to think like the people who use them, Back to the User enables Web marketers and developers to create...
This final installment shows you how to make sure your design is in service to your concept and includes a bit of admonishment to tell the truth...
When used properly, color can be a thing of beauty. When used improperly, it can be reasonably repulsive. Learn the importance of good color...
Over 15% of the population have a learning disability (LD). In addition, a sizable percentage of the population is physically challenged or has...
Writing for the Web is different than writing for printed media. But how different? This article discusses many of those differences, including...
In this installment we look at how to customize and personalize content, develop an attitude, and talk on the user's level.
This next installment discusses methods of keeping the text short for online articles. Sections included in this excerpt include 'Save The...
This last installment discusses vital but tangential or supplemental material, moving repeating categories of information into tables, charts, or...
This website introduces the reader to new ways of styling Web sites. Specific examples provides a wealth of techniques for the designer who wishes...
Building and buying Web sites should be a rewarding experience for both builder and buyer. For that to happen, though, the builder needs to make...
Information architecture is the practice of designing the infrastructure of a Web site, a combination of organizing a site's content into...
Information architecture is the practice of designing the infrastructure of a Web site. In the conclusion of this article, Alan covers...