asterix-app/src/main/resources/sdk/static/example/demo.html - asterixdb - Gitiles

 <!DOCTYPE html>

 <html>
 <head>
     <title>AsterixDB TinySocial Demo</title>

     <style>
         .pretty-printed {
     background-color: #eeeeee;
     margin-bottom: 1em;
         }

         .how-to-run {
     background-color: #c8c8c8;
     margin-bottom: 1em;
         }

         .result-output {
     background-color: #BED8E5;
     margin-bottom: 1em;
         }

         body {
     font-family : "Helvetica";
     margin-bottom: 1em;
         }
     </style>

     <script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"></script>
     <script src="../js/asterix-sdk-stable.js"></script>
     <script src="js/demo.js"></script>
 </head>
 <body>
     <h1>AQL: Querying TinySocial AsterixDB</h1>

     <h2>Query 0-A - Exact-Match Lookup</h2>
     <div class="sample-query">

         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     where $user.id = 8
     return $user;
         </pre></div>

         <div class="how-to-run"><pre><code class="javascript">
     var expression0a = new FLWOGRExpression({
         "dataverse" : "TinySocial",
         "success"   : function(res) {
                           $('#result0a').html(res["results"]);
                       }
         })
         .bind( new ForClause("user", null, new AsterixExpression().set(["dataset FacebookUsers"])) )
         .bind( new WhereClause(new BooleanExpression("$user.id = 8")));
         </code></pre></div>

         <div class="result-output" id="result0a">
         </div>

         <button id="run0a">Run #0-A</button>
     </div>
     <hr/>
     <h2>Query 0-B - Range Scan</h2>
     <div class="sample-query">

         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     where $user.id >= 2 and $user.id <= 4
     return $user;
         </pre></div>

         <div class="how-to-run"><pre>
         </pre></div>

         <div class="result-output" id="result0b">
         </div>

         <button id="run0b">Run #0-B</button>
     </div>
     <hr/>

     <h2>Query 1 - Other Query Filters</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     where $user.user-since >= datetime('2010-07-22T00:00:00')
     and $user.user-since <= datetime('2012-07-29T23:59:59')
     return $user;
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result1">
         </div>

         <button id="run1">Run #1</button>
     </div>
     <hr/>

     <h2>Query 2-A - Equijoin</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     for $message in dataset FacebookMessages
     where $message.author-id = $user.id
     return {
         "uname": $user.name,
         "message": $message.message
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result2a">
         </div>

         <button id="run2a">Run #2-A</button>
     </div>
     <hr/>

     <h2>Query 2-B - Index join</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     for $message in dataset FacebookMessages
     where $message.author-id /*+ indexnl */  = $user.id
     return {
         "uname": $user.name,
         "message": $message.message
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result2b">
         </div>

         <button id="run2b">Run #2-B</button>
     </div>
     <hr/>

     <h2>Query 3 - Nested Outer Join</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $user in dataset FacebookUsers
     return {
         "uname": $user.name,
         "messages": for $message in dataset FacebookMessages
                     where $message.author-id = $user.id
                     return $message.message
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result3">
         </div>

         <button id="run3">Run #3</button>
     </div>
     <hr/>

     <h2>Query 4 - Theta Join</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $t in dataset TweetMessages
     return {
         "message": $t.message-text,
         "nearby-messages": for $t2 in dataset TweetMessages
                            where spatial-distance($t.sender-location, $t2.sender-location) <= 1
                            return { "msgtxt":$t2.message-text}
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result4">
         </div>

         <button id="run4">Run #4</button>
     </div>
     <hr/>

     <h2>Query 5 - Fuzzy Join</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     set simfunction "edit-distance";
     set simthreshold "3";

     for $fbu in dataset FacebookUsers
     return {
         "id": $fbu.id,
         "name": $fbu.name,
         "similar-users": for $t in dataset TweetMessages
                          let $tu := $t.user
                          where $tu.name ~= $fbu.name
                         return {
                             "twitter-screenname": $tu.screen-name,
                             "twitter-name": $tu.name
                         }
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result5">
         </div>

         <button id="run5">Run #5</button>
     </div>
     <hr/>

     <h2>Query 6 - Existential Quantification</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $fbu in dataset FacebookUsers
     where (some $e in $fbu.employment satisfies is-null($e.end-date))
     return $fbu;
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result6">
         </div>

         <button id="run6">Run #6</button>
     </div>
     <hr/>

     <h2>Query 7 - Universal Quantification</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre><pre>
     use dataverse TinySocial;

     for $fbu in dataset FacebookUsers
     where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
     return $fbu;
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result7">
         </div>

         <button id="run7">Run #7</button>
     </div>
     <hr/>

     <h2>Query 8 - Simple Aggregation</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     count(for $fbu in dataset FacebookUsers return $fbu);
         </pre></div>

         <div class="how-to-run"><pre><code class="javascript">
         var expression8 = new FunctionExpression(
             "count",
             new ForClause("fbu", null, new AQLClause().set("dataset FacebookUsers"))
                 .bind(new ReturnClause("$fbu"))
         );

         OR

         var expression8 = new FunctionExpression()
             .fn("count")
             .expression(
                 new ForClause("fbu", null, new AQLClause().set("dataset FacebookUsers"))
                     .bind(new ReturnClause("$fbu"))
             );
         </code></pre></div>

         <div class="result-output" id="result8">
         </div>

         <button id="run8">Run #8</button>
     </div>
     <hr/>

     <h2>Query 9-A - Grouping and Aggregation</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $t in dataset TweetMessages
     group by $uid := $t.user.screen-name with $t
     return {
         "user": $uid,
         "count": count($t)
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result9a">
         </div>

         <button id="run9a">Run #9-A</button>
     </div>
     <hr/>

     <h2>Query 9-B - (Hash-Based) Grouping and Aggregation</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $t in dataset TweetMessages
     /*+ hash*/
     group by $uid := $t.user.screen-name with $t
     return {
         "user": $uid,
         "count": count($t)
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result9b">
         </div>

         <button id="run9b">Run #9-B</button>
     </div>
     <hr/>

     <h2>Query 10 - Grouping and Limits</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     for $t in dataset TweetMessages
     group by $uid := $t.user.screen-name with $t
     let $c := count($t)
     order by $c desc
     limit 3
     return {
         "user": $uid,
         "count": $c
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result10">
         </div>

         <button id="run10">Run #10</button>
     </div>
     <hr/>

     <h2>Query 11 - Left Outer Fuzzy Join</h2>
     <div class="sample-query">
         <div class="pretty-printed"><pre>
     use dataverse TinySocial;

     set simfunction "jaccard";
     set simthreshold "0.3";

     for $t in dataset TweetMessages
     return {
         "tweet": $t,
         "similar-tweets": for $t2 in dataset TweetMessages
         where  $t2.referred-topics ~= $t.referred-topics
         and $t2.tweetid != $t.tweetid
         return $t2.referred-topics
     };
         </pre></div>

         <div class="how-to-run">
         </div>

         <div class="result-output" id="result11">
         </div>

         <button id="run11">Run #11</button>
     </div>

 </body>
 </html>
	<!DOCTYPE html>

	<html>
	<head>
	<title>AsterixDB TinySocial Demo</title>

	<style>
	.pretty-printed {
	background-color: #eeeeee;
	margin-bottom: 1em;
	}

	.how-to-run {
	background-color: #c8c8c8;
	margin-bottom: 1em;
	}

	.result-output {
	background-color: #BED8E5;
	margin-bottom: 1em;
	}

	body {
	font-family : "Helvetica";
	margin-bottom: 1em;
	}
	</style>

	<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.0/jquery.min.js"></script>
	<script src="../js/asterix-sdk-stable.js"></script>
	<script src="js/demo.js"></script>
	</head>
	<body>
	<h1>AQL: Querying TinySocial AsterixDB</h1>

	<h2>Query 0-A - Exact-Match Lookup</h2>
	<div class="sample-query">

	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	where $user.id = 8
	return $user;
	</pre></div>

	<div class="how-to-run"><pre><code class="javascript">
	var expression0a = new FLWOGRExpression({
	"dataverse" : "TinySocial",
	"success" : function(res) {
	$('#result0a').html(res["results"]);
	}
	})
	.bind( new ForClause("user", null, new AsterixExpression().set(["dataset FacebookUsers"])) )
	.bind( new WhereClause(new BooleanExpression("$user.id = 8")));
	</code></pre></div>

	<div class="result-output" id="result0a">
	</div>

	<button id="run0a">Run #0-A</button>
	</div>
	<hr/>
	<h2>Query 0-B - Range Scan</h2>
	<div class="sample-query">

	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	where $user.id >= 2 and $user.id <= 4
	return $user;
	</pre></div>

	<div class="how-to-run"><pre>
	</pre></div>

	<div class="result-output" id="result0b">
	</div>

	<button id="run0b">Run #0-B</button>
	</div>
	<hr/>

	<h2>Query 1 - Other Query Filters</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	where $user.user-since >= datetime('2010-07-22T00:00:00')
	and $user.user-since <= datetime('2012-07-29T23:59:59')
	return $user;
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result1">
	</div>

	<button id="run1">Run #1</button>
	</div>
	<hr/>

	<h2>Query 2-A - Equijoin</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	for $message in dataset FacebookMessages
	where $message.author-id = $user.id
	return {
	"uname": $user.name,
	"message": $message.message
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result2a">
	</div>

	<button id="run2a">Run #2-A</button>
	</div>
	<hr/>

	<h2>Query 2-B - Index join</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	for $message in dataset FacebookMessages
	where $message.author-id /+ indexnl / = $user.id
	return {
	"uname": $user.name,
	"message": $message.message
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result2b">
	</div>

	<button id="run2b">Run #2-B</button>
	</div>
	<hr/>

	<h2>Query 3 - Nested Outer Join</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $user in dataset FacebookUsers
	return {
	"uname": $user.name,
	"messages": for $message in dataset FacebookMessages
	where $message.author-id = $user.id
	return $message.message
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result3">
	</div>

	<button id="run3">Run #3</button>
	</div>
	<hr/>

	<h2>Query 4 - Theta Join</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $t in dataset TweetMessages
	return {
	"message": $t.message-text,
	"nearby-messages": for $t2 in dataset TweetMessages
	where spatial-distance($t.sender-location, $t2.sender-location) <= 1
	return { "msgtxt":$t2.message-text}
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result4">
	</div>

	<button id="run4">Run #4</button>
	</div>
	<hr/>

	<h2>Query 5 - Fuzzy Join</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	set simfunction "edit-distance";
	set simthreshold "3";

	for $fbu in dataset FacebookUsers
	return {
	"id": $fbu.id,
	"name": $fbu.name,
	"similar-users": for $t in dataset TweetMessages
	let $tu := $t.user
	where $tu.name ~= $fbu.name
	return {
	"twitter-screenname": $tu.screen-name,
	"twitter-name": $tu.name
	}
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result5">
	</div>

	<button id="run5">Run #5</button>
	</div>
	<hr/>

	<h2>Query 6 - Existential Quantification</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $fbu in dataset FacebookUsers
	where (some $e in $fbu.employment satisfies is-null($e.end-date))
	return $fbu;
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result6">
	</div>

	<button id="run6">Run #6</button>
	</div>
	<hr/>

	<h2>Query 7 - Universal Quantification</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre><pre>
	use dataverse TinySocial;

	for $fbu in dataset FacebookUsers
	where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))
	return $fbu;
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result7">
	</div>

	<button id="run7">Run #7</button>
	</div>
	<hr/>

	<h2>Query 8 - Simple Aggregation</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	count(for $fbu in dataset FacebookUsers return $fbu);
	</pre></div>

	<div class="how-to-run"><pre><code class="javascript">
	var expression8 = new FunctionExpression(
	"count",
	new ForClause("fbu", null, new AQLClause().set("dataset FacebookUsers"))
	.bind(new ReturnClause("$fbu"))
	);

	OR

	var expression8 = new FunctionExpression()
	.fn("count")
	.expression(
	new ForClause("fbu", null, new AQLClause().set("dataset FacebookUsers"))
	.bind(new ReturnClause("$fbu"))
	);
	</code></pre></div>

	<div class="result-output" id="result8">
	</div>

	<button id="run8">Run #8</button>
	</div>
	<hr/>

	<h2>Query 9-A - Grouping and Aggregation</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $t in dataset TweetMessages
	group by $uid := $t.user.screen-name with $t
	return {
	"user": $uid,
	"count": count($t)
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result9a">
	</div>

	<button id="run9a">Run #9-A</button>
	</div>
	<hr/>

	<h2>Query 9-B - (Hash-Based) Grouping and Aggregation</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $t in dataset TweetMessages
	/+ hash/
	group by $uid := $t.user.screen-name with $t
	return {
	"user": $uid,
	"count": count($t)
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result9b">
	</div>

	<button id="run9b">Run #9-B</button>
	</div>
	<hr/>

	<h2>Query 10 - Grouping and Limits</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	for $t in dataset TweetMessages
	group by $uid := $t.user.screen-name with $t
	let $c := count($t)
	order by $c desc
	limit 3
	return {
	"user": $uid,
	"count": $c
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result10">
	</div>

	<button id="run10">Run #10</button>
	</div>
	<hr/>

	<h2>Query 11 - Left Outer Fuzzy Join</h2>
	<div class="sample-query">
	<div class="pretty-printed"><pre>
	use dataverse TinySocial;

	set simfunction "jaccard";
	set simthreshold "0.3";

	for $t in dataset TweetMessages
	return {
	"tweet": $t,
	"similar-tweets": for $t2 in dataset TweetMessages
	where $t2.referred-topics ~= $t.referred-topics
	and $t2.tweetid != $t.tweetid
	return $t2.referred-topics
	};
	</pre></div>

	<div class="how-to-run">
	</div>

	<div class="result-output" id="result11">
	</div>

	<button id="run11">Run #11</button>
	</div>

	</body>
	</html>