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."

Read more about CRUD cycle: - Andrew Novick wrote "Implementing CRUD Operations Using Stored Procedures" for Database Journal. - Martin Heller blogged about "REST and CRUD: the Impedance Mismatch" for InfoWorld. - Roger Wolter and Kirk Haselden commented on differing CRUD cycles for master data management subject areas at MSDN.com.

Do you have something to add to this definition? Let us know. Send your comments to techterms@whatis.com

Digg This!     StumbleUpon     Del.icio.us