rel="canonical" href="" /> What is database management system Skip to main content

What is database management system

What is database management system

What is database management system

A database management system (DBMS) is system programming for making and overseeing databases. The DBMS gives clients and software engineers a systematic method to make, recover, refresh and oversee information.

A DBMS makes it workable for end clients to make, read, refresh and erase information in a database. The DBMS basically fills in as an interface between the database and end clients or application programs, guaranteeing that information is reliably sorted out and remains effectively open.

The DBMS oversees three vital things: the information, the database motor that enables information to be gotten to, bolted and changed - and the database construction, which characterizes the database's coherent structure.

 These three primary components help give simultaneousness, security, information respectability and uniform organization techniques. Run of the mill database organization errands bolstered by the DBMS incorporate change management, execution checking/tuning and reinforcement and recuperation.

 Numerous database management systems are additionally in charge of mechanized rollbacks, restarts and recuperation and also the logging and examining of movement.

The DBMS is maybe most valuable for giving a unified perspective of information that can be gotten to by various clients, from numerous areas, in a controlled way. 

A DBMS can constrain what information the end client sees, and in addition how that end client can see the information, giving numerous perspectives of a solitary database blueprint. 

End clients and programming programs are free from understanding where the information is physically found or on what kind of capacity media it lives in light of the fact that the DBMS handles all solicitations.

The DBMS can offer both coherent and physical information freedom. That implies it can shield clients and applications from having to know where information is put away or being worried about changes to the physical structure of information (stockpiling and equipment). 

For whatever length of time that projects utilize the application programming interface (API) for the database that is given by the DBMS, designers won't need to alter programs since changes have been made to the database.

With social DBMSs (RDBMSs), this API is SQL, a standard programming dialect for characterizing, ensuring and getting to information in a RDBMS.

Popular posts from this blog

Limitations of Terzaghi Theory

Limitations of Terzaghi Theory The value of the coefficient of consolidation has been assumed to be constant.  The distance d of the drainage path cannot be measured accurately in the field. The thickness of the deposit is generally variable, and an average value has to be estimated.  There is sometimes difficulty 1n locating the drainage face, sometimes thin previous seams that can act as good drainage face are missed in the boring operations. The equation is based on the assumption that the consolidation is one-dimensional. In the field, the consolidation is generally 3-dimensional. The lateral drainage may have a significant effect on the time rate of consolidation. The initial consolidation and secondary consolidation have been neglected. Sometimes these form an important part of the total consolidation. In actual practice, the pressure distribution may be far from linear or uniform. Read More Muller-Breslau principle

Price Guard Wire Method

Price Guard Wire Method Some form of  Price Guard Wire Method  is generally used to eliminate the errors caused by leakage currents over insulation. Fig. 3.14 illustrates the operation of This Method. In fig 3.14(a), a high resistance mounted on a piece of insulating material is measured by the ammeter voltmeter method. The micro-ammeter measures the sum of the current through the resistor (IR) and the current through the leakage path around the resistor. The measured value of resistance computed from the readings indicated on the voltmeter and the microammeter, will not be a true value but will be in error.   Figure 3.14 Application of  guard  circuit for measurement of high resistance In fig, 3.14 (b), the  guard  terminal has been added to the resistance terminal block. The  guard  terminal surrounds the resistance terminal entirely and is connected to the battery side of the micro-ammeter. The leakage current IL now

Streamer Theory of Breakdown in Gases

Streamer Theory of Breakdown in Gases According to the Townsend theory firstly, current growth occurs as a result of the ionization process only. But in practice, breakdown voltages were found to depend on the gas pressure and the geometry of the gap. Second chances time lags of the order of 10-5 s, but practically it was observed to occur at a very short time of 10-8 s. Also, the Townsend mechanism predicts a very diffused form of discharge, that actually discharges were found to be filamentary and irregular. Townsend's mechanism failed to explain all these observed phenomena and as a result, The Streamer theory was proposed. The theory predicts the development of a spark discharge directly from a single avalanche in which the space charge developed by the avalanche itself is said to transform the avalanche into a plasma steamer. In Fig 1.7, a single electron starting at the cathode by ionization builds up an avalanche that crosses the gap. The electrons in the a