From user-return-18323-apmail-couchdb-user-archive=couchdb.apache.org@couchdb.apache.org Sat Oct 15 03:50:10 2011 Return-Path: X-Original-To: apmail-couchdb-user-archive@www.apache.org Delivered-To: apmail-couchdb-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0715C99DE for ; Sat, 15 Oct 2011 03:50:10 +0000 (UTC) Received: (qmail 71263 invoked by uid 500); 15 Oct 2011 03:50:08 -0000 Delivered-To: apmail-couchdb-user-archive@couchdb.apache.org Received: (qmail 71109 invoked by uid 500); 15 Oct 2011 03:50:05 -0000 Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@couchdb.apache.org Delivered-To: mailing list user@couchdb.apache.org Received: (qmail 71101 invoked by uid 99); 15 Oct 2011 03:50:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Oct 2011 03:50:03 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of david@davidjfox.com designates 209.85.210.180 as permitted sender) Received: from [209.85.210.180] (HELO mail-iy0-f180.google.com) (209.85.210.180) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 15 Oct 2011 03:49:53 +0000 Received: by iakc1 with SMTP id c1so4841040iak.11 for ; Fri, 14 Oct 2011 20:49:32 -0700 (PDT) Received: by 10.231.69.146 with SMTP id z18mr4807435ibi.79.1318650572168; Fri, 14 Oct 2011 20:49:32 -0700 (PDT) Received: from [192.168.0.181] (c-67-175-247-247.hsd1.il.comcast.net. [67.175.247.247]) by mx.google.com with ESMTPS id ge16sm13995597ibb.2.2011.10.14.20.49.30 (version=SSLv3 cipher=OTHER); Fri, 14 Oct 2011 20:49:31 -0700 (PDT) Message-ID: <4E9902C3.80807@davidjfox.com> Date: Fri, 14 Oct 2011 22:49:23 -0500 From: David Fox User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1 MIME-Version: 1.0 To: user@couchdb.apache.org Subject: When to normalize data References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hey guys, I have a database containing thousands of documents fairly large in size. These documents contain something similar to an access key inside them, so users can control who can view their "documents", how many times, etc... Besides these access keys, which get updated very often, the rest of the document is relatively static. Would this be a case where it would make sense to normalize my document and store these access keys separately? Are there any general guidelines determining when it makes sense to normalize? -David