Batch verses Streaming Analytical Application

This week’s episode discusses the nature of batch vs. streaming analytical applications, and the relationship to balance creation and history requirements. Analytical processes are moment in time processes; one creates a balance which says at this point, here is how much has been done. These analytical processes typically do not line up with the nature of transaction processing. Transactions occur at different times than when … Continue reading Batch verses Streaming Analytical Application

Computer Efficiency and Consistent Data Structures

This week’s episode of Conversations with Kip deals with the computer efficiencies that can be gained through consistent data structures. Analytical processes typically aggregate or combine data in some way. To understand our spending over time, we have to accumulate spending. If the format of each expense record is different, logic will have to be applied to each one to find the common fields needed … Continue reading Computer Efficiency and Consistent Data Structures

Tabulating System Program Structure

Continuing our series on the principles behind tabulating system, let’s discuss the basic program structure. Perhaps some of the first tabulating systems were developed before the idea of structured programming, but this pattern for program structure developed very early in the life of system development.  Most Tabulating Systems have as the top constructs the following: Initiate Processing Perform Until End of File Terminate Processing These … Continue reading Tabulating System Program Structure

Where are We Going? Final Conversation with Tata Rao

This week we’ll conclude the series of conversations with Tata Rao, previously Lead Architect of a Global Financial Services Financial System Platform. I asked Tata where our systems are going.  His response was three part: Cloud Migration.  The data security issues have been holding back some level of migration of these types of systems, but over time those problems will be overcome, and the systems … Continue reading Where are We Going? Final Conversation with Tata Rao

ERP Package: User Interface and Your Data

In my career, I have found that even for the largest organizations ERP packages create a great deal of value in two primary areas: They constrain choices in design and provide business process templates, thus creating greater efficiency of implementation.  Giving business partners a blank sheet of paper upon which to do whatever they want often leads them back to what the current system does. … Continue reading ERP Package: User Interface and Your Data

The Have It Your Way ERP Package

Contrasting with last week’s prescriptive ERP Package approach, the other major vendor uses an integration approach to the problem. This ERP Vendor grew through acquisition of various products, and integrated them. This means that often one can select only particular functions or parts of the package to use, and then construct or use other components to solve other parts of the problem. This can be … Continue reading The Have It Your Way ERP Package

ERP Package: My Way or Highway

This week’s episode characterizes one type of ERP Vendor often used in major corporations for finance functions, which is highly integrated but also quite prescriptive in approach. Vendor’s specialize in particular processes or industries; competition means no one is great at everything.  It the package does what you need to have done, then great.  If not, it is most often expensive to buy something that … Continue reading ERP Package: My Way or Highway

Blockchain Gap: Trust and Efficiency

I’ve taken a few weeks break from the blog, considering what to do next about financial systems. Today’s video though makes clear the major gap I see in blockchain. Trust is at the core of the efficiency of today’s financial and business systems.  But blockchain, as developed by Bitcoin, is premised on a “trustless” system. One of the significant promises of blockchain is greater efficiency. … Continue reading Blockchain Gap: Trust and Efficiency

ERP Systems and Reporting Processes

ERP systems perhaps were to deliver on three promises; Automate more business processes; perhaps approaching all of them.  ERP systems have added great automation to a lot of new business processes since their introduction 25+ years ago. Consistent IT Tooling.  ERP systems in some industries significantly increased the IT tooling consistency. Increase reporting ease and analysis.  The thought was that with all the data under … Continue reading ERP Systems and Reporting Processes