A wireless sensor network consists of many sensors that collect and transmit physical or environmental conditions at different locations to a server continuously. Many researches mainly focus on processing continuous queries on real-time data stream. However, they do not concern the problem of storing the historical data, which is mandatory to the historical queries. In this paper, we propose a system architecture for handling and storing sensor data stream in real-time to support the spatial and/or temporal queries besides continuous queries. We exploit a segment-based method to store the sensor data stream and reduce the managed tuples without any loss of information, which lead to the improvement of the accuracy of query results. In addition, we offer a method to reduce the cost of join operations in processing spatiotemporal queries by filtering out the list of irrelevant sensors from the query range before making the join operation. We then present a design of the system architecture for processing spatial and/or temporal queries. Finally, we implement a climate monitoring application system based on our proposed system architecture.