Scribd
Upload
61 views3 pages

Database Management System (DBMS)

A Database Management System (DBMS) is a collection of programs that allows users to store, modify, and extract data from a database. DBMSs range in size from small personal computer systems to large mainframe systems. They can be used for applications like libraries, ATMs, flight reservations, and inventory tracking. DBMSs differ technically in how they organize data internally, such as relationally, hierarchically, or in networks, which can affect retrieval speed and flexibility. Users make requests using queries in a supported query language like SQL. Sophisticated database management languages are called fourth-generation languages. A DBMS typically includes a report writer and graphics to output data in various formats.

Uploaded by

fatinzuberr
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
61 views3 pages

Database Management System (DBMS)

A Database Management System (DBMS) is a collection of programs that allows users to store, modify, and extract data from a database. DBMSs range in size from small personal computer systems to large mainframe systems. They can be used for applications like libraries, ATMs, flight reservations, and inventory tracking. DBMSs differ technically in how they organize data internally, such as relationally, hierarchically, or in networks, which can affect retrieval speed and flexibility. Users make requests using queries in a supported query language like SQL. Sophisticated database management languages are called fourth-generation languages. A DBMS typically includes a report writer and graphics to output data in various formats.

Uploaded by

fatinzuberr
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Database Management System (DBMS)

 DBMS is a collection of programs that enables you to store, modify, and extract


information from a database.
 There are many different types of DBMSs, ranging from
small systems that run on personal computers to huge systems that run on mainframes.
The following are examples of database applications:
 computerized library systems
 automated teller machines
 flight reservation systems
 computerized parts inventory systems

 From a technical standpoint, DBMSs can differ widely.


 terms relational,network, flat, and hierarchical all refer to the way a DBMS organizes
information internally.
 The internal organization can affect how quickly and flexibly you can extract
information.
 Requests for information from a database are made in the form of a query, which is a
stylized question. For example, the query:
SELECT ALL WHERE NAME = "FATIN" AND AGE >16
 requests all records in which the NAME field is FATIN and the AGE field is greater than
16.
 The set of rules for constructing queries is known as a query language.
 Different DBMSs support different query languages, although there is a semi-
standardized query language called SQL (structured query language).
 Sophisticated languages for managing database systems are called fourth-generation
languages, or 4GLs for short.
 The information from a database can be presented in a variety of formats.
 Most DBMSs include a report writer program that enables you to output data in the form
of a report.
 Many DBMSs also include a graphics component that enables you to output information
in the form of graphs and charts.
INFORMATION SYSTEM  

Information System (IS) is an integrated set of components for collecting, storing, processing, and
communicating  information

Transaction process system

  Short for transactions per second, a measurement used to determine how many


transactions have been processed in one second in transaction-oriented systems.

 Short for Transaction Process System it is a type of information system (IS) that collects,


stores, modifies and retrieves transaction of an organization. Here the word transaction is
used to mean any event that generates or modifies data stored in the IS. For example batch
processing is an example of TPS.

Enterprise collaboration system (ECS)

 ECS is a combination of groupware, tools, Internet, extranets and other networks needed


to support enterprise-wide communications, such as the sharing of documents and
knowledge to specific teams and individuals within the enterprise.
 Some examples of enterprise communication tools include e-mail, videoconferencing,
collaborative document sharing, project management tools and others.
 The objective of an ECS is to provide each user with the tools for managing
communications, documents and other information that individuals need to manage their
own tasks efficiently in their departments.
Management information system

 MIS refers broadly to a computer-based system that provides managers with the tools for
organizing, evaluating and efficiently running their departments.
 In order to provide past, present and prediction information, an MIS can
include software that helps in :
 decision making,
 data resources such as databases,
 the hardware resources of a system, 
 decision support systems,
 people management
 project management applications,
 any computerized processes that enable the department to run efficiently.
 Within companies and large organizations, the department responsible for computer
systems is sometimes called the MIS department. Other names for MIS include IS
(Information Services) and IT (Information Technology).
 
Decision Support System (DSS)

 DSS is a network of satellites that broadcast digital data. An example of a DSS


is DirecTV, which broadcasts digital television signals.
 DSS's are expected to become more important as the TV and computer converge into a
single medium for information and entertainment.

Executive Information System (EIS)

Abbreviated as EIS, Executive Information System is a reporting application targeted for use by
executives. It is same as Decision Support System (DSS).

You might also like