Abstract This paper discusses the increasing need for easy to operate databasemanagement systems and reviews the products currently available in the market. The three main players in this field are IBM, MICROSOFT and ORACLE.
Discusses the two major types of databasemanagement systems: relational databasemanagement systems (RDBMS) and object-oriented databasemanagement systems.
Abstract The paper explains the development, function, and purpose of databasemanagement systems. It explains the differences between the two major types of databasemanagement systems and evaluates some of their strengths and weaknesses. A comparison chart of databasemanagement systems is included at the end of the paper.
From the Paper "Object-oriented database management system (ODBMS) vendors were hopeful that future applications would be implemented with pure object-oriented systems (Devarakonda, 2001). Initially, these systems looked promising, but they were unable to live up to the expectations. A new technology has evolved in which relational and object-oriented concepts have been combined or merged. These systems are called object-relational database management systems (ORDBMS). ORDBMSs best ODBMSs in most situations because they can provide massive scalability as well as object-oriented features. Today, ODBMS use is mostly confined to niche applications where the data being managed falls into hierarchical structures with numerous and somewhat unpredictable relationships between data objects."
Abstract This paper explains that Object-Oriented DatabaseManagement Systems (OODBMS), which emerged in the 1990s, quickly found their niche in handling complex data types; however, the long-term vision of OODBMSs to replace relational databases has never materialized. The author points out that OODBMS technology remains a small niche market, generating only around a few hundred million dollars in revenues, compared to the multi-billion dollar relational database market. The paper states that the goals of large relational database vendors, such as Oracle, IBM, and Microsoft, have been to synthesize the best of relational databases and OODBMs, such as the flexibility of the OODBMS data model and the performance of relational database functions, into an Object-Relational DatabaseManagement System.
From the Paper "OODBMSs first started to be researched in the 1980s and the first commercial products gradually appeared in the early 1990s from vendors such as Object Design, Objectivity, Versant, Computer Associates and Ardent. By the late 1980s and early 1990s it was recognized that object oriented (OO) languages had some very strong advantages over non-OO languages for many programming applications. OODBMSs emerged to reduce the impedance mismatch between the programming languages and the DBMS, to offer performance advantages (due to navigation from roots and sophisticated caching and swizzling technologies), and to provide transparent support for complex user-defined types including the ability to store, call and query complex objects directly."
Abstract In today's information-rich society, databasemanagement is an ever-expanding and increasingly important field. This paper discusses databases, databasemanagement systems (DBMSs), and their importance in today's society. Additional topics include the need for security, concurrency, and control within databasemanagement, as well as the role of the database administrator.
From the Paper "A database can be defined as "a structure that can house information about multiple types of entities, the attributes of these entities, and the relationships among the entities" (St. Edward's University). Databases can contain a wide variety of information. For example, a university database may include information about students, courses and classrooms. Further, this university database may contain significant amounts of information about the relationships between these entities, such as student course enrollment, and the use of classrooms for courses (Ramakrishnan)."
Abstract This paper discusses on-line information technology and the problems that exist in database security. It continues to offer solutions to this problem, in discussing legislation, software and hardware to protect information databases from the illegal and malicious threats that effect them.
DatabaseManagement Systems
Database Security Policies
System Security Policy
Data Security Policy
User Security Policy
Auditing Policy
Bibliography
From the Paper "There are many measures and security policies that can be implemented to prevent illegal access to private databases. Typically, every security policy is dependent on the other policies. It is important to note that security policies work best if all the policies embedded within have strong walls against unauthorized access. Otherwise, once one policy fails, there are tendencies that its vulnerability and failure to protect the network, database, or information, can affect the rest of the policies. Following are some of the common policies, as extracted from Oracle Server Administration Guide, that are applied by many organizations which utilize information technology methods for database and information safety and security."
Abstract This paper discusses the use of an enterprise databasemanagement system and outlines the ways in which it can be used by a government contracting company to expand its business. The paper also highlights the attracting features and functionality offered by a DBMS and explains how it can improve activities at strategic, tactical and operational levels.
From the Paper "A DBMS renders the interface between the application program and the data. If the Government Contracting Company plans to expand its business, then a DBMS would make the data representation for the users and the developers a lot easier. If any changes are made to the data representation, the metadata maintained by the DBMS would automatically be modified and the DBMS would persevere to render data to application programs in the usual manner. "Hence, unlike previous databases the DBMS handles the task of transformation of data wherever necessary" (Gopal Gupta, Advantages Of Using A DBMS). The independence provided by the DBMS between the program and the data is referred to as data independence."
Abstract This paper examines the role of the database administrator, why they are necessary in organizations and how a database administrator differs from a knowledge manager. The paper examines the various jobs and functions of databasemanagement in large organizations.
From the Paper "Few companies today are able to exist without an information technology department. Whether a large multinational conglomerate or a small retail establishment nearly all companies rely on computers to some degree. Some companies are highly dependent on computer systems while others use them only for accounting and related tasks. Every organization even the smallest company has at least one person whose job entails making sure that the computer system is up and running or at least knowing who to call when the computer system goes ..."
Abstract This paper states that current technology now removes the risk of the data and information within a database from being used for illegal or fraudulent activities. The author points out that these new advances are related to new databasemanagement software, which can customize user accounts and access to the data as well as encrypt all of the data in a given database. The paper explains that data mining is one of the primary activities that is used to illustrate how important data security and management has become across most industries. The author suggest that failure related to security and encryption features is usually associated more with the planning, selection and deployment of the data management solution rather than intrinsic faults within the solution itself.
Table of Contents:
Executive Summary
Research Hypothesis
Introduction
Explanation of the Technology
Historical Background
Technology
How it functions
Suppliers
Consumers
Application of the Technology
Organizational use
Applications
Strengths and Costs
Weaknesses
Success
Failure
Future Trends
The future
Forces of change
Conclusions
Key Findings
From the Paper "Previously, most healthcare organizations were content to rely on internal IT platforms to automate some aspects of their internal functions without engaging the full spectrum of IT solutions such as data mining and data warehousing in a non-secure environment. Most often, these pre-existing IT solutions for healthcare management are independent software applications or separate modules of a healthcare enterprise resource planning (ERP) system that rely on existing databases of some type. While the application and use of these independent applications and ERP modules can certainly introduce cost-savings into the equation, they require an upfront investment in either IT applications, IT infrastructure or both, as well as on-going management of these new systems."
Abstract This paper methodically examines Access SQL, MS SQL Server 2000, Oracle, DB2 and MySQL. The author explains, for example, that MS Access is a relational databasemanagement system used on desktop computer to manage information on different levels for different purposes and provides some capabilities for making a database available on the web. The paper continues, for example, that the system requirements for DB2 includes a Microsoft Windows 2000 SP4, Windows XP SP1 or Windows 2003 Server operating system, a Pentium 100 MHz or faster processor, 128MB or more RAM and a hard drive with 75 MB of free disk space with additional space required to store vulnerability information.
Table of Contents
MS Access
System Requirements (Access 2003)
Company
MS SQL Server 2000
System Requirements (with Service Pack 4)
Company
Oracle
System Requirements
Recommended Server Specifications
Minimum Client Specifications
Company
DB2
System Requirements
Company
MySQL
System Requirements
Company
From the Paper "Oracle is a relational database management system. Oracles latest technology, today's system designers and developers can build 21st century enabled applications ranging from critical online transaction processing systems supporting thousand of users to multi-terabyte data warehouses for decision support and also World Wide Web-based applications. Bradmark Technologies is a company that offers database management software used with products from providers including Oracle, Sybase and Microsoft. Customers in a variety of industries use Bradmark's products for tasks such as database monitoring, performance tuning and database administration."
Abstract The paper considers how a relational database can be used to store types of files not normally stored in this manner, such as images. The paper finds that a means of doing so has been developed for art history classes so that the instructor can access information, including images, as needed. The paper demonstrates how relational databasemanagement systems provide for relating files, or linking files to one another through a key field. The paper explains how a relational database system has the advantage of allowing a simple database system to grow as needed.
From the Paper "Relational database management systems provide for relating files, or linking files to one another through a key field. A relational database system has the advantage of allowing a simple database system to grow as needed. Data file management is flexible so it can handle integrating new requirements. In order to make a database system work, there are certain design rules that need to be followed. It is important to eliminate any repeating groups of fields and it is necessary to eliminate fields that do not depend entirely on the key field (Dologite 164-165). Databases in the future are likely to be influenced by five factors: developments in telecommunications, scanning and storage improvements, increasing database distribution options, user needs and demands and changes in database production. These are the factors influencing databases today, and they will continue to be the pivotal elements in the future (Tenopir 70-71)."
Abstract This paper discusses the importance of using a database for the efficient running of a modern hospital. The paper describes the uses of a database and what type of information it can store, from patient records to employee information. The paper describes the advantages of an enterprise DatabaseManagement System (DBMS) like the recommended MySQL Network that includes advanced customer support, reduces the paper trail and provides data driven applications. The paper includes some lists.
From the Paper "The database and database strategy are vital parts of any modern business. As you would expect in any business involving a large number of clients, computerized databases will play an important role in the data infrastructure. Customer records will be kept in a safe, fast and reliable database to maximize efficiency. This document will recommend a database plan for a hospital including potential uses, advantages and a recommended project plan to develop the database."
Abstract The growth of information technology in line with the growth of the Internet demands for more data storage to facilitate retrieval of information at a rapid pace. The increased capacity og data storage gives rise to data warehousing and data mining, enabling businesses to index their data and formulate plans and projections using business intelligence mechanisms. In this essay, the writer discusses enterprise databasemanagement systems (DBMS). The writer concludes that no matter what the case may be, enterprise DBMS will continue to find its niche in various enterprise applications. Further, the writer notes that it will continually grow, as seen in various vendor sales statistics, and will be able to adapt to varying information technology changes.
From the Paper "Enterprise DBMS have been applied to geographic information systems, cross continental supply chain management systems and global contact centers. Its robustness, scalability and dependability make it an ideal platform for business with global reach or international affiliates and connections. For enterprise resource planning (ERP), the enterprise DBMS is the most suitable type of database for deployment however, the major debilitating factor is cost-enterprise DBMS are very expensive both in terms of purchasing and maintenance."
"Some flavors, both proprietary and open-source, of the enterprise DBMS are:
1. DB2 Universal Database Enterprise Edition 7.2 - A multimedia, Web-ready RDBMS for e-business applications such as electronic commerce, enterprise resource planning (ERP), customer relationship management (CRM) supply-chain management, Web self-service and business intelligence."
Abstract The narrow focus of the research is the appropriate level of convergence and divergence between education and practice in databasemanagement systems for the period 2001-2020.
Two research questions are investigated:
1. What emphasis distribution between theory and skills during postsecondary databasemanagement systems education will have the greatest positive impacts on the effectiveness of databasemanagement systems practice over the long-term?
2. Will a dichotomy of perspective between databasemanagement systems educators and practitioners concerning the appropriate emphasis distribution between theory and skills during postsecondary databasemanagement systems education have negative impacts on the effectiveness of databasemanagement systems practice over the long-term?
The research strategy proposes to investigate the issue of the appropriate level for the gap between education and practice in databasemanagement systems will involve both structural analysis and phenomenological analysis. Structural analysis is applied to investigate the potential roles of theory and skills development in postsecondary education as a means of promoting long-term effectiveness in databasemanagement systems practice. Phenomenological analysis is used in the proposed study to collect data, refine issues, and analyse data within the context of the research questions investigated.
Table of Contents
Abstract
Statement of the Problem
Significance of the Study
Barriers and Issues
Research Questions
Limitations and Delimitations of the Study
Definition of Terms
Summary
Review of the Literature
Historical Overview of the Theory and Research Literature
Theory and Research Literature Specific to the Topic
Summary of What Is Known About the Topic
Contribution the Study Will Make to the Field
Methodology
Research Method
Procedures
Formats for Presenting Results
Projected Outcomes
Resource Requirements
Reliability and Validity
Summary
Discussion of Expectations
Anticipated Benefits
Projected Outcomes
Practical Applications and Findings
Constraints and Limitations of the Study
Contributions to the Field of Study and Advancements of Knowledge
Reference List
From the Paper "The revolution in postsecondary education in the late-1980s and early-1990s focused in part on the relationship between academic instruction and professional practice in most disciplines. Proponents of the so-called "new pluralism" emphasize a need for a closer integration of theory, practice, and skills within the educative process (Edwards, 1993).
While few in either academia or the professions advocate a complete de-linking of theory, practice, and skills, many do advocate that the role of academia is to provide the theoretical grounding that will permit graduates to practice in a productive manner throughout a professional career, easily adjusting to innovations as they are introduced (Beyer, 1983). For some, the issue is whether postsecondary education should be for life or for a particular job (Macfarlane, Jeeves, & Boon, 1987). This latter position holds that postsecondary education that focuses on skills development in relation to specific tasks or the ability to apply specific technologies in an expert manner reduces postsecondary education to the level of vocational education, as opposed to preparing individuals for lifelong learning and developing a capacity to grasp and apply innovations as they develop (Madden & Mitchell, 1993)."
Abstract This paper analyzes the potential use of databases in the kitchen and looks at the advantages that a specialized databasemanagement system could offer to the culinary management sector.
From the Paper "This online recipe database is to be designed such that people can view the individual recipes and the preparation methods as well create and update their own favorite recipes. Furthermore the company is also interested into using the web as a means of increasing their business by accepting customer orders online and delivering them in a fairly short amount of time. The problem currently faced by the restaurant is that there is no proper integration between the different branches and this results in considerable loss. To avoid this loss there is an immediate need for designing complete recipe management database system. A fully integrated recipe database would facilitate real time information exchange pertaining to the different items. This would allow them to control their schedule with a view to optimizing the production. This is particularly significant for a big chain restaurant like "Funday" where a database system would constitute an effective decision support system."
