DBMS/U1 Topic 2 Organization of Database
Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft jet database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. In mid-May 2010, the current version Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version.
MySQL is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius’ daughter, my. The SQL phrase stands for Structured Query Language.
Microsoft SQL Server
Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI S SQL.
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS), produced and marketed by Oracle Corporation.
FileMaker Pro is a cross-platform relational database application from FileMaker Inc., formerly Claris, a subsidiary of Apple Inc. It integrates a database engine with a GUI-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms.
Singh (2009) illustrates advantages and disadvantages of DBMS. A true DBMS offers several advantages over file processing. The principal advantages of a DBMS are the followings:
- Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
- Fast response to information requests: Because data are integrated into a single database, complex requests can be handled much more rapidly then if the data were located in separate, non-integrated files. In many businesses, faster response means better customer service.
- Multiple access: Database software allows data to be accessed in a variety of ways (such as through various key fields) and often, by using several programming languages (both 3GL and nonprocedural 4GL programs).
- Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be shorter, which would increase user productivity.
- Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.
Warehouse of information, where large data can be stored.
Systematic storage meaning data can be stored in the form of tables.
Change of schema meaning it is not platform dependent tables can be edited to add new ones without hampering the applications.
No language dependence meaning use of various languages on various platforms.
Table joins meaning data can be in two or more tables and can be put into one table this enables easy retrieval of data.
- Data security meaning DBMS secures all your data.
- The data independence and efficient access of data
- Easy in data administration or data management.
- Provides concurrent access, recovers the data from the crashes.
A database system generally provides on-line access to the database for many users. In contrast, a conventional system is often designed to meet a specific need and therefore generally provides access to only a small number of users. Because of the larger number of users accessing the data when a database is used, the enterprise may involve additional risks as compared to a conventional data processing system in the following areas.
- Confidentiality, privacy and security.
- Data quality.
- Data integrity.
- Enterprise vulnerability may be higher.
- The cost of using DBMS.
Confidentiality, Privacy and Security
When information is centralised and is made available to users from remote locations, the possibilities of abuse are often more than in a conventional data processing system. To reduce the chances of unauthorised users accessing sensitive information, it is necessary to take technical, administrative and, possibly, legal measures.
Most databases store valuable information that must be protected against deliberate trespass and destruction.
Since the database is accessible to users remotely, adequate controls are needed to control users updating data and to control data quality. With increased number of users accessing data directly, there are enormous opportunities for users to damage the data. Unless there are suitable controls, the data quality may be compromised.
Since a large number of users could be using a database concurrently, technical safeguards are necessary to ensure that the data remain correct during operation. The main threat to data integrity comes from several different users attempting to update the same data at the same time. The database therefore needs to be protected against inadvertent changes by the users.
Centralising all data of an enterprise in one database may mean that the database becomes an indispensible resource. The survival of the enterprise may depend on reliable information being available from its database. The enterprise therefore becomes vulnerable to the destruction of the database or to unauthorised modification of the database.
The Cost of using a DBMS
Conventional data processing systems are typically designed to run a number of well-defined, pre-planned processes. Such systems are often “tuned” to run efficiently for the processes that they were designed for. Although the conventional systems are usually fairly inflexible in that new applications may be difficult to implement and/or expensive to run, they are usually very efficient for the applications they are designed for.
The database approach on the other hand provides a flexible alternative where new applications can be developed relatively inexpensively. The flexible approach is not without its costs and one of these costs is the additional cost of running applications that the conventional system was designed for. Using standardised software is almost always less machine efficient than specialised software.
Cost of hardware and software meaning having to upgrade the hardware used for file based system it is very costly.
Cost of data conversion meaning it’s costly to convert data of data files into database and have to hire database and system designers.
Cost of staff training meaning organization has to be aid a lot of amount for the training of staff to run dms.
Database damage meaning all data stored into a single file if database is damaged due to electric failure or database is corrupted on a storage media meaning all valuable data may be lost forever.
It also takes a lot of time and effort to get DBMS started.
Benefits of a Database Management System in an organization
As discuss by the Ezinearticles (2011), organizations often times find themselves in a dilemma on how they can effectively serve the needs of their members. At the same time, they also enter a situation wherein there is difficulty in handling data, given the sheer volume of information. More often than not, the results of these instances are not anything but desirable; confusion, chaos, mismanagement, lost confidence by members, etc.
To solve these problems, organizations turn to information technology (IT) experts for answers. With many years of experience in coming up with solutions for businesses and other entities, IT professionals have what it takes to come up with an effective data management and accreditation system that will be used by organizations. There must also be enhanced accessibility to the said system, which means that members from other locations can still gain entry into the system, regardless of elements such as time and geography.
Investing on the services of IT consultants is, however, not like buying something from a store. It entails huge sums of money to come up with a good data management and accreditation system for an organization, aside from engaging the professional services of IT experts. Fortunately, IT experts can help minimize the cost through the creation of a database system based on existing resources being held by the organization.
Investing on the services of IT experts and having a good data and accreditation management system may seem to be too costly, but the long-term benefits are worthy to be seen. By having a good database system, it will be much easier for organizations to deal with their members because of enhanced access to information. The placement of additional pieces of information can be done better if there is a good data management system.
Having a good data and accreditation management system empowers members of an organization. This is possible because they have the ability to gain the necessary information about things that matter to them as members. They conduction of business with the organization’s intervention is made faster and more efficient if a good data management system is in place.
There is no reason for organizations to hesitate when it comes to investing on a good data and accreditation management system. The long-term benefits of having one are far greater than the costs, and will be very helpful to the organization and their members in the long run.
- Improved strategic use of corporate data.
- Reduced complexity of the organization’s information systems environment.
- Reduced data redundancy and inconsistency.
- Enhanced data integrity.
- Application-data independence.
- Improved security.
- Reduced application development and maintenance costs.
- Improved flexibility of information systems.
- Increased access and availability of data and information.