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. As a best practice, it is recommended that you do not use your data store to store both raw key/value data and table data. If this is required for your situation, then it is recommended that you store your key/value data in a table with 2 columns: a key column and a data column. Doing so will allow you to use the Table APIs on both your table and key/value data. 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.