Blame - content/docs/0.8.7-incubating/aql/js-sdk.html - incubator-asterixdb-site

<p><a class="externalLink" href="http://asterixdb.ics.uci.edu/download/bindings/asterix-sdk-stable.js">Download</a> the javascript SDK and include it like any other javascript library by adding the following line in the appropriate HTML file:</p>

217

218

219

220

221

</pre></div></div></div>

222

223

<h2><a name="Interactive_Demos"></a>Interactive Demos</h2>

224

<p>There are two interactive demos that are available for download. Both of the demos illustrate how the javascript API would be used in an application:</p>

<ul>

<li><a class="externalLink" href="http://asterixdb.ics.uci.edu/download/demos/tweetbook-demo.zip">Tweetbook Demo</a>: a contrived geo-spatial application dealing with artificial Tweets allowing spatial, temporal, and keyword-based filtering.</li>

229

230

<li><a class="externalLink" href="http://asterixdb.ics.uci.edu/download/demos/admaql101-demo.zip">ADM/AQL 101 Demo</a>: an interactive version of all of the examples that are provided in the following section.</li>

231

</ul></div>

232

233

<h2><a name="The_javascript_SDK:_by_example"></a>The javascript SDK: by example</h2>

234

<p>In this section, we explore how to form AQL queries using the javascript SDK. The queries from <a href="primer.html">AsterixDB 101: An ADM and AQL Primer</a> are used as examples here. For each AQL statement, the equivalent javascript expression is shown below it, followed by the results of executing the query.</p>

235

236

<h3><a name="Query_0-A_-_Exact-Match_Lookup"></a>Query 0-A - Exact-Match Lookup</h3>

<pre>use dataverse TinySocial;

245

246

for $user in dataset FacebookUsers

247

where $user.id = 8

248

return $user;

249

</pre></div></div></div>

<pre>var expression0a = new FLWOGRExpression()

256

.ForClause("$user", new AExpression("dataset FacebookUsers"))

257

.WhereClause(new AExpression("$user.id = 8"))

258

.ReturnClause("$user");

259

</pre></div></div></div>

260

261

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 8 } , "alias": "Nila", "name": "NilaMilliron", "user-since": { datetime: 1199182200000}, "friend-ids": { unorderedlist: [{ int32: 3 } ]}, "employment": { orderedlist: [{ "organization-name": "Plexlane", "start-date": { date: 1267315200000}, "end-date": null } ]} }

266

</pre></div></div></div></div></div></div>

267

268

<h3><a name="Query_0-B_-_Range_Scan"></a>Query 0-B - Range Scan</h3>

<pre>use dataverse TinySocial;

277

278

for $user in dataset FacebookUsers

279

where $user.id >= 2 and $user.id <= 4

280

return $user;

281

</pre></div></div></div>

<pre>var expression0b = new FLWOGRExpression()

288

.ForClause("$user", new AExpression("dataset FacebookUsers"))

289

.WhereClause().and(new AExpression("$user.id >= 2"), new AExpression("$user.id <= 4"))

290

.ReturnClause("$user");

291

</pre></div></div></div>

292

293

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 2 } , "alias": "Isbel", "name": "IsbelDull", "user-since": { datetime: 1295691000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 4 } ]}, "employment": { orderedlist: [{ "organization-name": "Hexviafind", "start-date": { date: 1272326400000}, "end-date": null } ]} }

298

{ "id": { int32: 3 } , "alias": "Emory", "name": "EmoryUnk", "user-since": { datetime: 1341915000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 5 } , { int32: 8 } , { int32: 9 } ]}, "employment": { orderedlist: [{ "organization-name": "geomedia", "start-date": { date: 1276732800000}, "end-date": { date: 1264464000000} } ]} }

299

{ "id": { int32: 4 } , "alias": "Nicholas", "name": "NicholasStroh", "user-since": { datetime: 1293444600000}, "friend-ids": { unorderedlist: [{ int32: 2 } ]}, "employment": { orderedlist: [{ "organization-name": "Zamcorporation", "start-date": { date: 1275955200000}, "end-date": null } ]} }

300

</pre></div></div></div></div></div></div>

301

302

<h3><a name="Query_1_-_Other_Query_Filters"></a>Query 1 - Other Query Filters</h3>

<pre>use dataverse TinySocial;

311

312

for $user in dataset FacebookUsers

313

where $user.user-since >= datetime('2010-07-22T00:00:00')

314

and $user.user-since <= datetime('2012-07-29T23:59:59')

315

return $user;

316

</pre></div></div></div>

<pre>var expression1 = new FLWOGRExpression()

323

.ForClause("$user", new AExpression("dataset FacebookUsers"))

