Search DominoPower's 11,441 Lotus-related article archive 
Home
EasyPrint
News details Click here for the RSS feed's XML code. This is not a browser URL.
Articles-only Click here for the RSS feed's XML code. This is not a browser URL.
Twitter Feed Click here for the Twitter feed.
NOTES AND DB2
Notes is not a relational database
By Mick Moignard

The upcoming Notes/Domino 7 release (now in beta, see http://www-10.lotus.com/ldd/beta/nd7pubbeta.nsf) enables direct storage of Notes databases in DB2 for the first time. This isn't copying of Notes data to DB2, it's the actual storage of the Notes database itself in DB2.

We've commented on this upcoming functionality before, as information has become available at past Lotuspheres. Have a look at our Sphere 2004 report at http://www.dominopower.com/issues/issue200402/00001217001.html and for 2003 at http://www.dominopower.com/issues/issue200302/lotusphere001.html.

The power of storing Notes databases in DB2 comes not just from the performance improvements that will be available for applications that need it, but more from the ability to see the Notes data in some kind of relational form and work with it from there, while still maintaining the Notes access controls against the data.

Just don't get too carried away about your Notes data magically being relational, though! Firstly, the DB2 option is only available on servers. Local databases on clients are still stored as .NSF files. The server's NSF layer maps the data to DB2. The storage in DB2 is that of the Notes data model, it's not suddenly made the data all fully relational. While you can read -- and write -- the data with SQL from non-Notes applications, you will still be dealing with the Notes data model.

So how does Notes data storage compare to a relational database? Why isn't Notes already a relational database?

The Notes database
The fundamental reason why Notes isn't a relational database is because it isn't. The organization of a Notes database is different from that of a relational database, which contains tables of same-type "records," or sets of fields, and is optimized for rapid access by table-oriented operations.

A Notes database can contain any number of notes, and a note can contain any number and type of fields. In addition, there is information in the database header and in each note header that supports simultaneous access and replication between databases.

This schema-less database architecture means that Notes is uniquely able to store highly disparate data types in the one database extremely efficiently, given what Notes is expected to do. It does tend to occupy more disk space, because the data elements also carry their meta-data with them, but it is efficient in terms of space management, and of course the architecture is optimized for Notes' replication capabilities, which is one of Notes unique features.


1  ·  2  ·  3  ·  4  ·  5  ·  6  ·  Next »
Other articles you might like
Home > Social Computing (25 articles)
   Integrating Twitter with an IBM internal social network
   Fun with Sametime and Skype
   More thoughts on social computing and Lotus
Home > Lotus Technologies > Notes (84 articles)
   A walk down Memory Lane with Lotus Notes
   An application for scanning physical mail and distributing it virtually
   Managing Notes deployments with Teamstudio Build Manager
Home > Strategies > Best Practices (11 articles)
   Managing Notes deployments with Teamstudio Build Manager
   Managing production Notes deployments
   Using Balsamiq Mockups to create low-fidelity prototypes
Get Weekly Email Updates
Subscribe to our regular weekly email newsletter. It's packed with tips, reviews, deep analysis, and the latest news.
 
Recent DominoPower Articles
Application development, William Shatner, and the origin of the universe
Learn Domino Designer 8.5 for free
The (near) future of Sametime, Quickr, Connections, and Symphony
Inside the IBM Innovations lab
Lotusphere 2010: Hot fixes and cool news for Notes, Domino, and LotusLive
Lotusphere 2010: mobility and collaboration
2010: A Lotusphere of change
Latest Lotus Headlines
Xpages not loading? JVM errors? - Solution
How to implement an iCalendar feed into your Notes calendar with XPages
DWA Hotfixes for Domino 8.5.1FP1 - A Gotcha
IBM Adds DB2 to Lotus Foundations SMB Package
SNTT : XPages onclick Ghosts in the machine
Ports used by Lotus Sametime 8.5 servers
Exploring a Domino Date Bug
>> Read all the news
More from the ZATZ journals
Computing Unplugged: The iPad defenders have spoken
David Gewirtz Online: CNN commentary and analysis
OutlookPower: More about disappearing text
-- Advertisement --

Sophisticated Meets Simple For Document Management
Share. Control. Manage.
Documents, emails, and content in the context of how work is done. Native to Lotus Domino. The User Experience unseen for Lotus Domino. Do more with less. Really.

See the possibilities Docova unleashes for Lotus Domino.
-- Advertisement --

Integrate your Notes Applications with Microsoft Office and Symphony
Integra for Notes Integrates Microsoft Office and/or IBM Lotus Symphony
Requires NO change to the design of the appliation or Installations of DLL's and EXE's
  • Integra is a ready to use solution, enhance static reports with Excel data analysis, pivot tables, macros
  • User friendly aproach, using a point and click access to features
  • Reports from any Lotus Notes databases
  • Runs reports through a Notes client, web browser and scheduled basis
  • Allows use of LotusScript for advanced data manipulation
  • Enables self service reporting capabilities to end-users


Learn more at www.integra4notes.com.
ZATZ Home  ·  News  ·  Back Issues  ·  Credits/Trademarks ·  Link To Us
Copyright © 1998-2010, ZATZ Publishing. All rights reserved worldwide.
Editor's Login