Package edu.brown.workload

Examples of edu.brown.workload.TransactionTrace

324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
     */
    public void testWeightedQueryInvalidateCache() throws Throwable {
        // Make a new workload that only has a single weighted copy of our multi-partition transaction
        Workload new_workload = new Workload(catalogContext.catalog);
        int weight = 6;
        TransactionTrace multip_txn = this.getMultiPartitionTransaction();
        Procedure catalog_proc = multip_txn.getCatalogItem(catalogContext.database);
        TransactionTrace clone = (TransactionTrace)multip_txn.clone();
        clone.setTransactionId(1000);
        for (QueryTrace qt : clone.getQueries()) {
            qt.setWeight(weight);
        }
        new_workload.addTransaction(catalog_proc, clone);
        assertEquals(1, new_workload.getTransactionCount());
        assertEquals(multip_txn.getQueryCount(), new_workload.getQueryCount());
View Full Code Here
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
    /**
     * testHistograms
     */
    public void testHistograms() throws Exception {
        // Grab a txn with a JOIN
        TransactionTrace xact_trace = null;
        for (TransactionTrace xact : workload.getTransactions()) {
            assertNotNull(xact);
            if (xact.getCatalogItemName().equals(TARGET_PROCEDURES[2])) {
                xact_trace = xact;
                break;
            }
        } // FOR
        assertNotNull(xact_trace);

        // Change the catalog so that the data from the tables are in different partitions
        Database clone_db = CatalogCloner.cloneDatabase(catalogContext.database);
        assertNotNull(clone_db);
        CatalogContext clone_catalogContext = new CatalogContext(clone_db.getCatalog());
        Table catalog_tbl = clone_db.getTables().get(TM1Constants.TABLENAME_CALL_FORWARDING);
        assertNotNull(catalog_tbl);
        Column catalog_col = catalog_tbl.getColumns().get("START_TIME");
        assertNotNull(catalog_col);
        catalog_tbl.setPartitioncolumn(catalog_col);
       
        // Throw the TransactionTrace at the costmodel and make sure that there is a TransactionCacheEntry
        SingleSitedCostModel cost_model = new SingleSitedCostModel(clone_catalogContext);
        cost_model.estimateTransactionCost(clone_catalogContext, xact_trace);
        cost_model.setCachingEnabled(true);
        TransactionCacheEntry entry = cost_model.getTransactionCacheEntry(xact_trace);
        assertNotNull(entry);
//        System.err.println(entry.toString());

        // --------------------------
        // Query Counters
        // --------------------------
        assertEquals(xact_trace.getQueries().size(), entry.getTotalQueryCount());
        assertEquals(xact_trace.getQueries().size(), entry.getExaminedQueryCount());
        assertEquals(0, entry.getSingleSiteQueryCount());
        assertEquals(1, entry.getMultiSiteQueryCount());
       
        // ---------------------------------------------
        // Partitions Touched by Txns
View Full Code Here
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
   
    /**
     * testEstimateCost
     */
    public void testEstimateCost() throws Exception {
        TransactionTrace xact_trace = null;
        for (TransactionTrace xact : workload.getTransactions()) {
            assertNotNull(xact);
            if (xact.getCatalogItemName().equals(TARGET_PROCEDURES[0])) {
                xact_trace = xact;
                break;
            }
        } // FOR
        assertNotNull(xact_trace);
       
        // System.err.println(xact_trace.debug(catalogContext.database));
        SingleSitedCostModel cost_model = new SingleSitedCostModel(catalogContext);
        cost_model.estimateTransactionCost(catalogContext, xact_trace);
        TransactionCacheEntry entry = cost_model.getTransactionCacheEntry(xact_trace);
        assertNotNull(entry);
       
        assertEquals(xact_trace.getQueries().size(), entry.getTotalQueryCount());
        assertEquals(xact_trace.getQueries().size(), entry.getExaminedQueryCount());
        assertEquals(1, entry.getSingleSiteQueryCount());
        assertEquals(1, entry.getMultiSiteQueryCount());
       
        // Check Partition Access Histogram
        Histogram<Integer> hist_access = cost_model.getQueryPartitionAccessHistogram();
View Full Code Here
562
563
564
565
566
567
568
569
570
571
572
        // This will cause the Txn entry to be thrown out completely because all the
        // queries have been invalidated
        cost_model.invalidateCache(this.getTable(TM1Constants.TABLENAME_SUBSCRIBER));
        cost_model.invalidateCache(this.getTable(TM1Constants.TABLENAME_CALL_FORWARDING));
       
        TransactionTrace xact_trace = xacts.get(0);
        assertNotNull(xact_trace);
        TransactionCacheEntry entry = cost_model.getTransactionCacheEntry(xact_trace);
        assertNull(entry);
       
        // Make sure that we updated the Execution Histogram
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
        Database clone_db = CatalogCloner.cloneDatabase(catalogContext.database);
        assertNotNull(clone_db);
        CatalogContext clone_catalogContext = new CatalogContext(clone_db.getCatalog());
       
        Procedure catalog_proc = this.getProcedure(clone_db, GetAccessData.class);
        TransactionTrace target_txn = null;
        for (TransactionTrace txn : workload.getTransactions()) {
            if (txn.getCatalogItemName().equals(catalog_proc.getName())) {
                target_txn = txn;
                break;
            }
View Full Code Here
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
     */
    public void testMultiColumnPartitioning() throws Exception {
        Database clone_db = CatalogCloner.cloneDatabase(catalogContext.database);
        CatalogContext clone_catalogContext = new CatalogContext(clone_db.getCatalog());
        Procedure catalog_proc = this.getProcedure(clone_db, GetAccessData.class);
        TransactionTrace target_txn = null;
        for (TransactionTrace txn : workload.getTransactions()) {
            if (txn.getCatalogItemName().equals(catalog_proc.getName())) {
                target_txn = txn;
                break;
            }
        } // FOR
        assertNotNull(target_txn);
        System.err.println(target_txn.debug(catalogContext.database));
       
        // Now change partitioning
        MultiProcParameter catalog_param = MultiProcParameter.get(catalog_proc.getParameters().get(0), catalog_proc.getParameters().get(1));
        assertNotNull(catalog_param);
        catalog_proc.setPartitionparameter(catalog_param.getIndex());
View Full Code Here
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
                @Override
                public String debugImpl() { return null; }
                @Override
                protected void resetImpl() { }
            }, workload);
            TransactionTrace txn0 = CollectionUtil.first(workload.getTransactions());
            assertNotNull(txn0);
            TransactionTrace txn1 = CollectionUtil.first(clone.getTransactions());
            assertNotNull(txn1);
            assert(txn0.getTransactionId() != txn1.getTransactionId());
           
            // assertEquals(WORKLOAD_XACT_LIMIT, workload.getTransactionCount());

            // for (TransactionTrace xact : workload.getTransactions()) {
            // System.err.println(xact + ": " + p_estimator.getAllPartitions(xact));
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
94
        Iterator<TransactionTrace> it = workload.iterator(filter);
        assertNotNull(it);

        int count = 0;
        while (it.hasNext()) {
            TransactionTrace element = it.next();
            String name = element.getCatalogItemName();
            assert(results.containsKey(name)) : "Unexpected " + name;
            results.put(name, results.get(name) + 1);
            count++;
        } // WHILE
        assert(count > 0);
View Full Code Here
27
28
29
30
31
32
33
34
35
36
37
38
        int count = 0;
        while (it.hasNext()) {
            AbstractTraceElement<? extends CatalogType> element = it.next();
            if (element instanceof TransactionTrace) {
                // Make sure that this txn's base partition is what we expect it to be
                TransactionTrace txn = (TransactionTrace)element;
                int base_partition = p_estimator.getBasePartition(txn.getCatalogItem(catalog_db), txn.getParams(), true);
                assert(base_partition != HStoreConstants.NULL_PARTITION_ID);
                assertEquals(BASE_PARTITION, base_partition);
                count++;
            }
        } // WHILE
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
        int count = 0;
        while (it.hasNext()) {
            AbstractTraceElement<? extends CatalogType> element = it.next();
            if (element instanceof TransactionTrace) {
                // Make sure that all of the array parameters have the same size
                TransactionTrace txn = (TransactionTrace)element;
                assertEquals(TARGET_PROCEDURE, txn.getCatalogItemName());
                Object val = txn.getParam(PARAM_IDX);
                assertNotNull(val);
                assertEquals(txn.toString(), PARAM_VALUE, val);
                count++;
            }
        } // WHILE
        assert(count > 0);
    }
View Full Code Here
TOP

Related Classes of edu.brown.workload.TransactionTrace

  • edu.brown.costmodel.AbstractCostModel
  • edu.brown.costmodel.MarkovCostModel
  • edu.brown.costmodel.SingleSitedCostModel
  • edu.brown.costmodel.TestMarkovCostModel
  • edu.brown.costmodel.TestSingleSitedCostModel
  • edu.brown.costmodel.TestTimeIntervalCostModel
  • edu.brown.costmodel.TimeIntervalCostModel$IntervalProcessor
  • edu.brown.designer.mappers.AffinityMapper
  • edu.brown.hstore.estimators.markov.TestMarkovEstimator
  • edu.brown.hstore.specexec.checkers.TestMarkovConflictChecker
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.