Information

スパイラル開発

Information

System Development Methodology for Indonesia

2020/2/28  

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.

オンライン化が進むほどオフラインでの差別化が可能になる

Business Environment Information

The more you go online, the more you can differentiate yourself offline.

2017/3/6  

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.

CASE式・結合JOIN・統合UNIONで同じ結果を表示させる

Information

CASE式・結合JOIN・統合UNIONで同じ結果を表示させる

2017/1/14  

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

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

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

EXCEL作業をシステム化することは正義なのか

Information

Is it justice to systemize Excel work?

2016/9/28  

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.

システム置き換えの理由とコスパの問題

Information

Reasons for system replacement and the problem of cost performance

2016/9/22  

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

IoT化により業務の本質を理解するために時間を費やす必要はなくなるのか

Information

Will IoTization make it unnecessary to spend time understanding the nature of the business?

2016/8/11  

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?

情報共有

Information

Level of information quality

2015/10/2  

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.

内部統制とITコンプライアンス

Information

Internal Control and IT Compliance

2014/3/18  

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.

業務システム

Information

The work of introducing business systems

2014/1/18  

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.

© 2020 BAHTERA HISISTEM Powered by STINGER