Would someone happen to have a link to a definition of a database index and “Updall” or View Updates. I’m tyring to define these elements and tasks to a “non-notes” individual. They refer to “4GL” as thier background. If someone could relate to that I’d appreciate it.
Thanks
Subject: Simple Definition of an Index and Updall
This is from the Notes Help
A view index is an internal filing system that builds a list of documents that belong in a view. When users add or change documents, the view index must be refreshed to show them which documents are new or changed. Refreshing a view index can occur manually when users press F9, as part of a condition built into the view design, or as part of the Updall (Update ALL) server process set up by the server administrator.
The Updall (Update All) server task, which runs by default on each server at 2 AM, deletes the view index. Domino deletes the index the first time Updall runs after the index becomes eligible for deletion. For example, if you select “After each use” and the view is used at 10 AM Tuesday, the index is not actually discarded until 2 AM Wednesday.
If you choose to delete the index after one day, Domino waits until the index is at least one day (24 hours) old before deleting it. If the view is used at 10 AM Tuesday, it is only 16 hours old at 2 AM Wednesday when Updall runs, so it is not deleted until the next time Updall runs at 2 AM Thursday.
Does that help, or are you looking for something else?
Subject: RE: Simple Definition of an Index and Updall
Index, Update and Updall are easy – but explaining the rest of Notes to a 4GL guy’s gonna be the hard part. He’s going to be used to thinking in relational database terms, and that’s going to lead to unfulfilled expectations and some misunderstanding at the application (as opposed to administration) level.
Subject: RE: Simple Definition of an Index and Updall
I see…ok thanks!
Subject: RE: Simple Definition of an Index and Updall
I was looking for something that would be for a “Non-Notes” person. For someone who doesn’t understand what a “view” or “document” is. I appreciate the effort though.
Subject: RE: Simple Definition of an Index and Updall
The real problem is that there are no real equivalents in other systems, especially in RDBMS. A Notes overview really can’t be avoided. Do you have (or have access to) The Notes and Domino 6 Programming Bible? A link if you don’t have it:
The introductory bits by Rich Schwartz are hands-down THE best overview of Notes ever, and can help your 4GL guy acclimatise somewhat.
Subject: RE: Simple Definition of an Index and Updall
I will take a look at that…Thanks for the reference…