Triggers in SQL are the programs that are executed automatically when a certain condition is met. The trigger can even be used to maintain the integrity of data. The triggers are created and stored in the database and then it is the responsibility of the database system to get the trigger executed whenever a certain condition is met. In this section ahead we will discuss the … [Read more...] about Triggers in SQL
Procedures in SQL
Procedures in SQL are the small subprograms or executable named blocks that can be created and saved in the database. These procedures can be invoked and executed whenever required. It is similar to functions or methods in other programming languages such as C, C++ and Java, etc. In the section ahead, we will discuss the procedure in-depth such as how it is defined, how it … [Read more...] about Procedures in SQL
Views in SQL
Views are virtual tables whose tuples or records do not physically exist in the database. Instead, the tuples of this virtual relation or virtual table are computed spontaneously when the user executes the query associated with the view. The database stores the query associated with the view so that the user does not have to write the query again and again. In the section … [Read more...] about Views in SQL
Classification of Database Management System
Classification of database management system is based on various parameters such as the kind of data model used to construct the DBMS, the number of users that will be using the database system, the way in which the database is distributed. In the section ahead, we will be discussing all the criteria on which the database system can be classified. Classification of Database … [Read more...] about Classification of Database Management System
Domain Relational Calculus
Domain relational calculus (DRC) is a formal query language that is 'non-procedural' and 'declarative'. Being a form of relational calculus the domain relation calculus also specifies what information has to be retrieved, not how that information has to be retrieved. Domain relational calculus is much similar to the tuple relational calculus the only difference is that the … [Read more...] about Domain Relational Calculus
Tuple Relational Calculus
Tuple relational calculus is a formal query language that we use to retrieve information from the relational database. It is a non-procedural query language, that only states what information has to be retrieved but, it does not state how the particular information has to be retrieved. We also refer to the tuple relational calculus as a declarative query language as it … [Read more...] about Tuple Relational Calculus
Database System Environment
The database system environment is comprised of the components that are meant for defining and managing the data that we collect, store, manage and use in the database environment. In the section ahead, we will discuss all the components that constitute the database environment and along with this, we will also discuss the system utilities that are used to control and manage … [Read more...] about Database System Environment
Stream Control Transmission Protocol
Stream control transmission protocol (SCTP) is also a transport layer protocol like TCP and UDP. SCTP protocol includes the best features of TCP and UDP along with this it also supports the new applications supporting voice over the internet. In this section, we will discuss the working of SCTP and we will also discuss services provided by SCTP along with its … [Read more...] about Stream Control Transmission Protocol
Transmission Control Protocol (TCP)
The transmission control protocol (TCP) is a connection-oriented and reliable transport layer protocol that provides process-to-process communication. Like in user datagram protocol (UDP), we refer to the data transfer unit as user datagram in TCP we refer it to as a segment. Content: Transmission Control Protocol Introduction TCP Working TCP Services Advantages … [Read more...] about Transmission Control Protocol (TCP)
User Datagram Protocol (UDP)
User datagram protocol (UDP) provides connectionless and unreliable process-to-process communication. It is a transport layer protocol. UDP has less overhead and provides faster delivery of the packets. UDP packets are referred to as user datagrams. Content: User Datagram Protocol (UDP) Introduction UDP Services Working UDP Applications Advantages and … [Read more...] about User Datagram Protocol (UDP)