Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Bhanu Priya
Page 67 of 106
C program to calculate sum of series using predefined function
ProblemThe program to calculate the sum of the following expressionSum=1-n^2/2!+n^4/4!-n^6/6!+n^8/8!-n^10/10!User has to enter the value of n at runtime to calculate the sum of the series by using the predefined function power present in math.h library function.SolutionIt is explained below how to calculate sum of series using predefined function.AlgorithmRefer an algorithm given below to calculate sum of series by using the predefined function.Step 1 − Read the num valueStep 2 − Initialize fact = 1, sum = 1 and n =5Step 3 − for i= 1 to n a. compute fact= fact*i b. if i %2 = 0 c. ...
Read MoreC program to count characters, lines and number of words in a file
A file is a physical storage location on disk and a directory is a logical path which is used to organise the files. A file exists within a directory.The three operations that we can perform on file are as follows −Open a file.Process file (read, write, modify).Save and close file.ExampleConsider an example given below −Open a file in write mode.Enter statements in the file.The input file is as follows −Hi welcome to my world This is C programming tutorial From tutorials PointThe output is as follows −Number of characters = 72Total words = 13Total lines = 3ProgramFollowing is the C ...
Read MoreC program to remove a line from the file
A file is a physical storage location on disk and a directory is a logical path which is used to organise the files. A file exists within a directory.The three operations that we can perform on file are as follows −Open a file.Process file (read, write, modify).Save and close file.AlgorithmAn algorithm is given below to explain the C program to remove a line from the file.Step 1 − Read file path and line number to remove at runtime.Step 2 − Open file in read mode and store in source file.Step 3 − Create and open a temporary file in write ...
Read MoreC program to store even, odd and prime numbers into separate files
A file is a physical storage location on disk and a directory is a logical path which is used to organise the files. A file exists within a directory.The three operations that we can perform on file are as follows −Open a file.Process file (read, write, modify).Save and close file.ProgramFollowing is the C program to store even, odd and prime numbers into separate files − Live Demo#include #include /* Function declarations */ int even(const int num); int prime(const int num); int main(){ FILE * fptrinput, * fptreven, * fptrodd, * fptrprime; int num, success; ...
Read MoreWhat is Hierarchical architecture in parallel databases?
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, disks are used parallel to enhance the processing performance.Operations like data loading and query processing are performed parallel. Centralized and client server database systems are not powerful enough to handle applications that need fast processing.Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly.Architectural ModelsThere are several architectural models for parallel ...
Read MoreWhat is a parallel database and explain how it works?
A parallel database is one which involves multiple processors and working in parallel on the database used to provide the services.A parallel database system seeks to improve performance through parallelization of various operations like loading data, building index and evaluating queries parallel systems improve processing and I/O speeds by using multiple CPU’s and disks in parallel.Working of parallel databaseLet us discuss how parallel database works in step by step manner −Step 1 − Parallel processing divides a large task into many smaller tasks and executes the smaller tasks concurrently on several CPU’s and completes it more quickly.Step 2 − The ...
Read MoreWhat are the capabilities of DBMS and why relational DBMS is powerful?
Database management system (DBMS) is a software or tool which can be used for managing and maintaining the data within the database.Major Capabilities of DBMSThe major capabilities of DBMS are listed below −Data StorageData RetrievalData UpdateSecurityData IndependenceExplanationGenerally a person has to work with a huge amount of information every day. In order to interact with the large amount of data we need a system where we can store, manipulate, security, sharing the information all over the world. It is a core reason the industries are maintaining database management tools.Powerful Relational DBMSThe relational DBMS is more powerful because of the reasons ...
Read MoreExplain the classification of database security
The database security is broadly classified into physical and logical security. Database recovery is the way of restoring a database to a correct state in the event of a failure.Physical security − Physical security refers to the security of the hardware that is associated with the system and the protection of the site where the computer resides. The natural events like fire, floods, and earthquakes can be considered as some of the physical threats. It is advisable to have backup copies of databases in the face of massive disasters.Logical security − Logical security refers to the security measures present in ...
Read MoreWhat are the steps of SQL Query processing in DBMS?
Query Processing is a translation of high-level queries into low-level expression. It is a step wise process that can be used at the physical level of the file system, query optimization and actual execution of the query to get the result.It requires the basic concepts of relational algebra and file structure. It refers to the range of activities that are involved in extracting data from the database. It includes translation of queries in high-level database languages into expressions that can be implemented at the physical level of the file system.Given below is the diagram that shows the steps of the ...
Read MoreExplain parallel and distributed database management system
In parallel database system data processing performance is improved by using multiple resources in parallel. In this CPU, the disk is used parallel to enhance the processing performance.Operations like data loading and query processing are performed parallel. The centralized and client server database systems are not powerful enough to handle applications which need fast processing.Parallel database systems have great advantages for online transaction processing and decision support applications. Parallel processing divides a large task into multiple tasks and each task is performed concurrently on several nodes. This gives a larger task to complete more quickly.Architectural ModelsThere are several architectural models ...
Read More