Oracles Berkeley DB - PowerPoint PPT Presentation

Loading...

PPT – Oracles Berkeley DB PowerPoint presentation | free to download - id: 138e76-OGMxM



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Oracles Berkeley DB

Description:

?? ??????a Sleepycat Software et? ap? a?t? a ??a ep??tas? t?? Berkeley DB (1996) ... ?? Berkeley DB de ??????e? t?p?ta ??a t?? es?te???? d? ? t?? keys/data. ... – PowerPoint PPT presentation

Number of Views:259
Avg rating:3.0/5.0
Slides: 33
Provided by: IAS79
Learn more at: http://www.cs.ucy.ac.cy
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracles Berkeley DB


1
Oracles Berkeley DB
  • ?????a? ??a??????

2
?? e??a? t? Oracles Berkeley DB
  • ??a embedded database p?? pa???e? ????? ap?d?s?,
    a???p?st?a ?a? p??sa?µ?st???t?ta.
  • ??a non-relational system engine
  • To application ???s?µ?p??e? ap?? function calls.
  • ??a ß?ß??????? p?? s??d?eta? ?µesa µe t?
    application.
  • ?e? e??a? ??a client-server architecture.

3
?st????? a?ad??µ?
  • ??µ?????????e ?a? a?apt?????e st? University of
    California at Berkeley (1986-1994)
  • H ??e??a s??e??st??e st? Harvard University.
  • ??µ??????a Sleepycat Software µet? ap? a?t?µa ??a
    ep??tas? t?? Berkeley DB (1996).
  • ?????st??e t? Feß??????? t?? 2006 ap? t?? Oracle.

4
??e??e?t?µata
  • Library/Not a language
  • ????? µ??e???
  • G?????? ?a? asfa??? ap????e?s?
  • ?e ??e???eta? ?e????st?? server
  • ?e ??e???eta? ??p???? administrator
  • H d?epaf? p????aµµat?sµ?? e??a? ?e???? ?a? e?????
  • ????? APIs (C,C,Perl,Tcl,Java)
  • ?e???a keys/data (µ???? 232 bytes)
  • ???a? open source

5
?e???e?t?µata
  • ?e? e??a? e????? ? ep????????a µe s?es?a???
    ß?se??
  • ?e? ?p???e? SQL interface
  • O p????aµµat?st?? p??pe? ?a ??????e? epa???ß??
    t?? a????e? t?? efa?µ????
  • ???ß?e?? stat???? queries
  • ??s????a ?ta? ? efa?µ??? apa?te? p????? e?d??
    queries.

6
??d?se?? t?? Berkeley DB
  • Berkeley DB
  • Berkeley DB XML
  • Berkeley DB Java Edition

7
???at?stas? Berkeley DB
  • Download Oracles Berkeley DB
  • http//www.oracle.com/database/berkeley-db/index.h
    tml
  • Prepare Berkeley DB for compilation
  • cd build_unix
  • ../dist/configure --prefix/usr
    --enable-compat185 --enable-cxx
  • Compile the package
  • Make
  • Install the package
  • make docdir/usr/share/doc/db-4.7.25 install

8
???at?stas? Berkeley DB
9
?? Berkeley DB e??a? µ?a ß?ß???????
  • ?d?a d?e????s? µ??µ?? µe t? application.
  • ?? Berkeley DB e?s?µat??eta? ?µesa st? e?te??s?µ?
    a??e??.
  • ?e? ?p???e? ??a? ?e????st?? server (embedded).
  • ?p?st????? ?????d?? ta?t??????? threads.
  • ??e???? ta?t??????a?,epa?afe?s?µ?t?ta.

10
?? Berkeley DB de? e??a? query language
  • ???sf??e? APIs ??a insert,update,retrieve ?a?
    delete.
  • ??af??et??? interfaces ??a ???e e????e?a, µ?s?
    method calls
  • open() open the database in a prescribed fashion
  • close() closes the database
  • put() puts a record in database
  • get() gets record from database
  • del() deletes a record from the database

11
?? Berkeley DB ???s?µ?p??e? t? Applications Data
Model
  • ?? format e??? record se µ?a s?es?a?? ß?s?
    e??p??ete? t? ß?s? ded?µ????.
  • ?e? e??p??ete? t?? efa?µ???.
  • ?? ?????µe ?a µeta????s??µe ded?µ??a ap? ?a? p???
    t? ß?s? t?te
  • ? efa?µ??? p??pe? ?a µetaf???e? a??µesa st?
    format t?? record t?? efa?µ???? ?a? t?? ß?s??
    ded?µ????.