324

.WhereClause().and(

325

new AExpression("$user.user-since >= datetime('2010-07-22T00:00:00')"),

326

new AExpression("$user.user-since <= datetime('2012-07-29T23:59:59')")

327

).ReturnClause("$user");

328

</pre></div></div></div>

329

330

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 2 } , "alias": "Isbel", "name": "IsbelDull", "user-since": { datetime: 1295691000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 4 } ]}, "employment": { orderedlist: [{ "organization-name": "Hexviafind", "start-date": { date: 1272326400000}, "end-date": null } ]} }

335

{ "id": { int32: 10 } , "alias": "Bram", "name": "BramHatch", "user-since": { datetime: 1287223800000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 5 } , { int32: 9 } ]}, "employment": { orderedlist: [{ "organization-name": "physcane", "start-date": { date: 1181001600000}, "end-date": { date: 1320451200000} } ]} }

336

{ "id": { int32: 3 } , "alias": "Emory", "name": "EmoryUnk", "user-since": { datetime: 1341915000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 5 } , { int32: 8 } , { int32: 9 } ]}, "employment": { orderedlist: [{ "organization-name": "geomedia", "start-date": { date: 1276732800000}, "end-date": { date: 1264464000000} } ]} }

337

{ "id": { int32: 4 } , "alias": "Nicholas", "name": "NicholasStroh", "user-since": { datetime: 1293444600000}, "friend-ids": { unorderedlist: [{ int32: 2 } ]}, "employment": { orderedlist: [{ "organization-name": "Zamcorporation", "start-date": { date: 1275955200000}, "end-date": null } ]} }

338

</pre></div></div></div></div></div></div>

339

340

<h3><a name="Query_2-A_-_Equijoin"></a>Query 2-A - Equijoin</h3>

<pre>use dataverse TinySocial;

349

350

for $user in dataset FacebookUsers

351

for $message in dataset FacebookMessages

352

where $message.author-id = $user.id

353

return {

354

"uname": $user.name,

355

"message": $message.message

356

};

357

</pre></div></div></div>

<pre>var expression2a = new FLWOGRExpression()

364

.ForClause ("$user", new AExpression("dataset FacebookUsers"))

365

.ForClause ("$message", new AExpression("dataset FacebookMessages"))

366

.WhereClause(new AExpression("$message.author-id = $user.id"))

367

.ReturnClause({

368

"uname" : "$user.name",

369

"message" : "$message.message"

370

});

371

</pre></div></div></div>

372

373

<h6><a name="Results"></a>Results</h6>

<pre>{ "uname": "MargaritaStoddard", "message": " dislike iphone its touch-screen is horrible" }

378

{ "uname": "MargaritaStoddard", "message": " like verizon the 3G is awesome:)" }

379

{ "uname": "MargaritaStoddard", "message": " can't stand motorola the touch-screen is terrible" }

380

{ "uname": "MargaritaStoddard", "message": " can't stand at&t the network is horrible:(" }

381

{ "uname": "MargaritaStoddard", "message": " can't stand at&t its plan is terrible" }

382

{ "uname": "IsbelDull", "message": " like samsung the plan is amazing" }

383

{ "uname": "IsbelDull", "message": " like t-mobile its platform is mind-blowing" }

384

{ "uname": "WoodrowNehling", "message": " love at&t its 3G is good:)" }

385

{ "uname": "BramHatch", "message": " dislike iphone the voice-command is bad:(" }

386

{ "uname": "BramHatch", "message": " can't stand t-mobile its voicemail-service is OMG:(" }

387

{ "uname": "EmoryUnk", "message": " love sprint its shortcut-menu is awesome:)" }

388

{ "uname": "EmoryUnk", "message": " love verizon its wireless is good" }

389

{ "uname": "WillisWynne", "message": " love sprint the customization is mind-blowing" }

390

{ "uname": "SuzannaTillson", "message": " like iphone the voicemail-service is awesome" }

391

{ "uname": "VonKemble", "message": " dislike sprint the speed is horrible" }

392

</pre></div></div></div></div></div></div>

393

394

<h3><a name="Query_2-B_-_Index_join"></a>Query 2-B - Index join</h3>

<pre>use dataverse TinySocial;

403

404

for $user in dataset FacebookUsers

405

for $message in dataset FacebookMessages

406

where $message.author-id /*+ indexnl */ = $user.id

407

return {

408

"uname": $user.name,

409

"message": $message.message

410

};

411

</pre></div></div></div>

<pre>var expression2b = new FLWOGRExpression()

418

.ForClause ("$user", new AExpression("dataset FacebookUsers"))

419

.ForClause ("$message", new AExpression("dataset FacebookMessages"))

