What is a in memory database? thatis usually used in a computer .. is it a software, or a external?

An in-memory database is data management software that runs in-memory (RAM), as opposed to on-disk. The advantage to running data in-memory is that it is very fast but volatile. If the database crashes, you lose your data. There are methods to preventing data loss but that is another case.