Evaluation of Arithmetic Searches over String Searches for Better Performance | Chapter 2 | Theory and Practice of Mathematics and Computer Science Vol. 1

 

Most Data Base Administrators (DBA) prefers one form of data over another as their own advantages and

disadvantages. It is often easy to determine, but at times it is a little tougher to determine. We should address

these circumstances in today's blog article. The most important quality requirements for data in a database

involve the form and duration of data. DB2 automatically guarantees that only the right form of data is stored in

that column by clearly defining the data form of each column when a table is formed. A process is rejected

which attempts to insert or change the data to an incompatible meaning. In fact, the column is given a fixed

duration to avoid the accumulation of larger values in the table [1].

Author (s) Details

S. K. Kharade

Department of Mathematics, Shivaji University, Kolhapur, India.

K. G. Kharade

Department of Computer Science, Shivaji University, Kolhapur, India.

V. S. Kumbhar

Department of Computer Science, Shivaji University, Kolhapur, India.

View Book :-https://bp.bookpi.org/index.php/bpi/catalog/book/237

Selection of Small Index to Reduce the Number of Pages for Improving Efficiency | Chapter 5 | Recent Studies in Mathematics and Computer Science Vol.4

 Exact data figures are used for having the right method for the execution of SQL queries. Yet you can get the

badly performing question where the numbers do not correctly represent the actual table information. Stats are
important information used by the Database Optimizer SQL Server that influences the chosen database
execution schedule. The optimizer gets its awareness of the data, its distribution and, from statistics available,
the number of rows of a specific question that return. Depending on this information, it selects the optimal
access route, whether to search a table or to try an index, using a nestled loop link or a hash link, etc.

Author(s) Details

K. G. Kharade
Department of Computer Science, Shivaji University, Kolhapur, India.

S. K. Kharade
Department of Mathematics, Shivaji University, Kolhapur, India.

S. V. Katkar
Department of Computer Science, Shivaji University, Kolhapur, India.

R. K. Kamat
Department of Electronics, Shivaji University, Kolhapur, India.

View Book :- http://bp.bookpi.org/index.php/bpi/catalog/book/234

Performance Analysis of 2. 5 Gbps Downlink GPON with Higher Data Rate and Q Factor| Chapter 4 | Emerging Trends in Engineering Research and Technology Vol. 3

In this paper we discuss the performance of a Giga byte Passive Optical Network (GPON) for different wavelengths and power in a system having multiple users. The main characteristics is the use of passive splitters in the fibre distribution network, enabling one single feeding fibre from the provider's central office to serve multiple homes and small businesses. GPON architecture offers converged data and voice services at speeds upto 2. 5 Gbps to 10 Gbps. The quality of performance of a digital communication system is specified by its BER or Q factor and other parameters as well. 

Author(s) Details

Dr. S. Sugumaran
Department of ECE, Vishnu Institute of Technology, Bhimavaram, Andhra Pradesh, India.

View Book :- http://bp.bookpi.org/index.php/bpi/catalog/book/179