One of the most important objectives of Smart Grids is to achieve an intelligent use of power and energy to improve the overall performance of the power network. Pursuing the objectives of energy efficiency, the implementation of Microgrids, Demand Side Management and Home Energy Management is proposed by academia and industry to include the participation of end users as a part of the solution of power balance. In this path of grid transformation, the convergence of the electronics, telecommunication and computing technologies permits the deployment, in recent years, of advanced measurement infrastructures (AMIs), helping the utilities to obtain in realtime operational information. This work deals on the process of acquisition, processing and storage of data in the context of energy monitoring and management systems. We present a data management case of study for residential real-time power analysis and energy management applications. A SQL structure for the data management strategy is proposed and validated experimentally on residential buildings.