samples_tpch_tpch11.html

<html><head>
<title>DBToaster - Sample Queries</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/bootstrap.min.css" media="screen" />
<link rel="stylesheet" type="text/css" href="css/bootstrap-theme.min.css" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon">
<link rel="icon" href="favicon.ico" type="image/x-icon">
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
<link rel="stylesheet" href="http://fortawesome.github.io/Font-Awesome/assets/font-awesome/css/font-awesome.css">   


</head> <body>
<a name="pagetop"></a>
<div class="overallpage">
  <div class="pagebody">
    <div class="logobox">
        <a href="index.html" ><img src="dbtoaster-logo.gif" width="214" 
                    height="100" alt="DBToaster"/></a>    </div>
    <div class="navbar navbar-default">
      <div class="navbar-header">
        <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
          <span class="icon-bar"></span>
          <span class="icon-bar"></span>
          <span class="icon-bar"></span>
        </button>
      </div>
      <div class="navbar-collapse collapse">
        <ul class="nav navbar-nav">
          <li class="dropdown">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">About <b class="caret"></b></a>
            <ul class="dropdown-menu">
              <li><a href="index.html" >Welcome to dbtoaster.org</a></li>
              <li><a href="home_about.html" >Is DBToaster right for you?</a></li>
              <li><a href="home_performance.html" >Performance</a></li>
              <li><a href="home_features.html" >Features</a></li>
              <li><a href="home_features.html#roadmap" ><small><i class="fa fa-caret-square-o-right"></i> Roadmap</small></a></li>
              <li><a href="home_people.html" >The Team</a></li>
              <li><a href="home_research.html" >For Researchers</a></li>
            </ul>
          </li>
          <li class="dropdown">
            <!--?php if(!isset($now_building_distro)) { ?-->
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">Downloads <b class="caret"></b></a>
            <!--?php } else { ?-->
            <!--a href="#" class="dropdown-toggle" data-toggle="dropdown">License <b class="caret"></b></a-->
            <!--?php } ?-->
            <ul class="dropdown-menu">
              <!--?php if(!isset($now_building_distro)) { ?-->
              <li><a href="download.html" >Downloads</a></li>
              <!--?php } ?-->
              <li><a href="download.html#license" >License</a></li>
              <li><a href="download.html#changelog" >Changelog</a></li>
            </ul>
          </li>
          <li class="dropdown">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">Documentation <b class="caret"></b></a>
            <ul class="dropdown-menu">              
              <li><a href="docs.html" >Installation</a></li>
              <li><a href="docs_start.html" >Getting Started</a></li>
              <li><a href="docs_architecture.html" >Architecture</a></li>
              <li><a href="docs_compiler.html" >Command-Line Reference</a></li>
              <li><a href="docs_compiler.html#options" ><small><i class="fa fa-caret-square-o-right"></i> Command-Line Options</small></a></li>
              <li><a href="docs_compiler.html#languages" ><small><i class="fa fa-caret-square-o-right"></i> Supported Languages</small></a></li>
              <li><a href="docs_compiler.html#opt_flags" ><small><i class="fa fa-caret-square-o-right"></i> Optimization Flags</small></a></li>
              <li><a href="docs_sql.html" >DBToaster SQL Reference</a></li>
              <li><a href="docs_stdlib.html" >DBToaster StdLib Reference</a></li>
              <li><a href="docs_adaptors.html" >DBToaster Adaptors Reference</a></li>
              <li><a href="docs_cpp.html" >C++ Code Generation</a></li>
              <li><a href="docs_scala.html" >Scala Code Generation</a></li>
              <li><a href="docs_java.html" >DBToaster in Java Programs</a></li>
              <li><a href="docs_customadaptors.html" >Custom Adaptors</a></li>
            </ul>
          </li>
          <li class="dropdown">
            <a href="#" class="dropdown-toggle" data-toggle="dropdown">Contact <b class="caret"></b></a>
            <ul class="dropdown-menu">
              <li><a href="home_contact.html#inquiries" >Inquiries</a></li>

              <li><a href="home_contact.html#mailing" >Mailing List</a></li>

              <li><a href="bugs.html" >Bug Reports</a></li>

            </ul>
          </li>
        </ul>
      </div>
    </div>
    <div class="contentwrapper">
      <div class="content">
                <div class="titlebox">Sample Queries</div>
<table id="samplesTbl" style="border:0;width:100%;height:78%;margin-bottom:20px;">
  <tr style="height: 5%;">
    <td>
      <a href="htmlsql/tpch/schemas.sql.html">SQL Schema:</a>
      <iframe src="htmlsql/tpch/schemas.sql.html" style="border:0;width:100%;height:100%;"></iframe>
    </td>
    <td>
      <a href="htmlsql/tpch/query11.sql.html">SQL Query:</a>
      <iframe src="htmlsql/tpch/query11.sql.html" style="border:0;width:100%;height:100%;"></iframe>
    </td>
  </tr>
  <tr style="height: 100%;">
    <td style="padding-top:2%;">
      <a href="htmlcode/Tpch11.hpp.html">C++ IVM Program:</a>
      <iframe src="htmlcode/Tpch11.hpp.html" style="border:0;width:100%;height:100%;"></iframe>
    </td>
    <td style="padding-top:2%;">
      <a href="htmlcode/Tpch11.scala.html">Scala IVM Program:</a>
      <iframe src="htmlcode/Tpch11.scala.html" style="border:0;width:100%;height:100%;"></iframe>
    </td>
  </tr>
</table>

<script type="text/javascript">
window.onload = function() {
  $( ".titlebox" ).append(": Tpch11").prepend("<div onclick=\"location.href='samples.html';\" style=\"margin-bottom:-40px;margin-top:0px;\" class=\"sbutton dark center\">Back</div> ")
  $( ".pagebody" ).css("margin-bottom","0")
  var footer = $( ".footer" ).detach();
  $( "#samplesTbl" ).detach().appendTo("#pageEndElem");
  footer.appendTo("#pageEndElem");
};
</script>

              </div><!-- /content -->
    </div><!-- /contentwrapper -->
  </div><!-- /pagebody -->
  <div class="footer">
  <hr/>
  <p>Copyright (c) 2009-2014, The DBToaster Consortium. All rights reserved.</p>
  </div>
</div><!-- /overallpage -->
<div id="pageEndElem" style="padding: 0 20px;"></div>
<script type="text/javascript" src="js/jquery-2.0.3.min.js"> </script>
<script type="text/javascript" src="js/bootstrap.min.js"> </script>

</body>
</html>