Desktop Database

Why Trust Techopedia

What Does Desktop Database Mean?

A desktop database is a database system that is made to run on a single computer or PC. These simpler solutions for data storage are much more limited and constrained than larger data center or data warehouse systems, where primitive database software is replaced by sophisticated hardware and networking setups.

Advertisements

Techopedia Explains Desktop Database

Common desktop database systems like Microsoft Access enable easy installation on a computer and a relatively user-friendly database environment. By attaching a desktop database to a simple server network, companies can take advantage of more straightforward IT setups to store a variety of data. While desktop databases may be Open Database Connectivity (ODBC) compliant and offer a range of functionality for smaller data sets, they do not generally support the kinds of advanced predictive analytics and data mining that so many modern companies want included in their software architectures. That’s why modern database design is going far beyond the desktop database to database systems that may be composed of dozens of hardware pieces, multiple servers and virtualized network environments, as well as advanced data handlers that will move data pieces around in a much more complex trajectory than those supported by a desktop database system.

Advertisements

Related Terms

Margaret Rouse
Technology Specialist
Margaret Rouse
Technology Specialist

Margaret is an award-winning writer and educator known for her ability to explain complex technical topics to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles in the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret’s idea of ​​a fun day is to help IT and business professionals to learn to speak each other’s highly specialized languages.