1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Berkeley DB Concepts</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="dbsqlbasics.html" title="Chapter 1. Berkeley DB SQL: The Absolute Basics" />
<link rel="prev" href="miscdiff.html" title="Miscellaneous Differences" />
<link rel="next" href="sql_encryption.html" title="Encryption" />
</head>
<body>
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Berkeley DB Concepts</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="miscdiff.html">Prev</a> </td>
<th width="60%" align="center">Chapter 1. Berkeley DB SQL: The Absolute Basics</th>
<td width="20%" align="right"> <a accesskey="n" href="sql_encryption.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="bdb-concepts"></a>Berkeley DB Concepts</h2>
</div>
</div>
</div>
<p>
If you are a SQLite user who is migrating to the BDB SQL interface,
then there are a few Berkeley DB-specific concepts you might want
to know about.
</p>
<div class="itemizedlist">
<ul type="disc">
<li>
<p>
Environments. The directory that is created
alongside your database file, and which ends with
the "-journal" suffix, is actually a Berkeley DB
environment directory. This might be interesting to
you in some administrative situations. For some
minimal information on what an environment is, see
<a class="xref" href="configure.html#env-overview" title="Introduction to Environments">Introduction to Environments</a>.
</p>
</li>
<li>
<p>
The Locking Subsystem
</p>
<p>
You can configure the maximum number of locks
that can be in use at any given time when you use
the BDB SQL interface. This is probably only interesting to
you if you are using the BDB SQL interface in a concurrent
application that is running a very large number of
transactions.
</p>
<p>
For information on configuring your locking
subsystem, see
<a class="xref" href="admin-locking.html" title="Managing the Locking Subsystem">Managing the Locking Subsystem</a>.
</p>
</li>
<li>
<p>
The Logging Subsystem
</p>
<p>
The BDB SQL interface maintains log files in its journal
directory, and you can manage various aspects of
these. For the overwhelming majority of
applications, there is no need to manage this. But
for the sake of completeness, this topic is
described in this manual.
</p>
<p>
For more information, see
<a class="xref" href="admin-logfile.html" title="Administering Log Files">Administering Log Files</a>.
</p>
</li>
</ul>
</div>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="miscdiff.html">Prev</a> </td>
<td width="20%" align="center">
<a accesskey="u" href="dbsqlbasics.html">Up</a>
</td>
<td width="40%" align="right"> <a accesskey="n" href="sql_encryption.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Miscellaneous Differences </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Encryption</td>
</tr>
</table>
</div>
</body>
</html>
|
