Impeccable timing: just days after Computerworld named Zoho Creator one of five web apps they can't live without, Zoho DB is released today. While Creator is an application generator, DB is primarily for data manipulation, analysis and reporting. You can create a new database or import your dataset from an existing spreadsheet, be it Zoho's own Sheet or MS Excel. The UI is instantly familiar, as it reminds us of a spreadsheet, but one with drag-and-drop goodness, allowing the user to easily analyse data, create charts, reports, which, as typical with Zoho apps you can embed in your web page or blog, and of course other Zoho Apps.
Fur deeper analysis you can create Pivot Tables with simple drag & drop. Zoho DB Supports Query Tables - tables created based on a select query from a different table. It understands queries in many SQL dialects: Oracle, SQL Server, DB2, Sybase, MySQL, PostgreSQL, Informix and ANSI SQL. This sets Zoho DB apart from the rest of the industry, and it's made possible by leveraging another Adventnet (Zoho's parent) product: SwisSQL. In the near future it will also allow users to import and export database schemas.
The best way to get a feel for the capabilities is to watch the video introduction, then get your hands "dirty" by diving into Zoho DB yourself.
Tags: zoho, zoho db, zoho creator, databases, online database, data analysis, spreadsheets, excel, pivot table, sql, data query, web applications, web office, ms access
link to original post