Systems Analysis

Systems Analysis















Systems Analysis

Database Development

Sample Articles

The basic categories of databases technologies are two: Database Management System (DBMS) and Relational Database Management Systems (RDBMS). Examples of RDBMS include MySQL and Oracle whereas an example of a DBMS is MS Access. Companies adopt different database technologies according to their preferential needs. This fact ranges from their capital investments, data to preferences. However, most companies in this era tend to adopt RDBMS, which keeps evolving annually. Modern information technology shops such as Microsoft, Sybase and Oracle keep changing their data technologies. The Microsoft development and data technologies represented in their paper regarding its historical progress displays its evolution. Similarly, database management papers of both Oracle and Sybase present the chronological progress of their technological development, which displays evolutionary significance.

New Database Technologies

            In the late 1980s, Microsoft had only two database services: Microsoft Access and MySQL server. However, that is not the present case. The company came up with additional databases as the years progressed. Development of its database technology enables it to provide more services. In 2010, it developed the direct data access. This was after the introduction of ADO.NET in 2003 and Language-Integrated Query (LINQ) in 2007. Conversely, their best innovation was the introduction of data in the cloud. The company plans to evolve the Open Data Protocol and Entity Framework in the future. In the Oracle Company, it introduces the PL and SQL database programs. Currently, it created the Oracle Database Extensions for .NET, which provides a common language for hosting its database. Other current databases by the two companies are object database management, in-memory, active and cloud databases as well as realistic databases.

Comparison and Contrast with Contemporary Relational Database Technology

Relational database includes a set of tables, which a server can manipulate in accordance with model of data. There are three relational databases, user, system and remote relational databases. System relational database relies on the presence of an iSeries system whereas user relational database refers to the additional databases on the iSeries system, which the user creates. Finally, remote relational databases refer to both non-iSeries and iSeries databases, which can be located remotely. Cloud database management is the most efficient database system since most data retains in the in the cloud technology providing an opportunity to programmers to develop it as the end users serve the maintenance purpose. Active databases are able to respond to both internal and external commands. Conversely, the realistic database management only makes analysis on the available data by drawing inferences. The object database management is slightly efficient since it draws object related information from provided data and proceeds to conclude it, thus efficient to both end users and developers


Impact of Internet Applications Growth

                        Information technologies have potential effects on the efficiency and distribution of database systems. It influences developers to alter their systems in order to make them compatible with recent developments provided on the internet. Increased internet applications means increased internet use, which promotes creation of low-cost computers. Innovation on computers means they have advanced properties such as portability, impressive multifunction and faster connection enabling organizations to adopt progressed network technologies. Furthermore, some of these applications rely on database management systems. Larger numbers of such applications attract the data-sharing notion hence, creating the need to shelter investments in DBMS software.

Serious Contender to Replace Relational Database Technology

Currently, non-relational databases in most organizations have evolved both outside and inside the cloud. This sends a key message that the need for scalability and vast solely relies on non-relational databases. In fact, no official organization or name for the new non-relational databases exists yet. On numerous occasions, their names refer according to their respective characteristics such as attribute-oriented, internet facing and document-oriented. The significance of value database overweighs those of relational databases. For instance, the key databases have no relations defined within a specific domain or between domains. However, relational analysis removes data duplication. This boosts relationship between tables, hence, establishing data relationships. Conversely, this direction is non-efficient in the current information technological era. This factor makes the non-relational databases replace the current relational databases.

CASE Tools

Most Popular CASE Tools

Computer Aided Software Engineering (CASE) refers to a set of methods and tools of a scientific application within a software system suitable for producing detect-free, maintainable and high-quality software products. There are various types of software support systems including real CASE and classic case tools. Classic CASE tools such as compliance and system architect assist in software development and support. Currently, there are various CASE tools used by various organizations for software development. The most popular is the artwork drawn, Visio. Manufactured by Microsoft Visio, this tool is efficient in creating schematic block diagrams including a physical map regarding the field of information. Visio is not only the most popular CASE tool but also the SourceNavigator. It is an upgraded form of the SourceInsight by having an additional win32 from the original Redhst Linux version. However, some organizations still prefer the original SourceInsight from the upgraded SourceNavigator. This is evident with the relative number of organizations who use this tool while developing and supporting software systems. Cynagus Solutions created these two CASE tools from which developers can choose which best suits their respective software. The Dia is the last most popular CASE tool in current use. Dia Developer resources created a tool that is sufficient and free.


