What is the CRUD cycle?
The CRUD cycle describes the elemental functions of a persistent database. CRUD stands for Create, Read, Update and Delete. (Retrieve may occasionally be substituted for Read.) These functions are also descriptive of the data life cycle.
Different users may have different CRUD cycles based upon the requirements of the system. A customer, for instance, might have the ability to create an account, retrieve it upon return to a website, update billing information, or delete it if necessary. An operations manager, by contrast, might create product records, call them up as needed, modify packaging or raw materials details or delete it if the product was discontinued.
The CRUD cycle is at the heart of most dynamic websites, especially those created during the Web 2.0 era. In this paradigm, both users and administrators have privileges to create, browse, edit or delete online records.
The first reference to the CRUD cycle was made by Haim Kilov in 1990 in an article entitled "From semantic to object-oriented data modeling."