ACID – The acronym standing when it comes to properties maintained by standard database administration systems, standing for Atomicity, Consistency, Isolation, and Durability.
Application Server – a host that processes application-specific database operations produced from application customer programs. The DBMS is in-process with all the application rule for quickly interior access.
Aperiodic Server – computer Software that is particular to a certain system that is embedded. Such code that is application-specific generally speaking constructed on a layered architecture of reusable components, such as for example a real-time operating-system and community protocol stack or any other middleware. Then this term may not be used if there is no such architecture. The application form application is not likely to be reusable across embedded platforms, mainly because each embedded system has an application that is different.
Atomicity – the house of the deal that guarantees that either all or none of this noticeable changes produced by the deal are written into the database.
AVL-Tree – An AVL tree is a self balancing search tree that is binary.
Big-Endian – a data representation for the multibyte value which includes the most crucial byte stored in the cheapest memory target. Remember that only the bytes are reordered, never ever the nibbles or bits that comprise them. Every processor stores its information either in big-endian or format Anchorage dating ideas that is little-endian. Sun’s SPARC, Motorola’s 68k, and also the PowerPC families are typical big-endian. The Java machine that is virtual big-endian too. Similarly, every communications protocol must define the byte order of its values that are multibyte. TCP/IP makes use of big-endian representation.
BLOB – An abbreviation for Binary Large OBject. In SQL, BLOB may be a basic term for any information of type long varbinary, long varchar, or long wvarchar. Additionally it is a particular term (and synonym) for data of type long varbinary.
Breakpoint – an area in a scheduled system of which execution is usually to be stopped and control of the processor switched towards the debugger. Mechanisms for producing and eliminating breakpoints are supplied by many debugging tools.
B-tree – An indexing technique when the values for the columns found in the index are effectively maintained in sorted purchase that also provides quick access (three to four extra disk accesses) to an index entry that is individual. See Wikipedia
Cache – The computer memory this is certainly put aside to include a percentage associated with the database information that includes of late been accessed by the database application system. A cache is employed to attenuate the actual quantity of physical disk I/O performed by the DBMS.
Cascade – A foreign key feature that automatically migrates the changes built to a referenced (i.e., main key) table to all or any of this referencing (international key) dining dining table rows.
Catalog – A repository for the form that is computer-readable of database’s information meaning meta-data. Often called the operational system catalog or simply just syscat.
Checksum – a check that is numerical determined from a more substantial pair of information. A checksum is usually used whenever giving a packet of information more than a community or other communications channel. One checksum formula is really an addition that is simple with overflow ignored, wherein the bytes of this packet are added together into a adjustable of a fixed size/width (say, 16 bits) because they are delivered. The checksum is usually delivered by the end regarding the packet and utilized at the end that is receiving verify the integrity associated with preceding information.
Client – A client-side procedure, containing proxy functions, linking up to a host procedure that provides the real database functions.
Client/Server – a host is a scheduled program that operates on a pc that directly manages the database. A customer is a program that is separateor procedure) that communicates utilizing the database host through some type of Remote Procedure Call (RPC) so that you can perform application-specific database operations.
Cloud – Cloud is really a term that is recently coined to explain an execution model for computing systems where functions and data are invoked with a title that describes a remote system whoever location is unimportant (ergo the idea of it being “out here somewhere.” such as for instance a cloud). Cloud-based systems enable thin-client interfaces to get into this functionality over the internet, and frequently with wi-fi, reducing the charged energy demands for the customer computer systems.
Column – an individual product of known as information that features a specific information type ( e.g., number, text, or date). Columns just exist in tables.
Compiler – A software-development tool that translates language that is high-level to the machine-language guidelines that a specific processor can realize and perform. Nevertheless, the item rule that outcomes just isn’t yet prepared to be run; at the very least a linker or link-step must follow.
Commit – The action which causes the most of the modifications produced by a transaction that is particular be reliably written towards the database files making noticeable to other users.
Concurrency – the house by which a couple of computing processes are performing in the time that is same.
Connection – The method of interaction between a customer and a host. An ongoing process could have numerous connections started, each in its thread that is own more than one databases at any given time.
Consistency – the house of a transaction that guarantees that the state regarding the database both pre and post execution associated with deal stays constant (for example., free from any information integrity errors) set up deal commits or is rolled straight back.
Core/Core-level – A lower-level pair of database primitives in the shape of a complete API, employed by database processors such as for example SQL or Cursors.
Cost-based Optimization – The procedure where information circulation statistics ( e.g., the sheer number of rows in a dining dining dining table) are acclimatized to guide the SQL query optimizer’s range of the easiest way to recover the required information through the database.
Cross-compiler – A compiler that operates on a different sort of platform through the one for which it produces code that is object. Frequently perhaps the processor architecture/family associated with the target and host platforms vary.