6 Comments

Summary:

Although we’ve seen online office suites added to the portfolio of web worker productivity tools, database tools have been curiously absent from the mix. Even suites like Google Apps lack a dedicated application for managing and sharing specialized data, leaving users creating crude spreadsheet-based approximations.

square

In 2004, Tim O’Reilly’s famous Web 2.0 manifesto suggested that “data would be the next Intel Inside,” and that any Internet service of significance would be underpinned by specialized datasets, such as Amazon’s product database or Foursquare’s places.

However, although we’ve seen online office suites added to the portfolio of web worker productivity tools, database apps have been curiously absent from the mix. Even suites like Google Apps lack a dedicated application for managing, publishing and sharing specialized data, leaving users creating crude spreadsheet-based approximations. The average web worker may not have as much need for an online equivalent of Access as they would of Excel, but it seems strange that a collaborative database tool is missing from online apps suites like Google Apps and Microsoft’s Office Web Apps.

Fortunately, a new generation of tools are providing just that kind of functionality. “Data-as-a-service” providers are emerging that are enabling users to create, manage and publish specialized datasets, providing both authoring tools and opportunities to participate in a web of data, not just of pages.

Factual

When Factual launched a few months ago, I wondered if it was a “Flickr for data.” Indeed, the company pitches itself as an “open data repository” where users can upload and create datasets, as well as add data hosted by Factual to their own sites and apps.

Factual currently hosts datasets as diverse as videogame cheats, hiking trails and U.S. presidents. Interestingly, each dataset also includes a history of changes, which provides a level of accountability.

User can create new datasets by importing files, parsing web pages or using Factual’s extraction tools. Data can be accessed manually through a browser or via a public API.

InfoChimps

InfoChimps is similar to Factual in many respects, but positions itself as a “data marketplace” that enables publishers and owners of datasets to charge for their usage. Publishers can offer free and paid datasets, charging either for API access or for making them downloadable.

Interestingly, some datasets are organized into collections from particular organizations, such as Wikipedia and Data.gov, indicating the InfoChimps has become a useful means for organizations to outsource management of their open data policies.

Google Squared

It’s no surprise that Google is also experimenting in this area, though the company’s Google Squared service takes a slightly different approach, enabling its search data to serve as a source for creating smaller subsets ot data.

Squared can take any set of Google’s search results and format then into a structured table, or “square” which can be edited as well as exported to CSV or Google’s Spreadsheets format. The example here illustrates how a search for “british cities” creates a two-column square that can be expanded with additional user-created columns (i.e. population size) and saved for use elsewhere.

Where is the “YouTube for Data”?

Though Factual, InfoChimps and Google Squared show promise and the value of a web-based database authoring and hosting service, the demise of solutions such as Swivel and the defunct Dabble DB indicate that this application category is yet to mature. Perhaps it will take a company of Google’s scale to offer a “data-as-a-service” application that can truly rival the tools we’ve long used on the desktop and, more importantly, to enable us to share and monetize that data in ways which we haven’t been able to, thus far.

Do you have unique datasets in your business that could be valuable to others?

Related content from GigaOM Pro (sub. req.):

You’re subscribed! If you like, you can update your settings

You're subscribed! If you like, you can update your settings

  1. You missed Zoho.com’s database tools which appear to be fairly sophisticated. It also includes a small marketplace for buying ready-made or customized apps. It’s not as easy to use as Zoho’s other office applications (just as Access isn’t as easy to use as Word or Excel), but even I can figure out how to create a simple database with it.

    Andy

  2. Data-as-a-Service: Market Definitions « DataMarket blog Sunday, October 24, 2010

    [...] a comment » A recent post by GigaOm’s Imran Ali on the field of Data-as-a-Service made me think how vaguely our young field is still defined. Imran – somewhat randomly – [...]

  3. In reply to the above article, here’s an attempt to categorize different services and startup companies in the Data-as-a-Service sector: http://blog.datamarket.net/2010/10/24/data-as-a-service-market-definitions/

  4. I’d argue that the issue is not about “Data-as-a-service providers are emerging” but rather what is Data-as-a-service.
    One needs to first define what “data” is before trying to address the service part of it.
    Is data only a storage for data (docs, pictures, music, other)? Smart document store? Management system for doc storage? On-line primitive database?
    Data-as-a-service is a private case, or further abstraction if you will of Database-as-a-service.
    If it’s DBaaS you’re seeking, be aware of several types often times confusing: 1. Virtualized DB but Not-as-a-service (Install MySQL or alike on-top of AWS virtual instance), 2. Virtualized DB Partially-as-a-service (Amazon RDS), 3. Full DBaaS (Xeround.com), or Hybrid? DB/Data-as-a-service (FathomDB).
    Razi Sharir (blog.xeround.com)

  5. What are some of the best free data aggregation APIs available? – Quora Tuesday, February 8, 2011

    [...] of them are usable for free to some extent. Here's an article from GigaOM comparing all three.http://gigaom.com/collaboration/…Also check out Freebase (freebase.com)Insert a dynamic date hereView All 0 CommentsCannot add [...]

  6. Forrester: Big Data, Cloud Will Merge in 2011: Cloud Computing News « Monday, February 14, 2011

    [...] Although placing any proprietary data into a public data marketplace (Windows Azure DataMarket or InfoChimps, for example), is a decision beyond the realm of IT, the latter group can play an important role in [...]

Comments have been disabled for this post