IO - CRUD (Create/Read/Update/Delete) - basic functions of persistent storage

Card Puncher Data Processing

About

In computer programming, create, read, update and delete (as an acronym CRUD) are the four basic functions of persistent storage.

Operation

Operation SQL HTTP File System mutator
Create INSERT PUT / POST write Row Level
Read (Retrieve/Query) SELECT GET read / take -
Update (Modify) UPDATE POST / PUT write Field Level
Delete (Destroy) DELETE DELETE delete/dispose Row Level

Principle

Documentation / Reference





Discover More
Undraw File Manager Re Ms29
File - Persistent Storage Operations

In a file system, the basic persistent storage operations that permits to manage the file content are called: create - Creates a new file and open it write - Opens the file for write access (append...
Process Explorer Handle Open File Search
File System - File Descriptor or Handle (Open File)

A file descriptor (Unix, Linux) or a file handle (Windows) is the connection id (generally to a file) from the Operating system in order to perform IO operations (Input/Ouput of Bytes). For Wikipedia,...
HTTP - DELETE

delete is a http request method that should perform a data delete operation
Card Puncher Data Processing
IO - Create Operation

create is a IO operation that will add/insert/create data in a data store. The following command are create operation: SQL: INSERT HTTP: PUT / POST File: Write
Card Puncher Data Processing
IO - Write

A write is a persistent storage operation that write data into a storage device The storage device performs write one sector at at time The OS file system write abstracts the storage device write....
Sorting Quicksort Anim
Performance - Constant Time - O(1)

A algorithm executes in constant time if no matter how large N is, it will always execute with the same latency (time). In Big O notation, it performs as A hashmap performs the IO operation get and...
Data System Architecture
SQL - DELETE

delete is a sql clause that will delete data. It's one of the basic function of persistent storage.
Data System Architecture
Shared Lock

A shared lock is a lock acquired in the shared mode over a data structure. The data structure can be any: from a file to any in-memory structure (ie variable with a complex type, generally a collection)...
Data System Architecture
State - Mutable

A state who is mutable can be changed. Mutation happens with mutator method: in CRUD term, they are known as Create, Update, Delete at a object level, they are known as the mutator method (ie set,...
Data System Architecture
Structured Query Language (SQL)

SQL is the standard language used to operate on table and its auxiliary data Structure (such as view, aggregate,...). SQL permits application designers to manipulate sets of rows with a non-procedural...



Share this page:
Follow us:
Task Runner