DATABASE
Database Organization
John Reading
10.14.1999
Rating: --- (out of 5)
Organizing you workspace/bookmarks for efficiency and usability!
Code
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
efficiently.
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 TimeHoliday Time
Vacation TimeSick Time
Performance ReviewsManagement
Performance ReviewsClerical
Performance ReviewsHourly
i.e. Views
Vacation TimeAll Time
Vacation TimeHoliday Time
Vacation TimeSick Time
Performance ReviewsAll
Performance ReviewsManagement
Performance ReviewsClerical
Performance ReviewsHourly
Each Form, View, and Agent is protected by Form and View ACL's and Fields not
by the database ACL.
Works great!
|
|
Rate this Tip
|
To rate tips, you must be a member of SearchDomino.com.
Register now
to start rating these tips. Log in if you are already a member.
|
DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.
|
|
|
|
|
|
|
