What is discretionary control?

In discretionary control, a given user will typically have different access rights on different objects. Different users will typically have different rights on the same object. Discretionary schemes are, thus, flexible. Discretionary control can be compared with the access control in the UNIX operating system. In UNIX file system, access permissions of user, group and others (ugo) are associated with each file. All three (ugo) has the combination of read, write and execute permission on the file.

Read More

Various aspect to the security problem in a database

The various aspects to the security problem are:

1. Legal, social and ethical aspects (for example, does the person making the request, say for withdrawing money from a bank, has legal rights for making the requested transaction?)
2. Physical controls (for example, is the computer or terminal room always locked or otherwise guarded.)
3. Policy Questions (for example, how does the enterprise owning the system decide who should be allowed access and to what?)

Read More

What is Database Security?

Generally the terms "security" and "integrity" are considered to be same, but these two concepts are quite distinct. Security refers to the protection of data against unauthorized disclosure, alteration or destruction; integrity refers to the accuracy or validity of data. In other words:

• Security involves ensuring that users are allowed to do the things they are trying to do;
• Integrity involves ensuring that the things they are trying to do are correct.

Now the Question arises that why do we need Security?

Read More

Data Dictionary in Database management system

Database management system provide a facility known as data definition language (DDL), which can be used to define the conceptual scheme and also give some details about how to implement this scheme in the physical devices used to store the data.

This definition includes:

• All entity sets and their associated attribute as well as the relationships among the entity sets.
• Any constraints that have to be maintained, including the constraints on the value that can be assigned to a given attribute and the constraints on the value assigned to different attributes in the same or different records.

Read More

What are Physical and Logical data independence?

Physical data independence is the ability to modify the physical schema without causing application programs to be rewritten. Modifications at the physical level are occasionally necessary to improve performance.

Logical data independence is the ability to modify the logical schema without causing application programs to be rewritten. Modifications at the logical level are necessary whenever the logical structure of the database is altered. It is more difficult to achieve.

Read More

Define Data Independence in a database system

The data independence can be defined as "the immunity of applications to change in storage structure and access techniques" which clearly implies that applications concerned do not depend on ally one particular storage structure or access technique.

We can also say that data independence is the ability to modify a schema definition in one level without affecting a schema in the next higher level.

Read More

What are the Disadvantages of Data Dependence in Database Systems?

In database systems, data dependence is undesirable for two reasons:

1. Different applications will need different views of the same data. Suppose there are two applications, A and B. Let A stores records in decimal and B stores records in binary. If application C using A and B is data dependent then C will not be able to integrate A and B. So, major work of programmers, done in applications A and B will be wasted. But, it will still be possible to integrate the two files and to eliminate the redundancy, provided the DBMS is ready and able to perform all necessary conversions between the stored representations chosen and the form in which each application wishes to see it.

Read More

What is Data Dependence in Database Systems?

Data dependence is the way in which the data is organized in secondary storage, and the technique for accessing it, are both dictated by the requirements of the application under consideration, and moreover that knowledge of that data organization and that access technique is built into the application logic and code.

Read More

Advantages of Conventional or Centralized DBMS

Following are the main advantages of Conventional or Centralized Database management system (DBMS):

1. Redundancy can be reduced: As we know that in non-database systems (file oriented systems) each application has its ow11 private files, because of which there exists considerable redundancy in stored data, resulting in wastage of storage space.

Read More

What are the disadvantages of file-oriented approach in information processing?

File-oriented approaches which came into being with the first commercial applications of computers did provide an increased efficiency in the data processing compared to earlier manual paper record-based systems as the demand for efficiency and speed increased the computer-based simple file oriented approach to information processing started suffering from the following significant disadvantages.

Read More

Discuss Traditional File Oriented Approach

The traditional file-oriented approach to information processing for each application has a separate master file and its own set of personal files. An organization needs flow of information across these applications also, and this requires sharing of data, which is significantly lacking in the traditional approach. One major limitation of such a file-based approach is that the programs become dependent on the files and the files become dependent upon the programs.

Read More

What are Database Instances and Database Schemas?

Databases change over time as information is inserted and deleted. 'The collection of information stored in the database at a particular moment is called an instance of the database. The overall design of the database is called the database schema. If schema change at all, they change very infrequently.

Read More

What is Database management system (DBMS)

A database-management system (DBMS) consists of a collection of interrelated data and a set of programs to access those data. The primary goal of the DBMS is to provide an environment that is both convenient and efficient to use in retrieving and storing database information. Thus we can say that, a database management system is a combination of hardware and software that can be used to set up and monitor a database, and can manage the updating and retrieval of database that has been stored in it.

Read More

What are the advantage of database system over any traditional file system?

The benefits of database system over any traditional file system are very obvious as data in database (at least in large system), is integrated as well as shared, thus, a database eliminates redundancy and unnecessary repetition of data, and also as a consequence, database lets multiple users access the same piece of data.

Read More

What is a Database System (DS)?

A database system is essentially a sophisticated, computerized record keeping system, a repository for a collection of computerized data files. A database system maintains information and makes that information available on demand, for this purpose a database system provides set of facilities to perform such operations. For example, adding new empty files in database, inserting new data in existing files, retrieve data, update data, delete data, query the database etc. Thus we can say that a database system stores data and provides information related to data. Although some people use "data" and "information" synonymously, but some prefer to distinguish between two. Data refers to the values actually stored in the database and information refers to the meaning of those values as understood by user.

Read More

What is a Database?

A collection of data, usually referred to as database, contains information about one particular enterprise. It is a collection of related information stored so that it is available to many users for different purpose. It is a kind of electronic file, which has a large number of ways of cross-referencing checks so that the user can reorganize arid retrieve data in the way he wants.

Read More