Manage Learn to apply best practices and optimize your operations.

Database Organization

Organizing you workspace/bookmarks for efficiency and usability!
Have you ever been frustrated because you have so many different Notes
databases. Some users desktops look like a cluttered mess. I've come up with
a solution that allows users to reduce the number of icone or bookmarks
(databases) they need to access, which in turn allows them to work more

Here is what I did. I took common databases and grouped them according to
commonalities, such as departments, or general use. Then I created new
"Centralized" databases. I buily all of the forms views and agents into it's
own respository (database). i.e. New Centralized database=Human Resources. I
eliminated our vacation time database, Performance Evaluations database, Time
Entry database, Operating Standards, Employee Information database, etc. These
databases were eliminated because I inserted them into the New Human Resources
database. When they were inserted I made a scheme for all forms, views, and
agents, so that I knew what databases they were with. This also made
traversing that multiple databases with one easy. I made folders for all of
the forms and views.

This has allowed users to get all of the information they need in a couple of
databases rather than in many different databases. It also makes data lookups
easier since data resides within the same databases most of the time. Works
great and users like the clean workspace appearance and databases are easier to
find since there are not a ton to look through.

i.e. Forms
Vacation Time\Holiday Time
Vacation Time\Sick Time
Performance Reviews\Management
Performance Reviews\Clerical
Performance Reviews\Hourly

i.e. Views
Vacation Time\All Time
Vacation Time\Holiday Time
Vacation Time\Sick Time
Performance Reviews\All
Performance Reviews\Management
Performance Reviews\Clerical
Performance Reviews\Hourly

Each Form, View, and Agent is protected by Form and View ACL's and Fields not
by the database ACL.
Works great!
This was last published in November 2000

Dig Deeper on Lotus Notes Domino Database Management

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...