On Mon, 2010-11-08 at 13:56 -0500, William L. Thomson Jr. wrote: > There is TONS of documentation > http://firebirdsql.org/index.php?op=doc > > The old InterBase 6.0 manuals are 99% still relevant. I bought a copy of > the InterBase 7.0 media pack. Basically printed versions of the 6.0 > documentation with errors corrected. > http://firebirdsql.org/index.php?op=doc#category_10 > > Some of that documentation I have never seen any other db cover, like > the Operations guide. Much less the Data Definition guide that should be > read before creating any databases using any RDBMS. Talks about design, > structure, normalization, etc.
Check out the second chapter of the InterBase Data Definition Guide. This can benefit anyone, regardless of RDBMS, though allot is InterBase/Firebird specific. Stuff like this I have yet to see anything cover. Much less the other guides and rest of this one ;) Chapter 2 Designing Databases Overview of design issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Database versus data model . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Design goals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Design framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Analyzing requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Collecting and analyzing data . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 Identifying entities and attributes . . . . . . . . . . . . . . . . . . . . . . . . . 25 Designing tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Determining unique attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Developing a set of rules . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Specifying a datatype . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Choosing international character sets. . . . . . . . . . . . . . . . . . . . . . 30 Specifying domains . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Setting default values and NULL status . . . . . . . . . . . . . . . . . . . . . 31 Defining integrity constraints . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Defining CHECK constraints . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Establishing relationships between objects . . . . . . . . . . . . . . . . . . . . 32 Enforcing referential integrity . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Normalizing the database . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Choosing indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Increasing cache size . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Creating a multifile, distributed database . . . . . . . . . . . . . . . . . . . 39 Planning security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 http://www.ibphoenix.com/downloads/60DataDef.zip -- William L. Thomson Jr. Obsidian-Studios, Inc. http://www.obsidian-studios.com This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. --------------------------------------------------------------------- Archive http://marc.info/?l=jaxlug-list&r=1&w=2 RSS Feed http://www.mail-archive.com/[email protected]/maillist.xml Unsubscribe [email protected]
