http://netvouz.com/emweb/tag/database?feed=rss emweb's bookmarks tagged "database" on Netvouz http://www.dbdebunk.com/resources.html 04-28-06 Iterative Software Development 04-28-06 No Silver Bullet 4-21-06 Ow, My Unnormalized Head! 4-14-06 The Wonderful World of XML 2-17-06 When Your Data Is Stored in XML 2-3-06 10 Common Design Mistakes 1-27-12 Why SQL Sucks 1/20/06 Future of Computing 12/10/05-Authors Don't Read 11/11/05 OTLT and EAV 11/04/05 Bullshit about RDBMS 08/26/05 Two big design mistakes 07/01/05 Iterative Software Development 5/27/05 Why Significant UML Change is Unlikely 5/13/05 Is XML the Answer? 5/13/05 Arrogance & Slashing Slashdot (& MySQL) 5/6/05 I'm Not Buying In 04/22/05 Intro Iterative & Narrative Integration 01/4/05 Is Criticism Unprofessional? 03/18/05 A Simple Guide to Five Normal Forms 10/15/04 Systems Software Research is Irrelevant 10/15/04 emweb Tue, 03 Apr 2007 08:42:50 GMT http://www.google.com/search?num=100&hl=en&safe=off&pwst=1&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=integrity+constraints+definition&spell=1 Google Search emweb Fri, 23 Mar 2007 14:57:13 GMT http://kickjava.com/ A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Java Books java.* applet (6) awt (94) beans (12) io (110) lang (275) math (15) net (44) nio (34) rmi (2) security (20) sql (81) text (37) util (292) javax.* accessibility (1) activation (2) activity ce crypto (10) ejb (13) enterprise imageio (7) jms (16) mail (26) management (1) microedition (16) naming (9) net (10) pim (2) power (1) print (15) resource (6) rmi (1) security (21) servlet (53) sound (2) sql (7) swing (165) telephony (7) transaction (3) tv xml (76) javacard.* framework (9) security (2) javacardx.* crypto org.* ietf (1) omg (11) w3c (92) xml (27) emweb Thu, 01 Mar 2007 12:14:58 GMT http://cse-mjmcl.cse.bris.ac.uk/blog/ # accessibility # ajax # aop # apache # applet # autowire # axis # blog # bookmarklets # breadcrumbs # canvas # cas # castor # cms # css # css2.1 # csshack # derby # design # dhtml # dwarf # e4x # ehcache # feedfetcher # firefox # gdata # geotools # geourl # gmaps # gml # google # googleajaxsearch # googlecalendar # googleearth # googlenews # googlesuggest # googlewebapi # gpx # ibatis # ie7 # imap # ioc # jato # java # javascript emweb Wed, 09 May 2007 11:21:41 GMT http://souptonuts.sourceforge.net/readme_mysql.htm TIP 1: Find out who is doing what, and kill the process if needed. This example kills Id 657. mysql> show processlist; show processlist; +-----+------+-----------+---------+---------+-------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------+---------+---------+-------+-------+------------------+ | 657 | prog | localhost | weather | Sleep | 28619 | | NULL | | 782 | prog | localhost | weather | Sleep | 853 | | NULL | | 785 | prog | localhost | NULL | Query | 0 | NULL | show processlist | +-----+------+-----------+---------+---------+-------+-------+------------------+ 3 rows i emweb Thu, 05 Apr 2007 09:01:04 GMT http://www.dbdebunk.com/page/page/621935.htm DK/NF is best thought of as a straw man (sorry, straw person). It was introduced by Ron Fagin in his paper "A Normal Form for Relational Databases that Is Based on Domains and Keys," ACM TODS 6, No. 3 (September 1981). As Valdez says (more or less), Fagin defines a relvar R to be in DK/NF if and only if every constraint on R is a logical consequence of what he (Fagin) calls the domain constraints and key constraints on R. Here: A domain constraint--better called an attribute constraint--is simply a constraint to the effect a given attribute A of R takes its values from some given domain D. A key constraint is simply a constraint to the effect that a given set A, B, ..., C of R constitutes a key for R. Thus, if R is in DK/NF, then it is sufficient to emweb Mon, 02 Apr 2007 09:27:01 GMT http://oldweb.uwp.edu/academic/mis/baldwin/normal.htm A Well Designed Relational Database [ Anomalies | NF Overview | Functional Dependence | Multivalued Dependence | Keys ] [ Normal Forms | 1NF | 2NF | 3NF | BCNF | 4NF | 5NF | DKNF | Interrelation Constraints ] emweb Thu, 05 Apr 2007 08:57:47 GMT http://www.builderau.com.au/architect/database/soa/Relational_databases_The_untold_story/0,339024547,320273389,00.htm Discover the origins of the modern relational data model, how rules were set for relational database theory, and how to put the theory into practice. Trying to use a relational database management system (RDBMS) without applying relational database theory to your design is like trying to drive a standard transmission without using the clutch: You're not going to get very far. In fact, your application may come to a grinding halt. If you're lucky, you'll end up with just an inefficient database. But it could be much worse. You could create a database that erroneously reports data or even destroys data. In this series of articles, you'll learn how to apply relational rules and, in the process, develop an efficient design that protects the validity of your dat emweb Tue, 20 Mar 2007 13:04:02 GMT http://builder.com.com/5100-6388-5029912.html Go further from here: * SQL Server tips for working with nested triggers and dump files * Take part in the latest Builder.com technology use survey * Increase code reuse with Oracle user-defined aggregate functions emweb Thu, 22 Mar 2007 15:26:23 GMT http://www.datamodel.org/NormalizationRules.html 1NF Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. 2NF Eliminate Redundant Data - If an attribute depends on only part of a multi-valued key, remove it to a separate table. 3NF Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table. BCNF Boyce-Codd Normal Form - If there are non-trivial dependencies between candidate key attributes, separate them out into distinct tables. 4NF Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. 5NF Isolate Semantically Related Multiple Relationships - There may be practical constrains o emweb Mon, 02 Apr 2007 09:31:29 GMT