Database
Latest
Microsoft reveals Data Explorer tool, gets into the sorbet business (video)
Redmond houses quite a few little teams beavering away on quirky projects and one of those has just gone public with its latest creation. It's codenamed "Data Explorer", which perhaps isn't an ideal codename since it describes exactly what the enterprise-focused service does. Instead of manually searching and copying data into a report, Data Explorer pulls information from SQL databases, spreadsheets and other "random sources" that could be relevant, and then attempts to "clean it up, transform it, merge it together and then publish it out" as a coherent report. You can learn more and sign up for the beta at the source link, or click past the break to watch a Microsoft exec demo the tool using a real-world case study -- we found it a bit dense, but you'll be fine as long as you remember that kids love frozen yogurt.
FCC to test white space database at its own pace
See that faint silhouette lurking on the horizon? That'd be a wave of white space internet, and it's inching ever closer to the US. On Wednesday, the FCC confirmed that it will begin testing a new database that will enable gadgets to operate on white space airwaves, nearly a year after first ratifying its "super WiFi" initiative. The Spectrum Bridge database, as outlined last year, will map out all channels that aren't being used by radio or TV services, thereby preventing broadband devices from interfering with broadcasts. The system will be tested over a 45-day period beginning on September 19th and ending on November 2nd, in order to make sure that it correctly distinguishes available channels from those currently in use. Cable operators and wireless mic users are invited to register with the database to test its accuracy, but this trial period could easily be extended if the Commission determines that further tests are in order. And, though there's still no indication that unlicensed broadband devices will be hitting the market anytime soon, FCC Chairman Julius Genachowski seems confident that this white space spectrum could drastically change the industry. "Unleashing white spaces spectrum will enable a new wave of wireless innovation," Genachowski explained. "It has the potential to exceed the billions of dollars in economic benefit from WiFi, the last significant release of unlicensed spectrum, and drive private investment and job creation." You can read the FCC's full public notice, after the break.
London's E-Health Cloud program will send patient records to the stratosphere next month
You'd think that the recent spate of high-profile cyberattacks would've deterred the healthcare industry from sending patient records to the cloud -- but you'd be wrong. Beginning next month, all data on patients at London's Chelsea and Westminster Hospital will be stored in a centralized database, accessible from any computer, smartphone or tablet. Under the National Health Service's pilot program, known as E-Health Cloud, patients will be able to decide which doctors, nurses or family members can view their records, allowing them to easily share their data with other specialists. Flexiant, the Scottish software company that developed the platform, hopes to eventually expand it to other treatment phases, including assisted living, and insists that its system will help the NHS save money in the long-term. Security, however, will likely prove critical to the program's success. Users will have to pass multiple ID checkpoints to access the database, but privacy-wary Londoners might demand protection a bit more robust than an automated bouncer. You won't need to adhere to a dress code to view the full PR, available after the break.
Sega's online Pass hacked, 1.3 million user passwords stolen
Let's bid a bitter welcome to Sega, the latest entrant to the newly founded club of hacked online communities. Sega Pass, the company's web portal, suffered a breach of its defenses on Thursday, which has now been identified to have affected a whopping 1.29 million users. Usernames, real names, birth dates, passwords, email addresses, pretty much everything has been snatched up by the malicious data thieves, with the important exception of credit / debit card numbers. We'd still advise anyone affected to keep a watchful eye on his or her banking transactions -- immediately after changing that compromised password, of course. In the meantime, Sega's keeping the Pass service offline while it rectifies the vulnerability; it'll be able to call on an unexpected ally in its search for the perpetrators in the form of LulzSec, a hacker group that boasted proudly about infiltrating Sony's network, but which has much more benevolent intentions with respect to Sega. What a topsy-turvy world we live in!
The Daily Grind: How dependent are you on internet guides?
Allow me to indulge in my old-timey voice. Back in the day, we didn't have no dang internets to hold our hands through every twist and turn of them videotronic games. No, we got through by the pluck in our spines, the sheer focus of 10-hour gaming sessions, and the frantic calls to our friends begging for help to pass a level. OK, even by those early days, we were pretty weak when it came to tough spots in games, but still -- it was nothing compared to what we see today. Times have changed, but our desire to bypass difficult sections of games has not. If we can't cheat our way past it, we'll gladly leap to any aid that presents itself, whether it's a strategy guide, a walkthrough, or an elaborate database devoted to cataloguing every step of every quest in our MMOs. Today is an honesty check for you: How dependent are you on spoilers to get through quests when you get stuck? Do you try to puzzle things out for yourself, or is your first instinct to tab out and look up the solution? For bonus discussion, does this mean that it's impossible for devs to really surprise us anymore? Every morning, the Massively bloggers probe the minds of their readers with deep, thought-provoking questions about that most serious of topics: massively online gaming. We crave your opinions, so grab your caffeinated beverage of choice and chime in on today's Daily Grind!
IBM's Jeopardy-winning supercomputer headed to hospitals. Dr. Watson, we presume?
We always knew that Watson's powers extended well beyond the realm of TV trivia, and now IBM has provided a little more insight into how its supercomputer could help doctors treat and diagnose their patients. Over the past few months, researchers have been stockpiling Watson's database with information from journals and encyclopedias, in an attempt to beef up the device's medical acumen. The idea is to eventually sync this database with a hospital's electronic health records, allowing doctors to remotely consult Watson via cloud computing and speech-recognition technology. The system still has its kinks to work out, but during a recent demonstration for the AP, IBM's brainchild accurately diagnosed a fictional patient with Lyme disease using only a list of symptoms. It may be another two years, however, before we see Watson in a white coat, as IBM has yet to set a price for its digitized doc. But if it's as sharp in the lab as it was on TV, we may end up remembering Watson for a lot more than pwning Ken Jennings. Head past the break for a video from the University of Maryland School of Medicine, which, along with Columbia University, has been directly involved in IBM's program.
Blizzard improves the WoW community site (again)
Blizzard debuted the new World of Warcraft community site a while back, and it's definitely a huge improvement over the old one, which was really outdated and rarely helpful. The new site has a built-in Armory, better forums, a fairly robust Game Guide, and even regular dev blogs to give some insight on the development process. Apparently the improvements don't stop there, though, as Blizzard recently announced a laundry list of updates for the site, including: Rotatable 3-D models for gear in the item database Boss info pages, loot tables, and ability information Improved, easier-to-read search results And more! Check out the full list of changes and updates after the break.
SOE answers our questions about the recent database incursion
After PSN's data breach a couple of weeks back, questions and rumors spread across the internet, including speculation about the source of the incursion and how many records were actually taken. However, we still did not have all the answers. Customers of Sony Online Entertainment have been curious about the details of the recent intrusion into SOE servers, so Massively teamed up with our sister site, Joystiq, to get some direct statements from Sony. We put only our best detectives on the job. Joystiq Contributing Editor Ben Gilbert fired up the communicator with SOE PR Representative Ryan Peters to discuss the issues plaguing the MMO developer. Admittedly, many of the answers given were reiterated from a press release on SOE's website, but he was able to extract a few nuggets of information regarding the depth of the incident, which we've compiled past the break. Rest assured that our team will continue to keep you up to date on the latest information.
Stolen Camera Finder promises to find your camera with EXIF data, probably won't
Stolen Camera Finder is a site that promises to find missing cameras, as long as they've been stolen by cooperative criminals. All you have to do is drag and drop a JPG photo taken with your lost camera, and Stolen Camera Finder will hunt for any matches on the web, using the image's EXIF data. To find matches, the site consults a database of photos posted on Flickr and elsewhere, though, without only one million images to its name, this database is still very much a work-in-progress (the tests we conducted came up dry). It's a nifty idea, but one that would probably pay dividends only under certain circumstances. For instance, the thief would have to take pictures with the camera (rather than selling it) and post the images online without wiping the EXIF data. In other words, he'd have to be someone willing to steal a camera purely for the sake of sharing undoctored self-shots on Flickr. We're not sure those people exist.
Epsilon breach exposes TiVo, Best Buy email addresses, spambots stir into action
If you're subscribed to any of TiVo's email-based communiqués, now would be a good time to make sure your spam filters are up to scratch. Epsilon, TiVo's email service provider, has reported the discovery of a security breach that has compromised the privacy of some customers' names and / or email addresses. A rigorous investigation has concluded that no other personal data was exposed, however it's not just TiVo that's affected -- other big names, such as JPMorgan Chase, Citi, US Bank, Kroger, and Walgreens have also seen their users' deets dished out to the unidentified intruder. As we say, no credit card numbers or any other truly sensitive data has escaped, so the only thing you really have to fear is fear itself... and an onslaught of spam. Update: Best Buy and the US College Board have also joined the extremely broad list of affected organizations now, judging by the warning emails they've been sending off to our readers. Valued Best Buy customers should expect an email similar to the scawl posted after the break. Update 2: You can also count Chase Bank customers among those also affected -- not their bank accounts, mind, but their e-mail addresses. [Thanks to everyone who sent this in]
The Soapbox: The industry's obsession with shards
Disclaimer: The Soapbox column is entirely the opinion of this week's writer and does not necessarily reflect the views of Massively as a whole. If you're afraid of opinions other than your own, you might want to skip this column. The MMO genre is now over a decade old, and in that time we've seen countless innovations in game design, graphics technology and hardware infrastructure. Some of these innovations have become so essential that without them a game looks cheap, old or backward. A functional market or auction mechanic now replaces the old meet-and-trade style barter of some early MMOs, for example, and an MMO without copious map or chat tools is seen as grossly incomplete. The limits of what is possible have been pushed gradually forward, and yet certain ideas that were formed in the genre's infancy still seem to stick to new titles like glue. Sharded server models made a lot of sense in the early 2000s, when server hosting was expensive and the teams working on the server code were small. Those limitations have been rapidly shattered in recent years, but still new MMOs shard their communities into small groups. There are even alternative server models out there that are just as cost-effective as the sharded model but are devoid of the negative side-effects of smashing the community into hundreds of pieces. Read on as I take a look at why developers rely on the sharded server model, the problems surrounding splitting communities and what alternative server models are out there.
FileMaker Starter Solutions released for mobile apps
FileMaker announced the availability of three new Starter Solutions for its FileMaker Go mobile application. FileMaker Go lets you access and edit your FileMaker databases on your iPhone, iPad or iPod touch while away from your desktop. The three Starter Solutions are optimized for Apple's multi-touch mobile devices and include: Contacts: Organize and search your contacts. Documents: Work on documents remotely and synchronize any changes to a master database. Assets: Track all types of assets and create custom categories, such as serial numbers, purchase dates, depreciation calculations and more. The Starter Solutions can be edited on your mobile device and your Mac or Windows computer. Mobile usage requires the FileMaker Go application, which is available from iTunes for the the iPad (US$39.99) and the iPhone and iPod touch ($19.99). Desktop editing requires Filemaker Pro 11 ($299) for the Mac or Windows. For a limited time, you can purchase FileMaker Go and receive a 50 percent discount on the full version of FileMaker Pro. Not ready to lay out $150+ for this database solution? Then point your browser to FileMaker's website where you can download the Starter Solutions and a 30-day trial version of FileMaker Pro 11 for free. You can also check out our review of FileMaker Go for the iPad.
ZAM opens up a full database for RIFT
Databases are a good thing for an MMO. When you have buckets of different items, quests, stats, enemies, bosses, and so forth, it's good to be able to reference a wide variety of different data on the fly. Wowhead is pretty much the gold standard for database services, giving World of Warcraft players the opportunity to use talent calculators, compare items, and browse a comprehensive quest database with ease. ZAM, the parent company of Wowhead, is porting that same all-encompassing database over to RIFT with today's launch of the appropriately named RIFT Database. Although the system has just gone live, it already includes a robust listing of abilities, items, and quests for players to browse, as well as details on the various collections available in-game. Complete with a soul calculator, the new repository of knowledge should be welcome for any and all RIFT players looking for quick and easy reference. About the only thing it currently lacks is an option for integration into browser, but given time, it seems inevitable that the database will just keep improving.
Smithsonian captures 201,000 wild photos with automated cameras
We have this big, fang-filled, claw-sharpened big cat all up in our grill thanks to the researchers at the Smithsonian, who have created a new database filled with over 201,000 pictures of elusive animals in their natural habitats. These candid shots were made possible with motion-activated automated cameras scattered around the world, and feature over 200 species of birds and mammals, and here's most impressive part -- these photos are au naturel. That's right... there's no editing here, these are untouched raw shots straight from the rain forests of places like Peru and China -- which allow us to see these magnificent creatures as scientists do. If you want more info or desire to check out these wild photos, hop over to the source link or check out the gallery below. %Gallery-118866%
Panorama Sheets for Mac: A first look
Back in the first days of the Mac (in the days when I still had a full head of hair) a developer by the name of Jim Rea created one of the first database apps for the platform, Overvue. That application became Panorama (US$299), which is still around and has evolved through the years to remain a powerful and incredibly fast relational database for Mac. Sometimes, though, Mac owners need a database management system that isn't as powerful as Panorama but can handle operations that would choke Excel or Numbers. On January 6, Jim Rea's company -- ProVUE Development -- released a new product into the wild via the Mac App Store. That product is called Panorama Sheets (US$39.99) and it uses a spreadsheet-like interface for all data entry, searching, sorting, and data analysis and manipulation. The app has a feature called Total Recall that can protect your data through system crashes and power outages, and uses the same RAM-based database engine as Panorama for blinding speed in sorts and other operations. One feature that's sure to be popular with Mac users who need to manipulate large address list databases is support for many Avery mailing labels. If a database has standard address fields (first name, last name, street address, etc...), Panorama Sheets will automatically configure the fields on a label. If a field is missing (like the ever-popular "address2" field), the app automatically slides label fields up and to the left so there are no blank areas on the mailing label. Panorama Sheets also converts raw data into an interactive summary outline with subtotals, averages, and other calculations. Searches can be done phonetically with a "soundslike" operator, combined, and saved for future reference. If you're interested in trying Panorama Sheets to see if it's right for you, ProVUE has a 15-day free trial version available for download.
Cobra iRadar on the CES 2011 show floor
We liked the idea of the iRadar when we first heard about it, and Cobra put the device front and center at its CES 2011 booth (well, right next to the girls in skimpy police uniforms). The iRadar is a radar detector that hooks right up to Cobra's official iPhone app, and it will not only alert you when you see speed radar units out on the road, but it will also tune in to two different services. "Aura" is Cobra's own service that keeps a "verified" database of red light cameras and speed traps, and the iRadar ThreatCenter is a database specific to the iRadar that tracks, in real time, when the iRadar goes off. In other words, if someone with an iRadar drives by a speed trap right before you do, you'll be alerted ahead of time. Cobra told us that it has seen over 30,000 downloads of the app, so there's quite a bit of interest out there. The iRadar itself is designed to be a very simple radar detector -- it's just got a small button and a speaker, since most of the information is relayed through the iPhone. But Cobra confirmed that it is working on other radar detector models that will work with the app (as well as an Android version sooner rather than later), and it's even considering bringing the ThreatCenter system to non-smartphone enabled models. Eventually your iPhone may be alerting other Cobra users, even those without phones, about the speed traps you see. "That's why the app is free," the Cobra rep joked. iRadar is US$129, and both the detector unit and the dock come with the purchase. You may not have a need for speed, but if you do, Cobra's unit offers a nice integration with your iPhone. Please note that radar detector use may not be legal in some jurisdictions. TUAW reminds all our readers to always avoid distractions, focus on the road and drive prudently and safely. Be sure to check out the rest of our CES coverage on our CES page.
Google opens Android database at former phone store URL, but only for devices using Google services
Remember when Google opened up its own portal for purchasing the Nexus One? It was January 2010, and the URL was as simple as www.google.com/phone -- ah, those were the days. Of course, the store has been down since late July when the phone sold out (permanently), so what's the company to do with such a catchy web address? Simple: make a database of devices running your über-popular Android OS and help customers both compare and find where to buy. Only, it's not just any devices running the platform: according to the Official Google Mobile blog, "all the phones in the gallery include Android Market, Google Search, and other Google Mobile services such as Gmail, Maps, and YouTube." In other words, no phones that meddle with the Android Vision by opting for Bing or Yahoo instead. Maybe Fascinate can join the ranks after that purported Android 2.2 launch, but for now it's conspicuously absent. Them's the breaks -- still, it's fun to explore and draw up side-by-side comparison charts. Go on, give it a whirl, why don't ya? [Thanks to everyone who sent this in]
Lost Pages of Taborea: The Runes of Magic Database
A long long time ago, I wrote about community resources for Runes of Magic. In that article is a handy resource that gathers collected data from RoM called the buffed database. Key personnel from buffed.de started a new venture called Playata to provide content services to game publishers. The point of this boring news snippet is that Playata, in conjunction with Frogster, has created the official RoM database. This shiny new official site could be viewed as getbuffed 2.0. The official version is streamlined, runs better, and has a few nice extras that the original never had. This week I put together a guide explaining what the database is, what you can do with it, and some of the extra fun stuff it offers.
Dropbox updates iOS apps, announces App Directory
The Dropbox app for iPhone and iPad has been updated recently. There's a UI redesign in there now that takes full advantage of the Retina Display, so your shared files will look better than ever. The iPad version has gained a landscape view, and the app will now finish uploads and downloads in the background. Dropbox also allows file caching now, so once you've viewed a file, you won't have to go back and in and re-download it again. I presume that means only while the app is running -- if you have to actually close the app for any reason, you might have to connect up to see the file again. [Update: No, cached files remain accessible even without network access. –Ed.] But you can find out for yourself because the Dropbox app is free (as long as you sign up for a free account with their excellent service). The company has also released something called the App Directory, which is an online database of iPhone and iPad apps that will work in conjunction with Dropbox and its file sharing capability. You can browse, review, and rate Dropbox compatible apps (and actually, Android, Blackberry, and Windows Mobile apps are included as well, if you happen to have one of those phones), and even follow links straight from the listings to download and use whatever apps you need. If you save a lot of things on your Dropbox account, you might want to take a look through there. There's standard stuff like GoodReader and Documents to Go, but odds are that, even if you've found another use for sharing on Dropbox, there's probably an app to help you do it. Note: Please don't put Dropbox referral links in the comments. They will be deleted, and repeat offenders will be banned.
TUAW's Daily App: Phases
Phases is one of those apps that has a lot of information you wouldn't really think of or need -- until you actually have an app available to give it to you. Basically, Phases tells you everything you need to know about the moon, from when it wanes and waxes, rises and sets, and when and where it appears in the sky. Sure, it might not be the most pressing information to have, but it's kind of fun to check and see if it really is a full moon out, or find out just when the moon will be up in the evening. And you don't even need an Internet connection -- the app has a database of over 20,000 cities, so even if you can't hook up to the 'net, you can still get information from the app. It's just 99 cents in the store right now, so if the clean design and surprising amount of data available in this one appeals to you, definitely give it a download.
