Amazon web service provides both relational database services and non-relational database services. AWS customers now have three cloud based database solutions available:
Amazon SimpleDB service – Amazon SimpleDB can be useful for those who need a non-relational database for storage of smaller, non-structural data. Amazon SimpleDB has restricted storage size to 10GB per domain and it can achieve up to 25 writes/second. Amazon SimpleDB offers simplicity and flexibility. SimpleDB automatically indexes all data. Amazon SimpleDB pricing is based on your actual box usage. You can store any UTF-8 string data in Amazon SimpleDB.
Amazon DynamoDB service – Amazon DynamoDB can be useful for those who need a fast, highly scalable non-relational database. There is no limit on the storage size per table and you can specify how much request capability you require. Amazon DynamoDB offers good performance and incremental scalability. DynamoDB indexes only the primary key, which can be a composite primary key. DynamoDB is priced according to how much request capacity you have requested. You can store Strings and Numbers.
Amazon Relational Database Service (Amazon RDS) – Amazon RDS can be useful for those who need relational database service that offloads database administration. Amazon RDS provides the full capabilities of MySQL or Oracle database. Amazon RDS Database instances are instances of familiar MySQL or Oracle databases, running on an EC2. RDS offers backup/restore of databases scalability, and allows you to have up to 1TB database size.
Know more about these services -
This new version of SDB Explorer brings a set of features, to enhance your SimpleDB data connectivity and querying experience significantly.
Now you can query your data stored on Amazon’s SimpleDB much more efficiently. This version also allows you to store your Database Connection Settings, Database name and Table names using the Add/Manage database connection feature.
New Query features:
- Highlight the portion of query statement to be executed
- Comment out the query not to be executed
- Edit queries
Highlight the query - Highlight a part of a query and execute. So you could still be in the process of finalizing your query condition by trying multiple criteria, you do not need to erase everything that you have typed but do not want to execute in your current run. Just highlight and execute.
Comment out the query - Comment out Amazon SimpleDB queries that you do not want to execute. The Commented query will not get executed.
Editing queries - Editing queries using SDB Explorer has now become much easier. It Supports basic text editing features like copy, paste, undo and redo, that you would be able to do in any of the commonly used database query tools.
Add/Manage Database Connection Profile:
We have heard about the pain point of entering database connection settings repeatedly, to upload My SQL data to Amazon SimpleDB, from many of you. We have added an option to save the connection settings and now we can use the saved connection profiles to connect to the SimpleDB database. This profile can save your host address, port number, user-name and password to connect.
SDB Explorer will also list all Databases by name and the Tables for the selected Database. You need to select only database name and its Table that you would like to upload from My SQL using SDB Explorer before upload.
You can save database connection profile either “With Password” to protect your “Database Password” from malicious access.
SDB Explorer allows you to Update, Delete and List your database connection profiles.
You can find more details on the release notes page:
Users from Japan can take benefit from Tokyo Region, to reduce latency for the end-users, by keeping their data entirely in Japan.
Amazon SimpleDB is currently available in the following region endpoints:
- US East (Northern Virginia)
- US West (Northern California)
- EU (Ireland)
- Asia Pacific (Singapore)
- Asia Pacific (Tokyo)
First 1 GB data stored per month is free and thereafter Amazon SimpleDB will charge $0.29 per GB-per month. SDB Explorer supports making requests to each region and calculates charges based on the region endpoints, for which the requests are made.
You can find detailed listing on the release notes page ->
In Amazon SimpleDB, you require a unique id called item name for each row, to store data into a Domain.
Now SDB Explorer will auto generate this unique id for you, using Auto Item Name Generator Interface.
SDB Explorer can auto generate a sequence of numbers, with zero padding and prefix, for the item name. Since Amazon SimpleDB stores data as UTF-8 strings, you can not query numeral data. All data comparisons are done lexicographically but zero-padding will help you query the numerical data too.
You need to provide starting number, zero pad digits and prefix at the Auto Item Name Generator Interface, and it will generate item names for you based on the numbers you provide.
- Starting Number – from where the sequence of number will start.
- Zero Pad Digits – how many zero numbers you would like to add before generated numbers.
- Prefix – if you would like to add prefix.
Starting Number – 0
Zero Pad Digits – 0
Result : 0, 1, 2, 3.. N (Number of Rows)
Starting Number – 0
Zero Pad Digits – 2
Result : 00,01,02, 03.. N
Starting Number – 0
Zero Pad Digits – 4
Result : a0000,a0001,a0002, a0003.. N
You can find more tips and tricks for building query -
SDB Explorer was supporting Item Name searches even before Amazon SimpleDB started supporting Item Name searches, which was very recently. Now, using SDB Explorer, you can also sort your records by Attribute Name or by Item Name without writing Queries.
SDB Explorer helps you sort the records by Attribute Name or by Item Name, according to the specified order type (Ascending / Descending) in the Grid.
SDB Explorer adds next set of results at the bottom of the results table, so that you can sort table column without sending another request to Amazon SimpleDB.
More details can find here -
You can find detailed query samples on the underlying page:
Tips and Trick for Amazon SimpleDB Query:
Amazon SimpleDB is a web service for storing and running queries on non-relational structured data in real time.
SDB Explorer is a very simple to use graphical user interface (GUI) to explore Amazon SimpleDB service. SDB Explorer facilitates the core features of Amazon’s NoSQL SimpleDB very effectively. This tool offers the functionality to store, process and query the structured data without writing any code.
Use SDB Explorer to store data on Amazon SimpleDB very quickly and enjoy the abundant benefits of Amazon SimpleDB. SDB Explorer helps you manage large amount of distributed data on Amazon SimpleDB. It provides very fast retrieval of data and secured access control.
SDB Explorer Features :
- Export Domain – Export content of multiple Domains from Amazon SimpleDB to native file system in XML format.
- Run Amazon SimpleDB Query – You can run Amazon SimpleDB query to search the data and perform any operation on it.
- Create and Delete Domain – Domains are like a simple tables containing rows and columns. You can Create and Delete Domains.
- Explore Domain – You can see all records in a Grid.
- Support Page Size – Amazon SimpleDB returns data in chunks. You can specify how many records Amazon SimpleDB should return in each response.
- Create, Update and Delete Attributes – Amazon Simple DB provides flexibility to add new attributes that only apply to certain rows. You can perform Update and Delete on existing ones.
- Security Access Control – Save AWS Credentials in a secured way on local for the ease of connecting to AWS.
- Support for MAC/Linux/Windows platform.
- Support Proxy – You can connect to Amazon SimpleDB using your proxy settings.
- Tips, On-line Help, Documentation, Demos, Screen shots, Discussion forums, Product Support, Status info and Error reporting
SDB Explorer is now available to everyone. We still consider SDB Explorer in its “early stages”. As we did with Bucket Explorer, we are committed to improve SimpleDB Explorer based on user feedback. So, feel free to provide feedback via phone, email or our support forum.
Download latest SDB Explorer from our download page – http://www.sdbexplorer.com/simpledb-download.html
Video and Gallery -