3D Database Concept

Pat Hartman said:
SharePoint tables are something like:

UniqueRowID (a unique identifier for the row)
GroupID (what would in a normal table be the primary key)
FieldName (the name of the field)
FieldValue (the value of the field)

So, instead of a table having 20 columns per row, each column would be stored as a separate row in the SharePoint table.

Thanks, Pat. That's exactly how this works, if I have understood your description correctly (which was much clearer than my attempted description of this database design.)

The specific field names are stored as field values, that's the essence of it. The actual field names are generic, so that the same structure / design can store anything.
 
Alan is correct about patents, copyrights, and trademarks being different beasts, each with its own proper method of keeping. However, my point was that in all cases, nobody can protect anything that is so basic as to be considered "public domain" for any reason. I was addressing the common parts, namely the inability to make money off of something that everyone already uses widely anyway, or that someone can derive from base methods.

Hi, Alan, and thanks for pointing out that it is a bigger can of worms than I said by way of simplification. Anyone who wants to consider Alan's comments about "costing too much to defend" should look at recent history for the "Blackberry" controversy, in which the result was a one-time payment of $500 million to the patent holder to settle the dispute. Think about how much money must have been involved that the infringer decided to settle out of court rather than challenge the legality of the patent.
 
rak said:

Wow, thanks for this too! This sounds like exactly the same concept. This has got to be where the generic ("copyrighted") database came from. Pick and sharepoint both seem to be the very same idea, if I am understanding correctly. I still haven't seen any table design (for pick or sharepoint) to know this for sure, but from what I can gather, it is exactly the same thing.
 
The_Doc_Man said:
Alan is correct about patents, copyrights, and trademarks being different beasts, each with its own proper method of keeping. However, my point was that in all cases, nobody can protect anything that is so basic as to be considered "public domain" for any reason. I was addressing the common parts, namely the inability to make money off of something that everyone already uses widely anyway, or that someone can derive from base methods.

Hi, Alan, and thanks for pointing out that it is a bigger can of worms than I said by way of simplification. Anyone who wants to consider Alan's comments about "costing too much to defend" should look at recent history for the "Blackberry" controversy, in which the result was a one-time payment of $500 million to the patent holder to settle the dispute. Think about how much money must have been involved that the infringer decided to settle out of court rather than challenge the legality of the patent.

That's really incredible! I think people lose these cases 99% of the time. Not only that, but it seems there is some law about commercial inventions that the patents expire after a certain period of time so that they will become generally available.

But just what was this "Blackberry" controversy? What product was the fight all about?
 
Microsoft lost one of these infringement cases last fall and we're all suffering for it. Apparently someone had patented the idea of updating a spreadsheet from Access. The upshot was that a release to Jet last November removed the ability of Access to update a linked spreadsheet!
 
Hi I'm a new user

Different thought

I think the physical structure of an Access database does not actually consist of individual tables etc, (but is rather a monolithic file structure of some sort - ie a black box that returns the correct results) so presumably the database manager (Jet) then applies appropriate logical structures to structure the data. With this in mind it would be very hard to define a modelled structure that would perform quicker than optimised queries etc.

Am I right?
 
Very few databases actually consist of "formal" tables these days. Instead they are all pointer-driven. This is because pointer lists are FAR easier to sort according to whatever key you are using. It also has to do with the terrible but true fact that each table's recordsize is different (in potential) than any other recordsize for any OTHER table. Therefore, you cannot build a one-size-fits-all record without wasting LOTS of space. Therefore, you run into problems rearranging the records. Not to mention that one report will want the recordsets sorted one way, the form does it another way, and the datasheet-view query has it a third way. So pointer manipulation is the far easier way to manage the records.

Imagine if you will a bucket of living worms of different sizes. Watch them move around for a while. Access records are about like a bucket of worms.
 

Users who are viewing this thread

Back
Top Bottom