| New/modified statement | Return Type | Meaning |
| SELECT * FROM Cap [WHERE ... ] | Relation | Query |
| CREATE VIEW <ViewName > AS SELECT statement [UNION/... SELECT statement] | Capability | Create a view and a capability to the view. |
| SELECT * FROM CATALOG OF Cap | Catalog info | Look up capability in catalog |
| CREATE BASEVIEW | Capability | Create the base view |
| DROP VIEW Cap | Void | Drop view associated with capability |
| ALTER VIEW Cap ... | Void | Modify view associated with capability |
| RESTRICT Cap RIGHTS rights | Capability | Create new capability to same view, possibly |
| with different access rights | ||
| REVOKE Cap1 USING Cap2 | Void | Revoke capability Cap1 |
| SELECT * FROM C 'C |
| WHERE date > '2006-01-01' |
| AND place = 'France' |
| SELECT * FROM C 'C |
| WHERE CONTAINS (description,'snow') |
| CREATE VIEW Italy AS |
| SELECT * FROM CM0 WHERE place = 'Italy' |
| UNION |
| SELECT * FROM C 'C WHERE place = 'Italy' |
| => CIT |
| RESTRICT CIT RIGHTS SELECT => C 'IT |
| SELECT * FROM ViewTable V, CapTable C |
| WHERE V.GlobalViewID = C.GlobalViewID |
| AND V.GlobalViewID = GlobalViewID(X) |
|
| HomeViews | Applications | ||
| Feature | ViewGallery | ViewFS | |
| View operations (create, drop) | X | ||
| Query execution | X | ||
| Distribution | X | ||
| Capability generation | X | ||
| Capability revocation | X | ||
| App-level abstractions (R) | X | X | |
| (Graphical) User Interfaces (R) | X | X | |
| Metadata for app-level | X | ||
| abstractions (O) | |||
| Transmit capabilities (O) | |||
| Track capabilities (O) | |||
| Help users annotate files (O) | |||
| Result size | Time (ms) | |||
| (# filenames) | Beagle | Local eval | LAN | Broadband |
| 1000 | 1297 | 1341 | 1349 | 1779 |
| 3000 | 3897 | 4009 | 4025 | 5876 |
| 5000 | 6465 | 6641 | 6661 | 11876 |
| Result size | Time (ms) | |||
| Spotlight | Local eval | LAN | Broadband | |
| 1000 | 332 | 376 | 384 | 814 |
| 3000 | 473 | 585 | 601 | 2452 |
| 5000 | 546 | 722 | 742 | 5957 |
| Result size | View depth | ||||
| (# filenames) | 1 | 2 | 3 | 4 | 5 |
| 100 | 175 | 182 | 198 | 208 | 225 |
| 1000 | 1341 | 1353 | 1376 | 1400 | 1429 |
| 5000 | 6641 | 6669 | 6785 | 6788 | 6849 |
| Result size | View breadth | |||
| (# filenames) | 1 | 2 | 3 | 4 |
| 100 | 179 | 218 | 221 | 261 |
| 1000 | 1355 | 1566 | 1594 | 1616 |
| 5000 | 6665 | 7663 | 7749 | 7848 |