420

.WhereClause(new AExpression("$message.author-id /*+ indexnl */ = $user.id"))

421

.ReturnClause({

422

"uname" : "$user.name",

423

"message" : "$message.message"

424

});

425

</pre></div></div></div>

426

427

<h6><a name="Results"></a>Results</h6>

<pre>{ "uname": "MargaritaStoddard", "message": " dislike iphone its touch-screen is horrible" }

432

{ "uname": "MargaritaStoddard", "message": " like verizon the 3G is awesome:)" }

433

{ "uname": "MargaritaStoddard", "message": " can't stand motorola the touch-screen is terrible" }

434

{ "uname": "MargaritaStoddard", "message": " can't stand at&t the network is horrible:(" }

435

{ "uname": "MargaritaStoddard", "message": " can't stand at&t its plan is terrible" }

436

{ "uname": "IsbelDull", "message": " like samsung the plan is amazing" }

437

{ "uname": "IsbelDull", "message": " like t-mobile its platform is mind-blowing" }

438

{ "uname": "WoodrowNehling", "message": " love at&t its 3G is good:)" }

439

{ "uname": "BramHatch", "message": " dislike iphone the voice-command is bad:(" }

440

{ "uname": "BramHatch", "message": " can't stand t-mobile its voicemail-service is OMG:(" }

441

{ "uname": "EmoryUnk", "message": " love sprint its shortcut-menu is awesome:)" }

442

{ "uname": "EmoryUnk", "message": " love verizon its wireless is good" }

443

{ "uname": "WillisWynne", "message": " love sprint the customization is mind-blowing" }

444

{ "uname": "SuzannaTillson", "message": " like iphone the voicemail-service is awesome" }

445

{ "uname": "VonKemble", "message": " dislike sprint the speed is horrible" }

446

</pre></div></div></div></div></div></div>

447

448

<h3><a name="Query_3_-_Nested_Outer_Join"></a>Query 3 - Nested Outer Join</h3>

<pre>use dataverse TinySocial;

457

458

for $user in dataset FacebookUsers

459

return {

460

"uname": $user.name,

461

"messages": for $message in dataset FacebookMessages

462

where $message.author-id = $user.id

463

return $message.message

464

};

465

</pre></div></div></div>

<pre>var expression3messages = new FLWOGRExpression()

472

.ForClause("$message", new AExpression("dataset FacebookMessages"))

473

.WhereClause(new AExpression("$message.author-id = $user.id"))

474

.ReturnClause("$message.message");

475

476

var expression3 = new FLWOGRExpression()

477

.ForClause ("$user", new AExpression("dataset FacebookUsers"))

478

.ReturnClause({

479

"uname": "$user.name",

480

"messages" : expression3messages

481

});

482

</pre></div></div></div>

483

484

<h6><a name="Results"></a>Results</h6>

<pre>{ "uname": "MargaritaStoddard", "messages": { orderedlist: [" dislike iphone its touch-screen is horrible", " like verizon the 3G is awesome:)", " can't stand motorola the touch-screen is terrible", " can't stand at&t the network is horrible:(", " can't stand at&t its plan is terrible" ]} }

489

{ "uname": "IsbelDull", "messages": { orderedlist: [" like samsung the plan is amazing", " like t-mobile its platform is mind-blowing" ]} }

490

{ "uname": "NilaMilliron", "messages": { orderedlist: [ ]} }

491

{ "uname": "WoodrowNehling", "messages": { orderedlist: [" love at&t its 3G is good:)" ]} }

492

{ "uname": "BramHatch", "messages": { orderedlist: [" dislike iphone the voice-command is bad:(", " can't stand t-mobile its voicemail-service is OMG:(" ]} }

493

{ "uname": "EmoryUnk", "messages": { orderedlist: [" love sprint its shortcut-menu is awesome:)", " love verizon its wireless is good" ]} }

494

{ "uname": "WillisWynne", "messages": { orderedlist: [" love sprint the customization is mind-blowing" ]} }

495

{ "uname": "SuzannaTillson", "messages": { orderedlist: [" like iphone the voicemail-service is awesome" ]} }

496

{ "uname": "NicholasStroh", "messages": { orderedlist: [ ]} }

497

{ "uname": "VonKemble", "messages": { orderedlist: [" dislike sprint the speed is horrible" ]} }

498

</pre></div></div></div></div></div></div>

499

500

<h3><a name="Query_4_-_Theta_Join"></a>Query 4 - Theta Join</h3>

<pre>use dataverse TinySocial;

509

510

for $t in dataset TweetMessages

511

