Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One table may be sufficient for an application
Message
From
04/03/2004 14:44:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
23/02/2004 09:45:33
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00879888
Message ID:
00883221
Views:
10
It seems to me that this would add unnecessary complications, without much benefits. I would like to know what advantages you perceive of such an approach.

>I’ve written an application of medium complexity which uniquely relies upon one table of simple structure (no Memo fields involved). The table (and the power of VFP) mimic all the tables and fields needed, with logical database normalization (master-detail), avoiding redundance as well. No Create/Alter Table will be necessary for adding new functionalities.
>After one year of upgrade and real usage, pros and cons are clearer.
>I want now to write and explain about the experimentation.
>To begin with, I’m looking for articles over the Internet pertaining the idea of reducing the number of relational tables tipically used by applications.
>A search through Google didn’t help.
>So I’m asking for useful links about the topic.
>Thanks.
>
>Bruno Maddalozzo
>MCP
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform