On 3/26/13 8:55 AM, Edward K. Ream wrote:
I know next to nothing about data bases, and have never used schemas.
Indeed, I've never used a db at all except to interface Leo nodes with
the zodb.
I would appreciate your suggestions for learning resources that might
bring me somewhat up to speed for the sprint. Thanks!
There are aspects of databases that are worth knowing for anyone who has
to implement, use, or maintain a "data store" that has interrelated data
of any kind, and especially if it has to allow multiple simultaneous
accesses. For a start, look up "referential integrity" and the concept
of transaction, particularly the "ACID properties"
(http://en.wikipedia.org/wiki/ACID). Also, the basic concepts of types
of relationship between entities: one-one, one-many, and many-many.
Finally, it's worth a light reading of database normalization (e.g.,
http://en.wikipedia.org/wiki/Database_normalization), to be sensitive to
issues like redundancy and intedependencies.
For a classic bad example, the MS Windows Registry will suffice. It's
easily corrupted, and repairing the corruption can be difficult. There
are at least hundreds of tools out there purporting to help manage this
situation.
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Google Groups
"leo-editor" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/leo-editor?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
