Database machine

A database machines or back end processor is a computer or special hardware that stores and retrieves data from a database. It is specially designed for database access and is tightly coupled to the main (front-end) computer(s) by a high-speed channel, whereas a database server is a general-purpose computer that holds a database and it's loosely coupled via a local area network to its clients.

Database machines can retrieve large amount of data using hundreds to thousands of microprocessors with database software. The front end processor asks the back end (typically sending a query expressed in a query language) the data and further processes it. The back end processor on the other hand analyzes and stores the data from the front end processor. Back end processors result in higher performance, increasing host main memory, increasing database recovery and security, and decreasing cost to manufacture.

NCR Teradata Worldmark 5100 system (2002)

History

Britton-Lee (IDM), Tandem (Non-Stop System), and Teradata (DBC) all offered early commercial specialized database machines.^[1] A more recent example was Oracle Exadata.

Criticism and suggested remedy

^{[clarification needed]}

According to Julie McCann,^[2]

"Finally, back in 1983 Boral predicted the demise of the Database Machine (DBM) and he was right to an extent [5].^[3] DBM architectures based on specialised hardware or tightly coupled to specific specialised machines were always going to be problematic. However as componentisation dissolves the DBMSs architecture into components and that this is integrated, without boundaries, with the operating system (which in turn only activated the components that are required by the DB function, thus tailoring the architecture down to the metal), means that at that instant the system becomes effectively a Database Machine but potentially without the problems of standardisation and portability of the past."

See also

• Content Addressable File Store (CAFS)

References

1. Ricardo, Catherine M. (2002). "Database Machines". Encyclopedia of Information Systems. Academic Press. pp. 403–410. doi:10.1016/B0-12-227240-4/00027-7. ISBN 978-0-12-227240-0.
2. Mccann, Julie A. (2003). "The Database Machine: Old Story, New Slant?" (PDF). First Biennial Conference on Innovative Data Systems Research, CIDR 2003, Asilomar, CA, USA, January 5-8, 2003, Online Proceedings. Conference on Innovative Data Systems Research (CIDR) (1 ed.). Asilomar, CA, USA.
3. Boral, Haran; DeWitt, David J. (1983). Database Machines: An Idea Whose Time Has Passed? A Critique of the Future of Database Machines (Report).

Further reading

• Berra, P. Bruce. “Data base machines.” SIGIR Forum 12, 3 (Winter 1977), 4–23. https://doi.org/10.1145/1095317.1095318
• Banerjee, Jayanta. “Data structuring and indexing for data base machines.” In Proceedings of the fifth workshop on Computer architecture for non-numeric processing (CAW '80). Association for Computing Machinery, New York, NY, USA, 11–16. https://doi.org/10.1145/800083.802687
• Song, Siang Wun. “A Survey and Taxonomy of Database Machines.” IEEE Database Eng. Bull. 4 (1981): 3-13.
• Hoffer, Jeffrey A.; Alexander, Mary B. “The diffusion of database machines.” SIGMIS Database 23, 2 (Spring 1992): 13–19. https://doi.org/10.1145/141342.141352