Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of whitesensless@googlemail.com
 designates 209.85.214.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=googlemail.com; s=gamma;
        h=mime-version:from:date:message-id:subject:to:content-type;
        b=FWTHM4A4lz8T0rolzyRTfl9u2OwydGAk9Cs/zfa3vKQ3WsAysd5ghBWWfnHIV2U2hr
         EJFCcxlbK26kgApa9tQ12n+R0aLGLzhWmpdAjE8mfQNWTmqlbv0+GneHKOKMz43DRY68
         0slTBxn7NnRk4Ei2Q8dx6H94kaAxkpx/EDwdk=
MIME-Version: 1.0
From: Johannes Weissensel <whitesensless@googlemail.com>
Date: Mon, 14 Jun 2010 20:13:01 +0200
Message-ID: <AANLkTinL7gX3cNH6PnSL2isahb8boh0VGmAgCHJoi3SW@mail.gmail.com>
Subject: help for designing a cassandra
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hi everyone,
i am new to nosql databases and especially column-oriented Databases
like cassandra.
I am a student on information-systems and i evaluate a fitting no-sql
database for a web analytics system. Got the use-case of data like
webserver-logfile.
in an RDBMS it would be for every hit a row in the database, and than
endless grouping and counting on the data for getting the metrics you
want.
Is there anyone who has experiences with data like that in hypertable,
how should i design the database?
Also for every hit a single row, or maybe for every session an
aggregated version of the data, or for every day and every page a
single aggregated version.
Maybe some has an idea, how to design the database? Just like an
typical not normalized sql database?
Hope you have some ideas :)
Johannes