صحيفة روافد العربية ننقل الحدث كما حدث
Read-only deal – A Multi-Version Concurrency Control (MVCC) feature that enables database information to be read by one procedure without blocking another procedure’s modification of that exact same information. Often known as a “snapshot.”
Real-time – a environment that is real-time one by which particular tasks needs to be assured to perform inside a specified time period. For a DBMS to be looked at really real-time, it should be in a position to perform certain database-related tasks in an occasion which can be deterministically demonstrated—i.e., the worst instance execution time could be demonstrated. Must be general-purpose DBMS relates to dynamic data where the sizes of tables differ in the long run, and because DBMS reaction times be determined by the actual quantity of information become prepared they can not be looked at real-time. This might be real also for RDM. It really is real-time friendly, it to be used in beneficial ways in a real-time application because it is fast, has a small footprint and has features (such as virtual tables and in-memory storage) that allow.
Record Instance/Occurrence – One group of associated information industry values related to a record that is specific to an SQL row.
Record Type – an accumulation of closely associated information fields—equivalent to an SQL table. Just like a C struct, an archive kind is defined by a collection of closely associated information areas.
Referential Integrity – an ailment when the international key column values in every for the rows within one dining table have actually matching rows into the referenced primary table that is key. Referential integrity is maintained by SQL throughout the processing of a INSERT and DELETE statement and any UPDATE statement that modifies a foreign or primary key value.
Relational Model – A database by which inter-table relationships are arranged mainly through typical information columns, which define a one-to-many relationship between a line regarding the main key dining dining table and another or higher rows associated with matching international key table. Equi-joins relate tables which have matching primary/foreign key values, but other evaluations (relationships) might be defined. Along with explaining the http://datingmentor.org/escort/albuquerque/ way the database tables are related, the model that is relational describes exactly just how a related information could be accessed and manipulated. SQL is considered the most widely used relational model database language. See Wikipedia
Remote Procedure Phone – a way of interprocess interaction where a function living within another procedure is named as if it’s a regional (in-process) function. The technique is implemented through an area proxy function and a remote stub function. Parameter values are marshalled right into a block of information which can be sent through the proxy into the stub for demarshalling and calling the real function. Return values are prepared into the in an identical way as input values.
Replication – a procedure where chosen alterations in a master database is replicated (re-played) into another database.
Regulation Factor – Each expression that is relational when you look at the WHEREIN clause of the question posseses an associated limitation component that is believed by the SQL optimizer, which specifies the small small fraction (or portion) for the dining table which is why the phrase may be real. For instance, when you look at the query choose * from book where bookid = ‘austen013px’ the relational phrase bookid = ‘austen013px’ includes a limitation element corresponding to .003 (only 1 away from 3213px rows will satisfy this phrase).
Result Set – the whole group of rows that is came back by way of a specific choose statement.
Rollback – a procedure, frequently done by the SQL ROLLBACK statement, that discards all the noticeable modifications produced by all INSERT, IMPROVE and DELETE statements which have been performed considering that the most recently started deal ( e.g., START DEAL declaration).
Row – One pair of relevant values for many associated with the columns declared in a provided table. Also called an archive incident.
Royalty – A License cost established in an Agreement (Product and Pricing Addendum).
