Solved

Easy Question

Posted on 1998-10-15
11
194 Views
Last Modified: 2013-12-18
I am VERY new to Lotus Notes, but not to relational databases and the like .... how does Notes store its information .... are there tables within the databases?  Underneath the pretty pictures is there a relational database, one big table???????????  Sorry for my green-ness.
0
Comment
Question by:tmjp26
11 Comments
 
LVL 12

Expert Comment

by:fulscher
ID: 1117555
Notes stores documents (internally called "notes") in an unspecified format in its "databases". I don't have detailed information about it, but it appears that a note basically consists of a list of pairs <fieldname, value>, a database consists of a list of such notes. There is also some index information in the database. When you change the definition of a note (the corresponding form), the contents does _not_ change.

_Every_ item in a Notes database is a note: the documents you're reading, forms, views, etc.

Hope this helps

0
 

Author Comment

by:tmjp26
ID: 1117556
It seems like the form defines a database .... however, when you delete the form, the documents based on it still remain as do the fields.  Odd.


0
 
LVL 12

Expert Comment

by:fulscher
ID: 1117557
In a database, you can have many forms and documents with inhomogeneous stucture. In fact, Notes decides at run time which form to use for a specific document (if you double-click on a document in a view, Notes reads this document and searches for a a special field with title "Form" (with the value "Memo", let's say). It then searches for a form with name "Memo", loads it and uses it to show the document. Thus, you can change the form a document used by changing the "Form" field.
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 

Expert Comment

by:PsychoEffer
ID: 1117558
Basically the foundation of a Notes database is the document.  Forms basically act as templates for documents.  Views sort the display of those documents to show them in different orders, or to display different fields.

Notes is not a relational database at all.  If you change a field in one document, only that document is changed.
0
 

Author Comment

by:tmjp26
ID: 1117559
Isn't it plausible to suggest that the generation of a FORM in NOtes is equivalent to the generation of a table?  All docs created from that form are rows in that table.  When a new form is created, so is a new table.  If a form is deleted, the docs, ie the table structure, remains.  Just a thought.
0
 
LVL 12

Expert Comment

by:fulscher
ID: 1117560
Actually, comparing Notes to a relational DB is highly misleading. Any table structure would imply that all rows have a common format; this is not the case. If you create a form and then create 10 documents with this form, later change the data type of one of the form's fields and again create 10 documents, the first set of 10 will have a different structure than the second set of 10. A document is just a list of field names and values, that's all.
0
 

Author Comment

by:tmjp26
ID: 1117561
I was suggesting that a form was the structure of the table.  If you create 10 documents, you create 10 rows in that table.  If you return to the original form and change a datatype, you have then created another table structure and all forms based on it will be part of that new structure and so on.

?
0
 
LVL 12

Expert Comment

by:fulscher
ID: 1117562
In a table, you'd normally store field _values_ only. In Notes, the field _name_ is part of the document - this makes it different.

With a view, you select all document that meet certain criteria, e.g. that contain a "subject" field. However, they could have been created using different forms. If a document is selected, it will still show up with the "correct" form (the one it was created with).

Thus, you can write applications containing a number of forms which are not related to each other (different "tables").

When I was new to Notes, I tried to understand it in terms of tables too. However, once you accept that the idea of a table is just not applicable, you begin to understand the power of Notes.


0
 
LVL 1

Accepted Solution

by:
Joshua111197 earned 50 total points
ID: 1117563
A Notes database is a set of documents.

Documents contain fields. But every document can contain other fields than the other documents. Some fields are mandatory, others can be added.

Forms are used to add fields with specific names and values to a document. The values are stored in the document.

Documents do not interact with other documents. Thats, why it is not a relational but a documentbased Database. An example: When you have documents with Cities and ZIP and you use this data to autmically insert the Cityname in your addressbook in relation to the entered ZIP, the document will not show a different City, when you change the first document (ZIP/city). OK, there are some ways to realize this, too. But that's not the way to create complex relations.

A view just make fields visible in a way very similar to a table. But: Every document can be shown in the view, wheter any field is displayed in the view or not. So a view is NOT table like in a relational database.

A hint: Do not try to use Notes like a relational database, and don't teach a cow to fly... The better way is, if the funcionality is needed, to connect a relational database to your notes database.

I hope this will help you understanding the notes basics.
0
 

Expert Comment

by:kenjones
ID: 1117564
Go to the Notes Design website,  http://www.notesdesign.com/  , and read the Notes tutorial.
0
 

Expert Comment

by:MrGrinch
ID: 1117565
Given your relational background, I'd suggest thinking of a Notes  database as a bunch of flat files.  I've heard the views in Notes defined as "a pre-defined query".  It's not relational in the sense of data normalization.  Each document (flat file) can pull information from other sources similar to a relational table (@DBLookup is a command that can do that).  But unlike a relational model, an update to the source table doesn't update the document (flat file).  Hope that helps.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to connect Lotus Notes to iPhone/Droid without Traveler 14 199
Resolving notes group email address to old name with subdomain 10 151
Lotus Notes 6.5.5 6 215
Lotus notes VB code 4 208
For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question