3 Introducing Oracle NoSQL Database Tables and Indexes

Using the Table API (in one of the supported languages) is the recommended method of developing an Oracle NoSQL Database client application. Table APIs let you manipulate data using a tables metaphor, in which data is organized in multiple columns of data. The table APIs support an unlimited number of subtables. You can also create indexes to improve query performance against your tables.

If you have a mix of clients accessing your store using both Table and Key/Value APIs, a remote chance exists that keys from different clients could collide. To avoid any possible conflict between keys, however unlikely, make sure that every KV key has either only:

• A single component

• A single major component

Note:

Throughout this manual, examples call TableAPI.getTable(). The cost of calling this API is relatively high, because doing so requires a round trip to the store to fulfill the request. For optimal performance, call this method sparingly in your code.