Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Logo
Logo
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • Cloud
    • Database
    • IT Management

    eWEEK Labs Walk-Through: Dabble DB SAAS Database

    By
    eWEEK Labs
    -
    January 21, 2009
    Share
    Facebook
    Twitter
    Linkedin

      PrevNext

      1eWEEK Labs Walk-Through: Dabble DB SAAS Database

      1

      by eWEEK Labs

      2Creating a New Category

      2

      In Dabble DB parlance, tables are known as “categories.” You begin your category building through cut and paste, importing from a Web source, or creating and populating fields by hand.

      3The Data Set

      3

      I tested Dabble DB with NBA stats for my fantasy basketball league. The source I use comes formatted for fixed-width column import in Excel or Openoffice.org Calc.

      4First Crack at an Import

      4

      I copied the data into Dabble DB, and I also tried importing via URL.

      5Import Troubles

      5

      As I could see from the import preview, Dabble DB wasn’t going to parse the fixed-width formatting correctly.

      6Light Data Adjustment in Calc

      6

      I used OpenOffice.org Calc to whip my stats into shape for Dabble. I also could have written a script to strip out redundant spaces.

      7Import Back on Track

      7

      Once massaged a bit, my data proved more palatable to Dabble DB, and I was able to check out (and correct, if needed) the service’s automatic data type detection.

      8Create a View

      8

      With my new category created, Dabble DB dropped me off at its view-creation interface, where all the real dabbling occurs.

      9Derived Columns Made Easy

      9

      I clicked my way through the process of creating a bunch of derived columns that I needed in order to calculate my player rankings.

      10Save Your View

      10

      Once you arrive at the views you desire, you must save before exporting your data in one of the RSS, Excel, CSV (comma-separated values), plain text or JSON formats that Dabble DB supports.

      11Freshening Your Data

      11

      For future daily stats updates, I chose “new similar” from the Dabble DB import page to conduct an update operation using the same settings.

      12Navigating Through Your Application

      12

      Dabble DB offers good facilities for sorting and filtering through your stored data, but the speed penalties associated with a Web application prompted me to use Dabble alongside my local spreadsheet, rather than in lieu of it.

      13Editing Your Entries

      13

      I could step into my data to make changes, and Dabble’s knack for sussing out list-based data types came in handy while editing data.

      14Charting a Course

      14

      Dabble DB offers some facilities for visualizing your data. This bar chart is based on the player rating I used Dabble DB to help calculate.

      15No Title

      PrevNext

      MOST POPULAR ARTICLES

      Big Data and Analytics

      Alteryx’s Suresh Vittal on the Democratization of...

      James Maguire - May 31, 2022 0
      I spoke with Suresh Vittal, Chief Product Officer at Alteryx, about the industry mega-shift toward making data analytics tools accessible to a company’s complete...
      Read more
      Cybersecurity

      Visa’s Michael Jabbara on Cybersecurity and Digital...

      James Maguire - May 17, 2022 0
      I spoke with Michael Jabbara, VP and Global Head of Fraud Services at Visa, about the cybersecurity technology used to ensure the safe transfer...
      Read more
      Applications

      Cisco’s Thimaya Subaiya on Customer Experience in...

      James Maguire - May 10, 2022 0
      I spoke with Thimaya Subaiya, SVP and GM of Global Customer Experience at Cisco, about the factors that create good customer experience – and...
      Read more
      Big Data and Analytics

      GoodData CEO Roman Stanek on Business Intelligence...

      James Maguire - May 4, 2022 0
      I spoke with Roman Stanek, CEO of GoodData, about business intelligence, data as a service, and the frustration that many executives have with data...
      Read more
      Cloud

      Yotascale CEO Asim Razzaq on Controlling Multicloud...

      James Maguire - May 5, 2022 0
      Asim Razzaq, CEO of Yotascale, provides guidance on understanding—and containing—the complex cost structure of multicloud computing. Among the topics we covered:  As you survey the...
      Read more
      Logo

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2022 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×