return {

512

"message": $t.message-text,

513

"nearby-messages": for $t2 in dataset TweetMessages

514

where spatial-distance($t.sender-location, $t2.sender-location) <= 1

515

return { "msgtxt":$t2.message-text}

516

};

517

</pre></div></div></div>

<pre>var expression4messages = new FLWOGRExpression()

524

.ForClause( "$t2", new AExpression("dataset TweetMessages"))

525

.WhereClause( new AExpression("spatial-distance($t.sender-location, $t2.sender-location) <= 1"))

526

.ReturnClause({ "msgtxt" : "$t2.message-text" });

527

528

var expression4 = new FLWOGRExpression()

529

.ForClause( "$t", new AExpression("dataset TweetMessages"))

530

.ReturnClause({

531

"message" : "$t.message-text",

532

"nearby-messages" : expression4messages

533

});

534

</pre></div></div></div>

535

536

<h6><a name="Results"></a>Results</h6>

<pre>{ "message": " hate verizon its voice-clarity is OMG:(", "nearby-messages": { orderedlist: [{ "msgtxt": " hate verizon its voice-clarity is OMG:(" }, { "msgtxt": " like motorola the speed is good:)" } ]} }

541

{ "message": " like iphone the voice-clarity is good:)", "nearby-messages": { orderedlist: [{ "msgtxt": " like iphone the voice-clarity is good:)" } ]} }

542

{ "message": " like samsung the platform is good", "nearby-messages": { orderedlist: [{ "msgtxt": " like samsung the platform is good" } ]} }

543

{ "message": " love t-mobile its customization is good:)", "nearby-messages": { orderedlist: [{ "msgtxt": " love t-mobile its customization is good:)" } ]} }

544

{ "message": " like samsung the voice-command is amazing:)", "nearby-messages": { orderedlist: [{ "msgtxt": " like samsung the voice-command is amazing:)" } ]} }

545

{ "message": " like motorola the speed is good:)", "nearby-messages": { orderedlist: [{ "msgtxt": " hate verizon its voice-clarity is OMG:(" }, { "msgtxt": " like motorola the speed is good:)" } ]} }

546

{ "message": " love verizon its voicemail-service is awesome", "nearby-messages": { orderedlist: [{ "msgtxt": " love verizon its voicemail-service is awesome" } ]} }

547

{ "message": " can't stand motorola its speed is terrible:(", "nearby-messages": { orderedlist: [{ "msgtxt": " can't stand motorola its speed is terrible:(" } ]} }

548

{ "message": " like t-mobile the shortcut-menu is awesome:)", "nearby-messages": { orderedlist: [{ "msgtxt": " like t-mobile the shortcut-menu is awesome:)" } ]} }

549

{ "message": " can't stand iphone its platform is terrible", "nearby-messages": { orderedlist: [{ "msgtxt": " can't stand iphone its platform is terrible" } ]} }

550

{ "message": " like verizon its shortcut-menu is awesome:)", "nearby-messages": { orderedlist: [{ "msgtxt": " like verizon its shortcut-menu is awesome:)" } ]} }

551

{ "message": " like sprint the voice-command is mind-blowing:)", "nearby-messages": { orderedlist: [{ "msgtxt": " like sprint the voice-command is mind-blowing:)" } ]} }

552

</pre></div></div></div></div></div></div>

553

554

<h3><a name="Query_5_-_Fuzzy_Join"></a>Query 5 - Fuzzy Join</h3>

<p>use dataverse TinySocial;</p>

<pre>set simfunction "edit-distance";

564

set simthreshold "3";

565

566

for $fbu in dataset FacebookUsers

return {

"id": $fbu.id,

"name": $fbu.name,

"similar-users": for $t in dataset TweetMessages

571

let $tu := $t.user

572

where $tu.name ~= $fbu.name

573

return {

574

"twitter-screenname": $tu.screen-name,

575

"twitter-name": $tu.name

576

}

577

};

578

</pre></div></div></div>

<pre>var similarUsersExpression = new FLWOGRExpression()

585

.ForClause("$t", new AExpression("dataset TweetMessages"))

586

.LetClause ("$tu", new AExpression("$t.user"))

587

.WhereClause(new AExpression("$tu.name ~= $fbu.name"))

588

.ReturnClause({

589

"twitter-screenname": "$tu.screen-name",

590

"twitter-name": "$tu.name"

591

});

592

593

var expression5 = new FLWOGRExpression()

594

.ForClause ("$fbu", new AExpression("dataset FacebookUsers"))

.ReturnClause(

{

"id" : "$fbu.id",

"name" : "$fbu.name",

599

"similar-users" : similarUsersExpression

600

}

601

);

602

</pre></div></div></div>

603

604

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 1 } , "name": "MargaritaStoddard", "similar-users": { orderedlist: [ ]} }

609

{ "id": { int32: 2 } , "name": "IsbelDull", "similar-users": { orderedlist: [ ]} }

610

{ "id": { int32: 8 } , "name": "NilaMilliron", "similar-users": { orderedlist: [{ "twitter-screenname": "NilaMilliron_tw", "twitter-name": "Nila Milliron" } ]} }

611

{ "id": { int32: 9 } , "name": "WoodrowNehling", "similar-users": { orderedlist: [ ]} }

612

{ "id": { int32: 10 } , "name": "BramHatch", "similar-users": { orderedlist: [ ]} }

613

{ "id": { int32: 3 } , "name": "EmoryUnk", "similar-users": { orderedlist: [ ]} }

614

{ "id": { int32: 6 } , "name": "WillisWynne", "similar-users": { orderedlist: [ ]} }

615

{ "id": { int32: 7 } , "name": "SuzannaTillson", "similar-users": { orderedlist: [ ]} }

616

{ "id": { int32: 4 } , "name": "NicholasStroh", "similar-users": { orderedlist: [ ]} }

617

{ "id": { int32: 5 } , "name": "VonKemble", "similar-users": { orderedlist: [ ]} }

618

</pre></div></div></div></div></div></div>

619

620

<h3><a name="Query_6_-_Existential_Quantification"></a>Query 6 - Existential Quantification</h3>

<pre>use dataverse TinySocial;

629

630

for $fbu in dataset FacebookUsers

631

where (some $e in $fbu.employment satisfies is-null($e.end-date))

632

return $fbu;

633

</pre></div></div></div>

<pre>var expression6 = new FLWOGRExpression()

640

.ForClause ("$fbu", new AQLClause().set("dataset FacebookUsers"))

641

.WhereClause(

642

new QuantifiedExpression (

643

"some" ,

644

{"$e" : new AExpression("$fbu.employment") },

645

new FunctionExpression("is-null", new AExpression("$e.end-date"))

646

)

647

)

648

.ReturnClause("$fbu");

649

</pre></div></div></div>

650

651

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 1 } , "alias": "Margarita", "name": "MargaritaStoddard", "user-since": { datetime: 1345457400000}, "friend-ids": { unorderedlist: [{ int32: 2 } , { int32: 3 } , { int32: 6 } , { int32: 10 } ]}, "employment": { orderedlist: [{ "organization-name": "Codetechno", "start-date": { date: 1154822400000}, "end-date": null } ]} }

656

{ "id": { int32: 2 } , "alias": "Isbel", "name": "IsbelDull", "user-since": { datetime: 1295691000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 4 } ]}, "employment": { orderedlist: [{ "organization-name": "Hexviafind", "start-date": { date: 1272326400000}, "end-date": null } ]} }

657

{ "id": { int32: 8 } , "alias": "Nila", "name": "NilaMilliron", "user-since": { datetime: 1199182200000}, "friend-ids": { unorderedlist: [{ int32: 3 } ]}, "employment": { orderedlist: [{ "organization-name": "Plexlane", "start-date": { date: 1267315200000}, "end-date": null } ]} }

658

{ "id": { int32: 6 } , "alias": "Willis", "name": "WillisWynne", "user-since": { datetime: 1105956600000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 3 } , { int32: 7 } ]}, "employment": { orderedlist: [{ "organization-name": "jaydax", "start-date": { date: 1242345600000}, "end-date": null } ]} }

659

{ "id": { int32: 7 } , "alias": "Suzanna", "name": "SuzannaTillson", "user-since": { datetime: 1344334200000}, "friend-ids": { unorderedlist: [{ int32: 6 } ]}, "employment": { orderedlist: [{ "organization-name": "Labzatron", "start-date": { date: 1303171200000}, "end-date": null } ]} }

660

{ "id": { int32: 4 } , "alias": "Nicholas", "name": "NicholasStroh", "user-since": { datetime: 1293444600000}, "friend-ids": { unorderedlist: [{ int32: 2 } ]}, "employment": { orderedlist: [{ "organization-name": "Zamcorporation", "start-date": { date: 1275955200000}, "end-date": null } ]} }

661

{ "id": { int32: 5 } , "alias": "Von", "name": "VonKemble", "user-since": { datetime: 1262686200000}, "friend-ids": { unorderedlist: [{ int32: 3 } , { int32: 6 } , { int32: 10 } ]}, "employment": { orderedlist: [{ "organization-name": "Kongreen", "start-date": { date: 1290816000000}, "end-date": null } ]} }

662

</pre></div></div></div></div></div></div>

663

664

