文章存档
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： 数据库开发技术
2008-03-14 21:22:18
很重要的数据库, 高效! 必须要学习的.
入门知识:
------------
使用berkeley db (bdb)必须理解的几个基本概念:
1>. key/data pairs
bdb使用key和data成对出现来表示数据库中的一行记录.
如:
key: data:
---------------
fruit apple
sport cricket
drink water
key and data items can be arbitrary binary data of practically any length, including 0 bytes. there is a single data item for each key item, by default, but databases can be configured to support multiple data items for each key item.
2>. object handles
整个数据库使用起来采用面向对象的思想.
3>. error returns
bdb api通常的错误返回:
0 执行成功
非0 执行失败
如果是系统错误, 如: 磁盘满, 没有操作权限, 非法的参数设置, bdb将返回errno值. 当然errno是大于0的.
db_strerror api返回任何错误消息, 类似ansi c中的strerror api一样.
还有两个api, db->err, db->errx, 类似ansi c中的printf
数据库使用需要理解的:
1>. 创建一个简单的数据库
打开一个数据库需要两步:
setp 1. 调用db_create api创建db句柄
setp 2. 使用句柄db->open来打开数据库.
如:
#include
#include
#include
#define database "access.db"
int main()
{
db *dbp;
int ret;
if ((ret = db_create(&dbp, null, 0)) != 0)
{
fprintf(stderr, "db_create: %s\n", db_strerror(ret));
exit (1);
}
if ((ret = dbp->open(dbp, null, database, null, db_btree, db_create, 0664)) != 0)
{
dbp->err(dbp, ret, "%s", database);
goto err;
}
....
}
the db_create interface takes three arguments:
dbp
a location to store a reference to the created structure.
environment
a location to specify an enclosing berkeley db environment, not used in our example.
flags
a placeholder for flags, not used in our example.
the db->open interface takes five arguments:
file
the name of the database file to be opened.
database
the optional database name, not used in this example.
type
the type of database to open. this value will be one of the four access methods berkeley db supports: db_btree, db_hash, db_queue or db_recno, or the special value db_unknown, which allows you to open an existing file without knowing its type.
flags
various flags that modify the behavior of db->open. in our simple case, the only interesting flag is db_create. this flag behaves similarly to the ieee/ansi std 1003.1 (posix) o_create flag to the open system call, causing berkeley db to create the underlying database if it does not yet exist.
mode
the file mode of any underlying files that db->open will create. the mode behaves as does the ieee/ansi std 1003.1 (posix) mode argument to the open system call, and specifies file read, write and execute permissions. of course, only the read and write permissions are relevant to berkeley db.
2>. 向数据库中添加数据
3>. 从数据库中查找记录
4>. 从数据库中删除记录
5>. 关闭数据库
see more:
入门知识:
------------
使用berkeley db (bdb)必须理解的几个基本概念:
1>. key/data pairs
bdb使用key和data成对出现来表示数据库中的一行记录.
如:
key: data:
---------------
fruit apple
sport cricket
drink water
key and data items can be arbitrary binary data of practically any length, including 0 bytes. there is a single data item for each key item, by default, but databases can be configured to support multiple data items for each key item.
2>. object handles
整个数据库使用起来采用面向对象的思想.
3>. error returns
bdb api通常的错误返回:
0 执行成功
非0 执行失败
如果是系统错误, 如: 磁盘满, 没有操作权限, 非法的参数设置, bdb将返回errno值. 当然errno是大于0的.
db_strerror api返回任何错误消息, 类似ansi c中的strerror api一样.
还有两个api, db->err, db->errx, 类似ansi c中的printf
数据库使用需要理解的:
1>. 创建一个简单的数据库
打开一个数据库需要两步:
setp 1. 调用db_create api创建db句柄
setp 2. 使用句柄db->open来打开数据库.
如:
#include
#include
#include
#define database "access.db"
int main()
{
db *dbp;
int ret;
if ((ret = db_create(&dbp, null, 0)) != 0)
{
fprintf(stderr, "db_create: %s\n", db_strerror(ret));
exit (1);
}
if ((ret = dbp->open(dbp, null, database, null, db_btree, db_create, 0664)) != 0)
{
dbp->err(dbp, ret, "%s", database);
goto err;
}
....
}
the db_create interface takes three arguments:
dbp
a location to store a reference to the created structure.
environment
a location to specify an enclosing berkeley db environment, not used in our example.
flags
a placeholder for flags, not used in our example.
the db->open interface takes five arguments:
file
the name of the database file to be opened.
database
the optional database name, not used in this example.
type
the type of database to open. this value will be one of the four access methods berkeley db supports: db_btree, db_hash, db_queue or db_recno, or the special value db_unknown, which allows you to open an existing file without knowing its type.
flags
various flags that modify the behavior of db->open. in our simple case, the only interesting flag is db_create. this flag behaves similarly to the ieee/ansi std 1003.1 (posix) o_create flag to the open system call, causing berkeley db to create the underlying database if it does not yet exist.
mode
the file mode of any underlying files that db->open will create. the mode behaves as does the ieee/ansi std 1003.1 (posix) mode argument to the open system call, and specifies file read, write and execute permissions. of course, only the read and write permissions are relevant to berkeley db.
2>. 向数据库中添加数据
3>. 从数据库中查找记录
4>. 从数据库中删除记录
5>. 关闭数据库
see more:
给主人留下些什么吧！~~