what is database what is database management types of database database usage what is database in sql

What Is Database? And The Types Of Database

Today we will see in this post what is Database?, in easy and understandable English language. Guys, Necessities Of Databases, what is Database Management?, Types Of Database, Database Usage And Issues etc. I hope it will be the best beneficial and enjoyable concept for all.

What Is Database?

organizations have multiple files related to the same subject or person. For example, the customer’s name and address may appear in separate files within the Sales Department, Billing Department, and Credit Department. This data is called redundancy. If the client makes a change, the address in each file must be updated. If one or more files are ignored, there is a possibility of a problem. For example, the ordered product can be sent to the new address but the bill can be sent to the old address. This situation is the result of lack of data integrity.

Also, data spread here and there in various files is not so useful. For example, the marketing department may want to offer special promotions to mass customers who order large quantities of goods. To identify these customers, the marketing department needs to have access to the files of the willing department and obtain permission. This would be much more effective if the slogan son is in a common database. The database can provide the necessary information.

Necessities Of Database

Databases required for an organization having many advantages:

  • .Sharing: In organizations, information from one department can be easily shared with another department . In billing to marketing it can be identified which customer has ordered a large quantity of goods.
  • Security: Users are only given passwords or access to information as per their requirement. In this way the Payral Department can access employees’ pay rates, but other departments will not be able to do so.
  • Equipped Data Redundancy: Different departments have to prepare and maintain their own data and data redundancy results if there is no common database. For example, an employee’s home address would likely appear in multiple files. Of unnecessary data storage space Causes inefficient usage and data maintenance problems. .
  • Data Integrity: When there are multiple sources of data each source can have variations. The customer’s address may be listed as “Main Street” in one system and “Main St.” in another. Such discrepancies are likely to treat the customer like two different languages.

What is Database Management

what is database what is database management types of database database usage what is database in sql
what is database what is database management types of database database usage what is database in sql

In order to create, modify, and gain access to a database, special software is required. This software is called database management system, commonly abbreviated as DBMS.

Some DBMSs such as Microsoft Access are specifically designed for personal computers. Other DBMSs are designed for specialized database servers. The DBMS software is made up of five parts or subsystems. DBMS Engine, Data Definition, Data Manipulation, Application Generation, and Data Administration .

DBMS engine acts as a bridge between a logical view of data and a physical view of data. When users request data (logical format), the DBMS engine handle actual search (physical format) information.

The data definition subsystem defines the logical structure of a database using a data dictionary or scheme. This dictionary details the data structure of the database. For a particular item of data it defines the names used for a particular field. It defines the type of data for each field (text, numeric, time, graphic, audio, and video)

The data manipulation subsystem provides tools to maintain and analyze data
Maintaining data is known as data maintenance. This includes adding new data, deleting old data, and editing existing data. Analysis tools assist in viewing all or selected parts of data, checking databases and preparing reports
Huh. Special tools include a special programming language called Query-by-Example and Structured Query Language (SQL) .

The application generation subsystem provides tools for preparing data entry forms and special programming languages ​​that interface or work with common or widely used programming languages ​​such as C ++ or Visual Basic . For a data entry form prepared by the Access Application Generation subsystem, .

Database Administration Subsystem helps manage all databases, including maintaining security, providing disaster recovery support, and overall monitoring database operations is very large organizations typically employ highly trained computer specialists called database administrators (DBAs) to interact with the data administration subsystem. Additional functions of the database administrator include determining the processing rights or determining which types of data are used by the people in the database.

Types of Database

what is database what is database management types of database database usage what is database in sql
what is database what is database management types of database database usage what is database in sql

Database may be small or large, limited in availability or widely available. Databases can be classified into four types: individual, company, distributed, and commercial.

A personal

personal database is also called a personal computer database. It is primarily a collection of integrated files used by just one person. There is usually direct control of data and DBMS users. They are stored on the user’s hard-disk dive or on a LAN file server.