<h3><a name="Query_7_-_Universal_Quantification"></a>Query 7 - Universal Quantification</h3>

<pre>use dataverse TinySocial;

673

674

for $fbu in dataset FacebookUsers

675

where (every $e in $fbu.employment satisfies not(is-null($e.end-date)))

676

return $fbu;

677

</pre></div></div></div>

<pre>var expression7 = new FLWOGRExpression()

684

.ForClause("$fbu", new AExpression("dataset FacebookUsers"))

685

.WhereClause(

686

new QuantifiedExpression (

687

"every" ,

688

{"$e" : new AExpression("$fbu.employment") },

689

new FunctionExpression("not", new FunctionExpression("is-null", new AExpression("$e.end-date")))

690

)

691

)

692

.ReturnClause("$fbu");

693

</pre></div></div></div>

694

695

<h6><a name="Results"></a>Results</h6>

<pre>{ "id": { int32: 9 } , "alias": "Woodrow", "name": "WoodrowNehling", "user-since": { datetime: 1127211000000}, "friend-ids": { unorderedlist: [{ int32: 3 } , { int32: 10 } ]}, "employment": { orderedlist: [{ "organization-name": "Zuncan", "start-date": { date: 1050969600000}, "end-date": { date: 1260662400000} } ]} }

700

{ "id": { int32: 10 } , "alias": "Bram", "name": "BramHatch", "user-since": { datetime: 1287223800000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 5 } , { int32: 9 } ]}, "employment": { orderedlist: [{ "organization-name": "physcane", "start-date": { date: 1181001600000}, "end-date": { date: 1320451200000} } ]} }

701

{ "id": { int32: 3 } , "alias": "Emory", "name": "EmoryUnk", "user-since": { datetime: 1341915000000}, "friend-ids": { unorderedlist: [{ int32: 1 } , { int32: 5 } , { int32: 8 } , { int32: 9 } ]}, "employment": { orderedlist: [{ "organization-name": "geomedia", "start-date": { date: 1276732800000}, "end-date": { date: 1264464000000} } ]} }

702

</pre></div></div></div></div></div></div>

703

704

<h3><a name="Query_8_-_Simple_Aggregation"></a>Query 8 - Simple Aggregation</h3>

<pre>use dataverse TinySocial;

713

714

count(for $fbu in dataset FacebookUsers return $fbu);

715

</pre></div></div></div>

<pre>var expression8 = new FunctionExpression(

722

"count",

723

new FLWOGRExpression()

724

.ForClause("$fbu", new AExpression("dataset FacebookUsers"))

725

.ReturnClause("$fbu")

726

);

727

</pre></div></div></div>

728

729

<h6><a name="Results"></a>Results</h6>

<pre>{ int64: 10 }

</pre></div></div></div></div></div></div>

735

736

<h3><a name="Query_9-A_-_Grouping_and_Aggregation"></a>Query 9-A - Grouping and Aggregation</h3>

<pre>use dataverse TinySocial;

745

746

for $t in dataset TweetMessages

747

group by $uid := $t.user.screen-name with $t

return {

"user": $uid,

"count": count($t)

};

</pre></div></div></div>

<pre>var expression9a = new FLWOGRExpression()

759

.ForClause("$t", new AExpression("dataset TweetMessages"))

760

.GroupClause("$uid", new AExpression("$t.user.screen-name"), "with", "$t")

.ReturnClause(

{

"user" : "$uid",

"count" : new FunctionExpression("count", new AExpression("$t"))

765

}

766

);

767

</pre></div></div></div>

768

769

<h6><a name="Results"></a>Results</h6>

<pre>{ "user": "ColineGeyer@63", "count": { int64: 3 } }

774

{ "user": "OliJackson_512", "count": { int64: 1 } }

775

{ "user": "NilaMilliron_tw", "count": { int64: 1 } }

776

{ "user": "ChangEwing_573", "count": { int64: 1 } }

777

{ "user": "NathanGiesen@211", "count": { int64: 6 } }

778

</pre></div></div></div></div></div></div>

779

780

<h3><a name="Query_9-B_-_Hash-Based_Grouping_and_Aggregation"></a>Query 9-B - (Hash-Based) Grouping and Aggregation</h3>

<pre>use dataverse TinySocial;

789

790

for $t in dataset TweetMessages

791

/*+ hash*/

792

group by $uid := $t.user.screen-name with $t

return {

"user": $uid,

"count": count($t)

};

</pre></div></div></div>

<pre>var expression9b = new FLWOGRExpression()

804

.ForClause("$t", new AExpression("dataset TweetMessages"))

805

.AQLClause("/*+ hash*/")

806

.GroupClause("$uid", new AExpression("$t.user.screen-name"), "with", "$t")

