Databases

Many companies are starting to follow the large Web players (Google, Yahoo, FaceBook, Amazon &c) in adopting scalable non-relational databases, that can handle the extreme demands of web-scale. New "nosql" databases not only address these demands, but also do it efficiently without the huge traditional costs of RDBMS clusters & storage solutions.

 

Here's a nice explanation of the different models & patterns of these databases:

udib 24/11/2009 - 01:49

Hello,

 

I would like to share my bad and good experience in application's design and planning.

 

1)

Remember, if you work with WEB/EJB container's objects, never make assumptions.

This stuff always tends to behave against your common sense.

As example:

peterk 10/09/2009 - 17:25

hi,

 

Can anyone recommend a hassle free tool that takes Java Entity objects code and generates an ERD? 

 

thanks,

Zvika

 

 

 

zvika 05/09/2009 - 17:30

I'd like to thank Ran for giving a great talk on NoSQL & Cassandra!


 

My summary can be found here:

udib 09/08/2010 - 19:35

One more .Net driver  for connecting to MongoDB - NoRM - open-source library managed on GitHub.

Speciality of this project in linkage of .Net types and document model of MongoDB.

With NoRM very easy to manipulate with .Net type without necessity to copy them to/from documents for saving/resolving in/from DB like  MongoDB-CSharp Driver.

 

NoRM Home http://wiki.github.com/atheken/NoRM/

Sample

 

    var coll = (new Mongo(connString)).GetCollection<Product>();

    //create a new object to be added to the collection
    var obj = new Product();
    obj._id = ObjectId.NewObjectID();
    obj.Title = "Shoes";

    //save the object
    coll.Insert(obj);

    //find the object
    var obj2 = coll.FindOne(new { _id = obj._id}).First();

 

michael 16/05/2010 - 13:32

Nice example of using Dynamic in manipulation with  MongoDB-CSharp document

 

Instead

Document post = new Document(); 
post["Published"] = DateTime.UtcNow; 
DateTime published = ((DateTime)mongo_post["Published"]).ToLocalTime();

 

With Dynamic

dynamic post = new Document(); 
post.Published = DateTime.UtcNow; 
DateTime published = mongo_post.Published.ToLocalTime();

 

Dynamic document implementation http://www.box.net/shared/knqqd9jn9k

 

michael 14/04/2010 - 11:20

Large scale analysis solution must be able to provide very fast response time (<1sec) to some complex queries which are typically structured from a large fact table which is joined to many dimension tables and grouped-by them.

 

Using standard SQL databases such as MySQL InnoDB (as well as leading commercial vendors) will result in poor performance even when correct indexes are set up since in many case the database will be forced to perform unnecessary full table scans which will kill the performance if dimension tables are large.

 

udid 30/03/2010 - 12:28

 I gave last week a talk on Non-relational databases in general & Cassandra in particular. Focussed on the advantages & cost/implications, to assist organizations in making a smart choice.

 

Posted the slides here:

http://www.slideshare.net/dibau_naum_h/nonrelational-databases-3328461

 

The last couple of slides contain links for great resources for further learning.

udib 08/03/2010 - 12:39

 

Modern projects need to manipulate with huge data amount, as result the necessity of high scalability and  high performance is very actual and always grows.

RDBMS databases cannot supply ultimate solution and alternative concepts like in NoSQL systems look very interesting.

 

The first interesting option is key-value stores like Google Big Table or Cassandra that provide fast and extremely large-scale solution but you can forget the comfort work with SQL queries like in RDBMS databases.  

 

Another option that tries to combine between advantages of RDBMS databases and key-values stores  is document-oriented databases like MonogDB.

 

MongoDB is development by commercial company as open-source project written in C++.

There are a lot of documentation, tutorials and samples on project site. 

 

michael 18/02/2010 - 18:15

Hi,

I'm looking for your experience with xml db.

I'm looking for a XQuery based xml db, that can store large amount of data and that I can work with large xml files (let's say 2G)

Does anyone familiar with eXist DB? what about oracle berkeley? and others...

10x,

Keren

keren 24/11/2009 - 18:38
Syndicate content