Oracle Berkeley DB SQL APIs the Getting Started with 12c Release 1
Oracle Berkeley DB
Getting Started with the
SQL APIs
12c Release 1
Library Version 12.1.6.2
Legal Notice
This documentation is distributed under an open source license. You may review the terms of this license at: http:// technetwork/database/berkeleydb/downloads/oslicense-093458.html
Oracle, Berkeley DB, and Sleepycat are trademarks or registered trademarks of Oracle. All rights to these marks are reserved. No third-party use is permitted without the express prior written consent of Oracle.
Other names may be trademarks of their respective owners.
To obtain a copy of this document's original source code, please submit a request to the Oracle Technology Network forum at:
Published 4/13/2017
Table of Contents
Preface ...................................................................................................... vi Conventions Used in this Book .................................................................... vi For More Information ............................................................................... vi Contact Us .................................................................................... vii
1. Berkeley DB SQL: The Absolute Basics .............................................................. 1 BDB SQL Is Nearly Identical to SQLite ........................................................... 1 Getting and Installing BDB SQL .................................................................... 1 On Windows Systems ......................................................................... 1 On Unix ......................................................................................... 2 The BDB SQL Interface ........................................................... 2 Prerequisites For Building The Package ................................. 2 Building BDB SQL Interface For Windows ................................ 2 Building BDB SQL Interface For Windows Mobile ..................... 3 Accessing BDB SQL Databases ..................................................................... 3 The Journal Directory ............................................................................... 4 User Authentication ................................................................................. 4 BDB User Authentication .................................................................... 4 The Interface ............................................................................ 5 Bootstrap ................................................................................. 6 Transaction ............................................................................... 6 Security Considerations ................................................................ 6 BDB SQL Key-store Based User Authentication ........................................... 7 Interface ................................................................................. 7 Bootstrap ................................................................................. 8 User Log In .............................................................................. 8 Transaction ............................................................................... 9 The Lock File ............................................................................ 9 Unsupported PRAGMAs .............................................................................. 9 Changed PRAGMAs ................................................................................... 9 PRAGMA auto_vacuum ........................................................................ 9 PRAGMA cache_size ......................................................................... 10 PRAGMA incremental_vacuum ............................................................. 10 PRAGMA journal_size_limit ................................................................. 10 Added PRAGMAs .................................................................................... 10 PRAGMA bdbsql_error_file .................................................................. 11 PRAGMA bdbsql_lock_tablesize ............................................................ 11 PRAGMA bdbsql_shared_resources ........................................................ 11 PRAGMA bdbsql_single_process ............................................................ 11 PRAGMA bdbsql_system_memory .......................................................... 12 PRAGMA bdbsql_vacuum_fillpercent ...................................................... 12 PRAGMA bdbsql_vacuum_pages ............................................................ 12 PRAGMA large_record_opt .................................................................. 12 PRAGMA multiversion ....................................................................... 13 PRAGMA snapshot_isolation ................................................................ 13 PRAGMA statistics ............................................................................ 13 PRAGMA statistics_file ...................................................................... 13
4/13/2017
Getting Started with the BDB SQL APIs
Page iii
4/13/2017
PRAGMA trickle ............................................................................... 13 PRAGMA txn_bulk ............................................................................ 13 Replication PRAGMAs ........................................................................ 14 PRAGMA bdbsql_userauth_add ............................................................. 14 PRAGMA bdbsql_user_login ................................................................. 14 PRAGMA bdbsql_user_edit .................................................................. 15 PRAGMA bdbsql_user_delete ............................................................... 15 Miscellaneous Differences ......................................................................... 15 Berkeley DB Concepts ............................................................................. 17 Encryption ........................................................................................... 17 Berkeley DB encryption ..................................................................... 17 SQLite Encryption Extension ............................................................... 17 Using Sequences .................................................................................... 18 create_sequence ............................................................................. 18 nextval ......................................................................................... 19 currval ......................................................................................... 19 drop_sequence ............................................................................... 19 Differences for Users of other SQL Engines .................................................... 19 2. Locking Notes .......................................................................................... 21 Internal Database Usage .......................................................................... 21 Lock Handling ....................................................................................... 22 SQLite Lock Usage ........................................................................... 22 Lock Usage with the BDB SQL Interface ................................................. 23 3. Berkeley DB Features ................................................................................. 25 Using Bulk Loading ................................................................................. 25 Using Multiversion Concurrency Control ........................................................ 25 Selecting the Page Size ........................................................................... 26 Controlling the Number of Accumulated Log Files ........................................... 26 4. Using DB_CONFIG to configure the Berkeley DB SQL interface ................................ 28 Introduction to Environments .................................................................... 28 The DB_CONFIG File ............................................................................... 28 Creating the DB_CONFIG File Before Creating the Database ......................... 29 Re-creating the Environment .............................................................. 29 Configuring the In-Memory Cache ............................................................... 29 5. Using Replication with the SQL API ................................................................ 31 Replication Overview .............................................................................. 31 Replication Masters .......................................................................... 31 Elections ....................................................................................... 32 Durability Guarantees ....................................................................... 32 Permanent Message Handling .............................................................. 32 Two-Site Replication Groups ............................................................... 33 Replication PRAGMAs .............................................................................. 33 PRAGMA replication ......................................................................... 33 PRAGMA replication_ack_policy ........................................................... 34 PRAGMA replication_ack_timeout ......................................................... 35 PRAGMA replication_get_master .......................................................... 35 PRAGMA replication_initial_master ....................................................... 35 PRAGMA replication_local_site ............................................................ 35 PRAGMA replication_num_sites ............................................................ 36
Getting Started with the BDB SQL APIs
Page iv
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction to oracle 12c pl sql programming itcourseware
- oracle database new features guide
- chapter 2 connecting to oracle 12c and basic sql select statements
- oracle sql 12c 11g basic sql advanced sql sarlakg
- oracle berkeley db sql apis the getting started with 12c release 1
- chapter 1 discovering databases and oracle 12c copyrighted material
- oracle database part fundamentals 12c sql i wiley
- chapter 2 solutions shop
- oracle 12c sql chapter 1 answers
- beginning oracle sql