\u00ab<\/B> Adding Configuration Properties<\/a><\/div>
Transaction Prediction Models<\/a> \u00bb<\/B><\/div><\/div><\/p>\n
A parameter mapping<\/strong> is a data structure that allows H-Store to link procedure input parameters (ProcParameter<\/tt>) to the input parameters of unique Statement invocations (StmtParameter<\/tt>). This allows the H-Store TransactionEstimator to calculate what partitions will be needed by a transaction before it begins execution.<\/p>\n
See the 2011 VLDB paper for a description on how these mappings are used by H-Store.<\/p>\n
\nA. Pavlo, E. P. C. Jones, and S. Zdonik, "On Predictive Modeling for Optimizing Transaction Execution in Parallel OLTP Systems," Proc. VLDB Endow.<\/em>, vol. 5, pp. 85-96, 2011. [PDF]<\/a> [BIBTEX]<\/a>\n\n @article{pavlo2011, \n author = {Pavlo, Andrew and Jones, Evan P.C. and Zdonik, Stanley}, \n title = {On Predictive Modeling for Optimizing Transaction Execution in Parallel {OLTP} Systems}, \n journal = {Proc. VLDB Endow.}, \n volume = {5}, \n issue = {2}, \n month = {October}, \n year = {2011}, \n pages = {85--96}, \n publisher = {VLDB Endowment}, \n url = {http:\/\/hstore.cs.brown.edu\/papers\/hstore-markov.pdf}, \n }<\/code>\n <\/div>\n<\/li>\n<\/ul>\nGenerating New Parameter Mappings<\/h2>\nYou first must build the target benchmark’s catalog. Since the Parameter Mappings are not specific to a cluster, you can use a single-partition cluster. This will cause the cluster to run faster, but requires sufficient amount of mmeory to store the entire database on a single machine:<\/p>\nant hstore-prepare<\/tt> -Dproject=tm1 -Dhosts=localhost:0:0<\/pre>\nYou can then use the make-workloads.py<\/a> utility to automatically generate, combine, and compress a sample workload. You must execute this command from the H-Store root directory.<\/p>\n .\/tools\/make-workloads.py tm1<\/pre>\nThis will create a workload file called “tm1-combined.trace.gz<\/tt>“. You can construct the mappings file with the mappings-generate<\/tt> command with this workload:<\/p>\nant mappings-generate<\/tt> -Dproject=tm1 \\\r\n -Dthreshold=1.0 \\\r\n -Dworkload=tm1-combined.trace.gz \\\r\n -Doutput=tm1.mappings<\/pre>\nThe threshold<\/tt> option defines the cut-off point for the matching coefficients of the mappings.<\/p>\n \u00ab<\/B> Adding Configuration Properties<\/a><\/div> Transaction Prediction Models<\/a> \u00bb<\/B><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"A parameter mapping is a data structure that allows H-Store to link procedure input parameters (ProcParameter) to the input parameters of unique Statement invocations (StmtParameter). This allows the H-Store TransactionEstimator to calculate what partitions will be needed by a transaction before it begins execution. See the 2011 VLDB paper for a description on how these […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":616,"menu_order":40,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/963"}],"collection":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/comments?post=963"}],"version-history":[{"count":18,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/963\/revisions"}],"predecessor-version":[{"id":1825,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/963\/revisions\/1825"}],"up":[{"embeddable":true,"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/pages\/616"}],"wp:attachment":[{"href":"https:\/\/hstore.cs.brown.edu\/wp-json\/wp\/v2\/media?parent=963"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}