Chapter 8. Playing with Data

"Any program is only as good as it is useful."

—Linus Torvalds

Enterprise applications store, retrieve, transmit, manipulate, and analyze data. Storing, processing, and analyzing data is very critical to any business. The Business Intelligence (BI) process transforms data into meaningful information for business. BI analyzes statistical data and helps with decision making and predictions for businesses, such as risk assessment, planning and forecasting, and analyzing buying trends. Information can be stored in a file or to a database. Querying and accessing data from a relational database is easier than the file system. This chapter covers the unit testing of the database layer. The following topics are covered in depth:

• Separation of concerns
• Unit testing the persistence layer
• Writing clean data access code using Spring JDBC
• Integration testing of JDBC code
• Integration testing of Spring JDBC