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.
History
Britton-Lee (IDM), Tandem (Non-Stop System), and Teradata (DBC) all offered early commercial specialized database machines.{{cite encyclopedia |title=Database Machines |encyclopedia=Encyclopedia of Information Systems |year=2002 |last=Ricardo |first=Catherine M. |pages=403–410 |publisher=Academic Press |doi=10.1016/B0-12-227240-4/00027-7 |isbn=978-0-12-227240-0 }} A more recent example was Oracle Exadata.
Criticism and suggested remedy
{{Clarify|date=May 2024|reason=This is interesting, but seems a bit out of context for someone not familiar. What are the implications, and can this be put in a historical context?}}
According to Julie McCann,{{cite conference |url=https://www.cidrdb.org/cidr2003/program/p6.pdf |title=The Database Machine: Old Story, New Slant? |first=Julie A. |last=Mccann |author-link=Julie McCann |year=2003 |conference=Conference on Innovative Data Systems Research (CIDR) |conference-url=https://www.cidrdb.org/cidr2003/program/program.html |edition=1 |book-title=First Biennial Conference on Innovative Data Systems Research, CIDR 2003, Asilomar, CA, USA, January 5-8, 2003, Online Proceedings |location=Asilomar, CA, USA |language=English }}
{{Blockquote
|text="Finally, back in 1983 Boral predicted the demise of the Database Machine (DBM) and he was right to an extent [5].{{cite report |author1-first=Haran |author1-last=Boral |author2-first=David J. |author2-last=DeWitt |date=1983 |title=Database Machines: An Idea Whose Time Has Passed? A Critique of the Future of Database Machines |url=https://minds.wisconsin.edu/handle/1793/58446?show=full }} 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
References
{{Reflist}}
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. “[http://sites.computer.org/debull/81DEC-CD.pdf 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
{{Database}}
{{compu-hardware-stub}}