Database Management Systems
The plain and simple fact is that e-businesses today cannot endure or prevail without quality data about their internal and external environment and operations (O’Brien, 2003). Therefore, many companies, large and small, need to use database management systems. We will be exploring some of the different types of databases, such as:We will also explore the different types of database structures, such as: In evaluating all of these various databases and structures, it will become clearer as to which is the best database management system for your company. Let’s start with operational databases, also known as, subject area databases, transaction databases, and production databases. This is a database containing up-to-date, modifiable data. Some examples of operational databases are Inventory databases, human resource databases, customer databases, and e-commerce database containing company information or data generated by the business. There are quite a few companies out there that sell operational database programs. For instance, the Informatica C
Next, let’s talk about distributed databases. It is a collection of several different databases that looks like a single database to the user. These databases can be found on network servers on the World Wide Web, or on corporate intranets or extranets (O’Brien, 2003). An example of a distributed database is the Internet Domain Name System (DNS) (foldoc.doc.ic.ac.uk, 2003). orporation sells one called PowerCenter 6. Informatica PowerCenter 6 is a data integration platform for building, deploying, and managing enterprise data warehouses. It enables users to easily transform data from various transaction sources into reliable information for strategic business analysis. Another operational database software is MicroStrategy 7i by MicroStrategy Inc. This program is an open platform that provides solid analysis of the business information stored in the computer system. This program can handle any size database and thousands of users. Some other features included are ad hoc query and analysis, statistical analysis and data mining, enterprise reporting, cube analysis, and report delivering and altering (Knowledgestorm.com, 2003). Like these, there are many more operational database programs available on the Web. The hierarchical structure was deemed insufficient in the late 60s because real connections between certain items of data were found to cut across branches of the pre-defined trees, therefore, the network structure emerged (btinternet.com, 2003). This structure is still used by some mainframe DBMS packages. This struct
Some topics in this essay:
Internet O’Brien,
Dell Computers,
External Databases,
MicroStrategy Inc,
Codd IBM,
According O’Brien,
Informatica PowerCenter,
,
Web Data,
System DNS,
o’brien 2003,
database management,
btinternetcom 2003,
database management system,
operational databases,
external databases,
database structures,
operational database,
types data,
hierarchical structure,
management system,
o’brien 2003 hierarchical,
complex types data,
hierarchical structured database,
database management systems,
Join now to see the rest of the essay!
Approximate Word count = 1045
Approximate Pages = 4 (250 words per page double spaced)
More Essays on Database Management Systems Professional Papers: |
CUSTOMER SERVICES
|
|
Saved Papers
You haven't saved any papers.
|