Database Design and Development

GitHub {14}

GitHub can be easily labeled as a distributed version control system, but GitHub is so much more than that. GitHub is a powerful collaboration and code management tool for open source and private projects. GitHub allows multiple people to work in friction-less development environments. People are able to work together on projects in organizations and communicate between each other with ease. With GitHub people are able to browse multiple repositories, create and manage different branches, and save changes both locally and on public servers. GitHub also leaves a paper trail so people it becomes easier to see who made what kind of changes to source codes.

read more...

A Career in Databases {18}

So the quarter is coming to an end and you loved the class. I mean who wouldn’t? The practical uses of databases are endless and the need for people to manage them will only grow. The careers within CIS are among the top 5 growing jobs in the U.S. and this blog will tell you why. As mentioned in many other presentations about 80- 90 percent of data has been created within the last 2 years and database admins are the ones who are responsible for managing and turning that data into useful information. Throughout this post I will discuss how to become an admin, discuss salary, work environment, and its job outlook.

read more...

Big Big Data {1}

 Big Data is loosely used term in the database industry. At first this term is seen as so simple it becomes complicated or might be used so general it becomes ineffective. Analyzing Big Data is essential in well-established businesses to help grow and mold the company. Big Data as described by Forbes is “ a collection of data from traditional and digital sources inside and outside your company that represents a source for ongoing discovery and analysis.” (What is Big Data) With the expansion of the information and technology age this becomes more and more relevant everyday. There are even organizations that companies can outsource to do this type of analysis for them. Big Data is a relatively new idea and has been becoming more efficient but, there can still be improvement.

read more...

How to become an Oracle DBA {3}

Last week I read and wrote about an article describing what a DBA’s job consists of, and the question arose of how a person might go about becoming a DBA. This week I read the article “How to become an Oracle DBA” by Burleson Consulting. The author starts off by listing the very generous salaries of DBA’s, which often start at around $100k/year and can reach up to $250k/year. While this is appealing, that salary doesn’t come easy. The author talks about the complex and specialized set of skills which are required. The main 3 points he brings up are outstanding communication, business degree, and of course DBA skills. The author also suggests taking courses such as Operations Research and getting Oracle certifications(however he later states in a comment on the article that certifications don’t mean much anymore).

read more...

DBA, a great position for a CIS major {4}

The main purpose of a DBA is to perform maintenance and optimization tasks on a daily basis. However, according to Craig Mullins, DBA’s often become much more than that. Because the DBA is often relied upon by both IT and business associates, the realm of what is asked and/or expected constantly grows. A DBA should expect this, and accept it as it makes him/her more valuable to a company while also extending their own personal abilities. Opportunities to grow may include (in addition to the standard DBA duties):  experience with new technologies, a better understanding of the meaning of data, actively participating in application development, or perhaps just a better understanding of business.

read more...

Friendly SQL Queries {7}

The peer review article that I read was called “Interactive SQL query suggestion: Making databases user-friendly” by Ju Fan talks about how SQL is a good tool for querying relational databases. The author mentions that it is hard for beginners with a lack of programming skills to make efficient SQL queries as they require being proficient in SQL syntax and having a good understanding of the underlying schema. The author proposes a SQLSUGG which is a user-friendly keyword-based method to help people create SQL queries. This method suggests SQL queries as users type the keyboard and also helps to save what the users type to avoid them having to type everything multiple times which avoids SQL debugging in a way.

read more...

Developing Mobile Database Apps {1}

Learning about application development and databases go hand-in-hand with each other. Speaking of hands, we frequently would like to access databases through a mobile device. In the journal “Building Database-Powered Mobile Applications” we can learn of the different API’s available to create applications on mobile platforms. API’s covered include those for Android, Symbian, Windows CE/Mobile and Windows Phone (sorry Apple isn’t covered!). For most of the OS’s, SQLite may be used. SQLite has some restrictions on it’s data types and does not support certain other features normally used in SQL server.

read more...

XML vs JSON {Comments Off on XML vs JSON}

The article that I read about was a peer review article called “Improving Data transmission in Web applications via the Translation between XML and JSON.” The article talks about the analysis of the form of two data serializing approaches used in the development of web applications using XML and JSON. The author remarks that both XML and JSON are used widely because of their high efficiency in transmitting data but still they cause certain application development problems.

read more...

SQL Crash Course {1}

This week I decided to read the article “SQL language crash course(just enough to be dangerous)”. The author covers things such as SELECT, FROM, WHERE, INSERT, UPDATE, DELETE, and several others. He ties each of these in with short examples and explanations of their implementations. These keywords work in all versions of SQL Servers and are important to know.

read more...

From Big Data to Big Impact {2}

I picked the article called Business Intelligence and analytics: from big data to big impact that talks about how these areas of study was created due to the urge to manage the excessive amount of data being created and the need to classify and analyze this data to use it as efficient as possible. According to the MIS Quartely after conducting a survey with over 4,000 IT professionals from about 93 counties in different industries the IBM tech reported in 2011 that business analytics is one of the four major technology trends in 2010. It also mentions that McKinsey Global Institute predicted that the United States will have a shortage of people with well-developed analytical skills by 2018.

read more...