Page 68 - DLIS408_INFORMATION_TECHNOLOGY-APPLICATIONSL SCIENCES

Unit 5: Types of Database

Database Management Systems are available for personal computers and for huge systems like Notes
mainframes.
Structured Query Language is used for querying the databases. Variations of this structured query
language in the form of T-SQL and PL-SQL are available. The data that is available in the database
is represented in various formats. Usually a report writer’s programme is bundled with the
database for generating reports. Crystal reports is one such application that is bundled with SQL
Server 2000 and later versions of it. These report generating programme makes it easy for generating
any kind of report-based on the data that is available in the database. Graphics components are
also available in the database management systems to generate reports in the form of charts and
graphs.

Did u know? DB2 is a database from IBM for Mainframe systems.
Products like Quest can be used in conjunction with your database to get more out of your database.
The database quality and performance can be improved by using the productivity tools provided
for the DBAs by Quest. This product enables to develop and test SQL code for optimum quality and
performance for an application before it ever reaches the production environment. Business
threatening performance issues before they reach the end user level are detected and diagnosed.
These issues are resolved as early as possible without interrupting the business. Monitoring,
diagnostics, tuning, space management and high availability are the solutions that are provided
by Quest like products. Automation and enforcement of business processes are done by using
these products. Impact analysis, patch management, version control, audit trial documentation
and migration support are available in most of the database management products.

Self Assessment

Multiple choice questions:
4. ERM stands for:
(a) Entity Relationship Model (b) Entry Record model
(c) Entry Relationship Mechanism (d) Entry Relationship Manual.
5. SQL data base is from .................... corporation.
(a) Microsoft (b) IBM (c) Oracle (d) All of these.
6. .................... is the container of the physical materialization of a database.
(a) Database storage (b) Database management
(c) Database security (d) Data store.

5.3 Bibliographic Database

A bibliographic database is a database of bibliographic records, an organized digital collection
of references to published literature, including journal and newspaper articles, conference
proceedings, reports, government and legal publications, patents, books, etc. In contrast to library
catalogue entries, a large proportion of the bibliographic records in bibliographic databases
describe analytics (articles, conference papers, etc.) rather than complete monographs, and they
generally contain very rich subject descriptions in the form of keywords, subject classification
terms, or abstracts.
A bibliographic database may be general in scope or cover a specific academic discipline. A
significant number of bibliographic databases are still proprietary, available by licensing agreement
from vendors, or directly from the abstracting and indexing services that create them.

LOVELY PROFESSIONAL UNIVERSITY 63