An In Depth Review Of Microsoft Access Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Microsoft Access is a system that manages the database developed by Microsoft which is packaged with Microsoft Office and compacted with the Jet relational database engine combined with a graphical interface. It is meant to be a user-friendly using the Database Management System (DBMS) product especially for the average unskilled programmers and even for the non-programmers but frequent users to easily developed much sophisticated and complex database. Meanwhile, for skilled developers, programmers and data architects, it will give an unlimited access for sophisticated application to be developed as it will tremendously assist them to be creative and innovative.

One of the major benefits of Microsoft Access is that it is relatively compatible with SQL as the queries can be converted to SQL statements whereby users will be able to view and edit such database. It also uses Visual Basic Application programming language in order to create forms and logic and will give more object-oriented opportunities. Microsoft Access is broadly used by hobby and part-time programmers as well as small businesses to create additional features for customizing systems in tackling small tasks. However, professional programmers will use Microsoft Access to build a much more powerful and speedier application to the extent that it can be integrated to other sophisticated DMBS products.

The main objects within a Microsoft Access Database are tables, queries, forms, reports, data access pages, macros and modules. This database is known as files in which data are stored which will include all major objects related to the storing of data and also objects defined to automat the data usage, while the term database in other database systems is only referred to files which data are stored. Below are the summary of the major objects in Microsoft Access Database:

Table

An object that is defined and use for storage of data whereby each table will consists of information of a specific subject such as orders or customers. A table will have columns or also known as fields with various kinds of data been stored such as name or address, and records or also known as rows with collection of information of a particular instance of subject such as company information. A primary key is known as one or more fields with each record having its own particular unique value, and one or more indexes to assist in retrieving data faster from each table.

Query

An object that gives a standard data view from one or more tables whereby in Microsoft Access, graphical query by example (QBE) facility can be used or even to write SQL statement in order to create queries. Query can be defined to select, insert, update and delete data as well as creating tables from data in one or more available tables.

Form

An object developed mainly to input and control data as well as for control in implementing the application. It can customized the data presentation that are generated from tables or queries.

Report

An object developed meant for the purpose of formatting, calculating, summarizing and printing the data been chosen. Users will be able to view the report before decided to print it out for report purposes.

Data Access Page

An object that gives standard access to data from Microsoft Internet Explorer which it features will have an HTML and other supporting files. Files can be published through intranet to give access for other users on the same network for them to search, view and edit such data available.

Macro

An object of a structured definition with one or more actions needed to be performed for a defined event. It could also run the easy conditions of macros to customize when one or more actions in the particular macro should be executed or avoided.

Modules

An object that have standard procedures with Visual Basic coding whereby it give a more detail actions flow and at the same time able to identify errors that is impossible with macros. It also can be a stand-alone consist of functions that can be retrieved from anywhere within the applications.

2.0 MICROSOFT SQL SERVER 2008

Microsoft's Data Platform vision of developing Microsoft SQL Server 2008 was built meant to assist companies to handle various data throughout places at all time. It main function is for storage of data straight from within the database itself from various sources and it could be in the form of unstructured and structured as well as semi-structured documents which comes in various form such as images and rich media. It also has given a new dimension of a rich set of combined and interrelated services which enable a lot more that can be done with the data stored which can be in the form of searching, querying, synchronizing, analyzing and also reporting.

In terms of security, Microsoft SQL Server 2008 gives the maximum level of scalability, reliability and security for business oriented critical applications. In this regards, organizations must have the capability to create and also must be able to the ability to identify as well as solve data as immediate as possible. Microsoft SQL Server 2008 takes an organization a step forward by taking advantage of opportunities that arise in the ever fast-moving business world by reducing the management of time and cost apart from continuous applications development.

Apart from the above statements, Microsoft SQL Server 2008 gives a detailed platform which can delivers brilliant and intelligence upon request from the end-users. The ability of a company to access data within the organization and by having control of the data available regardless of the storage location which is from the biggest servers within the center of the data to personal computers and even to mobility services.

Furthermore, end-user especially the information personnel will be able to access the data directly hassle-free by using and adapting the commonly used application and tools that are used every single day such as the Microsoft Office System applications and tools. The 2008 Microsoft SQL Server 2008 will have the ability in consuming data from standard applications that already been developed by using Microsoft.Net, Visual Studio, within the service-oriented architectures (SOA) via through Microsoft BizTalk Server.

