MySQL databases and Stored Procedures

From my position with my organization, I work with MySQL databases on a regular basis. I have to be honest with myself and say I do not have a working knowledge of SQL. In that, I understand the differences in the procedures each uses; with differences and similarities in functions, form and data processing. SQL stored procedures allow database programmers to avoid errors in creating queries for operations. According to Coronel & Robb in Database Systems Design, Implementation, and Management, the primary advantage gained from using stored procedures is encapsulation. Encapsulation streamlines the execution of a set of SQL statements improving performance and reducing the duplication of useful code unnecessarily (2005). Another benefit is the fact that stored procedures have been tested and debugged by database developers, improve the reliability of the procedures (Mandayam, 2005). In terms of Enterprise databases, stored procedures can be useful depending on whom one speaks to. According to a number of database administrators on Stackoverflow, in the case of Enterprise databases encapsulated queries lack the value add needed to be useful in large scale operations. Stored procedures are good at handling the simple CRUD operations (Create, Read, Update and Delete) but not Enterprise level queries (Karras, 2009). As an example of the converse, IBM’s DB2 Everyplace, which is designed for large scale databases uses pre-programmed procedures to for managing file subscriptions and application distribution (IBM, N.D.). Evaluating the needs of organization looking to implement a database will help determine the benefits stored procedures can offer. IBM. (N.D.). DB2 Everyplace: Features and benefits. IBM Information Management. Retrieved from, Karras, C. (2009). Disadvantage of stored procedures. Stack Overflow. Online resource. Retrieved from, Mandayam, P. (2005). Why use stored procedures? Online resource. Retrieved from, Robb, P., & Coronel, C. M. (2005). Database systems design, implementation, and management. Boston, MA: Course...

Read More

Web-based services and Databases

According to, web services is defined as an architecture or language used to provide function to users. Furthermore, the article in goes on to say that web services share three types of programming in XML, Standard Object Access Protocol (SOAP) which is exemplified in HTTP and SMTP, and Web Services Definition Language (WSDL) (Bloomberg, 2008). In the development of DB solutions for online merchants and web based solutions, these web services give programmers the ability to provide needed functions for performing business tasks online. XML allows for integration and data sharing across systems. While SOAP enables a wide variety of solutions for displaying, accessing and sharing information. Lastly, WSDL performs the networked services and systems to communicate with each other. While DBs provide the information necessary to make ‘information’ valuable, these web services transform the information into useable forms that help users make decisions, purchase goods and complete needed processes. Bloomberg, L.P. (2008). So, what the heck are web services? Bloomberg Businessweek. Online resource. Retrieved from,...

Read More