What Are The Limitations Of Microcomputer Based Databases?

Limitations of microcomputer based databases are:
The development of many independent microcomputer-based database systems within an organization leads to problem of redundancy and inconsistency of data. The same problems that plugged traditional file systems can arise in the organization. Hardware storage limitations may restrict the size of files severely, so that microcomputers cannot support very large databases using current storage media. Processing speed also limits the size of database that can be supported. The database management software may be less sophisticated, since the code may be design to fit in smaller main memory.

Some microcomputer operating systems are not design to provide all functions of mainframe computers, resulting in less efficient use of resources. Backup and recovery system are often minimal and are under user control. Unsophisticated users may not understand the need for backup, resulting in data loss. Organization wide data Standards may be nonexistent or ignored by users. The end user generally not capable of designing as well as an expert trained in designed technique would be.

The resulting database may not be efficient or flexible enough to handle changing information needs. Independent, user selected systems may be incompatible. If users decide that they want to share data, linkage of the separate system presents a major technical challenge.