well not really compressed. the camera doesn't capture at a certain PPI (don't use DPI, that's a common misuse when speaking about digital images, DPI is DOTS per inch, used in printing, PPI is pixels per inch) the camera just captures an image of certain pixel dimensions. way to think about this is... well, you're over thinking it. throw away your idea of ppi and image capture and stuff and just think about the pixel dimensions. again, the resolution you see in photoshop or bridge is an arbitrary number chosen by the program. this confuses TONS of people so don't be embarrassed, and im certainly not trying to insult you if i sound a bit stern at times - this is fun and educational for me too! let's look into a real world scenario:
My Canon 1Ds Mark II captures images that are 4992 x 3328 pixels.
Now, before i go back into this, it's important to point something out. Again, resolution (PPI) only matters for printing. I mean, it's kind of a reference point in cases to determine if a file is optimized for the specific printer it will be printed on. However, when you're dealing with web images or other photos just to be displayed on your computer, PPI does not matter at all. Now that doesn't mean you should get in the practice of setting image ppi's at random numbers, but just to give you an idea, I'll cover a common misconception here. A lot of people think that the PPI of an image changes its file size (in megabytes.) This simply isn't true.
Let's take this image from my 1Ds Mark II - captured at full resolution, processed in Adobe Lightroom. I've exported it as a level 12 JPEG and opened a finder window in Mac OS X for this example. In the screen capture below, I've selected one of the examples, which I exported with a resolution setting of 72ppi. (By the way, I just slugged the ppi number into the filename for reference.) Note the file size is 5.5 megabytes, and down towards the bottom, you can see the pixel dimensions of 3328x4992.

Now, here's the details on the one I exported with a resolution setting of 300ppi...

And look at that... 5.5 megabytes!