Database Management

Database Management

A Guide To Database Management

Database management occurs when you use computerized software to handle, store, organize, recall and structure information into a system.

Database management occurs when you use a complex set of different programs and commands to manipulate the information in a variety of ways, relating to organization, storage, management and retrieval of data that exists and has been entered into the database.

There are four typical types of organization used in database management. Hierarchal organization uses a treelike navigational structure, where records have a parent/child relationship with each other. The network organized database management systems offer a more flexible approach. Instead of each record only having one parent, a network model allows each record to have multiple relationships with other records.

Relational and object models are also used for organizational purposes and database management.

Database management will accept requests for data retrieval and storage through different instructions, which are dependent on the type of program used to manage the database, as well as the operating system.

All database applications are built on database management systems.

When storing information in a database management, typically an attribute management system is used. This is where a small chunk of information is considered an attribute to describe something within the database. For example, size could be an attribute for the shirt you're wearing. The value of the attribute may be expressed such as small, medium, large and so forth.

When somebody performs querying on a database system, what they're really doing is requesting certain attribute information based on a variety of different factors and combinations. For example, using the shirt example, you may inquire from the database -- "how many small shirts are there?"

Additionally, you can place aspects of security as it relates to requesting and receiving information in the database. This will give different authorization to different people, as to the type of information they can access, and what they are restricted from accessing. Typically, passwords are used to limit and restrict unauthorized personnel from the information in the database.

Additionally, when building a database, you want to use rule enforcement of certain attributes. For example, a rule for a shirt may be that it can only be assigned one size. If somebody tries to modify the size and give it another size as well, the database management system will deny that request, or report an error.

In conclusion, I've given you some of the basics as it relates to database management.

Database Management |