[MonetDB-users] SQL Table partitioning in MonetDB
I have this problem... i have a table with 33.000.000 of records.. the table is named i_predicate with four columns as follows (oid, name, isubj, iobj)... i want to execute a physical partition on i-predicate respect to the values of name column.. in this way if i query i_predicate monetdb has to use only the respective partition with the respective value of name... does it exist a sql statement for creating partitions of i_predicate? does it exist a script for this partition on MonetDB? and if i create the partition... i have to define function to query correctly the partitions? Thanks -- View this message in context: http://www.nabble.com/SQL-Table-partitioning-in-MonetDB-tp18384206p18384206.... Sent from the monetdb-users mailing list archive at Nabble.com.
On Thu, Jul 10, 2008 at 08:50:39AM -0700, Napoma wrote:
I have this problem... i have a table with 33.000.000 of records.. the table is named i_predicate with four columns as follows (oid, name, isubj, iobj)... i want to execute a physical partition on i-predicate respect to the values of name column.. in this way if i query i_predicate monetdb has to use only the respective partition with the respective value of name...
does it exist a sql statement for creating partitions of i_predicate?
no sql statement exists for this
does it exist a script for this partition on MonetDB?
We don't have such scripts, but it shouldn't be difficult to create.
and if i create the partition... i have to define function to query correctly the partitions?
Views and functions could both work depending on the application Niels
Thanks -- View this message in context: http://www.nabble.com/SQL-Table-partitioning-in-MonetDB-tp18384206p18384206.... Sent from the monetdb-users mailing list archive at Nabble.com.
------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl
Napoma wrote:
I have this problem... i have a table with 33.000.000 of records.. the table is named i_predicate with four columns as follows (oid, name, isubj, iobj)... i want to execute a physical partition on i-predicate respect to the values of name column.. in this way if i query i_predicate monetdb has to use only the respective partition with the respective value of name...
Database does not seem too large, between 1-2 GB. Common strings are detected and hashing will ensure quick access to the elements with the same name.
does it exist a sql statement for creating partitions of i_predicate?
The SQL frontend does not provide a partitioning option. It is a decision the system should make itself, such features are part of the research. See e.g. the cracker papers, whose code is included in the distribution.
does it exist a script for this partition on MonetDB?
and if i create the partition... i have to define function to query correctly the partitions?
Thanks
participants (3)
-
Martin Kersten -
Napoma -
Niels Nes