ChrisA is right...
I hacked a "split/Y" USB cable (designed to power an external 2.5" HD using 2 USB ports) and replaced the mini USB connector with a standard female USB connector.
I tested the franken-cable with several USB devices (including the external 2.5" HD it came with) and it works fine.
However, it fails to work with the MacBook Air SuperDrive, regardless on how I "inject" power to the second USB connector (I tried a separate hub as well as a dedicated 1A USB power supply similar to the one supplied with the iPhone)!
My franken-cable works fine on the MacBook Air.
Bottom line: the MacBook Air SuperDrive is always recognized on Macs and PCs as a USB mass storage device (optical drive), but doesn't power up on anything but the MacBook Air.
My franken-cable does not work because the MacBook Air SuperDrive is requesting power from the computer or hub connected to the first USB connector (the data one), and gets a "no" reply, thus never powers up the drive mechanism in order to protect the port, regardless of how much power is actually supplied.
It would not work. The way USB works is that a device when you plug it it will send a request for a certain amount of power. It says something lke "I need 500 milliwatts" the hub can respond with a "yes" or a "no". The problem here is that the new DVD drive is asking for an amount of power that every USB port built today except one will send a "No". If is a software issue All ports are current programmed to say "no".
Typically the way this works is the hub will keep track of the power being used by all devices plugged in so if you split the USB cable it can't work because the total is still to large the the second plug in the Y-cable will get the "no" answer. OK possibly you can use two powered hubs and plug one part of the Y-cable into each hub. What a hassel, who'd do that. Better to simply buy a DVD that uses a power brick.
By convention if the device uses only some very, small amount of power it need not ask for more. A USB memory stick I doubt as to ask the hub for power. Likewise the DVD at first uses this method when you first plug it in so that it can run just enough to ask for more power.