Lance's questions

I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine?

Can you import .dmp files into PostgreSQL or other SQL/NoSQL databases that are easy to get running on a Mac (MySQL, SQLite3, MongoDB)?

If not, what are the options? Even being able to convert the .dmp to a CSV for free would work.

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I am not sure if by RAM they mean only memcached, or something else.

My questions are:

• Can entire SQL databases be stored in RAM? I'm thinking sharding and all that here... Just learning (not from a db background).
• Are SQL database indexes stored in RAM?
• Are NOSQL databases stored in RAM? Can they be?
• Or is Memcached the standard for storing things in RAM? So 99% of requests read from RAM (Memcached), and the database (disk) is a backup?

Just looking for a point in the right direction.

I am wondering where to begin with database scaling/optimization strategies. After reading articles like highscalability.com's facebook architecture article, and this twitter architecture article, I am not sure if by RAM they mean only memcached, or something else.

My questions are:

• Can entire SQL databases be stored in RAM? I'm thinking sharding and all that here... Just learning (not from a db background).
• Are SQL database indexes stored in RAM?
• Are NOSQL databases stored in RAM? Can they be?
• Or is Memcached the standard for storing things in RAM? So 99% of requests read from RAM (Memcached), and the database (disk) is a backup?

Just looking for a point in the right direction.