The invention relates to a stored data warehouse row and column storage transformation implementation method for a database all-in-one machine. The method comprises the steps of constructing a stored data warehouse all-in-one machine storage model, wherein a dimension table concentrated storage and fact table distributed storage strategy is adopted on a database all-in-one machine framework; arranging a storage engine; arranging a row and column storage model conversion strategy; breaking up real-time OLAP search processing tasks into distributed OLAP search processing tasks on main node fact table row caching, shadow data column caching and storage server node fact table main sheets on the database all-in-one machine, and achieving OLAP analysis treatment based on real-time data. Row storage records of a transaction processing engine are efficiently converted into column storage records of an analysis engine, and the method supports OLAP analysis treatment on real-time data. The method is applicable to row and column storage structure conversion application scenarios in the updating operation for the stored data warehouse all-in-one machine.