Tag: Database
Ryan Van Fleet
Ryan Van Fleet
11 Jul, 2019

Data Identification and Persistence – Extract Transform and Load Part 5

The final two steps, identification and persistence, can make or break the data chain. Identification handles the deduplication of data and informs the system of it should be persistence. Understanding how data will be used by the system informs if the data is Single, Submitter, Transaction Source. Once data...
Ryan Van Fleet
Ryan Van Fleet
20 Apr, 2017

Taming of the Subselect: Three ways to use this troublesome SQL Query

Subselects can be used in many ways: filtering, retrieving specific data, and creating custom joins. Writing effective SQL using subselects, though, can be frustrating. While SQL is ubiquitous in software engineering and is a valuable skill for testing, data analysis and reporting, nowadays a lot of SQL is abstracted...
Ryan Van Fleet
Ryan Van Fleet
24 Aug, 2016

Springing the JSON Template into Postgresql

Two popular open source components used in full stack development are Spring and Postgres. Spring gives the developer a plethora of opportunities to integrate with third party ORM libraries, such as Hibernate and iBatis. Frequently, rather than use a separate ORM library, developers elect to use the Spring JDBC...