|
|
database management system
<database> (DBMS) A suite of programs which typically manage
large structured sets of persistent data, offering ad hoc
query facilities to many users. They are widely used in
business applications.
A database management system (DBMS) can be an extremely
complex set of software programs that controls the
organisation, storage and retrieval of data (fields, records
and files) in a database. It also controls the security and
integrity of the database. The DBMS accepts requests for data
from the application program and instructs the operating
system to transfer the appropriate data.
When a DBMS is used, information systems can be changed much
more easily as the organisation's information requirements
change. New categories of data can be added to the database
without disruption to the existing system.
Data security prevents unauthorised users from viewing or
updating the database. Using passwords, users are allowed
access to the entire database or subsets of the database,
called subschemas (pronounced "sub-skeema"). For example, an
employee database can contain all the data about an individual
employee, but one group of users may be authorised to view
only payroll data, while others are allowed access to only
work history and medical data.
The DBMS can maintain the integrity of the database by not
allowing more than one user to update the same record at the
same time. The DBMS can keep duplicate records out of the
database; for example, no two customers with the same customer
numbers (key fields) can be entered into the database.
Query languages and report writers allow users to
interactively interrogate the database and analyse its data.
If the DBMS provides a way to interactively enter and update
the database, as well as interrogate it, this capability
allows for managing personal databases. However, it may not
leave an audit trail of actions or provide the kinds of
controls necessary in a multi-user organisation. These
controls are only available when a set of application programs
are customised for each data entry and updating function.
A business information system is made up of subjects
(customers, employees, vendors, etc.) and activities (orders,
payments, purchases, etc.). Database design is the process of
deciding how to organize this data into record types and how
the record types will relate to each other. The DBMS should
mirror the organisation's data structure and process
transactions efficiently.
Organisations may use one kind of DBMS for daily transaction
processing and then move the detail onto another computer that
uses another DBMS better suited for random inquiries and
analysis. Overall systems design decisions are performed by
data administrators and systems analysts. Detailed database
design is performed by database administrators.
The three most common organisations are the hierarchical
database, network database and relational database. A
database management system may provide one, two or all three
methods. Inverted lists and other methods are also used. The
most suitable structure depends on the application and on the
transaction rate and the number of inquiries that will be
made.
Database machines are specially designed computers that hold
the actual databases and run only the DBMS and related
software. Connected to one or more mainframes via a
high-speed channel, database machines are used in large volume
transaction processing environments. Database machines have a
large number of DBMS functions built into the hardware and
also provide special techniques for accessing the disks
containing the databases, such as using multiple processors
concurrently for high-speed searches.
The world of information is made up of data, text, pictures
and voice. Many DBMSs manage text as well as data, but very
few manage both with equal proficiency. Throughout the 1990s,
as storage capacities continue to increase, DBMSs will begin
to integrate all forms of information. Eventually, it will be
common for a database to handle data, text, graphics, voice
and video with the same ease as today's systems handle data.
See also: intelligent database.
(1998-10-07)
Try this search on OneLook / Google
Nearby terms:
database administrator « database analyst « database machine « database management system » database manager » database normalisation » database query language
This article was derived from the Free Online Dictionary of Computers and is available under ther terms of the GNU Free Documentation License.
Bluetooth Stereo HeadsetBluetooth Stereo Headset ** Bluetooth Stereo Headset **The Bluetooth Stereo Headset supports streaming music wirelessly. By connecting the headset to the PC via Bluetooth USB Dongle, the user can listen to hours of music available on their PC without the hassle of cords. With the easy adjusting design, the users enjoy sheer and unsurpassed comfort. Perfect for travel entertainment or as an add-on for your home entertainment system.General Features:- Streaming of music sources in PC - Replaceable AAA battery for long lasting play - Windows 2000, XP compatible - Easy controllable via 2 buttons - Comfortable headband - No Wire for easy to put on and take off - Stylish - Easy setupNotes:- Brand new retail packaged More ...
Paper Art Vol. 2: Gift WrappingPaper Art Vol. 2: Gift Wrapping How many times have you heard that its the thought that counts ? This is especially true when it comes to gifts - even a simple gift, thoughtfully presented, can bring special joy to the recipient as well as to the giver. Windows 98/ME/2000/XP and Mac More ...
IP Kamera 9000A Plus Internet IP Camera (White)IP Kamera 9000A Plus Internet IP Camera (White) ** IP Kamera 9000A Internet IP Camera **This IP Kamera 9000 Plus is an IP camera that has a built web server in the camera. This camera can put up live image on-line and make remote locations immediately accessible through standard web browsers.General Features:- Pearl White profile- Embedded Web Server- 10/100Mbps Fast Ethernet Network Access(RJ45 Jack)- Multiple Camera Suported- Monitoring up to 9 locations at the same time- Capture Video Motion up to 25 frames- Support MSN & Yahoo Messenger - Default HTTP Port support- Network/Internet - Browser by Internet -IE & Netscape- Video output image to Displays - TV , PDP , HDTVResolution: - True: 640 x 480, 352 x 288, 176 x 144Color Setup: - Brightness- Contrast- Hue- SaturationSupport Network Protocol:- HTTP, TCP/IP, UDP, RARP, PING, DNS, DDNS, ARP, DHCP, BOOTP or PPPoEConnectors:- RJ-45 jack- 3.5 mm Audio in jack- On/Off SwitchRegulatory Approvals:- FCC- CERetail Box Includes:- IP Kamera 9000A Plus IP Camera- RJ-45 patch cable- Tripod- CD-Manual, Quick Installation and IP Program on CD- Quick installation - Power Adapter (100-240V 50-60Hz) Compatibility/Requirements/Disclosures: ** Requirements *** Intel Pentium II 300 MHz and above* Windows 98/98SE/2000/ME/XP* 64 MB RAM* VGA Card* Internet card with RJ-45* Internet Hub* One set of IP provided by ISP More ...
SpamCatcher Personal EditionSpamCatcher Personal Edition Are you annoyed with SPAM? Or worried about scammers fishing for your personal information? Tired of wasting time with offensive and unwanted emails? Do you wish you'd never see a chain letter, virus hoax, or an outright scam email - and hope you never will again? If so, we've got good news for you. Take control of your email inbox with SpamCatcher.Windows 98/Me/2000/XP More ...
3x3 Case Fan w/Adjustable RPM &Blue LEDs (Clear)3x3 Case Fan w/Adjustable RPM &Blue LEDs (Clear) ** 3 x 3 (80mm) Case Fan w/Adjustable RPM & Blue LEDs **Keep your system cool with this clear case fan! This 3 x 3 (80mm) case fan lights up with bright blue LEDs and features 4000 RPM speed and 52.6 CFM air flow. It is equipped with an adjustable RPM speed control by simply rotating the RPM adjustment screw and fan speed will increase or decrease based on your settings!General Features:- Clear design- 3 x 3 (80mm) case fan- Blue LEDs- Adjustable RPM speed- 4000 RPM speed- 52.6 CFM air flow- 41.7 dBA noise level- 12 VDC volatage- 6.5 W current- 3-pin power to 4-pin molex adapterRetail Blister Pack Includes:- 3 x 3 (80mm) Case Fan w/Adjustable RPM & Blue LEDs- Fan mounting screws Compatibility/Requirements/Disclosures: ** Requirements *** Power supply with available 4-pin Molex power connector* Case for 80 mm case fan* Area to mount RPM adjustment screw* Phillips screwdriver to adjust RPM More ...
ImageForge Standard version 3.60 releasedLatest version of this free image editor adds various improvements to its set of graphics tools. Now includes support for .GIF images and animation
|
