Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>As stated previously, SQLite, JavaDB and SimpleDB are good examples. I would add <a href="http://bit.ly/eKvOPB" rel="nofollow">Berkeley DB</a> to the list. Berkleley DB is well documented, has been around for several years, has several available APIs as well as multiple access methods like HASH, QUEUE and RECNO in addition to the traditional B-tree. Berkeley DB is a key/value database library written in C. <a href="http://bit.ly/dSBLo5" rel="nofollow">Berkeley DB XML</a> is an XML database library written in C++ on top of Berkeley DB. <a href="http://bit.ly/dM4Qtw" rel="nofollow">Berkeley DB Java Edition</a> is a 100% Java key/value database library. All of them are available under a GPL-like license and the source code is included in the <a href="http://bit.ly/gNWr1C" rel="nofollow">distribution</a>. </p> <p>Berkeley DB's SQL API incorporates the SQLite API, basically implementing the BDB key/value pair data store underneath the SQLite query layer. Berkeley DB was also the first data storage implementation underneath MySQL, again taking a SQL query layer and storing the data in a simple key/data value data format. It's certainly an interesting way of looking at the problem -- if you have a flexible, fast, scalable, reliable data store, you can then layer any type of API or data representation/abstraction on top of it. This is exactly what Berkeley DB does, providing a choice between the core key/value pair data storage or XML, SQL, Java Collections or a POJO-like Persistence Layer on top of the base key/value pair infrastructure. </p> <p>Berkeley DB is about as close to a "pure" data storage engine as you're going to find. It makes no assumptions about structure, content or the format of the data being stored. It allows the upper layers to provide those abstractions while the lower layer focused on fast, scalable, reliable storage. That's one of the reasons why Berkeley DB is so widely used -- it's simplicity and focus makes it very fast, reliable and scalable. </p> <p>Disclaimer: I'm one of the Product Managers for Berkeley DB, so clearly I'm a little biased. But, I've also been working on database products for 25 years and I know a little about DBMS internals. :-)</p> <p>Good luck in your research.</p> <p>Dave</p>
    singulars
    1. This table or related slice is empty.
    1. POWhat'd be a good open-source database for learning database design? (Designing the DBMS, not normalizing tables/etc)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USdsegleau
    1. USdsegleau
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload