Arthur Fuller

Arthur Fuller has been developing database applications for more than 20 years. He frequently works with Access ADPs, Microsoft SQL 2000 and 2005, MySQL, and .NET.

22 February 2007
22 February 2007

Database Design: A Point in Time Architecture

In most relational database implementations. Update and Delete commands destroy the data that was there prior to their issue. However, some systems require that no information is ever physically deleted from or updated in the database. In this article, Arthur Fuller presents a solution to this requirement in the form of a Point-in-Time architecture: a database design which allows a user to recreate an image of the database as it existed at any previous point in time, without destroying the current image.… Read more
14 March 2006
14 March 2006

Dogs of War

0
0
In Canada, specifically the province of Ontario (where I live), and in the USA, specifically the state of Ohio, various dog-attacks have caused the respective legislatures of these places to enact laws specifically forbidding the ownership of Pit-Bulls. Clayton Ruby, Canada’s wanna-be equivalent of either Ralph Nader or William F. Kunstler, or perhaps both, is … Read more
0
0
08 March 2006
08 March 2006

Evaluation Software

0
0
Fuller’s Fifth Law: always bite the hand that feeds. In dutiful obeisance to my own laws, I have chosen  to vilify  the sponsor of  my blog,  Red Gate, whose evaluation software makes, in my opinion, a foolish mistake. Before I explain why, let me ask, How many hours did you work last week, and the … Read more
0
0
17 February 2006
17 February 2006

Intelligent Database Design Using Hash Keys

Your application may require an index based on a lengthy string, or even worse, a concatenation of two strings, or of a string and one or two integers. In a small table, you might not notice the impact. But suppose the table of interest contains 50 million rows? Then you will notice the impact both in terms of storage requirements and search performance.… Read more