[Monetdb-developers] Basics about MonetDB
Hi, I'm a new comer with some questions about basic conceptions of MonetDB. 1. The executor I've ever found the executor of postgreSQL at src\backend\executor, but cannot make sure where it is like that in MonetDB src. MonetDB\MonetDB\src\gdk or MonetDB5-server\MonetDB5\src\mal ? 3. MAL MAL (MonetDB Assembly Language) is a script tool only for MonetDB or a common script language that can be applied to other softwares. Why it is a must in MonetDB ? 4. .mx files In MonetDB, .mx files are compiled to make .h and .c files generated.(in this way ?) Why is this routines ? (not just coding in .h and .c files directly) Yel ---- Best Regards richardroky@gmail.com
On Mon, May 17, 2010 at 02:56:25PM +0800, 叶亮 wrote:
Hi,
I'm a new comer with some questions about basic conceptions of MonetDB.
1. The executor I've ever found the executor of postgreSQL at src\backend\executor, but cannot make sure where it is like that in MonetDB src.
MonetDB is not PostgresSQL. MonetDB has a completely different architecture, both as a DBMS and as software package (see website & research papers for details). I don't even know what the "executor" of PostgreSQl is, let alone what it is used for.
MonetDB\MonetDB\src\gdk or MonetDB5-server\MonetDB5\src\mal ?
3. MAL MAL (MonetDB Assembly Language) is a script tool only for MonetDB or a common script language that can be applied to other softwares.
MAL is MonetDB specific.
Why it is a must in MonetDB ?
It's a "must" only internally providing the column-store core functinality to high-level data model & query language front-ends, like, e.g., the SQL frontend. Externally, MonetDB/SQL (obviously) provides standard SQL.
4. .mx files In MonetDB, .mx files are compiled to make .h and .c files generated.(in this way ?) Why is this routines ? (not just coding in .h and .c files directly)
To facilitate literal programming and code expansion. Stefan
Yel ---- Best Regards richardroky@gmail.com
------------------------------------------------------------------------------
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |
1. The executor I've ever found the executor of postgreSQL at src\backend\executor, but cannot make sure where it is like that in MonetDB src.
MonetDB is not PostgresSQL. MonetDB has a completely different architecture, both as a DBMS and as software package (see website & research papers for details).
I don't even know what the "executor" of PostgreSQl is, let alone what it is used for.
Having also done some work using PostgreSQL, I'd say the MAL interpreter has a rough similarity with the PostgreSQL executor as far as both components will take some internal representation on how to acquire the query result and execute it to create the result. However, the comparison does not go very far as both database engines have substantially different architectures. Some notable differences are: MonetDB normally works on complete columns for high-speed bulk processing. Because of this, the MAL interpreter's plan execution will result in a fully materialized result set, while the row-based PostgreSQL executor expects results to be pulled from it row by row. Also, while the PostgreSQL executor does perform some local optimizations, MonetDB will do both global and local optimizations in different optimization pipeline components, before running the MAL interpreter. Best regards, Isidor
Thanks all.
I just got some senses about how to construct and manipulate BATs, BBPs,
Heap and etc with GDK, and
how commands and patterns are provided to manage BATs by bat5 and algebra,
with which
basically something was done to manage primitive data.
Of course, prior to that, MAL interpreter does acquire the query and execute
it.
All of them, generally make a rough similarity with the "executor" that be
mentioned.
Right or not, in my eyes it is that.
Best Regards
Yel
On Mon, May 17, 2010 at 5:30 PM, Isidor Zeuner
1. The executor I've ever found the executor of postgreSQL at src\backend\executor, but cannot make sure where it is like that in MonetDB src.
MonetDB is not PostgresSQL. MonetDB has a completely different architecture, both as a DBMS and as software package (see website & research papers for details).
I don't even know what the "executor" of PostgreSQl is, let alone what it is used for.
Having also done some work using PostgreSQL, I'd say the MAL interpreter has a rough similarity with the PostgreSQL executor as far as both components will take some internal representation on how to acquire the query result and execute it to create the result. However, the comparison does not go very far as both database engines have substantially different architectures. Some notable differences are: MonetDB normally works on complete columns for high-speed bulk processing. Because of this, the MAL interpreter's plan execution will result in a fully materialized result set, while the row-based PostgreSQL executor expects results to be pulled from it row by row. Also, while the PostgreSQL executor does perform some local optimizations, MonetDB will do both global and local optimizations in different optimization pipeline components, before running the MAL interpreter.
Best regards,
Isidor
------------------------------------------------------------ ------------------
______________________________ _________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
iam new to monetdb can any one provide the proper steps to be followed for running monetdb on ubuntu i have installed monetdb on ubuntu11.04 when iam running the command monetdb -h mserver5 iam getting the below statement monetdb: -h requires -P to be used should we install mserver5 separately if so could any one give me the link to do it iam unable to find it on monetdb homepage as most of the documents are access forbidden . please provide me the links to run monetdb on ubuntu , sql reference manual for monetdb ubuntu version . -- Thanks -- View this message in context: http://old.nabble.com/Basics-about-MonetDB-tp28580007p31740851.html Sent from the monetdb-developers mailing list archive at Nabble.com.
On Mon, May 17, 2010 at 4:01 PM, Stefan Manegold
3. MAL MAL (MonetDB Assembly Language) is a script tool only for MonetDB or a common script language that can be applied to other softwares.
MAL is MonetDB specific.
Why it is a must in MonetDB ?
It's a "must" only internally providing the column-store core functinality to high-level data model & query language front-ends, like, e.g., the SQL frontend. Externally, MonetDB/SQL (obviously) provides standard SQL.
Thanks. Well, historical things or not, it sounds like that MAL is originally specifically designed for cute infrastructure of MonetDB. I don't know when MonetDB project began from, ( probably 1990's ?) anyway, if without SQL or XQuery package, only with MAL script programming, users can still use MonetDB as they like, isn't it ? So could i understand MAL as a textual interface for whoever wanna manipulate MonetDB straight forward. Best Regards Yel ---- richardroky@gmail.com
Hello,
I've been working on optimizing the installation and usage process of
MonetDB with Ubuntu.
didn't really knew where to write this, so I thought I'll just post it
here. The current head of the development tree contains all the changes
described here, so this doesn't apply to the current packages yet.
The installation and usage intructions for Ubuntu/Debian will be
Install the MonetDB public key:
$ wget --output-document=- http://monetdb.cwi.nl/downloads/MonetDB-GPG-KEY | sudo apt-key add -
Add the MonetDB repository to your apt configuration, put the following lines in /etc/apt/sources.list.d/monetdb.list:
deb http://monetdb.cwi.nl/downloads/Ubuntu/ karmic monetdb
deb-src http://monetdb.cwi.nl/downloads/Ubuntu/ karmic monetdb
To install the monetdb sql server and all the dependecies use the command:
$ sudo apt-get install monetdb5-sql
If you want to be able to manage the monetdb databases you should add
yourself to the monetdb group of the system:
$ sudo usermod -G monetdb $USER
There is a new startup script available that will start merovingian and
optionally all databases.
$ sudo /etc/init.d/monetdb5-sql
hello, can anyone provide steps for installing monetdb on ubuntu 11.04 ?? do we have any eclipse pluggins for monetdb -- View this message in context: http://old.nabble.com/Basics-about-MonetDB-tp28580007p31735316.html Sent from the monetdb-developers mailing list archive at Nabble.com.
On 2011-05-30 20:34, rose26 wrote:
hello, can anyone provide steps for installing monetdb on ubuntu 11.04 ?? do we have any eclipse pluggins for monetdb
There is no official release yet that support 11.04, but there is a release candidate (with no guarantees that it will become a release) for the Apr2011-SP1 release at http://dev.monetdb.org/downloads/testing/deb/. There are instructions there on how to install. There is no eclipse plugin for MonetDB. -- Sjoerd Mullender
Thanks a lot are there tutorials to store an image and load it from monetdb Sjoerd Mullender-2 wrote:
On 2011-05-30 20:34, rose26 wrote:
hello, can anyone provide steps for installing monetdb on ubuntu 11.04 ?? do we have any eclipse pluggins for monetdb
There is no official release yet that support 11.04, but there is a release candidate (with no guarantees that it will become a release) for the Apr2011-SP1 release at http://dev.monetdb.org/downloads/testing/deb/. There are instructions there on how to install.
There is no eclipse plugin for MonetDB.
-- Sjoerd Mullender
------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- View this message in context: http://old.nabble.com/Basics-about-MonetDB-tp28580007p31739731.html Sent from the monetdb-developers mailing list archive at Nabble.com.
participants (8)
-
Fabian Groffen -
Gijs Molenaar -
Isidor Zeuner -
rose26 -
Sjoerd Mullender -
Stefan Manegold -
Yel -
叶亮