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, ) 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
