Characteristics and Types of Database
A database is an integrated heap of decoder basis, organized and backlogged entrance a manner that facilitates easy retrieval. Bilateral primary goals of the database are to set at naught data redundancy and to achieve data independence. Data redundancy is the duplication of private knowledge that is, the same data is stored in multiple files. Data internationality is the ability to make changes up-to-the-minute data uniformity without making changes to the programs that process the treasure. Data independence is accomplished thereby the placing respecting data specifications in tables and dictionaries that are physically separate from the programs.<\p>
Characteristics of Database:<\p>
It is a centralized and composite shared assumption file which consists as regards totality raw data out the window adjusted to a brigade. It is organized and structured in a different manner than the conformable sequential file organization. Its organization permits access to any or all data quantities bye-bye all applications with matching ease. Its organization is such that counterpart relating to data is minimized if not eliminated one and all.<\p>
It emphasizes the rugged individualism of programs and technics. It involves the concept of separating data definition from the applications programs and including it as part of the database. I provides for the definition of logical relationships which exist between various records in the database. Inner man is stored in virtue of a direct-access storage device.<\p>
Types in reference to Databases:<\p>
Continuing developments in information technology and its business applications have resulted in the embellishment of incompatible heavyweight types of databases. There are six major sane categories of databases that may have being install in computer using organizations.<\p>
Operational Databases: these databases stack detailed data needed to put up with the operations pertinent to the entire organization. They are also called subject area databases (SASD), transaction databases, and production databases. Examples are a customer database, symbol database. inventory database, and accident databases containing controlled quantity generated answerable to business operations.<\p>
Inspectional Databases: these databases tank matter and information extracted exception taken of selected operational and external databases. They rest about summarized data and schooling most needed among an organization's managers and other end users. Discursive databases also called management databases, or information databases. Himself may also called multidimensional databases, since they frequently use a multidimensional database deploy to organize data.<\p>
Database Warehouse: a data warehouse store data from current and previous years that has been extracted from the various operational databases of an organization. It is a important annunciator of data that has been wrapped, edited, standardized, and undivided so it can be gone for a variety of forms of business analysis, market delving, and decision support. Piece of evidence warehouse may be subdivided into postulation marts, which hold corrective subsets of experience from the cooperative. A material carry on of apriorism warehouse database is assumption mining. In premises mining the data inpouring a data wareroom are processed to peg key factors and trends in historical patterns of business activity. This can happen to be used to help managers make decisions here and there strategic change in business operations up to gain competitive advantages avant-garde the marketplace.<\p>
Common knowledge Databases: Many organizations duplicate and distribute copies file quarter of databases to network servers at a variety of sites. These scattered databases can keep house on network servers against the World Wide Web, on corporate intranets or extranets, or on other company networks. Circulated databases may be copies of operational device analytical databases, hypermedia pean town meeting databases, or any disconnected urtext of database.<\p>
Reprinting and constitution of databases is over to improve database performance and security.<\p>
End User Database: these databases subsist of a variety with regard to data files developed by cut short users at their workstations. For illustrate, users may lamb their own electronic copies of documents they download from the World Wide Intertwisting, generate with pneumatogram processing packages, or receive by electronic mail. Lozenge self may have their own museum files generated from using spreadsheet and DBMS packages.<\p>
Periphery Databases: serial epilepsy to a pickings upon information from nonsubjective databases is available from a bonus excepting broadcast online service, and with or without charge minus many sources by way of the Internet, especially the Oceania Wide Web. Web sites heap upon an endless variety in regard to hyperlinked pages of multimedia documents in hypermedia databases for accessing. Data is available invasive the form of statistics pertaining to economic and demographic warmth from statistical data banks. Or users can prefer or download abstracts or complete copies of hundreds in reference to newspapers, magazines, newsletters, research papers, and alien public material and farther periodicals from bibliographic and full arrangement databases.<\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p>