For better understanding of the above explanations, it is best summarized and illustrated in the below Microsoft SQL Server 2009 Data Platform Diagram:

Figure 1: Microsoft SQL Server 2008 Data Platform Diagram

(Source: Microsoft SQL Server 2008 Brochure. Accessed on 31 January 2010 from http:// download.microsoft.com/download/a/c/a/aca65fab-dd31-4caf-af6a-34fe3f8dd074/SQLServer2008_ Brochure.pdf)

The Microsoft SQL Server 2008 is best known for the ability and capability in providing solutions of the modern database management concepts which are as follow:

I. Business Intelligence.

This DBMS product will be able to give solutions in terms of giving measurable platform of business intelligence by maximizing the functions of data processing of integrating, analyzing and reporting the data needed.

II. Virtualization and Server Consolidation.

In today's world of IT era, among the hot issues been discussed is the hardware virtualization which is also known as server virtualization because it will give a dramatic savings in the costing perspective while at the same time enabling the organization's business potentials. Meanwhile, the server functions will have the flexibility in creating server consolidation solutions with business-class ability to manage and to perform well.

III. Data Warehousing and Application Development

This DBMS product will provide a detailed and measurable platform of data warehousing that will let companies to relate and integrate the data in a much faster manner and at the same time handling the ever growing quantity of users and data while giving the insights to all the available users. It can also be considered as the most important functions in the platform of comprehensive data programmes that will let access to those data and also to manipulate the organizational-critical data from various data, devices and platforms.

Overall, Microsoft SQL Server 2009 will be able to provide a database with high measurable performance engine capability in order to tackle business-critical applications. It is customized to be able to adapt to the highest level of security and availability, and at the same time, will be able to reduce the overall total cost of business by enhancing the business-class ability of management.

3.0 MICROSOFT SQL SERVER 2008 EXPRESS

Microsoft SQL Server 2008 Express is actually a free edition of SQL Server meant ideally for the purpose of learning, empowering and also developing desktops, web as well as small server applications. It is specially build for fully-featured small scale solutions to database management. Among the top features of Microsoft SQL Server 2008 Express are as below:

a) The ability to support data storage procedures, functions, views and triggers.

b) Stored various kinds of business data with the older vision types of supports such as for relational and spatial data, Filestream as well as XML

c) Improving the aspects of usage, visualize and also increasing the performance to add up with integrating and relating data with Microsoft Office System in the SQL Server Reporting Services.

d) Making easier the data development process by leveraging the ever existence of T-SQL skills and ADO.Net Entity Framework as well as LINQ.

e) Able to closely integrated and related with Visual Studio and Visual Web Developer.

A Powerful DMBS Product

Microsoft SQL Server 2008 Express has been developed to adapt the high-performance applications by utilizing the embedded database engine of SQL Server which will gives better compact footprint of functionality. It is also built meant for robust applications by using advance SQL Server characteristics to create either desktop or server applications. The uniqueness of this DBMS product is that it is able to upgrade the performance of applications and also centralizing the business logic through data storage procedures, integration, views as well as triggers.

In terms of managing the data, Microsoft SQL Server 2008 Express is able to handle and leverage various types of data which also include either unstructured or structured data. The ability of storing all kinds of organization data is also highly noted especially in dealing with native support of XML, spatial and also for relational data. It also will be able to do the task of delivering relevant needed information by visualization of the data through SQL Server Reporting Services and creating user-friendly readable reports that will help answer difficult question and at the same time understand the data.

A Productive DBMS Product

Microsoft SQL Server 2008 Express has simplified the efforts of development by leveraging the existing Transact-SQL skills by incorporate the new technologies which include ADO.NET Entity Framework and LINQ. It further assists users to develop a much quicker applications through the inter-relation and integrating the Visual Studio and Web Developer 2008 as well as SQL Server Management Studio.

It is also noted that this DBMS product is capable to leverage the existing skills by solving the ever complex of businesses and also rectifying the application needs with full support for Transact-SQL. This express edition will build intelligent data access norms and identify the business logic by storing the procedures and functions of user-defined. Hence, through triggers, it will help to respond to the end-user activity and react in data modification as well as by using views, will improve the performance endurance with consistent query logic.

