MySQL uses MyISAM as the default storage engine, which is based on older ISAM code but comprises many useful extensions. The MyISAM comprises three files having extensions- .frm, .MYI, and .MYD that are used to properly store the data. The MYI extension in MyISAM storage engine stands for MyIndex and refers to the index file in which table’s indexes are stored.
Microsoft SQL Server, the most preferred back-end (database) utility among organizations because of its scalability, consistency, and familiarity with users. A user of SQL Server uses SQL Server Management Studio (SSMS) to query character data from the database where non-Unicode data types like char, varchar, etc. are used. When the SSMS is being used to query the character data, you may not receive the accurate character data rather you may come across the following problems:
The DBCC DBREINDEX is a transactional-SQL command that reconstructs one or more indexes for a table in the SQL database file. Additionally, DBCC SHRINKDATABASE is a T-SQL command used to shrink the size of the data and register files in the particular database. In case both these commands are executed at the same time on a particular table, it is subjected to corruption. Therefore, with corruption issues, if the user is not having any back up, he can recover the table by utilizing effective SQL recovery software.
Secure Digital (SD) is small and thin but high capacity memory card, which has storage capacity in the range of 1MB to 4GB. SD cards are used in small portable devices like digital cameras, camcorders, audio players, mobile phones, etc. to enhance their memory. They are designed to support various files like image files, audio files, video files, etc. However, like other storage devices SD cards are also prone to corruption and data loss.
Hard disk is a non-volatile storage device used to store data. One can store data in various formats on hard disk. The data you store on hard disk can be personal or official. Whether the data is personal or official, it is very important for you. While on the other hand, being an electronic media, hard drive can be crashed any time leaving you blank handed. Losing all of your important data can thrill you.
Working with computers is all about managing documents and files. Both, home users and officials on regular basis deal with lots of documents and files. The document/file they manage can be a word file, excel file, executable software file, image file, or any other type of file depending on their work. Suppose you are creating an important document from last 25 days, which you have to submit in your organization after 5 days. One day while working with the document, you accidentally press the DELETE key or due to any other reason like virus attack, the document gets deleted.