Slashdot Mirror


DB Query Becomes Browseable In Virtual World

Jani Pirkola writes to tell us that Green Phosphor's new project "Glasshouse" allows users to take database queries or spreadsheets and create 3D representations in a virtual world. Man what I wouldn't give to mash my level 80 death knight up with some of the ugly joins I have run across in the past. "Users can see data, and drill into it; re-sort it; explore it interactively - all from within a virtual world. Glasshouse produces graphs which are avatars of the data itself. We've tailored the system for the use of biotech companies, specifically for drug discovery and development. Dr. David Resuehr, a molecular biologist, recently joined Green Phosphor as our Chief Scientist."

82 comments

  1. Huh. by Frosty+Piss · · Score: 1

    3D data graphing over Second-Lifeish CG landscapes. Groundbreaking.

    --
    If you want news from today, you have to come back tomorrow.
    1. Re:Huh. by Anonymous Coward · · Score: 0

      My thoughts exactly. Plus the word "avatar" is retarded.

    2. Re:Huh. by NotBornYesterday · · Score: 3, Funny

      Looks like a mini-nightmare I had when I nodded off during a late-afternoon DB2 class.

      --
      I prefer rogues to imbeciles because they sometimes take a rest.
    3. Re:Huh. by Anonymous Coward · · Score: 0

      Is he related to DB Cooper?

  2. It's a database query, I know this! by PotatoFarmer · · Score: 5, Funny

    But the real question, of course, is whether or not a teenage hacker girl can successfully use this to navigate your data and fix your TPS reports before the velociraptors eat you all.

    1. Re:It's a database query, I know this! by maxume · · Score: 1

      In Disclosure, the lead actually uses a 3d filing cabinet system to access some files that he needs (if I remember correctly, the premise was that the virtual system, setup as a demo, let him bypass some physical security).

      --
      Nerd rage is the funniest rage.
    2. Re:It's a database query, I know this! by sortius_nod · · Score: 1

      my eyes, my eyes, will you do nothing about the memes?!?!

    3. Re:It's a database query, I know this! by sukotto · · Score: 2, Funny

      Only if it's Unix. She KNOWS that.

      --
      Come play free flash games on Kongregate!
    4. Re:It's a database query, I know this! by magarity · · Score: 1

      I was really suprised there wasn't a new tag: iknowthisitsunix

    5. Re:It's a database query, I know this! by Moskit · · Score: 1

      It's not, it is Deutsche Bahn query, of course.

    6. Re:It's a database query, I know this! by rocketPack · · Score: 1

      Or teenage hacker boyz stealin' ur garbage filez. LOL I gotz proof!!!!111!11one!!1!1!

  3. This just in from the "World of SQL" ... by Anonymous Coward · · Score: 0

    Nerf distinct, it's OP!

    1. Re:This just in from the "World of SQL" ... by geminidomino · · Score: 1

      Screw that! Too many query builds depend on it! Do you want to make the whole class worthless?

      No, they need to nerf JOIN. Now THAT is a perfect example of a completely imba clause that should never have been added!

  4. Off topic and Gossipping.... by Anonymous Coward · · Score: 0

    But I currently work on an app that the current CEO of Green Phosphor, Ben Lindquist worked on back in 200X. For various reasons I'm not going to name anything, but let's just say his lack of commenting on many of the stuff he wrote is enough to drive me to drinking. I can't rag on him too bad for not having an IDE that let you know if assignments or private functions went unused, though.

    Seriously, the lack of commenting and hard-coded paths are a thing of the past I hope for his projects.

    Anyways, on topic, this is really neat, but unlike sound visualizers, is there going to be a consistent, concrete approach to the that industry professionals can extract information with? It isn't helpful to visualize this flat data if the standard for visualizing changes willy-nilly.

  5. And who's to blame? by Bozzio · · Score: 1

    I blame CSI for generating interest in these tools. Flashiness at the expense of clarity and efficiency.

    Now, just add an animated avatar removing its sunglasses and we're set.

    --
    I just pooped your party.
    1. Re:And who's to blame? by Seakip18 · · Score: 4, Funny

      [Outside a Miami office building, a quick shot to a broken window several floors up.]
      [Then a cut to the street where Horatio knells over a bloodied monitor, with the attached tower in parts. Delko pokes at the nearby keyboard various instruments]
      D: It looks like a lot of energy was transferred from the keyboard to this monitor.
      H: You can tell by the missing keys on the keyboard, this was an old fashion capacitor driven board...
      D: Well whoever did this did a select * on destruction with both hands.
      [Horatio stands, removing his sun glasses]H: He didn't just go Select *...he committed the changes without a rollback.
      [Intro to the The Who's "Won't Get Fooled Again"]

      --
      import system.cool.Sig;
    2. Re:And who's to blame? by Anonymous Coward · · Score: 0

      Haha, but it won't work because it always rains just before they get to outdoor crime scenes--or anywhere outdoors, actually.

    3. Re:And who's to blame? by Firehed · · Score: 1

      Flashiness and clarity don't have to be mutually exclusive - and aren't when executed well (which admittedly isn't too often). As for efficiency... the code may or may not be fantastic, but leaving end-users to wander around data visualizations leaves more time for you to do something that's actually important.

      --
      How are sites slashdotted when nobody reads TFAs?
    4. Re:And who's to blame? by arkowitz · · Score: 1

      LOL those "user interfaces" in CSI are so cheesy - Arkowitz

    5. Re:And who's to blame? by Nefarious+Wheel · · Score: 1

      Now, just add an animated avatar removing its sunglasses and we're set.

      "Hi. I'm Ray. Ray Tracer. I surf the net."

      I miss Reboot.

      --
      Do not mock my vision of impractical footwear
  6. Death Knights by Anonymous Coward · · Score: 0

    I hate Death Knights - they are almost always terribad players who think they can tank because they are wearing plate armor. "I'll just throw on frost presence and we'll go."

    As if.

    1. Re:Death Knights by Meski · · Score: 1

      Some of them can. There are bad tanks from every class. The ones that think they can tank heroic raids because they've tanked hVH...

  7. DNA got there first by Kupfernigk · · Score: 4, Insightful
    Remember when Zaphod Beeblebrox fixes things in the galactic accounting system by entering a virtual old-style accounting world? How many other big ideas did DNA get to first? - including his request for the universal power brick.

    More seriously, the point about visualisation of data is well made. How many people who think they are information literate produce incomprehensible spreadsheets and graphs that conceal reality? However, the example on the web page (oil production) is a terrible one - very hard to read, unnecessary wodges of solid color, everything that upsets Tufte. To make a project like this really work, I think they are going to have to concentrate on what to leave out, as much as what to leave in. And silly avatars don't cut it. Learn from Clippy, guys. I am sure that there is a right way to use data to virtual reality 3D modelling, but, and I can't say this too strongly, when marketing demands more color, more widgets and exciting background sound tracks, tell them to go fornicate off. Thousands of data analysts will thank you.

    --
    From scarped cliff or quarried stone she cries "A thousand types are gone, I care for nothing, no not one."
    1. Re:DNA got there first by cencithomas · · Score: 1

      when marketing demands {*anything at all*}, tell them to go fornicate off.

      Yeah right. Sounds like a fast way to get "rightsized" where I work.

      --
      ...'tis easier to blame than to improve.
    2. Re:DNA got there first by lennier · · Score: 3, Insightful

      "How many people who think they are information literate produce incomprehensible spreadsheets and graphs that conceal reality? "

      You say that as if revealing reality were what corporate reports were about in the first place.

      --
      You are not a brain: http://books.google.com/books?id=2oV61CeDx-YC
    3. Re:DNA got there first by Anonymous Coward · · Score: 0

      I am sure that there is a right way to use data to virtual reality 3D modelling

      It might possibly be used to generate different landscapes... On the other hand, trying to fit complex multidimensional data into a 3D environment is a foolish idea. There are many highly efficient and perfectly usable 2D graphing techniques available. The cost of navigation and lost clarity does not outweigh the advantages of only having to drop 997 dimensions, as opposed to 998, especially when the the 3D environment will then have to be projected on a 2D screen, anyway.

    4. Re:DNA got there first by Reality+Master+101 · · Score: 1

      Remember when Zaphod Beeblebrox fixes things in the galactic accounting system by entering a virtual old-style accounting world?

      I'm as big a DNA fan as anyone, but you must not be that old. They've been talking about 3D data visualization (and other forms of virtual reality) for about 50 years now.

      --
      Sometimes it's best to just let stupid people be stupid.
    5. Re:DNA got there first by StormReaver · · Score: 2, Insightful

      > How many people who think they are information literate produce incomprehensible spreadsheets and graphs that conceal reality?

      And that is why this "technology" won't displace any current business methods. Producing business data in 3D won't tell you anything more interesting than it will in 2D (with the exception of a few specialized fields which already represent their data in 3D). Anyone unethical enough to intentionally hide business reality in 2D will still unethically hide business reality in 3D. This is not magic pixie dust that will eliminate white collar deceit and crime. It is just another way to show the same data we've been showing since the invention of business graphics.

      There will be no additional business specialty that doesn't already exist. This is a neat tinker toy, and nothing more. The author is just very easily impressed.

    6. Re:DNA got there first by arkowitz · · Score: 2, Insightful

      Tufte unfortunately did not have an actual 3D world in which to experiment. He was stuck on the page. Screenshots are bullshit no matter what you do; 3D requires motion. Try it someday. Arkowitz

    7. Re:DNA got there first by arkowitz · · Score: 4, Insightful

      The magic pixie dust is the realtime collaboration. That's why it matters that the data is in the virtual world. Also, I have to respectfully disagree with your assumption that using three dimensions to display data gets you no more understanding than using two. Just the ability to see time, grouping, and magnitude all at once exposes relationships that were not obvious in two dimensions. This is why scientists have been using 3+D visualization for a long time. Why not apply the same techniques to business and to government? Arkowitz

    8. Re:DNA got there first by Tablizer · · Score: 1

      when marketing demands more color, more widgets and exciting background sound tracks, tell them to go fornicate off.

      Being employed and being right sometimes conflict. In this bad economy, I'll pick the first for now. They want dancing teddy bears, I'll give them dancing teddy bears. Just shower extra long when you get home.
           

  8. Ford Prefect's Expense Account by Anonymous Coward · · Score: 0

    Another idea from Douglas Adams stolen and put forward as original.

  9. New excuse by clarkkent09 · · Score: 5, Funny

    No boss, I'm not playing rpg games at work, I'm working on my quarterly sales report

    --
    Negative moral value of force outweighs the positive value of good intentions.
  10. Loot by castorvx · · Score: 1

    What drops?

  11. Has to be asked... by Linker3000 · · Score: 1

    Has someone been watching TRON? "Bring in logic probe!"

    --
    AT&ROFLMAO
    1. Re:Has to be asked... by arkowitz · · Score: 1

      hey man that's one of my favorite movies.

    2. Re:Has to be asked... by Tim_UWA · · Score: 2, Funny

      Yes... I mean no

  12. Eye candy by jayemcee · · Score: 1

    This is for the CEO of a small bioitech to pitch his shill to the VC, hard to imagine a molecular biologist seeing any need for it...

  13. ObDilbert by Anonymous Coward · · Score: 0

    I can't help but notice that most of the objects are purple.

    1. Re:ObDilbert by SQLGuru · · Score: 1

      But Mauve has the most RAM.

    2. Re:ObDilbert by Linker3000 · · Score: 2, Funny

      This is to prevent rouge programs.

      --
      AT&ROFLMAO
  14. Cathartic by clarkkent09 · · Score: 2, Funny

    Users can see data, and drill into it; re-sort it; explore it interactively - all from within a virtual world.

    Can you shoot at a stock prices chart until it explodes in a huge fireball? Can you chop it up with an axe? Can you take a dump on it? I can see some value in this after all

    --
    Negative moral value of force outweighs the positive value of good intentions.
  15. Make it look like hackers by insomniac8400 · · Score: 1

    Now just set up a file system that looks like buildings.

  16. You couldn't make this up... by BlackSabbath · · Score: 1, Insightful

    From the article:
    "First off I believe that visualization of money in/money out could have turned authorities on to the fishy accounting Enron was up to, and caught them earlier. Perhaps better visualization would have revealed Madoffâ(TM)s ponzi scheme as well."

    Hahahahahahaha....hmmm...maybe?...nah!....
    HAHAHAHAHAHAHAHAHAHAHAHAHAHA!

    Priceless!

    1. Re:You couldn't make this up... by BlackSabbath · · Score: 2, Interesting

      In a slightly more considered tone I will say this:

      This tool (assuming it has some diagnostic benefits), can be just as easily deployed to mislead as to inform. Anybody that's looked at company reports knows they're full of graphs that for the most part tend from lower left to upper right. "That's good isn't it?"

    2. Re:You couldn't make this up... by arkowitz · · Score: 1

      Yes, garbage in garbage out. There has to be a mechanism to vet data. Let's see, I think in the scientific community it's called peer review... Arkowitz

    3. Re:You couldn't make this up... by Anonymous Coward · · Score: 0

      Indeed. However, I didn't mean so much that the data itself could be wrong (although that is certainly possible). What I meant was that what you see is not always the full picture. Its not that the numbers are necessarily "buried" in some report, but that the multitude of interlinked companies related through convoluted paths, across jurisdictions, makes a clear picture of the totality most unlikely regardless of the tools used.

      The problem of corporate malfeasance is not one of lack of appropriate diagnostic tools (although they certainly help). Its that the playing field itself lends an air of opaqueness that is difficult to pierce.

    4. Re:You couldn't make this up... by BlackSabbath · · Score: 2, Insightful

      The above post (AC) belongs to me. For some reason I was logged in to one tab but not in another (FF 3.07). Weird.

    5. Re:You couldn't make this up... by arkowitz · · Score: 1

      I agree with you, and I also think this raises major issues around the extent to which we want the government to have access to information. The truth is a double-edged sword and hopefully we will someday have a system where the government has the data and analysis tools to catch the Enrons of the world, and the public has the data and tools to catch the governments when they abuse power.

  17. I've looked at this... by argent · · Score: 2, Informative

    It works, surprisingly well, but it really needs a richer scripting environment than Second Life provides to really produce good feedback. Also, it would benefit from having the ability to manage and maintain the parameters of the display outside the 3d world, because editing and retyping a database query in "chat" is not pretty.

    1. Re:I've looked at this... by arkowitz · · Score: 1

      Try the new beta! There's an applet which runs via Java webstart, and gives you a UI for defining graphs - no more typing commands in chat. Arkowitz

    2. Re:I've looked at this... by argent · · Score: 1

      Oh good. Instead of a small simple web page with a set of pulldowns, a command line and history, which could be implemented without even involving javascript and would be simple enough to run in a secure browser, they do something that needs JAVA?

      Who came up with that idea? Bergholt Stuttley Johnson?

    3. Re:I've looked at this... by arkowitz · · Score: 1

      Look mon. Java is a sweet technology; the java app run through webstart (rather than applet within a browser sandbox [though you can still use the JApplet class :)]) is a great way to write code which can access the local filesystem, open sockets, do all the things a real programmer would want to do. Besides, one needs JRE or JDK 6 anyway to run the lg3d-wonderland application. Come on. Microsoft, whom you may or may not dislike strongly (I worked there in Redmond for a year and I am not a fan), screwed Java in a big way by "embracing and extending" it... J++ or whatever the **** they were calling it. The power of the Java applet-cation remains largely untapped while people keep muddling around with web-based applications. All those layers. They are actually counterproductive sometimes! Arkowitz

    4. Re:I've looked at this... by arkowitz · · Score: 1

      what? no pro-Java meta-moderatoroators? I should get a 4 on this at least...

    5. Re:I've looked at this... by argent · · Score: 1

      Besides, one needs JRE or JDK 6 anyway to run the lg3d-wonderland application.

      I have no idea what it's like in Sun's virtual world environment, I looked at it in Second Life.

      Java is a sweet technology; the java app run through webstart (rather than applet within a browser sandbox [though you can still use the JApplet class :)]) is a great way to write code which can access the local filesystem, open sockets, do all the things a real programmer would want to do.

      No thanks, I don't care whether they call it "Java Webstart" or "ActiveX", that whole class of technologies is a non-starter for me. No web content outside a sandbox, thanks.

    6. Re:I've looked at this... by arkowitz · · Score: 1

      It's not web content. I have no interest in "web content". The program is actually an instance of Glasshouse; it can access an Excel file locally and transmit visualization definitions to, and respond to commands received from, a virtual world through use of a protocol we created called CICP. The web is just a way to launch it. One benefit of this is we don't have to be in the business of storing people's data files. They never get uploaded; the application running on people's local pc's produces the visualizations. This also allows visualization of a database inside the firewall, within a virtual world that is outside the firewall.

    7. Re:I've looked at this... by argent · · Score: 1

      The web is just a way to launch it.

      Having the ability to launch unsandboxed code directly from the web is inherently insecure. If I am going to run unsandboxed code I'm going to download and install it, explicitly, as a local application. Anything else makes it too easy for "this application is going to install a virus on your computer, OK/CANCEL" type attacks.

    8. Re:I've looked at this... by arkowitz · · Score: 1

      The ability is there, and I'm using it. You know it's weird that I'm having this frustrating argument with a guy who hand-codes his html, optimizes for lynx, and is (or was?) an Amiga user. These are all things I respect, and have in common with you. And hey, even a total hatred of EJB, despite my use of Java.

    9. Re:I've looked at this... by argent · · Score: 1

      The ability is there, and I'm using it.

      It's people using things like this that turn them from security holes into security tarpits.

    10. Re:I've looked at this... by arkowitz · · Score: 1

      Are you against people creating any software designed to run locally on a PC, or just programs written in Java?

    11. Re:I've looked at this... by argent · · Score: 1

      I'm against the use of any facility that downloads and runs unsandboxed content directly from a web page, with or without "do you really want to infect your computer" dialogs. If it's going to run outside a sandbox, then the user should explicitly download and explicitly install it.

    12. Re:I've looked at this... by arkowitz · · Score: 1

      Webstart lets us package everything as an appliance which can be placed behind a customer's firewall and gives their people access to the local piece of the software without requiring installs.

      Again, the reaon for running locally is so that people can choose what to visualize, whether it be an Excel spreadsheet or a SQL query hitting any JDBC-accessible db, and the server doesn't have to have the data - only the visualization definition.

      While I could certainly take the same application and require people out there on the Internet to install it in order to try out our beta, rather than just clicking it and then approving it to run via webstart, I'm not in the business of making things more difficult.

      You've found a nice little point to make about security - more power to you. It would be cool if Slashdot had a "simultaneous post" thing so we could end this thread without one of us having to have the last word.

    13. Re:I've looked at this... by argent · · Score: 1

      Webstart lets us package everything as an appliance which can be placed behind a customer's firewall and gives their people access to the local piece of the software without requiring installs.

      Not precisely. What it does is let you hide the install behind a "security dialog".

      I spent almost a decade cleaning up after people who clicked the wrong thing in these kinds of dialogs.

      This isn't a "nice little point about security", this is the biggest security problem I had to face as a system/network admin from 1997 (when Microsoft introduced this as 'Active Desktop') until I quit that job. This whole approach is inherently insecure and unfixable. Everyone who uses and promotes it is part of the problem.

    14. Re:I've looked at this... by arkowitz · · Score: 1

      Would you at least agree that if it is deployed on an appliance sitting behind the firewall, and not public on the Internet, that it is not contributing to the problem?

    15. Re:I've looked at this... by argent · · Score: 1

      "Intranet" use of ActiveX has been frequently mentioned as justification for not killing it, so no. It is not possible to design this technology so it's safe. The closest is Firefox XPI installers, and they're more annoying to sit through than downloading a package and installing it would be. It's not acceptable, whether it's ActiveX, Webstart, Internet-enabled disk images, "Open Safe Files After Downloading", or XPI.

    16. Re:I've looked at this... by arkowitz · · Score: 1

      What if we deployed it in a boat, with a goat?

  18. These tools.. by mewsenews · · Score: 2, Interesting

    .. always seem fun and then never seem to go anywhere. Anyone else remember psDooM? Blast away unwanted processes with a shotgun? Sounds great, right?

    Well.. turns out, when you actually want to terminate a process, Windows Task Manager, or ps & kill are vastly more efficient, effective, and obvious tools to do the job.

  19. Not all that original... by Anonymous Coward · · Score: 0

    This company doing the same thing, but specialized to financial market data: www.aqumin.com.

  20. Earlier generation was "Adventure Shell" by billstewart · · Score: 5, Interesting


    You are in a small dusty directory called "$HOME".
    A stairway called ".." leads up and a stairway called "docs" leads down.
    There are files here.
    > throw file "foo" at lineprinter daemon.
    The lineprinter daemon eats your file and belches.
    > Delete file "bar"
    What? With your bare hands?

    Doug Gwyn's Adventure Shell added a layer of Adventure-like syntactic sugar to the regular Bourne Shell. It wasn't terribly useful, but it was fun for 15 minutes, and since it was written in shell, you could hack on it yourself, and everything worked relatively normally.

    If I were using the 3D visual interface, I'd expect my data to be slightly out of focus and to get carried off by pterodactyls if I didn't pay enough attention to everything at once...

    --

    Bill Stewart
    New Fast-Compression-only CPR http://preview.tinyurl.com/dy575ks
  21. Virtual too bad for ya bro by Anonymous Coward · · Score: 0

    "Man what I wouldn't give to mash my level 80 death knight up with some of the ugly joins I have run across in the past."

    Still can't get laid, huh.

  22. 3D got there first by Ostracus · · Score: 1

    It cam be more than that when local frames of reference and their magnitudes along individual axis are considered. In other words X+,X- (same with other axis) with respect to point of local origin can represent different things. Add in other qualities like color, texture, transparency, and even sound (everyone neglects sound) along with positional relationship to other frames as well as time and the information density can be higher than 2D

    The main question for 3D representations are the prevention of information overload, and focusing on the relevant to the task at hand.

    I think we'll see a growth with this as 3D hardware matures.

    --
    Shai Schticks:"You don't make peace with friends, you make peace with enemies"
  23. Survival got there first by Ostracus · · Score: 2

    They are if the company's small, private, and doesn't have the concept of a "golden parachute" for anyone.

    --
    Shai Schticks:"You don't make peace with friends, you make peace with enemies"
  24. "The power of interacting with data in 3D..." by SystematicPsycho · · Score: 1

    Isn't that what data warehousing is for, OLAP - Online Analytical Processing? Slicing data into cubes in a multi-dimensional space? Which has only been around for two+ decades?

    --
    Analytic & algebraic topology of locally Euclidean meterization of infinitely differentiable Riemmanian manifold
    1. Re:"The power of interacting with data in 3D..." by arkowitz · · Score: 1

      An OLAP database is the perfect backend for Glasshouse. What OLAP has been missing is a 3D user interface; now it's here.

  25. This is stupid by Anonymous Coward · · Score: 0

    I deal with Second Life every day, I work on specs and code relating to the client and even the open-source server components and even I think this is stupid. It's crap like this which makes me post under Anonymous Coward.

  26. WTF with the WoW references? by Anonymous Coward · · Score: 0

    "Man what I wouldn't give to mash my level 80 death knight up with some of the ugly joins I have run across in the past."

    You are pathetic. Are you so starved for approval that you have to "offhandedly" mention your MMO characters in articles that have nothing to do with games? You should stop.

  27. Golden Thingies by Anonymous Coward · · Score: 0

    They are if the company's small, private, and doesn't have the concept of a "golden parachute" for anyone.

    But, when I worked for a giant publicly held US company we had that "golden thingy" whether we liked it or not! Oh, wait, that was a golden shower.

    Never mind.

  28. Not part of the solution. by argent · · Score: 1

    I don't think that's part of the solution.

    In fact, if you put a boat in a goat, pretty soon you're going to have a bunch of precipitate to deal with.

    1. Re:Not part of the solution. by arkowitz · · Score: 1

      Well it seems the only thing you will accept is if it's in a box with a firefox.

    2. Re:Not part of the solution. by argent · · Score: 1

      No, no, firefox is part of the precipitate too.

  29. More visualization; email inbox in a virtual world by rexping · · Score: 1

    I used neural networks to categorize data first.. read yourself.