Verified Document

IBM DB2 Express - C Installing And Essay

IBM DB2 Express - C Installing and Analyzing IBM DB2 Express -- C

IBM DB2 Express-C database for Microsoft Windows was downloaded, installed and used as the basis of analysis in this paper. What differentiates UBM DB2 Express-C from the many comparable low-end enterprise-level databases is support for XML integration, dual core processors and 2GB of memory. IBM has been selling their DB2 databases for decades to enterprises globally, and has created this version for free download. While this is a low-end, freely downloadable version, IBM has been generous with its support for many core features. IBM also has included access to its online support communities and forums. These communities and forums are highly valuable for getting insights into the administration, development best practices, XML integration insights, and how to write programs with this application. The system the downloaded application is running on for purposes of this analysis has dual core processors and 2GB of memory. The insights gained from the implementation and initial programming using this application form the foundation of this report.

Assessments of DB2 Express-C Installation on IBM Laptop

The IBM ThinkPad used for completing this analysis is connected to the Internet via a cable modem running at speeds comparable to a fractional T1 connection. This made the initial download of the DB2 Express-C software installation packages fast, with the 389MB of data retrieved in less than five minutes. After the software was downloaded from the IBM site, the installation process was initiated and captured in a series of screen captures shown in the Appendix of this analysis. IBM's documentation was excellent in that it defines the initial installation...

IBM takes time to explain how the install process can also be completed using a command line interface as well. Both approaches were successfully attempted and completed for this analysis, with the Control Panel delivering more consistent results.
Within twenty minutes of having the software downloaded and installed, the DB-2 Control Center was up and running. The first application of the database was initiated using the db2cc command. IBM is careful to explain how both the graphical interface-based Command Center and command line deliver identical results. The first three pages of the documentation are excellent in this regard; they provide a strong foundation for learning of hwo to interact with the application and command line.

Following the invoking of the first application, the command db2sampl -xml -- sql was completed to create a table as defined in the user documentation. IBM provides a sample data set to accomplish this quickly so students and programmers alike get up and running quickly with DB2 Express-C. The graphical interface and command line approaches to defining the table worked identically, as the IBM documentation had indicated it would.

One of the most valuable lessons learned from this initial series of steps in the DB2 Express-C application is how quickly this application can be used for creating multidimensional tables both from the graphical interface and command line. The syntax of commands is somewhat cryptic yet is very logical in structure, which makes learning the options in this language easily accomplished. This initial phase of the analysis also showed how easily it is to create an application that can be edited, viewed and modified…

Sources used in this document:
References

Alsultanny, Y. (2010). Database management and partitioning to improve database processing performance. Journal of Database Marketing & Customer Strategy Management, 17(3-4), 271-276.

Beyer, K., Cochrane, R., Hvizdos, M., & Josifovski, V. (2006). DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL. IBM Systems Journal, 45(2), 271-298.

Cuzzocrea, A., Furfaro, F., & Sacca, D. (2009). Enabling OLAP in mobile environments via intelligent data cube compression techniques. Journal of Intelligent Information Systems, 33(2), 95-143.

Tulchinsky, V.G., Yushchenko, A.K., & Yushchenko, R.A. (2008). Graph queries for data integration using xml. Cybernetics and Systems Analysis, 44(2), 292-303.
Cite this Document:
Copy Bibliography Citation

Related Documents

IBM Case Study Compare and Contrast the
Words: 940 Length: 3 Document Type: Case Study

IBM Case Study Compare and contrast the project portfolio management approaches that IBM and Deloitte Consulting used to rank and select the projects for their respective portfolios. IBM uses the Q-sort approach to manage their project portfolio. This approach enables them to analyze opinions raised by groups based on rankings given by each group member. The company embraced this strategy as a way of measuring the relationship between opinions of different employees.

Databases: Access, SQL, MS SQL
Words: 1213 Length: 4 Document Type: Term Paper

Oracle supports stored programs such as stored procedures and packages. This enables the developers to centralize application logic in the database. Oracle provides powerful functions and sub-queries in its SQL statements. Developers can distribute systems by database links, materialized views and distributed queries. This feature saves much cost for developing distributed systems and applications. And there's a lot of features integrated with Oracle, compare to other database it is

American Express Media Strategy, Objectives
Words: 1804 Length: 6 Document Type: Research Paper

Said Mr. Harris: "We are always looking at new ways to reach our customers through innovative digital platforms." Mobile works well since "There is rapid growth in mobile devices supporting more and more of the everyday tasks that people want to perform." Another highly successful mobile application has been that of American Express' Android version of its free mobile app, which has had more than 1 million views since 2011.

C.S Pierce's "The Fixation Belief" a Reference,
Words: 997 Length: 3 Document Type: Essay

C.S Pierce's "The Fixation Belief" a reference, pages explain methods: (tenacity, authority, a priori science) In "The Fixation of Belief," author C.S. Pierce makes a number of contentions regarding the nature and importance of belief, and a variety of different methods that men utilize to accord their own particular convictions. The most rudimentary of these methods is known as tenacity -- which simply strives to eliminate all doubt from the

C.J. Pascoe. 2007. Hey Dude, You' a
Words: 1389 Length: 5 Document Type: Essay

C.J. Pascoe. 2007. Hey Dude, You' a Fag: Masculinity Sexuality High School. Berkeley: University California Press give overview reading, demonstrate understanding main arguments, raise questions comments. "Dude You're a Fag: Masculinity and Sexuality in High School" -- review and analysis Cheri Jo Pascoe's 2007 book "Dude You're a Fag: Masculinity and Sexuality in High School" provides an intriguing view concerning homophobic attitudes and masculinity in high school environments. It is surely impressive

Installing Handrails at Victoria BC Ogden Point
Words: 2004 Length: 6 Document Type: Research Paper

Installing Handrails at Victoria BC Ogden Point Breakwater: Zapco Welding and Fabricating, a Victoria Company, has been awarded the contract to construct an aluminum and stainless steel cable handrail at the Ogden Point breakwater. The firm was awarded this contract because of the good price, capacity, and past working relations with the Greater Victoria Harbour Authority. While it's a non-profit organization, the Greater Victoria Harbour Authority owns the property and invited

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now