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.
Questions tagged [monetdb]
441 questions
0
votes
1 answer
monetdb: Online Schema Alters
Does MonetDB support online schema changes? For example adding/changing a column on the fly while the tables are loaded in memory. Many in-memory databases have to restarted to get the schema changes reflected. So, I was wondering if MonetDB took…
Rahul
- 903
- 8
- 16
0
votes
1 answer
How to change default data directory in MonetDB?
I am trying to change the default data directory of MonetDB. I am running out of space, and I would like to migrate the data to another folder.
Does anyone know how to do that?
I have installed MonetDB using the ubuntu package, and by default the…
0
votes
2 answers
Dump and restore in Monetdb
I'm new to monet. When it comes to dump/restore activities I would like to use the same functionality of mysqldump. I tried the following:
mclient -u monetdb -lsql --database=my_db --dump > ~/my_db.sql
However, when restoring with:
mclient -u…
andtorg
- 179
- 1
- 6
0
votes
1 answer
how to calculate one column from another columns?
In monetdb I created a table:
create table extractedcatalog(id int, ra double, decl double, x double, y double, z double);
ra,decl are all inserted into tables already, now I want to calculate x,y,z from ra,decl columns. In sql I executed like…
user2706760
- 3
- 2
0
votes
2 answers
how to calculate a column using another column in sql?
the create table query is :
create table catalog (id int, ra double, decl double , zone int);
the zone value is calculated from decl using formula below:
CAST(FLOOR(decl) AS INTEGER),
i have insert all id,ra,decl values of the table, then I have…
user2706760
- 3
- 2
0
votes
1 answer
A MonetDB User Defined Function with two double parameters
I am trying to evaluate the performance of MonetDB for an analytical workload that contains a large amount of floating point calculations which are used in an aggregation.
I am trying to implement a C based UDF in MonetDB to achieve this and am…
amckinley
- 629
- 1
- 7
- 15
0
votes
1 answer
Concat a list of elements and scores without using a recursive function in XQuery with Tijah extensions
For a university search engine project, I am using MonetDB with Tijah extensions. I've got a list of nodes, returned from a search string:
let $qid := tijah:queryall-id($nexi)
let $nodes := tijah:nodes($qid)
$nodes now contains a list of elements,…
Scharrels
- 3,055
- 25
- 31
0
votes
1 answer
Is it possible to sort by lower case in MonetDB?
Is it possible to do an 'Order by lower(field_name)' in MonetDB?
Marina
- 3,222
- 5
- 25
- 35
0
votes
1 answer
Import CSV using monetdb from daemon
Is there a way to do this without having to fire up an instance?
ast4
- 791
- 8
- 19
0
votes
1 answer
php_monetdb.dll
I need the php_monetdb.dll for php 5.4. I've found that by building the monetDB with the HAVE_PHP=1 option on windows will create the dll, but the build procedure fails at numerous points. I am using the monetdb source from sourceforge which is a…
suchitra nair
- 535
- 7
- 13
-1
votes
1 answer
May I ask the source code related to Embedded Python/Numpy?
I want to learn about the code that's related to Embedded Python/Numpy and how the optimizer will handle the Python UDF. May I ask the related source code?
Alan
- 3
- 2
-1
votes
1 answer
PostgreSQL, MonetDB and MySQL add primary key to existing table
When I add a primary key to a table that already has data, what does each of these database management systems do?
Do they analyze each and every value of the column to confirm it is unique ?
Or do they have some other optimized mechanism ? And if…
João Amorim
- 3
- 4
-1
votes
1 answer
Concatenate rows to single row in SQL Server 2008
I'm using MonetDb for analytics, which is using SQL Server 2008 for query processing.
I have a table ROLES, which has data below.
Emp ROLE
1 ROLE_1
1 ROLE_2
1 ROLE_3
2 ROLE_1
2 ROLE_2
3 ROLE_3
3 ROLE_4
I want output as
EMP ROLE
1 …
Sreenath
- 480
- 2
- 6
- 17
-1
votes
1 answer
Initial value of these pointers in Monetdb
While coming across Monetdb source there are three structures which were used most often. They are
MalBlkPtr mb
MalStkPtr stk
InstrPtr pci
What are they meant for? What is their initial value and when do they get initialized?
Pradeep
- 23
- 8
-1
votes
1 answer
Type hugeint is not defined in MonetDB
I am facing one problem while running the query from Django-Python. I am getting error "Type hugeint is not defined" using database Monetdb. Can anyone suggest why this error is coming.
Jazz
- 17
- 2