Search tips
  • DATABASE DEBUNKINGS - LINKS
    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
    The web site that sets matters straight by dispelling fallacies, misinformation and confusion about database management. The forum for concepts, principles and methods and their practical implications that receive little, incorrect, or no coverage from the trade media and no consideration from vendors and industry pundits.
    articles chris data database date dbms education fabian management model papers pascal rdbms relational seminars technology
    in Public bookmarks with database tipsntricks tutorial
  • integrity constraints definition
    Google Search
    in Public bookmarks with database sql system:unfiled tutorial
  • KickJava.com - Java API By Example, From Geeks To Geeks.
    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)
    Java API By Example, From Geeks To Geeks.
    api book books developer development downloads enterprise example free j2ee j2me j2se java jobs jsp news resources servlets tom
    in Public bookmarks with api database java sourcecode sql tutorial by 3 users
  • Mark McLaren's Weblog - JSP, JSTL, XML, XSLT and stuff
    # 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
    in Public bookmarks with blog database html web2.0 xhtml by 2 users
  • MySQL Tips: Interesting Things to Know about MySQL
    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
    in Public bookmarks with database sql tipsntricks
  • ON DK/NF NORMAL FORM
    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
    The web site that sets matters straight by dispelling fallacies, misinformation and confusion about database management. The forum for concepts, principles and methods and their practical implications that receive little, incorrect, or no coverage from the trade media and no consideration from vendors and industry pundits.
    articles chris data database date dbms education fabian management model papers pascal rdbms relational seminars technology
    in Public bookmarks with database tutorial
  • Proper DB Design
    A Well Designed Relational Database [ Anomalies | NF Overview | Functional Dependence | Multivalued Dependence | Keys ] [ Normal Forms | 1NF | 2NF | 3NF | BCNF | 4NF | 5NF | DKNF | Interrelation Constraints ]
    in Public bookmarks with database tipsntricks tutorial
  • Relational databases - The untold story - Architect - Database - Builder AU
    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
    in Public bookmarks with database tutorial
  • Relational databases - Using normal forms to create databases
    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
    Collection of news articles, blog posts, white papers, case studies, videos and comments relating to
    case comments discussions information news papers studies video white
    in Public bookmarks with database sql tipsntricks
  • Rules of Data Normalization
    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
    Rules of Data Normalization Page
    data normalization rules
    in Public bookmarks with database tipsntricks utils by 6 users


database from all users