Logic For the Business or Database Layer?

In the video, Should Our Logic Be In the Application or Database Layer, we discuss the approach of designing business logic in the application or database layer. While smaller organizations may have more coordination among teams, this can be a challenge as an organization grows and is one of the larger challenges for big organizations. In addition to coordination, duplicating efforts may be costly or may cause conflicts.

Some questions that are answered in the video:

• Using SQL Server as an example, what are some strengths of using a database for business logic?
• What are some strengths mentioned for using the application layer for business logic?
• What are some strengths of using a hybrid approach and when would we want to consider this?
• What is one consideration that tends to be overlooked when any design is made?

Remember that we're often combining teams in these discussions - database/data engineering, software engineering, security, etc. Unless we're in a very small company or startup where we tend to wear many hats, these questions require coordination from all teams.

For mastering data transformation from one form to another form, check out the highest-rated Automating ETL course on Udemy. For a coupon to the course, check out the trailer video on the channel SQL In Six Minutes.

One colleague of mine mentioned a company did not consider this question. While their oversight didn't matter for a few years, eventually a disaster struck. They faced data corruption that went unnoticed for a period of time. The data corruption was reported to clients, who didn't initially realize they were receiving bad data. Bad data resulted in poor decisions for these clients, which led to significant costs. Once the clients discovered that they were receiving bad data, they notified the company. The company discovered that their design failed to account for data corruption in the appropriate layer.

Are you looking for tech consultants that can assist with design and development? From building custom applications to working with existing infrastructure that's causing you trouble, we can get you connected to consultants who can assist. You can contact for assistance.

SQL In Six Minutes (YouTube) | SQL In Six Minutes (Odysee) | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security