12
Key/data pairs
  • ??a record ap?te?e?ta? ap? ??a key ?a? ??a data.
  • Keys ?a? data e??a? bit strings µetaß??t??
    µe??????.
  • ?? efa?µ???? ?a???????? t? pe??e??µe?? ?a? t?
    s?µas?a t???.
  • ?? Berkeley DB de ??????e? t?p?ta ??a t??
    es?te???? d?µ? t?? keys/data.
  • To Berkeley DB e?s?µat??e? ?e?t?????e? t?? hash
    functions ??a ta keys.
  • Keys/data ap????e???ta? se ap??? d?µ??(DBTs).

13
DBT

14
Indexing

15
?e ??e???eta? administration
  • ?????? ???ste? de ??e???eta? ?a ?????? p?? ?a
    ?????? administration µ?a ß?s?.
  • ??e? ?? e??as?e? t?? administration ?????ta? µ?s?
    t?? Berkleys DB APIs.
  • ?? ???ste? de ????????? ?t? t? Berkeley DB e??a?
    µ???? t?? s?st?µ?t?? p?? ???s?µ?p?????.

16
????? pa?aµet??p???s?
  • ???p?p???s? t?? µe?????? t?? pages/cache.
  • Buffer replacement policy.
  • Policies ??a duplicate keys sta tables.
  • ??e???p???s? ta?t??????a?,locking ?a?
    transactions.
  • ???a??sµ?? e?t?p?sµ?? ?a? ap?f???? t?? deadlock
    ?.a.
  • ? pa?aµet??p???s? ???eta? s?µf??a µe t?? a????e?
    t?? application.

17
???at?t?te? t?? Berkeley DB
  • Messaging
  • Storage Systems
  • Switching and Routing
  • Logging
  • Caching ??a Scalable Web Applications
  • Devices

18
Environments, Databases and Files

19
Create/Open/Recover Environment
20
Create/Open Database
21
Transaction Read/Modify/Write
22
??a ap?? application

23
?p????e?s? st???e???
24
????t?s?/??a??af? st???e???
25
??e?s?µ? t?? ß?s??
26
Dynamic data, static queries
  • ???ste? ep?d?se?? µe p??ß????µ? data access.
  • ?da???? se applications, ?p?? ta queries e??a?
    stat???.
  • ?? developers p??pe? ?a µp????? ?a p??ß?????? ta
    data access t?? efa?µ????.
  • ?? s?es?a??? ß?se?? a?t??eta, e??a? p??? ?a???
    st? ?a apa?t??? ??a queries.

27
S?????s? s?es?a???,embedded ?a? Berkeley DB
28
S??e??as?a s?es?a??? ?a? embedded
29
?e????t???? e?d????
  • ??µ??????a embedded ß?se?? ap? ??a RDBMS.
  • S???????sµ?? µe t?? ????a RDBMS.
  • ??t?p?sµ??, p?? µ?a efa?µ??? ?a e??p??et???ta?
    ?a??te?a ap? µ?a embedded ß?s?.

30
S?µpe??sµata
  • G?????? a???p?st? ?a? ap?d?t??? ??a ??a p?????
    efa?µ???? s?µe?a.
  • ??a e?d??µes? ??s? µeta?? µ?a? p???p?????
    s?es?a??? ß?s?? ?a? e??? low-level file system.
  • ???s?µ?p??e? ??a p??? ap?? ?a? p??sa?µ?s?µ?
    s?ed?asµ? ?a? pa???e? ta storage services µ?a?
    s?es?a??? ß?s??
  • ?? small-footprint t?? Berkeley DB e??a? ??a
    s?µa?t??? p?e????t?µa st?? pe?????sµ??? ??sµ? t??
    ?ata?a??t???? s?s?e???.

31
??ß?????af?a
  • http//www.oracle.com/database/berkeley-db/index.h
    tml
  • ? Comparison of Berkeley DB and Relational
    Databases
  • How Berkeley DB Fits into Oracles Overall
    Embedded Database Strategy
  • http//en.wikipedia.org/wizi/Berkeley_DB
  • http//www.accu-usa.org/2001-08.html
  • http//pybsddb.sourceforge.net/reftoc.html

32
?????
  • ???a??st? ??a t?? p??s??? sa?!
  • ??????S
  • ??O??S??S
About PowerShow.com