Chapter 2 Information System in the Enterprise Evolution

Chapter 2 Information System in the Enterprise (ระบบสารสนเทศในองคกร )

Evolution of computerized decision support to analytics/data science 1970 s -DSS -AI -Expert System -Routine Reporting 1980 s -ERP -RDBMS 1990 s -EIS -Dashboard -Data Warehouse Ref: BI, Analytics and Data Ceience (Aronson, 2018) 2000 s -BI -Data/Text Mining -Cloud Computing 2010 s -Social Media Analytics -Big Data Analytics

In-database processing n In-database processing, sometimes referred to as in-database analytics, refers to the integration of data analytics into data warehousing functionality. Today, many large databases, such as those used for credit card fraud detection and investment bank risk management, use this technology because it provides significant performance improvements over traditional methods. https: //en. wikipedia. org/wiki/In-database_processing

Level in a Firm (ระดบการบรหารในองคกร ) BI (Business Intelligence)

The major business function n n Sales and marketing (การขายและการตลาด) Manufacturing and production (การผลต ) Finance and accounting (การเงนและบญช ) Human resources (ทรพยากรมนษย )

Transaction processing systems (TPS)

A symbolic representation for a payroll TPS �������

ตวอยาง TPS ������� http: //www. nanosoft. co. th/smartinvnetscr. htm

ระบบจดการฐานขอมล ) (Database Management System: DBMS Relational Database Management System (RDBMS) n n n MS Access My. SQL Postgre. SQL MS SQLServer Oracle No SQL DBMS n n Documentts Store n Mongo. DB n Couch. DB Wide Column Store n Cassandra n Hbase

ขอมลของ TPS จะถกรวบรวม เพอนำไปประมวลผลตอไป ESS Decision & Strategy Making MIS DSS Process Integration & Consolidated Data Warehousing Admin Transaction Processing System (TPS) HR Student Affairs Payroll Library Finance Students

Management Information Systems (MIS)

A sample MIS report (Summary Report) This report showing summarized annual sales data was produced by the MIS

Decision-support systems (DSS)

Decision-support systems (DSS) Ship file (e. g. , speed, capacity) PC Analytical models database Online queries Port distance restrictions file (������� ) Fuel consumption cost file (������ ) Ship charter hire history cost file (���� ) Port expense file (������ ��� ) Voyage–estimation decision-support system

Executive support systems (ESS) ����� TPS, MIS, DSS �������� Dashboard https: //powerbi. microsoft. com/en-us/features/

Characteristics of information processing systems Type of system Information inputs ESS Aggregate data ; external, internal DSS Low –volume data or massive databases optimized for data analysis; analytic models and data analysis tool MIS Summary transaction data; high-volume data; simple models TPS Transactions; events Continue

Characteristics of information processing systems Type of system Processing ESS Graphics; simulations; interactive DSS interactive; simulations; analysis MIS Routine reports; simple models; low-level analysis TPS Sorting; listing; merging; updating Continue

Characteristics of information processing systems Type of system Information outputs ESS Projections; responses to queries DSS Special reports; decision analyses; responses to queries MIS Summary and exception reports TPS Detailed reports; lists; summaries Continue

Characteristics of information processing systems Type of system User ESS Senior managers DSS Professionals; staff managers MIS Middle managers TPS Operations personnel; supervisors

Interrelationship among systems