Google Fusion Tables

June 12, 2009 (eWeek) - Google is showcasing an alpha version of a cloud-based data management system designed to make it easy for users to integrate data from tables in disparate databases.

Called Fusion Tables, the technology is in the alpha phase and is focused on “fusing” the areas of data management and collaboration - merging multiple data sources, discussion of the data, querying, visualization, and Web publishing.

“If you think about databases, they’re very much focused on giving very high performance SQL processing and high throughput transactions, which is great…what we’ve been trying to do is take a different angle on this,” said Alon Halevy, a software engineer at Google. “We try to support collaboration among people.”

Through Fusion Tables, users can insert tables from their databases and share them with other users, circumventing the semantic heterogeneity problems that occur when trying to merge data from different sources.

“Data integration has always been a challenge,” Halevy said. “Taking two tables from one database and joining them together versus taking two tables from different databases and joining them together are very, very different kinds of activities. The reason is you usually design a database in such a way that your tables will merge very easily… but when two people develop databases independently it’s a much bigger challenge.”

The technology allows users to filter and aggregate the data, as well as visualize it on Google Maps and other visualizations from the Google Visualization API. In addition, users can discuss the data with ‘collaborators’ - those they share it with - by using a chat feature. If a collaborator with edit permission changes data during the discussion, viewers will see the change as part of the discussion trail.

In the current version, users can upload tabular data sets up to 100 MB each, with a maximum of 250 MB of data per user. The files can be Excel spreadsheets (.xls) or CSV files. Google has entered a few tables in gallery for everyone's use as they try the technology out. "What our goal has been is to remove that boundary of a database," Halevy said. "If I develop a database table today and you develop a database table, and then we discover a few months later that they are actually related to each other, then let’s make it very, very easy for us to fuse the data from these two tables.”

Here is a link to my comment on Google's Technology Blog.

Comments

Post a Comment

Popular posts from this blog

EOQ Calculations in Excel

Image
Last week in Operations Management we used Excel to calculate the Economic Order Quantity and graph Carrying Costs, Ordering Costs, and Total Costs. The Economic Order Quantity or "EOQ" is the order size that "minimizes" Total Costs. Any more or less and you are spending too much on ordering or too much on keeping inventory. For example, in the Excel spreadsheet below, if you had an Annual Demand of 12000 units, Ordering Costs of $10 per order, and Holding costs of $4 per unit per year, the EOQ would be 245 units and Total Costs would be $980.00: We used the following formula in Excel to calculate EOQ: =SQRT((2*B2*B3)/B4) And the following formula to calculate Total Costs at this point: =$B$6/2*$B$4+$B$2/B6*$B$3 To create the graph, we used the following formulas and simply copied them over a range of 100 to 500 units. Ordering Costs: =$B$2/D2*$B$3 Holding Costs: =D2/2*$B$4 Total Costs: =F2+G2 Looking at this chart, we can clearly see that our order size of 245 is ...
Read more

Reliability Calculations in Excel

Image
In Operations Management today we used Excel to calculate product reliability. Reliability is defined as "the ability of a product, service, part, or system to perform its intended function under a prescribed set of circumstances" (Stevenson, 2009). In order to calulate reliability over a given length of time we need to use the following formula: P(no failure) = e -t/MTBF where: e = 2.7183 t = Length of service before failure MTBF = Mean Time Between Failures One of the cases we did in class involved an auto detailing company that wanted to calculate the reliability of its vacuum cleaners. Excel provides an "EXP" funtion that we can easily apply here. After entering all data for the problem as shown on the spreadsheet below, we type the formula =EXP(-A5/$B$2) in cell B5 and copy down. Next we plot the distribution for t=0 to the maximum life expectancy of 20 years using a line graph. What we end up with looks like a classic case of "ex...
Read more

“How Are We Doing?” Efficiency, Utilization, and Productivity

Image
In business, knowing how we are performing in relation to our competition is vital. Internally we want to know if we are using resources effectively and getting the most out of what we have. Efficiency and Productivity are two calculations that are fundamental to the success of any organization. While the calculations are simple, choosing what measures to use and collecting the necessary data requires a thorough understanding of your industry. To calculate Efficiency you will have to first decide what to use as a base for comparison. Does your company already have a “target” of some kind? Like total units produced? If so then you can compare everything to that. Once you have that, there are a couple of basic formulas that can be used: Efficiency = Actual Output/Effective Capacity X 100% Utilization = Actual Output/Design Capacity X 100% Design Capacity is the maximum output achieved under ideal conditions. Effective Capacity is always less than Design Capacity because of factors...
Read more