There may be times in your life when you will find this type of database valuable. For example, if you are in sales, a personal computer database can be used to monitor your customers. If you are a sales manager you can monitor your vendors and their performance. If you are an advertising accounts manager, you can keep an eye on your various projects and how many hours of work each client has been given.

Company

Companies naturally create databases for their own use. Company databases can be stored on a central database server and managed by the database manager. Users of the entire company access the database through their personal computers connected to a local or wide area network.

As we know that companies are intentional for database management information system. For example, a department store can record all sales transactions in a database. A sales manager can use this information to see which salespeople are selling the most products. The manager can then set the year end sales bonus. Or the store buyer can find out which products are selling well or not and can make adjustments when re-ordering.

 Distributed

Many times, data is stored in multiple locations in a company, not just one place. It is made accessible through diverse communication networks. The database is then a distributed database. That is, all data in a database is physically located in one location, usually providing links between database server data on the client / server network.

For example some database information may be in regional offices. Some company may have some at headquarters and some may also be external. Sales figures for the chain of department stores can then be located at various stores. But executive of district offices or chain headquarters can access all these figures.

Commercial

Commercial database is usually a large database that an organization develops to cover specific topics. It provides access to this database to public or selected outsiders in lieu of fees. Sometimes commercial databases are also called information utilities or data banks. NSE Infobus is an example of this which provides a variety of aggregated information and reporting services.
Some widely used commercial databases are:

Dialog Information Services – provides business information and technical and scientific information.

Dow Jones Interactive Publishing – provides world news and information related to business, investment and stocks.

NSE Infobase – provides news and information related to legal news, public recorders and business issues .

Most commercial databases are designed for organizational and personal use. Organizations usually pay membership fees and hourly usage fees with it. Often people are able to search databases to obtain a summary of the information available at no charge. They only pay for items that have been selected for further investigation. See Figure 9-7 for a summary of four types of data.

 Database usage and issues

what is database what is database management types of database database usage what is database in sql
what is database what is database management types of database database usage what is database in sql

Provide great opportunities for database productivity. In fact, in corporate libraries, electronic databases are now considered more important than books and journals although handling of databases means that users should continue to strive to prevent them from being interfered with or misused.

Important Usage Of Database

Database helps users stay up to date and make future plans. Many organizations diverse internal and external to support the needs of managers and other business professionals collect data from database. This data is then stored in a special type of database called a data warehouse. To search for these databases, a technique called data mining is often used to look for related information and patterns. Hundreds of databases are available to assist users with both general and specialized business purposes , including

  •  business directories providing address, financial and marketing information, products and trade and brand names.
  •  Demographic data such as state and city statistics, current estimates about population and income, employment statistics, census data, etc.
  •  Business statistical information, such as financial information about public trading companies,
  • Market potential and other business data and information of some retail outlets.
  •  Text database provides business publications, articles related to press releases, reviews about companies and products, etc.
  • The web database covers a wide range of topics including all of the above. Web search sites such as Google maintain an extensive database of available Internet content, as previously mentioned.

Security

Precisely because databases are so valuable, their security has become an important issue. One concern is that personal and personal information related to people stored in the database may be used for false purposes. For example a person’s credit history or medical record can be used to make planning or promotion decisions. The second concern is unauthorized users with access. For example, there are many instances in which computer viruses have been transported to a database or network. Every person who keeps singing and entering the company’s computer room for security

Identification of time may need to be checked. Some security systems check for electronic fingerprints. (See Figure 9–8 diagrammatically). Security is particularly important for organizations using UANs. Violations can occur without actually entering safe zones. As mentioned in earlier chapters, most major corporations today

use specialized hardware and software called fireballs to control access to their internal networks.

 

What is Internet And Web,Difference Between Internet And Web

How To Earn Money Online:10 Best Tips Of 2020 How To Earn Money Online From Home

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *