com presentations: SQl2 NoSQL for Midwest PHP: slides/mongodb/normal-form.xml sql2nosql-midwest14.xml
[email protected] (Derick Rethans)
| Newsgroups | php.pres |
|---|---|
| Message-ID | <[email protected]> |
Commit: f2fd1afb2626fff1cd259d82f9424109eca10ca8 Author: Derick Rethans <[email protected]> Sun, 16 Mar 2014 14:11:41 -0500 Parents: 4305ef5d9d79b44c03e14431a3b865f796c9068f Branches: master Link: http://git.php.net/?p=presentations.git;a=commitdiff;h=f2fd1afb2626fff1cd259d82f9424109eca10ca8 Log: SQl2 NoSQL for Midwest PHP Changed paths: M slides/mongodb/normal-form.xml A sql2nosql-midwest14.xml Diff: diff --git a/slides/mongodb/normal-form.xml b/slides/mongodb/normal-form.xml index f4c8df9..c1eed34 100644 --- a/slides/mongodb/normal-form.xml +++ b/slides/mongodb/normal-form.xml @@ -3,9 +3,11 @@ <div effect="fade-out yes"> <list> -<bullet>*1NF*: A relation is in first normal form if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.</bullet> -<bullet>*2NF*: No non-prime attribute in the table is functionally dependent on a proper subset of any candidate key</bullet> -<bullet>*3NF*: Every non-prime attribute is non-transitively dependent on every candidate key in the table. The attributes that do not contribute to the description of the primary key are removed from the table. In other words, no transitive dependency is allowed.</bullet> +<bullet>*1NF*: A relation is in first normal form if the domain of each +|aaaaaa|attribute contains| |cccccc|only atomic values, and the value of each attribute contains only a single value from that domain.|</bullet> +<bullet>*2NF*: No non-prime attribute in the table is |aaaaaa|functionally dependent| +|cccccc|on a proper subset of any candidate key|</bullet> +<bullet>*3NF*: Every non-prime attribute is non-transitively |aaaaaa|dependent on every| |cccccc|candidate key in the table. The attributes that do not contribute to the description of the primary key are removed from the table. In other words, no transitive dependency is allowed.|</bullet> </list> </div> <div effect="fade-in"> diff --git a/sql2nosql-midwest14.xml b/sql2nosql-midwest14.xml new file mode 100644 index 0000000..a93d2bf --- /dev/null +++ b/sql2nosql-midwest14.xml @@ -0,0 +1,67 @@ +<?xml version="1.0" encoding="utf-8"?> +<presentation css="10gen-strict.css"> +<topic>mongoDB</topic> +<title>From SQL to NoSQL</title> +<event>Midwest PHP</event> +<location>Minneapolis, MN, US</location> +<date>Mar 16th, 2014</date> +<speaker>Derick Rethans</speaker> +<email>[email protected]</email> +<twitter>derickr</twitter> +<url>http://derickrethans.nl/talks.html</url> +<joindin>http://joind.in/10557</joindin> +<slide>slides/mongodb/title.xml</slide> + +<!-- DINOSAUR vs PLATIPUS --> +<slide>slides/mongodb/relational-model.xml</slide> +<slide>slides/mongodb/dinosaur.xml</slide> +<slide>slides/mongodb/normal-form.xml</slide> +<slide>slides/mongodb/normal-form1.xml</slide> +<slide>slides/mongodb/normal-form2.xml</slide> +<slide>slides/mongodb/normal-form3.xml</slide> + +<!-- DIFFERENT NoSQL --> +<slide>slides/mongodb/nosql.xml</slide> +<slide>slides/mongodb/nosql-kv.xml</slide> +<slide>slides/mongodb/nosql-column.xml</slide> +<slide>slides/mongodb/nosql-graph.xml</slide> +<slide>slides/mongodb/nosql-document.xml</slide> +<slide>slides/mongodb/platipus.xml</slide> + +<!-- ACID vs CAP --> +<slide>slides/mongodb/acid.xml</slide> +<slide>slides/mongodb/cap.xml</slide> + +<!-- A FEW NOTES ON MONGODB --> +<slide>slides/mongodb/databasefield.xml</slide> +<slide>slides/mongodb/collections-documents.xml</slide> +<slide>slides/mongodb/document.xml</slide> +<slide>slides/mongodb/mongodb-1nf.xml</slide> +<slide>slides/mongodb/mongodb-2nf.xml</slide> +<slide>slides/mongodb/mongodb-3nf.xml</slide> +<slide>slides/mongodb/insert-intro.xml</slide> +<slide>slides/mongodb/update-intro.xml</slide> +<slide>slides/mongodb/update-atomicity.xml</slide> +<slide>slides/mongodb/update-consistency.xml</slide> + +<slide>slides/mongodb/arbitrary-keys1.xml</slide> +<slide>slides/mongodb/one-to-many2.xml</slide> +<slide>slides/mongodb/one-to-many4.xml</slide> +<slide>slides/mongodb/embed-vs-link.xml</slide> + +<slide>slides/mongodb/writeconcern-consistency.xml</slide> +<slide>slides/mongodb/writeconcern-consistency-list.xml</slide> + +<!-- REPLICATION --> +<slide>slides/mongodb/availability.xml</slide> +<slide>slides/mongodb/repl-features.xml</slide> +<slide>slides/mongodb/repl-works-basic.xml</slide> +<slide>slides/mongodb/repl-works-normal.xml</slide> +<slide>slides/mongodb/repl-works-failover.xml</slide> + +<slide>slides/mongodb/repl-eventual-consistency.xml</slide> + +<slide>slides/mongodb/sql2nosql-conclusion.xml</slide> +<slide>slides/mongodb/resources.xml</slide> + +</presentation>