Apart from the above, this DBMS product will also help to accelerate development by modelling the data using the new ADO.Net Entity Framework hiding the database scheme details and accessing the data suing entities that almost resemble the business logic. It is also a product use to increase the developer's productivity and thus making the deployment effort simplify by taking advantage of the inter-relation and integration with all editions of Visual Studio and Web Developer 2008.

A Flexible DBMS Product

Microsoft SQL Server 2008 Express has successfully develop the applications that will be able to manage as well as access to all types of data from various resources and simultaneously keeping the data been synchronized easily with a central database. It also has the advantage of simplifying the remote management business data infrastructure with the Policy-based Management and the policies to instances of SQL Server Express. It has also the ability to synchronize the corporate data by keeping the data with the product support for SQL Server Transactional and Merge Replication by leveraging the capabilities of the advanced conflict resolution to develop the robust business solutions. It also has the ability to access even with PHP whereby PHP developers will be able to access to SQL Server databases with the driver for PHP and even write PHP code within Visual Studio.

4.0 ORACLE DATABASE 11G

Oracle made a lot of efforts to improve the upgrading process of the database whereby the efforts of development needed in verifying, testing and upgrading the application. The invention of Oracle Database 11g will be much easier as well as faster and at the same time reducing risk than previously before. Oracle Database 11g is proven faster and smoothen the development process making it tempting for businesses to eliminate the idea of upgrading the older Oracle databases versions.

Oracle Database 11g was specially designed for assist in improving the business's bottom line. This will definitely assist an organization in determining if the value propositions and benefits are bigger that the cost of upgrading older visions. In the world of information technology, the creation of new features is often the primary target that can of justification for the upgrading process. Below are some of Oracle Database 11g enhancements:

New Change Assurance Capabilities

The pressure of an organization is to move faster and simultaneously manage the changes always remain the same and constant. In the world of technology, the system change in terms of hardware as well as software and applications patch are important for an organization in order to maintain the rapid competitiveness edge. Its feature of Oracle Real Application Testing compiled the capture of workload and replay feature with a SQL performance analysis to assist against real-life workloads comes together with the capabilities to fine-tune all the workloads before letting them back to the production. The best thing about Oracle Database 11g is the time of testing been reduced and the accuracy of testing is very much improved which have resulted in lower production deployment and most crucial is the decreasing the cost of such business.

Reduced Storage Needs.

The function of Oracle Advanced Compression gives a detailed set of compression abilities whereby by enabling compression for various types of data tremendously decreases the storage of database storage in terms back up data, unstructured or even structured data. The innovative Advanced Compression Technologies are built to decrease requirements of resource and cost for components of an IS infrastructure that is the network bandwidth, memory and back-up media.

Stronger Data Security.

Business need to highlight the requirements to regulatory compliance by having protecting sensitive data within the database itself and not to forget on backup media or even on the network from undisclosed authorization. Oracle Advanced Security will gives a much comprehensive but yet easy to implement solution in order to protect whatever communication to and from an Oracle Database. Meanwhile, Oracle Database Vault will the "who, when and where" data and applications that are available for access, hence will be able to protect organization against various security threats and also malicious internal users.

Faster Performance

One thing that is very fascinating is the Oracle Database 11g abilities to provide various performance achievements. The function of Oracle Real Application Clusters (Oracle RAC) has improved in terms of performance for various types of workloads. Furthermore, a lot more enhancement in performance has been put in various areas such as the Oracle Streams which is now up to two (2) times faster, while giving accurate and faster results in terms of the optimizer statistics gathering. It is also clearly obvious that the speeding up can be seen in a lot of business intelligence applications as a result of using the new partitioning methods as well as materialized views.

Greater Availability

As in the era of IT revolutionary, companies will be facing with a lot of challenges in efforts to further develop the quality of services and simultaneously trying to reduce any complexity and unnecessary cost implications. Companies will try to gain consistent in high performance by offloading the supplementary work to an imitation of production database. Therefore, in Oracle Database 11g will provide the Oracle Active Data Guard which will gives users the ability to utilize the standby database in order to improve the environmental production and at the same time giving ample protection of any system failures or even disasters of site-wide.

Enhanced Database Management Capabilities

