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

JSTL-JSP Standard Tag Library part 1

Evolution of JSTL: Java is a flexible, general-purpose programming language, JavaServer pages(JSP) depends on java but hides some of the hard details of writing full- fledged programs.  The JSP Standards Tag Library(JSTL) builds on top of JSP, making it even easier to use. Architecture : In this figure large web applications are designed using java, JSTL, and othe components like databases. In large applications, it's common for requests from web browser to be handled by a java program called a servlet, which interacts with databases and other Java code on the server. The servlet figures out how it wants a response be printed and then forwards the user to the right JSTL page, which takes care of nothing more than presenting information. 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 ...
Post a Comment
Read more

Java Server page tutorial part 3: JSP Life Cycle

JSP Life Cycle: A JSP life cycle can be defined as the entire process from its creation till the destruction which is similar to a servlet life cycle with an additional step which is required to compile a JSP into servlet. Following are the steps followed by a JSP Container: ◦ Compilation  ◦ Parsing the JSP.  ◦ Turning the JSP into a servlet.  ◦ Compiling  the servlet.  ◦ Initialization ◦ Execution ◦ Cleanup Architecture: 1.       JSP Compilation: When a browser asks for a JSP, the JSP engine first checks to see whether it needs to compile the page.  If the page has never been compiled, or if the JSP has been modified since it was last compiled, the JSP engine compiles the page. The compilation process involves three steps: ◦ Parsing the JSP. ◦ Turning the JSP into a servlet.  ◦ Compiling the servlet.  2.       JSP Initialization: When a container loads a JSP ...
Post a Comment
Read more

OPERATION MANUAL FOR RS232 TO RS422/RS485 VICE-VERSA

INTRODUCTION: Milestone model LD-15U is a RS232,  to RS422/RS485 converter is designed for high-speed data transmission between computer system and or peripherals over Iong distance under high noise conditions. They provide dual line interface per signal. APPLICATIONS: Application for these converters can be for factory automation, Programmable logic controllers,, attendance recording systems, Barcode Readers, remote data transmission, remote terminals, EPABX etc. SPECIFICATIONS: Input: RS232-T×D, R×D, DSR (for control), GND (D9 Female connector) Output: RS422/RS485-Tx+, Tx-, Rx+. Rx-(D9 Male Connector). Each signal is protected by spike suppressor, fuse and has opto-isolation. Selection Switch: 1. Rear side has 2-way'SELECT' switch for selecting 2-Wire or 4-Wire mode in RS422/RS485 application. 2. (Optional) Rear side has 3-way'SELECT' switch for selecting AUTO Mode (No Handshake Signal), DSR+ Mode (+12V Control) and DSR-Model (-_12V Control) for co...
Post a Comment
Read more