Skip to main content

JDBC FAQ part1

                                                                     JDBC FAQs
1:   What is the difference between Database and Database management system?
Ans:    Database is a collection of interrelated data. Database management system is a software which can be used to made the data by storing it on to the database and by retrieving it from the database.  And  DBMS is a collection of interrelated data and some set of programs to access the data.
            There are 3 types of Database Management Systems.
  • Relational DataBase Management Systems(RDBMS):   It is a software system, which can be used to represents data in the form of tables. RDBMS will use SQL2 as a Queries  language.
  • Object Oriented DataBase Management Systems(OODBMS):  It is a software system, which can be used to represent the data in the form of objects. This DBMS will use SQL as a Query language.
  • Object Relational DataBase Management Systems(ORDBMS):  It is a DBMS which represents some part of the data in the form of tables and some other part of the data in the form of objects. This management system will use SQL3 as a Query Language, it is a combination of  SQL2 and OQL.
2: How a query could be executed when we send a query to Database?
When we send an SQL Query from SQL prompt to the DataBaseEngine, then Database Engine will take the following steps.
  • Query Tokenization:  This phase will take SQL query as an input and divide into stream of tokens.
  • Query Parsing:   This phase will take the stream of tokens as an input, with them it tried to construct a query tree. If query parser constructs query tree successfully then it was an indication that no grammatical mistakes in the taken SQL query, Otherwise, there are some syntactical errors in the taken SQL query.
  • Query Optimization:   This phase will take query tree as an input and performs a number of query optimization mechanisms to reduce execution time and memory utilization.
  • Query Execution:  This phase will take optimized query as an input and executes that SQL query by using interpreters internally, as a result, we will get some output on the SQL prompt.

Comments

Post a Comment

Popular posts from this blog

Applications of Insulating Materials

All electrical systems require some kind of insulation to prevent short circuits and leaking currents. 3 forms of insulators: solid, liquid and gaseous Performance of these insulators depend on the temperature Classification according to their temperature rating. Impregnation: Letting the solid material absorb some liquid With the advent of new materials, the classification has been modified by International Electrotechnical Commission: The transformer insulation: (a) conductor or turn-to-turn insulation, (b) coil-to-coil insulation, (c) low voltage coil-to-earth insulation, (d) high voltage coil-to-low voltage coil insulation, and (e) high voltage coil-to-ground insulation. Transformer oil -- provides the required dielectric strength and insulation -- cools the transformer by circulating itself through the core and the coil structure. -- should be in the liquid state over the complete operating range of temperatures between -40°C and+50°C. -- gets o...
15 comments
Read more

JSTL-JSP Standard Tag Library part 2

Evolution of JSTL-JSP Standard Tag Library As JSP grew in popularity, it became clear that different sites' custom tags fell into familiar, frequently used patterns. For example, many pages needed to loop over data to print tables and lists. Vendors of JSP containers and members of the open-source community tried to address these needs by providing collections of tags --tag libraries--that solved common problems. While many JSP page authors used these libraries, nothing tied them together. To address this fragmentation, the Java Community Process --the same group that now maintains and standardizes JSP itself --decided to offer a standard tag library. JSTL 1.0, to include tags for the following common tasks:          •Looping over data to produce tables, lists, etc.          •Conditional operations          •Importing and processing data from other web pages         ...
Post a Comment
Read more

PV/GENSET HYBRID

Introduction: PV and genset systems do not have much in common. It is precisely for this reason that they can be mated to form a hybrid system that goes far in overcoming the drawbacks to each technology. Table 10.1 lists the respective advantages and disadvantages. As the sun is a variable energy source, PV system designs are increased in size (and therefore cost) to allow for a degree of system autonomy. Autonomy is required to allow for provision of reliable power during "worst case" situations, which are usually periods of adverse weather, seasonally low solar insulation values or an unpredicted increased demand for power. The addition of autonomy to the system is accomplished by increasing the size of the PV array and its requisite energy storage system (the battery). When a genset is added, additional battery charging and direct AC load supply capabilities are provided. The need to build in system autonomy is therefore greatly reduced. When energy demands cannot b...
Post a Comment
Read more