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 database that is application-specific created from application customer programs. The DBMS is in-process because of the application code for extremely fast interior access.
Aperiodic Server – Software this is certainly certain to a specific system that is embedded. Such application-specific rule is generally speaking constructed on a layered architecture of reusable elements, such as for example a real-time os and community protocol stack or other middleware. Then this term may not be used if there is no such architecture. The applying application is not likely to be reusable across embedded platforms, mainly because each embedded system has a various application.
Atomicity – the house of a deal that guarantees that either all or none associated with modifications produced by the transaction are written to your database.
AVL-Tree – An AVL tree is really a self balancing search tree that is binary.
Big-Endian – a information representation for the multibyte value which has the most crucial byte saved during the memory address that is lowest. Keep in mind that just the bytes are reordered, never ever the nibbles or bits that comprise them. Every processor stores its information in either big-endian or format that is little-endian. Sun’s SPARC, Motorola’s 68k, therefore the PowerPC families are typical big-endian. The Java digital device is big-endian too. Similarly, every communications protocol must define the byte order of their values that are multibyte. TCP/IP makes use of representation that is big-endian.
BLOB – An abbreviation for Binary Large OBject. In SQL, BLOB may be a general term for any http://datingmentor.org/green-dating/ information of type long varbinary, long varchar, or very very long wvarchar. Additionally, it is a certain term (and synonym) for data of type varbinary that is long.
Breakpoint – a place in system from which execution will be stopped and control of the processor switched into the debugger. Mechanisms for producing and eliminating breakpoints are supplied by many debugging tools.
B-tree – An indexing technique where the values associated with the columns utilized in the index are effectively maintained in sorted purchase which also provides quick access (three to four additional disk accesses) to an index entry that is individual. See Wikipedia
Cache – The computer memory this is certainly put aside to include a portion regarding the database information that features of late been accessed because of the database application system. A cache is employed to attenuate the quantity of physical disk I/O performed by the DBMS.
Cascade – A foreign key feature that automatically migrates the modifications built to a referenced (in other words., main key) dining dining dining table to any or all of this referencing (international key) dining dining table rows.
Catalog – A repository when it comes to computer-readable kind of a database’s information meaning meta-data. Often called the operational system catalog or simply syscat.
Checksum – A numerical check value determined from a bigger collection of information. A checksum is frequently utilized when sending a packet of information over a community or other communications channel. One checksum formula is really an addition that is simple with overflow ignored, wherein the bytes associated with packet are added together into a adjustable of a hard and fast size/width (say, 16 bits) because they are delivered. The checksum is normally delivered at the conclusion associated with packet and utilized at the end that is receiving verify the integrity associated with preceding information.
Customer – A client-side procedure, containing proxy functions, linking up to a host procedure that provides the real database functions.
Client/Server – a host is system that operates on a pc that straight manages the database. A customer is really a program that is separateor procedure) that communicates using the database host through some type of Remote Procedure Call (RPC) to be able to perform application-specific database operations.
Cloud – Cloud is a recently coined term used to explain an execution model for computing systems where functions and information are invoked with a title that describes a remote system whoever location is unimportant (ergo the thought of it being «out here somewhere.» just like a cloud). Cloud-based systems enable thin-client interfaces to gain access to this functionality through the net, and frequently with wi-fi, reducing the charged energy demands regarding the customer computers.
Column – a solitary device of known as data that features a specific data type ( ag e.g., number, text, or date). Columns just occur in tables.
Compiler – A software-development tool that translates language that is high-level to the machine-language guidelines that a specific processor can comprehend and execute. But, the thing rule that outcomes just isn’t yet willing to be run; at the very least a link-step or linker must follow.
Commit – The action which causes the all the modifications produced by a particular deal to be reliably written towards the database files making noticeable to other users.
Concurrency – the home in which a couple of computing procedures are performing during the exact same time.
Connection – The method of interaction between a customer and a server. An ongoing process could have numerous connections exposed, each with its thread that is own a number of databases at the same time.
Consistency – the home of the deal that guarantees that the state associated with database both pre and post execution regarding the deal stays constant (in other words., without any any information integrity errors) set up deal commits or is rolled right right back.
Core/Core-level – A lower-level group of database primitives by means of a total API, utilized by database processors such as for instance SQL or Cursors.
Cost-based Optimization – The procedure where data circulation data ( ag e.g., the sheer number of rows in a 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 an alternate platform through the one for which it produces code that is object. Usually even the processor architecture/family for the host and target platforms vary.
Deja un comentario