In order to manage database will definitely requires valuable administrative resources. In Oracle Database 11g, it will continue to provide improvement of user's productivity by introducing the new management capabilities and at the same time will tremendously save in the terms of the organizational operating cost. The function of Oracle Diagnostic Pack 11g will give self-diagnostic solution which will enable Oracle Database 11g automatically identify the problems in the performance, and therefore easy the users of solving difficult and complicated tasks.

MYSQL 5.1

MySQL 5.1 is one of the most popular Open Source SQL database management system which is supported, distributed as well as developed by Sun Microsystem, Inc. A database is basically a structured collection of data and may be everything beginning from a simple shopping list to a picture gallery or even to the extent of vast amounts of information in a corporate network. An organization will need a DBMS such as MySQL 5.1 in order to process, add and process data stored in a computerized database. This DBMS product plays a vital role in computerization in terms of role as utilities standalone and also as other application parts.

SQL means Structured Query Language whereby it is the most familiar standardized language for accessing the database and will be defined by the ANSI/ISO SQL standard. My SQL 5.1 is considered as a relational database that will separate tables rather than letting all the data available in one big storeroom. Through this separable table, these will help increase the performance by adding the speed and flexibility in the DBMS itself. MySQL 5.1 software is considered an Open Source which means that the software is available for any person to modify and use it and therefore anybody will be able to download the MySQL 5.1 software from the Internet and at the same time using it without having to pay any cost for such usage and downloading.

This MySQL 5.1 has proved that it is one of the Database Server that is recognized as very reliable, easy to use and very fast to complete tasks. It has a set of practical features specially built with close collaborations with the clients. It was initially built to be able to handle large volume of database in a much faster way compared to the existing solutions. Furthermore, it is also proven that it has been very successful utilized in production of a highly demanding environments. Even though the development of MySQL is still ongoing and continuously developed, MySQL 5.1 promised to offer a useful and richer set of functions by having connectivity, security and speed which makes it is highly suited to access databases through the Internet.

MySQL 5.1 eventually works in a client or server or even embedded systems. This database software is considered as a server or client system having a multi-thread SQL server which will be supporting the back ends differently, several clients programs differently, administrative tools and lastly a bigger range of application programming interfaces (APIs). It also will be able to act as a library's embedded multi-thread that can be linked into the application in order to get the result of a easier-to-manage standalone, a faster and a smaller product of DBMS. Among the features included into MySQL 5.1 are as below:

a) Partioning

The ability to enable distributing part of individual tables across a file system and is in accordance to rules that it can be set when the table is created. As for MySQL 5.1, queries against partitioned tables can take advantage of the pruning partition. In some circumstances, it can result in execution of query which is a magnitude order faster than same query against a non-partitioned version of such table.

b) Row-Based Replication

The capabilities of replication in MySQL 5.1 initially were based from the SQL statements propagation from master to slave and it also known as statement-based replication. It will have another replication basis available which is called row-based replication. This means that instead of sending SQL statements to the slave, eventually the master will write events to reflect to its binary log which shows that how does the individual table rows are effected. It will also have a third option available called mixed whereby it will have usage ability to use the replication of statement-based by default and only change to row-based application in certain cases.

c) Plugin API

MySQL 5.1 in definite has include supporting for a very flexible plugin API which will enable the tasks of loading as well as unloading various components at runtime without even having to restart the server. Although the work done is not totally completed yet, the plugin full-text parsers are actually the first step in that direction. It will allow users to implement their own filter of input on the indexed text, enabling full-text searching ability on arbitrary data such as PDF files or other relevant document formats. A pre-parser full-text plugin will perform the actual parsing and also the text extraction and hands it over to the built-in MySQL 5.1 full text search.

d) Event Scheduler

In MySQL 5.1, the events are considered as tasks that proceed in accordance to a schedule. In other words, when creating an event, the user must create an named database object consisting one or more SQL statements and to be executed at one or more regular intervals that begins and ends at a specific date as well as time.

6.0 IBM DB2

It is very possible that the database administration cost maybe exceeding the cost effecting the database hardware as well as software. Therefore, it is very crucial that the administrator of the database time be utilized efficiently and efficiently. IBM DB2 will consist of numerous autonomic characteristics such as the Self-Tuning Memory Manager that will operate to free the database administrator from various frequently administration tasks. Hence, database administrator will be able to spend lesser time handling the system and this valuable time can be concentrated in focussing on other activities that may benefit the organization.

