An Automated, yet Interactive and Portable DB designer

Tuning tools attempt to configure a database to achieve optimal performance for a given workload. Selecting an optimal set of physical structures is computationally hard since it involves searching a vast space of possible configurations. Commercial DBMSs offer tools that can address this problem. The usefulness of such tools, however, is limited by their dependence on greedy heuristics, the need for a-priori (offline) knowledge of the workload, and lack of an optimal materialization schedule to get the best out of suggested design features. Moreover, the open source DBMSs do not provide any automated tuning tools. This demonstration introduces a comprehensive physical designer for the PostgreSQL open source DBMS. The tool suggests design features for both offline and online workloads. It provides close to optimal suggestions for indexes for a given workload by modeling the problem as a combinatorial optimization problem and solving it by sophisticated and mature solvers. It also determines the interaction between indexes to suggest an effective materialization strategy for the selected indexes. The tool is interactive as it allows the database administrator (DBA) to suggest a set of candidate features and shows their benefits and interactions visually. For the demonstration we use large realworld scientific datasets and query workloads

Assessing the compliance of a product with an eco-label: from standards to constraints

The new awareness of the consumers regarding environmental issues should allow companies to gain a competitive advantage by obtaining eco-labels which certify the low impact of a product on the environment. Getting such label requires to analyse a product according to rules expressed in natural language which may be difficult to interpret but also to apply when the product is complex. In order to address this problem, we suggest a method aiming at providing support to the user when checking the compliance of a product with an eco-label. The method is applied on an illustrative example of the literature

Study to determine potential flight applications and human factors design guidelines for voice recognition and synthesis systems

A study was conducted to determine potential commercial aircraft flight deck applications and implementation guidelines for voice recognition and synthesis. At first, a survey of voice recognition and synthesis technology was undertaken to develop a working knowledge base. Then, numerous potential aircraft and simulator flight deck voice applications were identified and each proposed application was rated on a number of criteria in order to achieve an overall payoff rating. The potential voice recognition applications fell into five general categories: programming, interrogation, data entry, switch and mode selection, and continuous/time-critical action control. The ratings of the first three categories showed the most promise of being beneficial to flight deck operations. Possible applications of voice synthesis systems were categorized as automatic or pilot selectable and many were rated as being potentially beneficial. In addition, voice system implementation guidelines and pertinent performance criteria are proposed. Finally, the findings of this study are compared with those made in a recent NASA study of a 1995 transport concept

On-site customer analytics and reporting (OSCAR):a portable clinical data warehouse for the in-house linking of hospital and telehealth data

This document conveys the results of the On-Site Customer Analytics and Reporting (OSCAR) project. This nine-month project started on January 2014 and was conducted at Philips Research in the Chronic Disease Management group as part of the H2H Analytics Project. Philips has access to telehealth data from their Philips Motiva tele-monitoring and other services. Previous projects within Philips Re-search provided a data warehouse for Motiva data and a proof-of-concept (DACTyL) solution that demonstrated the linking of hospital and Motiva data and subsequent reporting. Severe limitations with the DACTyL solution resulted in the initiation of OSCAR. A very important one was the unwillingness of hospitals to share personal patient data outside their premises due to stringent privacy policies, while at the same time patient personal data is required in order to link the hospital data with the Motiva data. Equally important is the fact that DACTyL considered the use of only Motiva as a telehealth source and only a single input interface for the hospitals. OSCAR was initiated to propose a suitable architecture and develop a prototype solution, in contrast to the proof-of-concept DACTyL, with the twofold aim to overcome the limitations of DACTyL in order to be deployed in a real-life hospital environment and to expand the scope to an extensible solution that can be used in the future for multiple telehealth services and multiple hospital environments. In the course of the project, a software solution was designed and consequently deployed in the form of a virtual machine. The solution implements a data warehouse that links and hosts the collected hospital and telehealth data. Hospital data are collected with the use of a modular service oriented data collection component by exposing web services described in WSDL that accept configurable XML data messages. ETL processes propagate the data, link, and load it on the OS-CAR data warehouse. Automated reporting is achieved using dash-boards that provide insight into the data stored in the data warehouse. Furthermore, the linked data is available for export to Philips Re-search in de-identified format

자동차 사양 변경을 실시간 반영하는 데이터 기반 디자인 접근 방법

