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
-
Economics & Finance
Articles by Bhanu Priya
Page 58 of 107
What is shared nothing 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 Models For Parallel Database ...
Read MoreExplain the concept of secondary index in DBMS
In secondary Index (Unique value) is created for each record in a data file which is a candidate key. Secondary index is a type of dense index and also called a non clustering index.Secondary mapping size will be small as the two levels DB indexing is used.While creating the index, generally the index table is kept in the primary memory and the main table is kept in secondary memory because of its size.A table may contain thousands of records for this reason the sparse index becomes so large which cannot be handled in primary memory.Also, if we cannot keep the ...
Read MoreExplain about two phase locking (2PL) protocol(DBMS)
Locking and unlocking of the database should be done in such a way that there is no inconsistency, deadlock, and no starvation.2PL locking protocolEvery transaction will lock and unlock the data item in two different phases.Growing Phase − All the locks are issued in this phase. No locks are released, after all changes to data-items are committed and then the second phase (shrinking phase) starts.Shrinking phase − No locks are issued in this phase, all the changes to data-items are noted (stored) and then locks are released.The 2PL locking protocol is represented diagrammatically as follows −In the growing phase transaction ...
Read MoreExplain attributes and the different types of attributes in DBMS?
Attributes are the properties which describe an entity. Example The attributes of student entity are as follows − Roll number Name Branch Age Types of attributes The different types of attributes are as follows − Composite attribute It can be divided into smaller sub parts, each sub part can form an independent attribute. For example − ...
Read MoreExplain the role of the Database Administrator in DBMS?
A database administrator (DBA) is a person or group in charge of implementing DBMS in an organization. The DBA job requires a high degree of technical expertise. DBA consists of a team of people rather than just one person.The primary role of Database administrator is as follows −Database designPerformance issuesDatabase accessibilityCapacity issuesData replicationTable MaintenanceResponsibilities of DBAThe responsibilities of DBA are as follows −Makes the decision concerning the content of the database.Plans the storage structure and access strategy.Provides the support to the users.Defines the security and integrity checks.Interpreter backup and recovery strategies.Monitoring the performance and responding to the changes in the ...
Read MoreWhat is the difference between DFA and NFA?
DFA is the short form for the deterministic finite automata and NFA is for the Non-deterministic finite automata. Now, let us understand in detail about these two finite automata.DFAA Deterministic Finite automata is a five-tuple automata. Following is the definition of DFA −M=(Q, Σ, δ, q0, F)Where, Q : Finite set called states.Σ : Finite set called alphabets.δ : Q × Σ → Q is the transition function.q0 ϵ Q is the start or initial state.F : Final or accept state.NFANFA also has five states same as DFA, but with different transition function, as shown follows −δ: Q X Σ ...
Read MoreWhat is data Abstraction in DBMS?
Data Abstraction is a process of hiding unwanted or irrelevant details from the end user. It provides a different view and helps in achieving data independence which is used to enhance the security of data.The database systems consist of complicated data structures and relations. For users to access the data easily, these complications are kept hidden, and only the relevant part of the database is made accessible to the users through data abstraction.Levels of abstraction for DBMSDatabase systems include complex data-structures. In terms of retrieval of data, reduce complexity in terms of usability of users and in order to make ...
Read MoreHow to include the result of a calculation in HTML5?
To define or include a result of calculation in HTML, we use tag. The output tag helps in providing the result of calculation, which is performed by the JavaScript (Client side scripting language). Syntax Following is the usage of tag − --- Attributes The attributes used in output tag is shown below − Attribute Description for List of IDs of other elements, i.e. it indicates the elements who have contributed input value to the calculation. form Enables to place output elements anywhere within a ...
Read MoreSection that contains only navigation links in HTML5
Navigational links can be provided by using tag in the document. The links of nav element navigates to other webpages or points to different section of same webpage. Examples of nav element are contents, tables, menus and indexes. Syntax Following is the usage of tag in HTML − Links…… Example Following example where we are trying to create a section that contains only navigation links − TutorialsPoint ...
Read MoreHow do we display the main content in the document in HTML5?
To display the main content in the document, we use tag. The tag consists of open and closing tags, the content present in between element is unique to the document, it does not contain any content which is repeated across documents like navigation links, site logos, sidebars and search forms. In a document there should be only one element. The main is not a descendent of , , , or element. The tag supports almost all browsers and it also supports global and event attributes. Syntax Following is the usage of tag in ...
Read More