113 lines
3.8 KiB
Plaintext
113 lines
3.8 KiB
Plaintext
|
Database: testData/staedtetest
|
|||
|
|
Restore : YES
|
|||
|
|
|
|||
|
|
Operator : createbtree
|
|||
|
|
Number : 1
|
|||
|
|
Signature: (((rel (tuple (x1 t1)...(xn tn)))) xi) -> (btree (tuple ((x1 t1)...(xn tn))) ti)
|
|||
|
|
Example : query Staedte createbtree[SName]
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : createbtree
|
|||
|
|
Number : 2
|
|||
|
|
Signature: ((stream (tuple (x1 t1)...(xn tn) (id tid))) xi) -> (btree (tuple ((x1 t1)...(xn tn))) ti)
|
|||
|
|
Example : query Staedte feed extend[ID: tupleid(.)] sortby[SName asc] createbtree[SName]
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : createbtree
|
|||
|
|
Number : 3
|
|||
|
|
Signature: ((stream (tuple (x1 t1)...(xn tn) (id tid))) xi) -> (btree (tuple ((x1 t1)...(xn tn))) ti)
|
|||
|
|
Example : query Staedte createbtree[SName] Staedte exactmatch["Bremen"] count
|
|||
|
|
Result : 1
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : deletebtree
|
|||
|
|
Number : 1
|
|||
|
|
Signature: stream(tuple(x@[TID tid])) x (btree(tuple(x) ti) xi) -> stream(tuple(x@[TID tid]))]
|
|||
|
|
Example : query Staedte feed filter[.Bev < 200000] Staedte deletedirect staedte_SName deletebtree[SName] staedte_Bev deletebtree[Bev] consume
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : exactmatch
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple ((x1 t1)...(xn tn))) ti)(rel (tuple ((x1 t1)...(xn tn)))) ti) -> (stream (tuple ((x1 t1)...(xn tn))))
|
|||
|
|
Example : query staedte_SName Staedte exactmatch["Dortmund"] count
|
|||
|
|
Result : 1
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : exactmatchS
|
|||
|
|
Number : 1
|
|||
|
|
Signature: (btree( (tuple(X))) ti) ti->)(stream((id tid)))
|
|||
|
|
Example : query staedte_SName exactmatchS["Bochum"] Staedte gettuples consume
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : insertbtree
|
|||
|
|
Number : 1
|
|||
|
|
Signature: stream(tuple(x@[TID tid])) x (btree(tuple(x) ti) xi) -> stream(tuple(x@[TID tid]))]
|
|||
|
|
Example : query Kleinstaedte feed Staedte insert staedte_SName insertbtree[SName] staedte_Bev insertbtree[Bev] consume
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : leftrange
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple ((x1 t1)...(xn tn))) ti)(rel (tuple ((x1 t1)...(xn tn)))) ti) -> (stream (tuple ((x1 t1)...(xn tn))))
|
|||
|
|
Example : query staedte_SName Staedte leftrange["G"] count
|
|||
|
|
Result : 16
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : leftrangeS
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple (X)) ti) ti) -> (stream (tuple ((ti tid))))
|
|||
|
|
Example : query staedte_SName leftrangeS["H"] Staedte gettuples count
|
|||
|
|
Result : 18
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : range
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple ((x1 t1)...(xn tn))) ti)(rel (tuple ((x1 t1)...(xn tn)))) ti ti) -> (stream (tuple ((x1 t1)...(xn tn))))
|
|||
|
|
Example : query staedte_Bev Staedte range[500000, 600000] count
|
|||
|
|
Result : 7
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : rangeS
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple (X)) ti) ti ti) -> (stream (tuple ((ti tid))))
|
|||
|
|
Example : query staedte_Bev rangeS[500000, 600000] head[5] consume
|
|||
|
|
Result : ((rel (tuple ((Id tid)))) ( (22)(12)(7) (11) (54)))
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : rightrange
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple ((x1 t1)...(xn tn))) ti)(rel (tuple ((x1 t1)...(xn tn)))) ti) -> (stream (tuple ((x1 t1)...(xn tn))))
|
|||
|
|
Example : query staedte_SName Staedte rightrange["U"] count
|
|||
|
|
Result : 4
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : rightrangeS
|
|||
|
|
Number : 1
|
|||
|
|
Signature: ((btree (tuple (X)) ti) ti) -> (stream (tuple ((id tid))))
|
|||
|
|
Example : query staedte_SName rightrangeS["M"] head[10] Staedte gettuples consume
|
|||
|
|
Result : file
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : updatebtree
|
|||
|
|
Number : 1
|
|||
|
|
Signature: stream(tuple(x@[(a1_old x1)...(an_old xn)(TID tid)])) x (btree(tuple(x) ti) xi) -> stream(tuple(x@[(a1_old x1)...(an_old xn)(TID tid)]))]
|
|||
|
|
Example : query Staedte feed filter [.SName = "Saarbruecken"] Staedte updatedirect [SName: "Saarbr<62>cken"] staedte_Bev updatebtree[Bev] staedte_SName updatebtree[SName] count
|
|||
|
|
Result : 1
|
|||
|
|
|
|||
|
|
|
|||
|
|
Operator : getFileInfo
|
|||
|
|
Number : 1
|
|||
|
|
Signature: (btree(tuple(x) ti) xi) -> text
|
|||
|
|
Example : query isdefined(getFileInfo(staedte_SName))
|
|||
|
|
Result : TRUE
|
|||
|
|
|
|||
|
|
Operator : keyrange
|
|||
|
|
Number : 1
|
|||
|
|
Signature: (btree(tuple(x) rel(tuple(x) key) -> stream(tuple((Less real)(Equal Real)(Greater real)(NumOfKeys int)))
|
|||
|
|
Example : query staedte_SName Staedte keyrange["Dortmund"] extend[All: .Less + .Equal + .Greater] extract[All]
|
|||
|
|
Result : 1.0
|