Efficient and Robust Node-Partitioned Data Warehouses

2009 ◽  
pp. 658-677 ◽  
Author(s):  
Pedro Furtado

Running large data warehouses (DWs) efficiently over low cost platforms places special requirements on the design of system architecture. The idea is to have the DW on a set of low-cost nodes in a nondedicated local area network (LAN). Nodes can run any relational database engine, and the system relies on a partitioning strategy and query processing middle layer. These characteristics are in contrast with typical parallel database systems, which rely on fast dedicated interconnects and hardware, as well as a specialized parallel query optimizer for a specific database engine. This chapter describes the architecture of the nodepartitioned data warehouse (NPDW), designed to run on the low cost environment, focusing on the design for partitioning, efficient parallel join and query transformations. Given the low reliability of the target environment, we also show how replicas are incorporated in the design of a robust NPDW strategy with availability guarantees and how the replicas are used for always-on, always efficient behavior in the presence of periodic load and maintenance tasks.

2011 ◽  
pp. 203-229 ◽  
Author(s):  
Pedro Furtado

Running large data warehouses (DW) efficiently over low cost platforms places special requirements on the design of system architecture. The idea is to have the DW on a set of low-cost nodes in a non-dedicated local-area network (LAN). Nodes can run any relational database engine, and the system relies on a partitioning strategy and query processing middle layer. These characteristics are in contrast with typical parallel database systems, which rely on fast dedicated interconnects and hardware, as well as a specialized parallel query optimizer for a specific database engine. This chapter describes the architecture of the Node-Partitioned Data Warehouse (NPDW), designed to run on the low cost environment, focusing on the design for partitioning, efficient parallel join and query transformations. Given the low reliability of the target environment, we also show how replicas are incorporated in the design of a robust NPDW strategy with availability guarantees and how the replicas are used for always-on, always efficient behavior in the presence of periodic load and maintenance tasks.


Author(s):  
Pedro Nuno San-Bento Furtado

Some businesses generate giga or even terabytes of historical data that can be organized and analyzed for better decision making. This poses issues concerning systems and software for efficient processing over such data. While the traditional solution to this problem involves costly hardware and software, we focus on strategies for running large data warehouses over low-cost, non-dedicated nodes in a local-area network (LAN) and non-proprietary software. Once such a technology is in place, every data warehouse will be able to run in a small cost environment, but the system must be able to choose its placement and processing for maximum efficiency. We discuss the basic system architecture and the design of the data placement and processing strategy. We compare the shortcomings of a basic horizontal partitioning for the environment, with a simple design that produces efficient placements. Our discussion and results provide important insight into how low-cost efficient data warehouse systems can be obtained.


2011 ◽  
pp. 220-234
Author(s):  
Mahesh S. Raisinghani ◽  
Ann Shou-an Char

Client-server architecture is a local area network (LAN) based computing environment in which a central database sever or engine performs all database commands sent to it from client workstations, and application programs on each client concentrate on user interface functions. Client-server computing is a phrase used to describe a model for computer networking. In this shared processing model, a server has an intelligent database engine functioning as a service on the network. This model offers an efficient way to provide data/ information and services to many users as needed. A network connection is only made when a user needs to access the information or obtain the needed service. This lack of a continuous network connection provides network efficiency. Any change made in the server is transparent to clients.


Circuit World ◽  
2019 ◽  
Vol 45 (3) ◽  
pp. 141-147 ◽  
Author(s):  
Karthie S. ◽  
Salivahanan S.

Purpose This paper aims to present the design of a novel triangular-shaped wideband microstrip bandpass filter implemented on a low-cost substrate with a notched band for interference rejection. Design/methodology/approach The conventional dual-stub filter is embedded with simple fractal-based triangular-circular geometries through various iterations to reject wireless local area network (WLAN) signals with a notched band at 5.8 GHz. Findings The filter covers a wide frequency band from 3.1 to 8.8 GHz and has a fractional bandwidth of 98 per cent with the lower passband of 57.5 per cent and upper passband of 31.6 per cent separated by a notched band at 5.8 GHz. The proposed wideband prototype bandpass filter is fabricated in FR-4 substrate using PCB technology and the simulation results are validated with measurement results which include insertion loss, return loss and group delay. The fabricated filter has a sharp rejection of 28.3 dB at 5.8 GHz. Measured results show good agreement with simulated responses. The performance of the fractal-based wideband filter is compared with other wideband bandpass filters. Originality/value In the proposed work, a fractal-based wideband bandpass filter with a notched band is reported. The conventional dual-stub filter is deployed with triangular-circular geometry to design a wideband filter with a notched band to suppress interference signals at WLAN frequency. The proposed wideband filter exhibits smaller size and better interference rejection compared to other wideband bandpass filter designs implemented on low-cost substrate reported in the literature. The aforementioned wideband filter finds application in wideband wireless communication systems.


2013 ◽  
Vol 468 ◽  
pp. 141-144
Author(s):  
Su Hua Chen ◽  
Yong Guang Liu ◽  
Xu Fang

Smart home system mainly consists of home networking, wireless local area network and external network, and with the advantages of low cost and high reliability, Zigbee wireless technology is the right choice for smart home system and the main part of home networking. The design of smart home system based on Zigbee is proposed, the Zigbeethe design process of the systemintelligent socket and data communication rule are elaborated. The system has been applied in smart community of Shaoxing Electric Power Bureau, which has good performances, high availability and reliability, better market prospects.


2019 ◽  
Vol 37 (2) ◽  
pp. 26-42
Author(s):  
B. Kommey ◽  
E. O. Addo ◽  
K. A. Adjei

Location of appropriate seats in seating areas of theaters remains a significant challenge that patrons of these enterprises face. There is therefore, the need for seat occupancy monitoring system to provide readily accessible seat occupancy information to clients and management of these halls. This paper presents the design and implementation of a low cost seat occupancy detection and display system which is capable of monitoring seat occupancy in halls efficiently.  The system uses capacitive seat sensors which is designed based on the loading mode technology. It detects the presence of a human occupant using a single electrode. Occupancy data is relayed to a WiFi-enabled microcontroller unit which processes the data and wirelessly transfers the processed data to a central base station over a local area network for graphical and numerical display. Commands are also transferred from the base station to the microcontroller units when needed. Theoretical and empirical results show that the system is able to achieve seat occupancy monitoring accurately, neatly and cost effectively.Keywords: Capacitive sensing, seat occupancy, sensor cluster, microstrip transmission line, Wi-Fi 


Electronics ◽  
2019 ◽  
Vol 8 (9) ◽  
pp. 1007
Author(s):  
Zhuohang Zhang ◽  
Zhongming Pan

A novel reconfigurable filter antenna with three ports for three dependent switchable states for impulse radio-ultrawideband (IR-UWB)/wireless local area network (WLAN)/worldwide interoperability for microwave access (WiMAX) applications is presented in this paper. Three positive-intrinsic-negative diodes, controlled by direct current, are employed to realize frequency reconfiguration of one ultra-wideband state and two narrowband states (2.4 GHz and 3.5 GHz). The time domain characteristic of the proposed antenna in the ultra-wideband state is studied, because of the features of the IR-UWB system. The time domain analysis shows that the reconfigurable filtering antenna in the wideband state performs similarly to the original UWB antenna. The compact size, low cost, and expanded reconfigurable filtering features make it suitable for IR-UWB systems that are integrated with WLAN/WiMAX communications.


Sign in / Sign up

Export Citation Format

Share Document