Microsoft Visio has different versions such as the Visio v.1.0, Visio v.2.0 and Visio 2013. Due to its efficiency, the software has the largest number of users maximizing to approximately 4 million people from all parts of the world. Cynagus Solutions has a higher number of customers who split because of their different brands. The SourceInsight attracts approximately 1 million users whereas SourceNavigator has 2 million users. Dia’s popularity is relatively large but comparatively lower when compared with other popular CASE tools. Its user base is around 1 million. Therefore, the Microsoft Visio is the most used because of its high-valued specifications followed by SourceNavigators and SourceInsight and finally Dia. The popularity of a specific CASE tool depends on its efficiency.


The price of software depends on its efficiency. Microsoft Visio’s most expensive software is the Microsoft Office Visio Premium 2010, which costs $999.90 followed by the Microsoft Office Visio Professional 2007 SP2 and Professional 2010 with SP11 inclusive of both 32-bit and 64-bit, which costs $559.99. The cost tends to reduce with reduced proficiency. The Microsoft Office Visio Professional 2003 price is $349.95. Finally, its cheapest software tool is the Microsoft Office Visio Standard with SP1 that costs $249.99. SourceInsight’s 3.5 version costs $239 while the same version but with an additional CD-ROM costs $255. However, Dia’s popularity may be because it is free. Users have the ability to download it from the internet without incurring any costs. Due to the improved specifications and upgrading, the SourceNavigator cost relatively expensive compared to SourceInsight. The Enterprise Edition is around $499 while the Developer Edition’s price is $149.

Comparison and Contrast

Microsoft’s Visio software has by far the best specifications needed in developing software. Its ability to combine the design and various schemes including a map locating the specific field of information makes it ultimately unique. It is capable of presenting diverse types of diagrams such as maps, databases, visual networks, flowcharts, software structures and block diagrams. Its essence to developers is its ease of use such as the ability t run both separately and in unison. It can appear different forms such as a word document or an object while in other occasions it can appear as the integration of the two. It supports Unified Modeling Language (UML) dynamic and static models, which provides specifications and ways how the world molds not only behave application structure and architecture but also data structure and business processes. However, the software has few disadvantages such as its weak ability to configure diagrams.

Comparing the SourceInsight with the SourceNavigator, it is notable that they are relatively different with the SoureNavigator being more resourceful than the former. SourceIsight specifications are comparatively lower, hence not the best software to use. Nonetheless, it is advantageous in certain aspects. The presence of an original code makes it ideal for re-engineering browsing means by subdividing it into three parts. It also has the ability to highlight keywords from documents and newspapers with a perfect layout of the program. Its greatest disadvantage is the slow speed with which it conducts some processes.

Similarly, SourceNavigator has the same specifications as those of SourceInsight with slight differences in their operations. SourceNavigator’s speed is faster making it more efficient. It has an original code with the capabilities of editing and highlighting. It also contains class hierarchy, header and files. It most significant feature is the original code that facilitates file navigation because of its linkage to the files. The Dia Developers Resources are trying to market their product by offering it free of charge. This means that its popularity does not only depend on its specifications but also it’s pricing. Some of its important features are the ease with which one can draw customized diagrams and flowcharts, wide variety of technical objects and its ability to uninstall and install without issues. Comparing these tools show that the Microsoft Visio has the best specifications whereas Dia and SourceInsight have similarly the least.

Most Preferable CASE Tool for a Database Administrator (DBA)

Database administrators are technical personnel accountable for the environmental facets of a database. Microsoft Visio Professional is the most suitable. It is capable of create either upload able or printable diagrams due to the presence of the modeling tools. Additionally, the reversing engineering tool makes it possible to create a diagram from a previously existing database. The generic design tools help database administrators to have more authority due to additional database molding functionality. The presence of all these factors presents in one specific administrator makes it ore referable than others.

Calculate your order
275 words
Total price: $0.00

Top-quality papers guaranteed


100% original papers



Confidential service

We use security encryption to keep your personal data protected.


Money-back guarantee


Enjoy the free features we offer to everyone

  1. Title page


  2. Custom formatting


  3. Bibliography page


  4. 24/7 support assistance


Calculate how much your essay costs

Type of paper
Academic level
550 words

How to place an order

  • Push the orange button
  • Give instructions for your paper
  • Pay with PayPal or a credit card
  • Track the progress of your order
  • Approve and enjoy your custom paper

Ask experts to write you a cheap essay of excellent quality

Place an order