Create, read, update and delete

Create, read, update and delete

In computer programming, create, read, update and delete (CRUD) are the four basic functions of persistent storage.[1] Sometimes CRUD is expanded with the words retrieve instead of read or destroy instead of delete. It is also sometimes used to describe user interface conventions that facilitate viewing, searching, and changing information; often using computer-based forms and reports. The term was likely first popularized by James Martin in a 1983 book titled "Managing the Data-base Environment".[2]

Contents

Database applications

The acronym CRUD refers to all of the major functions that are implemented in relational database applications, that are considered as complete application. Each letter in the acronym is mapped to a standard SQL statement:

Operation SQL HTTP/REST
Create INSERT POST
Read (Retrieve) SELECT GET
Update UPDATE PUT
Delete (Destroy) DELETE DELETE

Although a relational database is a common persistence layer in software applications, there are numerous others. CRUD can be implemented with an object database, an XML database, flat text files, custom file formats, tape, or card, for example.

User interface

CRUD is also relevant at the user interface level of most applications. For example, in address book software, the basic storage unit is an individual contact entry. As a bare minimum, the software must allow the user to:

  • Create or add new entries
  • Read, retrieve, search, or view existing entries
  • Update or edit existing entries
  • Delete/deactivate existing entries

Without at least these four operations, the software cannot be considered complete. Because these operations are so fundamental, they are often documented and described under one comprehensive heading, such as "contact management" or "contact maintenance" (or "document management" in general, depending on the basic storage unit for the particular application).

See also

Notes

  1. ^ InfoWorld | Developer World | REST and CRUD: the Impedance Mismatch | January 29, 2007 06:00 AM | By Martin Heller
  2. ^ James Martin, Managing the Data-base Environment, Prentice-Hall, 1983



Wikimedia Foundation. 2010.

Игры ⚽ Нужна курсовая?

Look at other dictionaries:

  • List of computing and IT abbreviations — This is a list of computing and IT acronyms and abbreviations. Contents: 0–9 A B C D E F G H I J K L M N O P Q R S T U V W X Y …   Wikipedia

  • Read-copy-update — (RCU) is an operating system kernel technology for improving performance on computers with more than one CPU.More technically it is a synchronization mechanism which can sometimes be used as an alternative to a readers writer lock. It allows… …   Wikipedia

  • CRUD — Create Read Update Delete (Computing » Software) *** Create, Retrieve, Update, Delete (Computing » General) *** Create Read Update And Delete (Computing » General) * Chalk River Unidentified Deposits (Governmental » US Government) * Customer… …   Abbreviations dictionary

  • Computers and Information Systems — ▪ 2009 Introduction Smartphone: The New Computer.       The market for the smartphone in reality a handheld computer for Web browsing, e mail, music, and video that was integrated with a cellular telephone continued to grow in 2008. According to… …   Universalium

  • Comparison of MySQL database engines — This a comparison between the two primary database engines (InnoDB and MyISAM) for the MySQL database management system (DBMS). A database engine (or storage engine ) is the underlying software component that a DBMS uses to create, read, update… …   Wikipedia

  • Django (web framework) — Django The default Django page Developer(s) Lawrence Jou …   Wikipedia

  • Document-oriented database — A document oriented database is a computer program designed for storing, retrieving, and managing document oriented, or semi structured data, information. Document oriented databases are one of the main categories of so called NoSQL databases and …   Wikipedia

  • Data access object — This article is about the data access object design pattern in object oriented software design. For the Microsoft library of the same name, see Data Access Objects. In computer software, a data access object (DAO) is an object that provides an… …   Wikipedia

  • Crap — Crap(s) may refer to: Crap, a slang word for feces, also used to describe something substandard Craps, a casino dice game Crap Grisch, a mountain in the Lepontine Alps, situated near Vals in the canton of Graubünden in Switzerland Crap la Pala, a …   Wikipedia

  • Scaffold (programming) — Scaffolding is a meta programming method of building database backed software applications. It is a technique supported by some model view controller frameworks, in which the programmer may write a specification that describes how the application …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”