SDB Explorer UI is designed with many enhanced important features for using Amazon SimpleDB services. SDB Explorer is flexible, powerful, and easy to use interface for Amazon SimpleDB. It has following important features:
Upload MY-SQL table :
SDB Explorer helps to
upload structured database
table like Mysql on Amazon SimpleDB and provides an option to select a field as an item-identifier, after upload value of your selected field remains unique in an item row and rest of the columns are sorted accordingly.
SimpleDB Commander :
SimpleDB Commander
is a command line tool for Amazon SimpleDB. You can configure and
schedule SimpleDB Commander
for automation of
Export Domain
feature of SDB Explorer.
Amazon SimpleDB SELECT query :
Using SDB Explorer you can run
SELECT query
for each
Amazon SimpleDB domain
just like other database queries to fetch some specific attribute and to use WHERE clause to make a search with specific condition.
Export domain :
Export Domain
feature in SDB Explorer helps you to export data from Amazon server to your hard disk in XML format. You have option to export all items in a SimpleDB domain in single XML or multiple XMLs as per your work requirement.
Search on Item Name ( Item Identifier ) :
This feature of SDB Explorer provides search on Item name (i.e.
Amazon SimpleDB item identifier
). Amazon does not provide search on item identifier, SDB Explorer has an extra attribute "Sdb-item-identifier" for each row. Using this feature you can quickly retrieve an item row and can perform the 'Update' and 'Delete' item row beyond the
pagination
limit.
Sort by Item Identifier ( Item Name) or Attributes :
This feature of SDB Explorer provides sorting of records in ascending/ descending order by any of the attributes. It has an extra attribute 'Sdb-item-identifier' to provide
sort on item identifier
.
Put Attribute with REPLACE :
SDB Explorer helps in putting attributes in SimpleDB domain. 'Replace' option is provided when you perform '
put attribute
' operation. You can add multi-value for an attribute OR can replace older value by choosing Replace option.
Update an Item Row or an Attribute :
SDB Explorer provides facility to
update
whole item row as well as single attribute value as per your requirement..
Displays SimpleDB Domain property :
A right click '
domain properties
' option on selected domain displays its properties. Properties get displayed are: Domain name, Total item, Item-Name Size, Total Attributes, Attribute-Name Size, Total Attribute-Values, Attribute-Values Size.
Minimizes Amazon SimpleDB request for fast listing :
SDB Explorer uses QueryWithAttributes which provides fast listing of results. It includes list of attributes-value pairs with item identifiers which reduces number of requests and hence, it saves money.
Create Domain and item row :
You can create new
Amazon SimpleDB domain
using SDB Explorer. SimpleDB Domains consist of rows and columns in which you can store your structured data. With SDB Explorer you can also add new item row (s) any time in domain.
Delete Domain and item row :
You can
delete Amazon SimpleDB domain
/ item row using SDB Explorer. Item row can be deleted one by one or all at once using 'Delete all items' option.
Display Query Charges :
SDB Explorer shows the charges for the last executed query and the total of all executed queries for the current session which is calculated by
Amazon SimpleDB BoxUsage
in USD. Thus you are able to know about how much you have to pay.
Quick Connect :
Name option after
Access Key and Secret Key
is used for storing user's name. Quick connect menu shows saved Name to login Amazon SimpleDB. You can use 'Edit Credentials' option to add/ edit or remove AWS credentials in quick connect menu. By using 'clear history' option all your saved credentials can be deleted.
Protects AWS Credentials with or without password :
You can save your
AWS credentials
with or without password on local. When you use save without password option, your credentials are decrypted with machine name and every time when you run SDB Explorer you don't need to give password, decryption will be done automatically.
Preference panels for pagination and proxy setting :
SDB Explorer provides two options in preference window for
pagination setting and Proxy setting
which makes it more user friendly.
Help on start up :
On start up SDB Explorer provide help for you, if you don't have an
account on Amazon SimpleDB
. It also guides you how to create a domain on Amazon SimpleDB, if you have no domain in your account.
Tip and Tricks :
SDB Explorer provides tips and tricks on startup which helps users in getting information about its features and makes it easy to perform SimpleDB operations.
Debug on/off :
You can set
debug on
to create debug logs of all the activities performed in your Amazon SimpleDB account. Using debug logs you can track all the activities in SDB Explorer. Set 'debug off' stops debug logging.
