Monday, 20 August 2012

Amazon Dynamo DB Database

The book I read to research this post was The Amazon Dynamo DB Database Development Guide which is a very good book which I downloaded for free from kindle. This database is part of the cloud computing services offered by Amazon Web Services integrates with things like S3 or Simple Storage Service & EC2 or Elastic Computing Cloud. For developers Amazon do freely downloadable software development kits in PHP, Java & Microsoft .Net. Some people use one of the C languages which are compatible. Much of this book is examples of code in various languages and this is a very big book. Dynamo is a NoSQL database and uses Hive for doing things like queries or performing general database commands. You can upgrade or downgrade the amount of storage your database uses without leaving the program. This has to be done in increments of at least 10%. There is a free option if you hardly use any storage which I think is primarily for people to try this out. Your first 40 million transactions on your database are free but I am sure you realise on a reasonably big database that will soon be used up. Some people get confused about the different methods of updating a database so I'm going to explain it. Imagine you are in a warehouse and someone asks have you got x in stock. You would use a query to check this and if you thought he might make the same request again you would name it and save it. Now suppose he asks for a printout to say it's in stock and the price etc you would do a report which is a bit more presentable than a query. Now suppose some stock arrives and you need to update the database you would use an update query if it was one type of item or a form if it there was several items. Setting up forms sometimes needs programming knowledge and can get very advanced. They call these things objects and the table were everything is stored is another example of one. There is other things like crosstab queries which incidently draw information from several tables into one query.

No comments:

Post a Comment