.ReturnClause(

{

"user" : "$uid",

"count" : new FunctionExpression("count", new AExpression("$t"))

811

}

812

);

813

</pre></div></div></div>

814

815

<h6><a name="Results"></a>Results</h6>

<pre>{ "user": "ColineGeyer@63", "count": { int64: 3 } }

820

{ "user": "OliJackson_512", "count": { int64: 1 } }

821

{ "user": "NilaMilliron_tw", "count": { int64: 1 } }

822

{ "user": "ChangEwing_573", "count": { int64: 1 } }

823

{ "user": "NathanGiesen@211", "count": { int64: 6 } }

824

</pre></div></div></div></div></div></div>

825

826

<h3><a name="Query_10_-_Grouping_and_Limits"></a>Query 10 - Grouping and Limits</h3>

<pre>use dataverse TinySocial;

835

836

for $t in dataset TweetMessages

837

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></div>

<pre>var expression10 = new FLWOGRExpression()

852

.ForClause("$t", new AExpression("dataset TweetMessages"))

853

.GroupClause("$uid", new AExpression("$t.user.screen-name"), "with", "$t")

854

.LetClause("$c", new FunctionExpression("count", new AExpression("$t")))

855

.OrderbyClause( new AExpression("$c"), "desc" )

856

.LimitClause(new AExpression("3"))

.ReturnClause(

{

"user" : "$uid",

"count" : "$c"

}

);

</pre></div></div></div>

864

865

<h6><a name="Results"></a>Results</h6>

<pre>{ "user": "NathanGiesen@211", "count": { int64: 6 } }

870

{ "user": "ColineGeyer@63", "count": { int64: 3 } }

871

{ "user": "NilaMilliron_tw", "count": { int64: 1 } }

872

</pre></div></div></div></div></div></div>

873

874

<h3><a name="Query_11_-_Left_Outer_Fuzzy_Join"></a>Query 11 - Left Outer Fuzzy Join</h3>

<pre>use dataverse TinySocial;

883

884

set simfunction "jaccard";

885

set simthreshold "0.3";

886

887

for $t in dataset TweetMessages

888

return {

889

"tweet": $t,

890

"similar-tweets": for $t2 in dataset TweetMessages

891

where $t2.referred-topics ~= $t.referred-topics

892

and $t2.tweetid != $t.tweetid

893

return $t2.referred-topics

894

};

895

</pre></div></div></div>

<pre>var expression11 = new FLWOGRExpression()

902

.ForClause( "$t", new AExpression("dataset TweetMessages"))

903

.ReturnClause({

904

"tweet" : new AExpression("$t"),

905

"similar-tweets": new FLWOGRExpression()

906

.ForClause( "$t2", new AExpression("dataset TweetMessages"))

907

.WhereClause().and(

908

new AExpression("$t2.referred-topics ~= $t.referred-topics"),

909

new AExpression("$t2.tweetid != $t.tweetid")

910

)

911

.ReturnClause("$t2.referred-topics")

912

});

913

</pre></div></div></div>

914

915

<h6><a name="Results"></a>Results</h6>

<pre>{ "tweet": { "tweetid": "10", "user": { "screen-name": "ColineGeyer@63", "lang": "en", "friends_count": { int32: 121 } , "statuses_count": { int32: 362 } , "name": "Coline Geyer", "followers_count": { int32: 17159 } }, "sender-location": { point: [29.15, 76.53]}, "send-time": { datetime: 1201342200000}, "referred-topics": { unorderedlist: ["verizon", "voice-clarity" ]}, "message-text": " hate verizon its voice-clarity is OMG:(" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["iphone", "voice-clarity" ]}, { unorderedlist: ["verizon", "shortcut-menu" ]}, { unorderedlist: ["verizon", "voicemail-service" ]} ]} }

920

{ "tweet": { "tweetid": "6", "user": { "screen-name": "ColineGeyer@63", "lang": "en", "friends_count": { int32: 121 } , "statuses_count": { int32: 362 } , "name": "Coline Geyer", "followers_count": { int32: 17159 } }, "sender-location": { point: [47.51, 83.99]}, "send-time": { datetime: 1273227000000}, "referred-topics": { unorderedlist: ["iphone", "voice-clarity" ]}, "message-text": " like iphone the voice-clarity is good:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["verizon", "voice-clarity" ]}, { unorderedlist: ["iphone", "platform" ]} ]} }

921

{ "tweet": { "tweetid": "7", "user": { "screen-name": "ChangEwing_573", "lang": "en", "friends_count": { int32: 182 } , "statuses_count": { int32: 394 } , "name": "Chang Ewing", "followers_count": { int32: 32136 } }, "sender-location": { point: [36.21, 72.6]}, "send-time": { datetime: 1314267000000}, "referred-topics": { unorderedlist: ["samsung", "platform" ]}, "message-text": " like samsung the platform is good" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["iphone", "platform" ]}, { unorderedlist: ["samsung", "voice-command" ]} ]} }

922

{ "tweet": { "tweetid": "1", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [47.44, 80.65]}, "send-time": { datetime: 1209204600000}, "referred-topics": { unorderedlist: ["t-mobile", "customization" ]}, "message-text": " love t-mobile its customization is good:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["t-mobile", "shortcut-menu" ]} ]} }

923

{ "tweet": { "tweetid": "12", "user": { "screen-name": "OliJackson_512", "lang": "en", "friends_count": { int32: 445 } , "statuses_count": { int32: 164 } , "name": "Oli Jackson", "followers_count": { int32: 22649 } }, "sender-location": { point: [24.82, 94.63]}, "send-time": { datetime: 1266055800000}, "referred-topics": { unorderedlist: ["samsung", "voice-command" ]}, "message-text": " like samsung the voice-command is amazing:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["samsung", "platform" ]}, { unorderedlist: ["sprint", "voice-command" ]} ]} }

924

{ "tweet": { "tweetid": "3", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [29.72, 75.8]}, "send-time": { datetime: 1162635000000}, "referred-topics": { unorderedlist: ["motorola", "speed" ]}, "message-text": " like motorola the speed is good:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["motorola", "speed" ]} ]} }

925

{ "tweet": { "tweetid": "9", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [36.86, 74.62]}, "send-time": { datetime: 1342865400000}, "referred-topics": { unorderedlist: ["verizon", "voicemail-service" ]}, "message-text": " love verizon its voicemail-service is awesome" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["verizon", "voice-clarity" ]}, { unorderedlist: ["verizon", "shortcut-menu" ]} ]} }

926

{ "tweet": { "tweetid": "5", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [40.09, 92.69]}, "send-time": { datetime: 1154686200000}, "referred-topics": { unorderedlist: ["motorola", "speed" ]}, "message-text": " can't stand motorola its speed is terrible:(" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["motorola", "speed" ]} ]} }

927

{ "tweet": { "tweetid": "8", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [46.05, 93.34]}, "send-time": { datetime: 1129284600000}, "referred-topics": { unorderedlist: ["t-mobile", "shortcut-menu" ]}, "message-text": " like t-mobile the shortcut-menu is awesome:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["verizon", "shortcut-menu" ]}, { unorderedlist: ["t-mobile", "customization" ]} ]} }

928

{ "tweet": { "tweetid": "11", "user": { "screen-name": "NilaMilliron_tw", "lang": "en", "friends_count": { int32: 445 } , "statuses_count": { int32: 164 } , "name": "Nila Milliron", "followers_count": { int32: 22649 } }, "sender-location": { point: [37.59, 68.42]}, "send-time": { datetime: 1205057400000}, "referred-topics": { unorderedlist: ["iphone", "platform" ]}, "message-text": " can't stand iphone its platform is terrible" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["iphone", "voice-clarity" ]}, { unorderedlist: ["samsung", "platform" ]} ]} }

929

{ "tweet": { "tweetid": "2", "user": { "screen-name": "ColineGeyer@63", "lang": "en", "friends_count": { int32: 121 } , "statuses_count": { int32: 362 } , "name": "Coline Geyer", "followers_count": { int32: 17159 } }, "sender-location": { point: [32.84, 67.14]}, "send-time": { datetime: 1273745400000}, "referred-topics": { unorderedlist: ["verizon", "shortcut-menu" ]}, "message-text": " like verizon its shortcut-menu is awesome:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["t-mobile", "shortcut-menu" ]}, { unorderedlist: ["verizon", "voice-clarity" ]}, { unorderedlist: ["verizon", "voicemail-service" ]} ]} }

930

{ "tweet": { "tweetid": "4", "user": { "screen-name": "NathanGiesen@211", "lang": "en", "friends_count": { int32: 39339 } , "statuses_count": { int32: 473 } , "name": "Nathan Giesen", "followers_count": { int32: 49416 } }, "sender-location": { point: [39.28, 70.48]}, "send-time": { datetime: 1324894200000}, "referred-topics": { unorderedlist: ["sprint", "voice-command" ]}, "message-text": " like sprint the voice-command is mind-blowing:)" }, "similar-tweets": { orderedlist: [{ unorderedlist: ["samsung", "voice-command" ]} ]} }

931

</pre></div></div></div></div></div></div></div>

</div>

</div>

</div>

<hr/>