database management

The various functions performed by Data Manager are: It is the central component of the DBMS which execute the query. It converts the user query from the user logical view to the physical file system. It synchronize the concurrent access and maintains the backup for recovery purpose It takes...

Cloud is the nothing but it is the virtual environment which provide the computer resources on lease. Cloud is maintained by the third party. If you have need for database then you can take database on lease from third party. There are several advantage of cloud database like no need of hardware...

The most active feature of DBMS is that it provides a facility of fault tolerance. They continue to run if errors occurs and provide the facility allowing users to detect their mistake at the same time. DBMS, in addition provides the feature of recovery in the failure of functions. Take an...

Database managment system allowing data to be shared, it also ensures that data in only accessed by authorized users. Database managment system provides features needed to implement security at the enterprise level.The data of a user cannot be accessed by other users unless the owner gives...

Data manipulation include the steps as mentioned below :- Adding new data, for example adding details of new student or new item. Deleting unwanted data, for example deleting the details of students who have completed course or removing items out of stock Changing existing data,for example...

Database is one of the most important assets of a company. It is very important to make sure data is stored and maintained accurately and quickly.Database management system is a system that is used to store and manage data.A DBMS is a set of programs that is used to store and manipulation data.

Distributed database model for database that are spread out over several systems, possible across a country, continent or planet. The limitations in the amount of memory,the number of hard disk drives which can be connected to it or the number of processor it can run in parallel can be managed...

Inventory helps to get the items identified, priced and traced. Inventory system which forms a list,can be used to maintain the records of item and to find when the item goes out of stock. It provides tools needed to minimize out of stock conditions anf maximize valuable management information...

Cursors are the work area where the oracle engine executes the sql queries. It allows to store and execute the sql queries.The data stored in cursors is known as active dataset. There are 2 types of cursors: Implicit Cursor: They are open, closed and managed by PL/SQL implicitly without user...

The main differences between Relatinal algebra and calculus are: Relational algebra is a procedural language whereas Relational Calculus is a non-procedural language. In Relational algebra we need to specify what is required and how to get it whereas in Relational Caculus we only need to...

Whenever any failure occurd it is required to check the entire log file to determine what is to be undone and what is to be redone which ofcourse is a very daunting task. In order to over come this problem the concept of CHECKPOINTS are used. As every transection is recorded in the log file and...

There are number of datatypes defined by Oracle. Few commonly used are listed below: VARCHAR2: Contains the variable length text string of upto 2000bytes. CHAR: Contains fixed length text string upto 255 bytes. NUMBER: Contains numeric data, its by default precision value is upto 38 digits...

Indexing is a access strategy that allows to sort or search records in the table efficiently using the index column. In Indexing unique ROWID is assigned to each to row in a table. Types of Indexes: UNIQUE INDEX: It does not allow the duplicate value in the index SIMPLE INDEX: Index created on...

Database is divided into 3 levels namely external level also known as user view level, conceptual level, internal level or physical level.

Re-engineering is the method of re-thinking the way work is done. It involves examination and analysis of the the processes. It is method of making a re model of any software or program in a more efficient way so as to increase the output as a whole.Sometimes it can be done to find the malicious...

Distributed object oriented database is used to store the real time data like Computer added design data, Photoshop data , matlab data etc. As we know conventional data are stored in the form of row and column say table. But all the real time data like video , image and sound are stored in the...

Difference between Third Normal form and BCNF?

Data Warehouse is used to analyze data for businesses. Data Warehouse is a type of database that integrates the copies of transaction data from disparate source systems and provisions them for analytical use.For example, source A and source B may have different ways of identifying a product, but...

It is mechanism for the computers to perform tasks just like human brains do. Example of artificial intelligence is a robot. You will give command and it will perform functions for you.Computers are fundamentally well suited to performing mechanical functions, using fixed programmed rules. This...

The data independence is the work just as the abstract data type in C++ programming language. Both are the hiding useless information from the user, this allows user to work on the general structure. Data independence also allow for the changes at the one level of database without affecting any...