Ask Your Question

Does Base offer a straightforward way to impliment window functions? [closed]

asked 2014-03-22 00:35:32 +0200

andrewH gravatar image

updated 2015-09-27 18:53:29 +0200

Alex Kemp gravatar image

Hi folks! I would like to use base to create and query some very large flat data files that I now have in .csv or tab-delimited format (mainly Census data and the like). One of the things that I would like to do with the data is to create a variety of summary statistics from various subsets of the data. I would like to do this in Base where possible to avoid problems with line limits (in Calc) or memory (in R).

I am almost completely new to databases except for using forms others have written to access pre-existing databases, but my understanding is that creation of the sort of summary statistics I am talking about can most easily be created via the use of window functions for those databases that support window functions. So, two related questions: 1. Does LibreOffice base support window functions? and if so: 2. Is there a good how-to guide or tutorial on using such functions via Base that you would recommend for someone new to Base, and indeed, almost new to databases?

Help and guidance very much appreciated. I am using LibreOffice under Windows 7 64-bit with Service Pack 1.

Warmest regards, andrewH

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:55:36.266112


m.a.riosv gravatar imagem.a.riosv ( 2014-03-22 00:51:45 +0200 )edit

What do you mean by 'window functions'?

frofa gravatar imagefrofa ( 2014-03-22 08:12:01 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-03-22 12:05:11 +0200

David gravatar image

updated 2014-03-22 12:19:20 +0200

[N.b. This answer might be deletable!]

"Windows functions" are new to me (not difficult), but I take it that this tutorial explanation points in the right direction. See also the PostgreSQL docs.

As explained elsewhere, Base uses HSQLDB (see first line of link). My understanding is that Firebird is close to implementing windows functions but it looks like it's not quite there yet.

According to the tutorial linked above, MySQL and SQLite and other open source DBs do not have this function yet; PostgreSQL is the only option. There is some documentation on connecting Base and PostgreSQL (also earlier on AskLibO), so if Window Functions are important it should be feasible, but not by default ("out of the box") -- it looks like it would require PostgreSQL.

edit flag offensive delete link more


And see THIS for info on HSQLDB and future windowing functions.

frofa gravatar imagefrofa ( 2014-03-23 05:24:20 +0200 )edit

Question Tools



Asked: 2014-03-22 00:35:32 +0200

Seen: 150 times

Last updated: Mar 22 '14