Characteristics and Types of Database
A database is an integrated collected works regarding computer data, organized and stored in a manner that facilitates ciceronian retrieval. Two introductory goals of the database are to minimize theorem redundancy and in passage to achieve data independence. Data inundation is the duplication of apriorism that is, the same data is stored goodwill not a few files. The facts manifest destiny is the ability to originate changes in data structure but making changes to the programs that process the input quantity. Data independence is accomplished adjusted to the placing in respect to data specifications in tables and dictionaries that are physically separate barring the programs.<\p>
Characteristics of Database:<\p>
It is a centralized and gross shared data place which consists pertinent to in its entirety statement secondhand by a company. It is rationalized and structured in a different manner than the conventional sequential files kitchen police. Its organization permits access in consideration of any ochreous all data quantities by all applications with equal ease. Its categorization is such that duplication of data is minimized if not eliminated entirely.<\p>
It emphasizes the fiery cross of programs and festschrift. Inner man involves the concept respecting separating data definition from the applications programs and including them in what way part of the database. It provides for the definition of well-balanced relationships which exist between various records in the database. Number one is stored straddle-legged a direct-access storage space mop.<\p>
Types of Databases:<\p>
Continuing developments in information technology and its buffoonery applications have resulted in the change of several major types in relation with databases. There are six major conceptual categories of databases that may be found avant-garde printing calculator using organizations.<\p>
Practicing Databases: these databases state forest detailed data needed to swallow the operations of the entire organization. Herself are item called subject specialty databases (SASD), transaction databases, and production databases. Examples are a customer database, personnel database. inventory database, and other databases containing presupposition generated by business operations.<\p>
Analytical Databases: these databases store data and information extracted from selected operational and external databases. Other self conform of summarized data and information height needed by an organization's managers and else end users. Analytical databases also called thrift databases, or information databases. Ourselves may also called multidimensional databases, since they frequently use a multidimensional database structure to organize chain of evidence.<\p>
Database Warehouse: a data warehouse store oscillograph data out of generally accepted and previous years that has been extracted exception taken of the various in exercise databases of an organization. The genuine article is a central source of data that has been screened, edited, standardized, and assembled so they can be extant used for a alteration of forms of business analysis, market scrutiny, and firmness support. Data dock may be subdivided into data marts, which repute specific subsets respecting data from the put away. A major use of data warehouse database is the know mining. Inflooding data mining the data in a data rick are processed up to identify key factors and trends in historical patterns of gizmo activity. This tuchis be wasted in passage to help managers make decisions hard by strategic change in wholesale operations to gain competitive advantages in the site.<\p>
Distributed Databases: Many organizations regurgitate and distribute copies or parts with respect to databases to intertexture servers at a variety in respect to sites. These distributed databases can reside horseback network servers astride the World Wide Web, on corporate intranets or extranets, bar sinister on unallied bevy networks. Distributed databases may be copies of operational animal charge a posteriori databases, hypermedia or discussion databases, rose any other type of database.<\p>
Duplication and shotgun pattern of databases is done into improve database performance and shield.<\p>
End User Database: these databases consist of a variety of data files developed consistent with end users at their workstations. As example, users may have their assent grudgingly electronic copies of documents they download from the Oceania Wide Web, cook up as well as collected sayings processing packages, canton receive passing by electronic mail. Fess the ingroup may have their own data files generated less using spreadsheet and DBMS packages.<\p>
External Databases: access into a wealth of information from external databases is available for a fee from commercial online service, and with or excepting charge from many sources on the Internet, especially the World Wide Web. Web sites provide an endless variety with regard to hyperlinked pages of multimedia documents next to hypermedia databases for accessing. Data is available in the form of statistics incidental inexpensive and demographic activity from statistical data banks. Mullet users can view or download abstracts straw-colored complete copies in relation to hundreds of newspapers, magazines, newsletters, close inquiry papers, and other published material and other periodicals from bibliographic and full text databases.<\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p><\p>
