ERP stands for “Enterprise Resource Planning,” which refers to the management and planning of essential business resources such as people, goods, and money. It involves creating strategies based on business goals and allocating resources efficiently.
Systems designed to support and streamline these business strategies are also called ERP systems,
| Core ERP |
SAP S/4HANA Cloud Oracle ERP Cloud Microsoft Dynamics 365 Finance Infor CloudSuite Workday Financial Management |
| CRM |
Salesforce HubSpot CRM Microsoft Dynamics 365 Sales Zoho CRM Freshsales |
| SFA (Sales Support) |
Salesforce Sales Cloud Microsoft Dynamics 365 Sales Senses (Japan) eSales Manager (Japan) |
| Marketing Automation (MA) |
Marketo HubSpot Marketing Hub Salesforce Marketing Cloud / Pardot Adobe Campaign |
| SCM (Supply Chain) |
SAP IBP Oracle SCM Cloud Kinaxis RapidResponse Blue Yonder SCM |
| WMS (Warehouse Management) |
Manhattan WMS Blue Yonder WMS SAP EWM Oracle WMS Cloud |
| Manufacturing (MES / PLM) |
Siemens Teamcenter (PLM) PTC Windchill (PLM) Dassault 3DEXPERIENCE (PLM) SAP MES Oracle MES |
| HR / HCM |
Workday HCM SAP SuccessFactors Oracle HCM Cloud Microsoft Dynamics 365 HR SmartHR (Japan) |
| BI / Analytics |
Microsoft Power BI Tableau Looker Qlik Sense |
| Accounting / Finance |
SAP S/4HANA Finance Oracle NetSuite freee (Japan) Money Forward Cloud (Japan) |
| Model | What you manage | What the provider manages | Typical example |
|---|---|---|---|
| On-Premises | Servers, storage, network, OS, middleware, runtime, data, applications (everything is in your own data center) | Nothing – you buy, install, operate and maintain all infrastructure and software | Company-owned servers running ERP, DB, in-house apps |
| IaaS (Infrastructure as a Service) | OS, middleware, runtime, data, applications (you design and operate the system on virtual machines) | Physical servers, storage, network, virtualization layer | Virtual machines on AWS, Azure, GCP |
| PaaS (Platform as a Service) | Data, applications (you focus on code and configuration) | Servers, OS, runtime, databases, scaling, security updates | Heroku, Azure App Service, Firebase, managed DBs |
| SaaS (Software as a Service) | Usage settings, user accounts, data inside the app | All infrastructure, platform, and application itself | Microsoft 365, Google Workspace, Salesforce, Slack |
| On-Premises | IaaS | PaaS | SaaS |
|---|---|---|---|
| Applications | Applications | Applications | Applications |
| Data | Data | Data | Data |
| Runtime | Runtime | Runtime | Runtime |
| Middleware | Middleware | Middleware | Middleware |
| Operating System | Operating System | Operating System | Operating System |
| Virtualization | Virtualization | Virtualization | Virtualization |
| Servers | Servers | Servers | Servers |
| Storage | Storage | Storage | Storage |
| Networking | Networking | Networking | Networking |
| Item | Database | Excel |
|---|---|---|
| Data Volume Management | Capable of handling large amounts of data | Performance slows down as data increases |
| Simultaneous Editing | Strong support for multi-user simultaneous access | Limited simultaneous editing capabilities |
| Data Integrity | Automatically prevents duplication and inconsistencies | Requires manual management |
| Security | Supports access control and permissions | Limited control |
Consistency,Integrity,Availability
Normalization
A Database Management System (DBMS) is software designed to streamline operations such as creating, searching, updating, and deleting data within a database. In English, it is written as “DataBase Management System”, and it serves as the core component of database management.
A DBMS allows users to interact with data safely and efficiently without directly manipulating the raw data. It also provides strong capabilities for security, concurrency control, and high‑speed processing.
Consistency
Consistency ensures that data remains valid and follows all defined rules and constraints after any transaction. The database never enters an invalid state.
Integrity
Integrity ensures that data is accurate, complete, and protected from corruption or unauthorized modification. Relationships such as primary keys and foreign keys maintain reliable data structure.
Availability
Availability ensures that data is accessible whenever needed. Redundant systems and failover mechanisms allow continuous operation even if one server fails.
Normalization
Normalization is the process of organizing data to reduce redundancy and prevent inconsistencies. Large tables are divided into smaller related tables using keys.
Activation(顧客に体験を提供する)
Retention(リピーターにする)
Referral(顧客が第三者に紹介する)
Revenue(収益化する)
| Model | What you manage | What the provider manages | Typical example |
|---|---|---|---|
| On-Premises | Servers, storage, network, OS, middleware, runtime, data, applications (everything is in your own data center) | Nothing – you buy, install, operate and maintain all infrastructure and software | Company-owned servers running ERP, DB, in-house apps |
| IaaS (Infrastructure as a Service) | OS, middleware, runtime, data, applications (you design and operate the system on virtual machines) | Physical servers, storage, network, virtualization layer | Virtual machines on AWS, Azure, GCP |
| PaaS (Platform as a Service) | Data, applications (you focus on code and configuration) | Servers, OS, runtime, databases, scaling, security updates | Heroku, Azure App Service, Firebase, managed DBs |
| SaaS (Software as a Service) | Usage settings, user accounts, data inside the app | All infrastructure, platform, and application itself | Microsoft 365, Google Workspace, Salesforce, Slack |
| On-Premises | IaaS | PaaS | SaaS |
|---|---|---|---|
| Applications | Applications | Applications | Applications |
| Data | Data | Data | Data |
| Runtime | Runtime | Runtime | Runtime |
| Middleware | Middleware | Middleware | Middleware |
| Operating System | Operating System | Operating System | Operating System |
| Virtualization | Virtualization | Virtualization | Virtualization |
| Servers | Servers | Servers | Servers |
| Storage | Storage | Storage | Storage |
| Networking | Networking | Networking | Networking |
| Item | Database | Excel |
|---|---|---|
| Data Volume Management | Capable of handling large amounts of data | Performance slows down as data increases |
| Simultaneous Editing | Strong support for multi-user simultaneous access | Limited simultaneous editing capabilities |
| Data Integrity | Automatically prevents duplication and inconsistencies | Requires manual management |
| Security | Supports access control and permissions | Limited control |