I was having lunch with a good friend of mine the other day. He recently took a new position as analytical big wig for a marketing company. The company has a great deal of data, but he lamented that all the current business logic was coded as stored procedures in their databases.
To be sure, there are benefits to stored procedures. A lot of the processing requirements get off-loaded to the database server which typically has plenty of power, and it reduces the volume of data transfer that may be required. Additionally, in some cases it allows you to call business logic directly within SQL queries.
These benefits come at a steep price, however. Stored procedures are typically very difficult to modify and any modification requires involvement of IT personnel. This is a death knell in environments where competitive advantage relies on continuous learning and updating of business logic and strategies. And really, show me an industry vertical where continuous learning and improvement is not essential to remain ahead of the game. A decisioning platform that allows business analysts to control decision flows and strategies can take you to the next level if you're still doing your automated decisioning in stored procedures.
No comments:
Post a Comment