On Wed, Apr 21, 2010 at 2:37 PM, Adam DeVita <adev...@verifeye.com> wrote: > Yes. > > A Date dimension is a table that has all possible dates for your > data, thus making reporting on properties of the date easy. Something > like this > > CREATE TABLE Date_dimension ( > DateID int NOT NULL , /*an int key to match up to date fields in fact > storage tables*/ > [Date] datetime NOT NULL, > [Year] int NOT NULL, > [Month] int NOT NULL, > [Day] int NOT NULL, > [QuarterNumber] int NOT NULL, > [DayofWeek_name] text, > [Month_name] text, > > ) >
methinks you can calculate all of the above storing your dates as strings in a single column, and using the date time functions on that column. Check out the functions in the link I sent you. > > > On Wed, Apr 21, 2010 at 3:25 PM, Pavel Ivanov <paiva...@gmail.com> wrote: > >> > What is a "Date Dimension"? >> >> Probably OP meant this: >> http://en.wikipedia.org/wiki/Dimension_(data_warehouse)<http://en.wikipedia.org/wiki/Dimension_%28data_warehouse%29> >> . >> But I don't have any answer to the question asked. >> >> >> Pavel >> >> On Wed, Apr 21, 2010 at 3:21 PM, P Kishor <punk.k...@gmail.com> wrote: >> > On Wed, Apr 21, 2010 at 1:50 PM, Adam DeVita <adev...@verifeye.com> >> wrote: >> >> Good day, >> >> >> >> Given the context I'm in, sqlite is going to be used for our data >> >> warehousing. (We generate about 2MB of raw data in a month, so we don't >> >> think we need a heavy DB engine.) >> >> >> >> Since most warehouses have one, which are very similar from application >> to >> >> application, I'm wondering if there is somewhere to download a >> pre-defined >> >> Date Dimension? >> > >> > What is a "Date Dimension"? For SQLite's date time functions, see >> > http://www.sqlite.org/lang_datefunc.html >> > >> >> I could write my own script, but re-invent and debug the >> >> wheel? >> >> >> >> regards, >> >> Adam >> >> >> >> -- >> >> VerifEye Technologies Inc. >> >> 905-948-0015x245 >> >> 7100 Warden Ave, Unit 3 >> >> Markham ON, L3R 8B5 >> >> Canada >> >> _______________________________________________ >> >> sqlite-users mailing list >> >> sqlite-users@sqlite.org >> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> >> > >> > >> > >> > -- >> > Puneet Kishor http://www.punkish.org >> > Carbon Model http://carbonmodel.org >> > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org >> > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor >> > Nelson Institute, UW-Madison http://www.nelson.wisc.edu >> > ----------------------------------------------------------------------- >> > Assertions are politics; backing up assertions with evidence is science >> > ======================================================================= >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > VerifEye Technologies Inc. > 905-948-0015x245 > 7100 Warden Ave, Unit 3 > Markham ON, L3R 8B5 > Canada > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