Organization with businesses that have a large volume of data will feel the expensive cost of storage of database. In this case, IBM DB2 will be able to decrease the cost drastically with the benefits of the industry leading data compression technologies. Its function is mainly to compress rows, indexes, temporary tables, LOBs, XML and even back-up data with compression rates that can reach up to over 80%. With the compression benefits, it will give way for IBM DB2 in keeping more data in the memory by avoiding the performance-robbing disk I/O and will resulting in database performance be increased considerably.

Over a period of time, it is recognized that IBM DB2 has controlled the benchmark of the key performance which include both On-Line Transaction Processing (OLTP) and also On-Line Analytical Processing (OLAP) benchmarks. World class performance for businesses if when organization running the IBM DB2 and as a result, it can do work with existing hardware, therefore, delaying or avoiding costly server upgrades.

In terms of the scalability, IBM DB2 pureScale utilizes a cluster-bases, high availability and shared-disk architecture in order to offer an easy scalability. It will avoid various of drawbacks of cluster-based shared-disk solution from other competitor's vendors. Other solutions available incur a cluster overhead which will limit the scale ability beyond a few nodes as it grows with efficiency of near-linear. Other solutions will take minutes to resume the processing after a node failure, and simultaneously will continue to operate without degradation of performance. IBM DB2 will allow organization to go through to do the scale of the database even without system tuning and with minimal changes to application code.

The ever present threat of unauthorized data access is something of a important matter as will result ending up the costing business considerable sums of money and reputation or even both of the them. IBM DB2 will have a detailed security features that effectively and ultimately minimize this kind of threat. It will provide additional peace of mind with lightweight security audit mechanism which can be utilized to identify that there has been no unauthorized accessing of data. For most businesses, the database downtime will be the same as both money and opportunity loss. IBM DB2 will be able to minimize the downtime that related with various planned activities by either to totally eliminate the downtime or in reducing the duration to a few seconds.

The XML will definitely reduce the developing cost and also assist to maintain applications by continuously evolving reporting abilities and evolving input such as simple example of on-line income tax forms. With the breakthrough native XML support only provided by IBM DB2, therefore the benefits of XML will extend to the database and also include the capabilities to easily evolve an XML schema or the existing XML data in the particular same table.

Good database tool cut costs by making expensive application developer, DBA and other human resources be more productive. Furthermore, good tools can be helped with someone with average database skills achieving the results of an expert. For these reasons, IBM DB2 may also consists various useful tools such as Configuration Expert which optimally configures IBM DB2 to its hardware at installation time. Complimenting the tools consist of IBM DB2 is a much bigger range of IBM Data Management tools to assist with all aspects of data management life-cycle.

For businesses with multiple database servers were not using full hardware capacity but the cost-saving benefits of virtualization are clear, space savings, reduced power and cooling. IBM DB2 will let businesses enjoying this saving that with flexible licensing terms which allow all various aspects of IBM DB2 to be deployed in virtualized environment matter.

As a conclusion, IBM DB2 will be managing data smarter, more reliably, faster and less cost than ever before. The IBM DB2 has a solution for every need that to meet all demands with thousands of users and most demanding workloads.

Sources:

a) Kroenke, David M. & Auer, David J. (2009). Database Processing: Fundamentals, Design and Implementation (Eleventh). New Jersey, USA: Prentice Hall.

b) Microsoft SQL Server 2008 Brochure. Retrieved on 31 January 2010. <http://download.microsoft.com/download/a/c/a/aca65fab-dd31-4caf-af6a-34fe3

f8dd074/SQLServer2008_Brochure.pdf)>

c) Microsoft SQL Server 2008 Express Overview. Retrieved on 31 January 2010. <http://www.microsoft.com/sqlserver/2008/en/us/express.aspx>

Why Upgrade to Oracle Database 11g. An Oracle White Paper (July 2009). Retrieved on 2 February 2010. <http://www.oracle.com/technology/

products/database/oracle11g/upgrade/presentations/11g_upgrade_benefits_whitepaper.pdf>

e) MySQL 5.1 Introduction. Retrieved on 2 February 2010. <http://dev.mysql.

com/doc/refman/5.1/en/introduction.html>

f) Introduction to IBM DB2. Retrieved on 3 February 2010. <http://www-01.ibm.com/software/data/db2/linux-unix-windows/features.html>

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.