학위논문 (박사) -- 서울대학교 대학원 : 융합과학기술대학원 융합과학부(지능형융합시스템전공), 2020. 8. 곽노준.The automotive industry is entering a new phase in response to changes in the external environment through the expansion of eco-friendly electric/hydrogen vehicles and the simplification of modules during the manufacturing process. However, in the existing automotive industry, conflicts between structured production guidelines and various stake-holders, who are aligned with periodic production plans, can be problematic. For example, if there is a sudden need to change either production parts or situation-specific designs, it is often difficult for designers to reflect those requirements within the preexisting guidelines. Automotive design includes comprehensive processes that represent the philosophy and ideology of a vehicle, and seeks to derive maximum value from the vehicle specifications. In this study, a system that displays information on parts/module components necessary for real-time design was proposed. Designers will be able to use this system in automotive design processes, based on data from various sources. By applying the system, three channels of information provision were established. These channels will aid in the replacement of specific component parts if an unexpected external problem occurs during the design process, and will help in understanding and using the components in advance. The first approach is to visualize real-time data aggregation in automobile factories using Google Analytics, and to reflect these in self-growing characters to be provided to designers. Through this, it is possible to check production and quality status data in real time without the use of complicated labor resources such as command centers. The second approach is to configure the data flow to be able to recognize and analyze the surrounding situation. This is done by applying the vehicles camera to the CCTV in the inventory and distribution center, as well as the direction inside the vehicle. Therefore, it is possible to identify and record the parts resources and real-time delivery status from the internal camera function without hesitation from existing stakeholders. The final approach is to supply real-time databases of vehicle parts at the site of an accident for on-site repair, using a public API and sensor-based IoT. This allows the designer to obtain information on the behavior of parts to be replaced after accidents involving light contact, so that it can be reflected in the design of the vehicle. The advantage of using these three information channels is that designers can accurately understand and reflect the modules and components that are brought in during the automotive design process. In order to easily compose the interface for the purpose of providing information, the information coming from the three channels is displayed in their respective, case-specific color in the CAD software that designers use in the automobile development process. Its eye tracking usability evaluation makes it easy for business designers to use as well. The improved evaluation process including usability test is also included in this study. The impact of the research is both dashboard application and CAD system as well as data systems from case studies are currently reflected to the design ecosystem of the motors group.자동차 산업은 친환경 전기/수소 자동차의 확대와 제조 공정에서의 모듈 단순화를 통해서 외부 환경의 변화에 따른 새로운 국면을 맞이하고 있다. 하지만 기존의 자동차 산업에서 구조화된 생산 가이드라인과 기간 단위 생산 계획에 맞춰진 여러 이해관계자들과의 갈등은 변화에 대응하는 방안이 관성과 부딪히는 문제로 나타날 수 있다. 예를 들어, 갑작스럽게 생산에 필요한 부품을 변경해야 하거나 특정 상황에 적용되는 디자인을 변경할 경우, 주어진 가이드라인에 따라 디자이너가 직접 의견을 반영하기 어려운 경우가 많다. 자동차 디자인은 차종의 철학과 이념을 나타내고 해당 차량제원으로 최대의 가치를 끌어내고자 하는 종합적인 과정이다. 본 연구에서는 여러 원천의 데이터를 기반으로 자동차 디자인 과정에서 활용할 수 있도록 디자인에 필요한 부품/모듈 구성요소들에 대한 정보를 실시간으로 표시해주는 시스템을 고안하였다. 이를 적용하여 자동차 디자인 과정에서 예상 못한 외부 문제가 발생했을 때 선택할 구성 부품을 대체하거나 사전에 해당 부품을 이해하고 디자인에 활용할 수 있도록 세 가지 정보 제공 채널을 구성하였다. 첫 번째는 자동차 공장 내 실시간 데이터 집계를 Google Analytics를 활용하여 시각화하고, 이를 공장 자체의 자가 성장 캐릭터에 반영하여 디자이너에게 제공하는 방식이다. 이를 통해 종합상황실 등의 복잡한 인력 체계 없이도 생산 및 품질 현황 데이터를 실시간으로 확인 가능하도록 하였다. 두 번째는 차량용 주차보조 센서 카메라를 차량 부착 뿐만 아니라 인벤토리와 물류센터의 CCTV에도 적용하여 주변상황을 인식하고 분석할 수 있도록 구성하였다. 차량의 조립 생산 단계에서 부품 단위의 이동, 운송, 출하를 거쳐 완성차의 주행 단계에 이르기까지 데이터 흐름을 파악하는 것이 디자인 부문에 필요한 정보를 제공할 수 있는 방법으로 활용되었다. 이를 통해 기존 이해관계자들의 큰 반발 없이 내부의 카메라 기능으로부터 부품 리소스와 운송 상태를 실시간 파악 및 기록 가능하도록 하였다. 마지막으로 공공 API와 센서 기반의 사물인터넷을 활용해서 도로 위 차량 사고가 발생한 위치에서의 현장 수리를 위한 차량 부품 즉시 수급 및 데이터베이스화 방법도 개발 되었다. 이는 디자이너로 하여금 가벼운 접촉 사고에서의 부품 교체 행태에 대한 정보를 얻게 하여 차량의 디자인에 반영 가능하도록 하였다. 시나리오를 바탕으로 이 세 가지 정보 제공 채널을 활용할 경우, 자동차 디자인 과정에서 불러들여오는 부품 및 모듈의 구성 요소들을 디자이너가 정확히 알고 반영할 수 있다는 장점이 부각되었다. 정보 제공의 인터페이스를 쉽게 구성하기 위해서, 실제로 디자이너들이 자동차 개발 과정에서 디자인 프로세스 상에서 활용하는 CAD software에 세 가지 채널들로부터 들어오는 정보를 사례별 컬러로 표시하고, 이를 시선추적 사용성 평가를 통해 현업 디자이너들이 사용하기 쉽게 개선한 과정도 본 연구에 포함시켜 설명하였다.1 Introduction 1 1.1 Research Background 1 1.2 Objective and Scope 2 1.3 Environmental Changes 3 1.4 Research Method 3 1.4.1 Causal Inference with Graphical Model 3 1.4.2 Design Thinking Methodology with Co-Evolution 4 1.4.3 Required Resources 4 1.5 Research Flow 4 2 Data-driven Design 7 2.1 Big Data and Data Management 6 2.1.1 Artificial Intelligence and Data Economy 6 2.1.2 API (Application Programming Interface) 7 2.1.3 AI driven Data Management for Designer 7 2.2 Datatype from Automotive Industry 8 2.2.1 Data-driven Management in Automotive Industry 8 2.2.2 Automotive Parts Case Studies 8 2.2.3 Parameter for Generative Design 9 2.3 Examples of Data-driven Design 9 2.3.1 Responsive-reactive 9 2.3.2 Dynamic Document Design 9 2.3.3 Insignts from Data-driven Design 10 3 Benchmark of Data-driven Automotive Design 12 3.1 Method of Global Benchmarking 11 3.2 Automotive Design 11 3.2.1 HMI Design and UI/UX 11 3.2.2 Hardware Design 12 3.2.3 Software Design 12 3.2.4 Convergence Design Process Model 13 3.3 Component Design Management 14 4 Vehicle Specification Design in Mobility Industry 16 4.1 Definition of Vehicle Specification 16 4.2 Field Study 17 4.3 Hypothesis 18 5 Three Preliminary Practical Case Studies for Vehicle Specification to Datadriven 21 5.1 Production Level 31 5.1.1 Background and Input 31 5.1.2 Data Process from Inventory to Designer 41 5.1.3 Output to Designer 51 5.2 Delivery Level 61 5.2.1 Background and Input 61 5.2.2 Data Process from Inventory to Designer 71 5.2.3 Output to Designer 81 5.3 Consumer Level 91 5.3.1 Background and Input 91 5.3.2 Data Process from Inventory to Designer 101 5.3.3 Output to Designer 111 6 Two Applications for Vehicle Designer 86 6.1 Real-time Dashboard DB for Decision Making 123 6.1.1 Searchable Infographic as a Designer's Tool 123 6.1.2 Scope and Method 123 6.1.3 Implementation 123 6.1.4 Result 124 6.1.5 Evaluation 124 6.1.6 Summary 124 6.2 Application to CAD for vehicle designer 124 6.2.1 CAD as a Designer's Tool 124 6.2.2 Scope and Method 125 6.2.3 Implementation and the Display of the CAD Software 125 6.2.4 Result 125 6.2.5 Evaluation: Usability Test with Eyetracking 126 6.2.6 Summary 128 7 Conclusion 96 7.1 Summary of Case Studies and Application Release 129 7.2 Impact of the Research 130 7.3 Further Study 131Docto

