Stack Overflow
Stack Overflow

Questions tagged [monetdb]

MonetDB is an open-source implementation of a column-oriented database. It is focused on analytical applications on a main memory resident database. MonetDB is a relational database and provides an SQL top-level interface. It is actively developed at CWI in Amsterdam, The Netherlands.

441 questions
0
votes
1 answer

I want to uninstall the monetdb before I install it again

what should I do? only remove the bin directory? or I need some extra operation?
psnbbgy
  • 3
  • 2
0
votes
1 answer

how to get the complete time when I run a sql script using monetdb

when I use the command-line interface of sql after I type "mclient -dmydatabase", if I type the "select...." instruction directly, I will get the complete time like this (query result) 7 tuples (15.4s) but if I put the same instruction into the sql…
psnbbgy
  • 3
  • 2
0
votes
1 answer

MonetDB multi-tenancy?

I am evaluating MonetDB for a multi-tenanted OLAP solution. I understand that there is a concept of schema similar to mysql in MonetDb but is it really scalable in terms of schema's. Can I put a reasonable number of schemas and all performing nearly…
Utkarsh Sopan
  • 51
  • 11
0
votes
1 answer

OIDs in MonetDB

Is there a way to query the OIDs in MonetDB using SQL? That is, I'd like to do something along the lines of SELECT , , ..., FROM and SELECT * FROM
WHERE IN (...) I looked through the documentation…
TR.
  • 200
  • 1
  • 7
0
votes
1 answer

calculating ratio of aggregates for subsample satisfying a condition

I have annual earnings (loneink) for 2007 for each individial ID (personlopnr), and I want to calculate for each company ID (peorglopnr) how much of the total wage bill was paid to worker born after 1980 (birth year is fodelsear), in aggregate.…
László
  • 3,914
  • 8
  • 34
  • 49
0
votes
2 answers

are SQL subqueries within CASE WHEN run once for a query, or for each row?

Basically, is the code below efficient (if I cannot use @ variables in MonetDB), or will this call the subqueries more than once each? CREATE VIEW sys.share26cuts_2007 (peorglopnr,share26cuts_2007) AS ( SELECT peorglopnr, CASE WHEN share26_2007 <…
László
  • 3,914
  • 8
  • 34
  • 49
0
votes
1 answer

variables in SQL for monetdb

I am confused whether at-sign variables could ever work in MonetDB. Is it standard SQL or only mySQL? (See e.g. this answer here on SO.) MonetDB claims to support SQL:2003 (full feature list here, hard for me to parse), but this is what they say on…
László
  • 3,914
  • 8
  • 34
  • 49
0
votes
1 answer

changes in aggregates from annual tables by grouping in sql (monetdb)

My data consists of annual tables for many workers (e.g. a file2006,file2007) incl. an employer ID as well as a firm ID. I also made a view to group firms by some calculations (groups below), which seem to complete fine so they are not shown.…
László
  • 3,914
  • 8
  • 34
  • 49
0
votes
1 answer

Does MonetDB's code contain the X100(VectorWise) 's research?

Since X100 project has been commercialized into the Actian/VectorWise company. I wonder if it's technology remains in MonetDB's code base. In paper 'MonetDB: Two Decades of Research in Column-oriented Database Architectures', it is said that both…
Amos
  • 3,238
  • 4
  • 19
  • 41
0
votes
2 answers

How does Monetdb schedule its MAL instructions and threads?

Monetdb profiler stethoscope shows that MAL instructions are assigned to different threads. What's the policy inside monetdb governing this? To which thread, a MAL instruction should be assigned? Is there a maximum number threads to be used? And,…
thierry
  • 217
  • 2
  • 12
0
votes
2 answers

How do I generate a (dummy) column of arbitrary length with MonetDB?

I would like to run the equivalent of PostgreSQL's SELECT * FROM GENERATE_SERIES(1, 10000000) I've read this: http://blog.jooq.org/2013/11/19/how-to-create-a-range-from-1-to-10-in-sql/ But most suggestions there don't really take an arbitrary…
einpoklum
  • 118,144
  • 57
  • 340
  • 684
0
votes
1 answer

dynamic sql: merge partitioned tables (annual tables into a single table of all years)

I need to merge the data from annual tables into one large table. I am confused about how dynamic SQL (or else) should be used for this. All this is in MonetDB, which follows the SQL 2008 standard, I think. I am not sure they support partitioning…
László
  • 3,914
  • 8
  • 34
  • 49
0
votes
2 answers

Monetdb - tables size in the database

I've loaded .tbl files in the tables, now how I can see the total space used on the disk by the database? I'm using Fedora
Mark
  • 141
  • 1
  • 3
  • 15
0
votes
2 answers

SQL statement to generate a column whose value is the record index

I have some SQL table, say with a single column c1: c1 10 3 1 10 5 Now, I'd like to issue an SQL command (not some operation of my DBMS, which I have intentionally not mentioned) which causes my table to…
einpoklum
  • 118,144
  • 57
  • 340
  • 684
0
votes
2 answers

what's the difference between the next codes?

the first code can not be executed in MonetDB: SELECT rc0.id as runcat, x0.id as xrtcat FROM extractedcatalog x0 INNER JOIN image i0 ON i0.id = 1 AND i0.id = x0.image INNER JOIN runningcatalog rc0 ON…
user2706760
  • 3
  • 2
1 2 3
…
29 30