Information

When I joined a banking system company as a fresh graduate in the 1990s, I had never thought why waterfall was suitable for system development.

The reason why a product that just happens to be a hit doesn't last until later is because you don't know why it sold, so you can't keep up with the changes of the times and don't know how to sell it next.

結合と統合はほぼ同じ意味ですが、SQLの場合は結合はJOIN、統合はUNIONを使い結果が異なります。

一般的には左テーブルを優先して右テーブルの主キー（プライマリーキー）と合致することを結合条件として左テーブルに列を追加する左外部結合LEFT (OUTER) JOINを使いますが、右テーブルを優先して左テーブルの主キーと合致することを結合条件として右テーブルに列を追加する右外部結合RIGHT (OUTER) JOIN、そして左右両方のビューのどちらかに1個でも主キーがあれば結合する完全外部結合FULL OUTER JOINもありますが、実際に使う機会はほぼありません。

完全外部結合FULL OUTER JOINは、主キー以外の情報列の並び順が合致しない左右のビューを統合UNION ALLして主キーでグループ化するのと同じです。

If information is managed by Excel, the information is stored in separate files for each department and each person in charge, and the format and accuracy of the information may depend on the discretion of the person in charge. However, the argument that an immediate business system should be introduced is hasty, and there is even a possibility that a simple system that only imports the data and manages it centrally in a database while making use of the Excel operating ability of the staff who are familiar with it for many years is more cost effective.

There are two main reasons why Japanese companies in Indonesia ask us to replace their systems: aging or functional constraints.

As IoT progresses and things are connected to the Internet, and the transcription of events in the real three-dimensional world into the two-dimensional world of books is fully automated, will humans no longer need to spend time understanding the nature of their work?

The sharing of visible results leads to a common recognition of the problems, but if there are people who are troubled because the scarcity of information is diminished by the increasing sharing, the political power to increase the position by monopolizing useful information is at work.

In order to check the appropriateness of financial statements, it is essential to check the slips as evidence of business operation. However, it is not possible to check all the huge amount of slips, so it is good to be able to confirm that the data of the business system is flowing properly, and it is good to be able to confirm that the approval function of the system is functioning properly.

System introduction is the standardization of business, and it can be said that the easier it is to standardize the business, the easier it is to systemize. However, in general, Indonesians consider systemization to be automation, and they have a strong conservative tendency to want to systemize the current business as it is, so they explain that systemization is the process of standardizing the results of improving the current business.