Soil Moisture Sensor

Since water is an important resource and not all communities around the world can afford to be liberal with their water needs; it has become important to use available water as efficiently as possible, especially in agriculture. For the purpose of reducing the overwatering of crops, an unattended ground moisture sensor can be implemented to measure the moisture level in the soil surrounding the plants. This will allow a farmer to know when to water or stop watering crops. For convenience, the moisture data information should be transmitted wirelessly to the user. The design of an unattended ground moisture sensor and wireless communication/user interface system is discussed. The sensor design consists of a Wheatstone bridge for determining the resistance of the soil, followed by a differential amplifier for converting the measured resistance into a voltage. This is done because there exists a correlation between moisture and resistance. This voltage is interpreted by a micro controller as moisture data and sent wirelessly to a Lora receiver. The receiver then relays that information to the user via a mobile or web based app

Proceedings of the 1994 Monterey Workshop, Increasing the Practical Impact of Formal Methods for Computer-Aided Software Development: Evolution Control for Large Software Systems Techniques for Integrating Software Development Environments

Office of Naval Research, Advanced Research Projects Agency, Air Force Office of Scientific Research, Army Research Office, Naval Postgraduate School, National Science Foundatio

ATLAS Commander: an ATLAS production tool

This paper describes the ATLAS production tool AtCom (for ATLAS Commander). The purpose of the tool is to automate as much as possible the task of a production manager: defining and submitting jobs in large quantities, following up upon their execution, scanning log files for known and unknown errors, updating the various ATLAS bookkeeping databases on successful completion of a job whilst cleaning up and resubmitting otherwise. The design of AtCom is modular, separating the generic basic job management functionality from the interactions with the various databases on the one hand, and the computing systems on the other hand. Given the near future reality of different flavors of computing systems (legacy and GRID) deployed concurrently at the various, or even a single ATLAS site, AtCom allows several of them to be used at the same time transparently.Comment: Talk from the 2003 Computing in High Energy and Nuclear Physics Conference (CHEP03), La Jolla, Ca, USA, March 2003, 7 pages, PDF, PSN : MONT00