A data model driven database query tool

2002 ◽  
Author(s):  
K. Higa ◽  
V. Owei
2013 ◽  
Vol 8 (1) ◽  
pp. 24-29 ◽  
Author(s):  
Margaret Garnsey ◽  
Andrea Hotaling

ABSTRACT In this case, students assume the role of an accounting professional asked by a client to investigate why net income is not as strong as expected. The students must first analyze a set of financial statements to identify areas of possible concern. After determining the areas to investigate, the students use a database query tool to see if they can determine causes by examining transaction level data. Finally, the students are asked to professionally communicate their findings and recommendations to their client. The case provides students with experience in using query-based approaches to answering business questions. It is appropriate for students with basic query and financial analysis skills and knowledge of internal controls. A Microsoft Access database with transaction details for the final seven months of the current year as well as financial statements for the current and prior year are provided.


Author(s):  
Kunkun Peng ◽  
Xinyu Li ◽  
Liang Gao ◽  
Xi (Vincent) Wang ◽  
Yiping Gao

Abstract Intelligent manufacturing plays a significant role in Industry 4.0. Dynamic shop scheduling is a key problem and hot research topic in the intelligent manufacturing systems, which is NP-hard. However, traditional shop scheduling mode, dynamic event prediction approach, scheduling model and scheduling algorithm, cannot cope with increasingly complicated problems under kinds of scales production disruptions in the real-world production. To deal with these problems, this paper proposes a new joint data-model driven dynamic scheduling architecture for intelligent workshop. The architecture includes four new and key characteristics in the aspects of scheduling mode, dynamic event prediction, scheduling model and algorithm. More specifically, the new scheduling mode introduces data analytics methods to quickly and accurately deal with the dynamic events encountered in the production process. The new prediction model improves the deep learning method, and further applies it predict the dynamic events accurately to provide reliable input to the dynamic scheduling. The new scheduling model proposes a new hybrid rescheduling and inverse scheduling model, which can cope with almost scales of abnormal production problems. The new scheduling algorithm hybridizes dynamic programming and intelligent optimization algorithm, which can overcome the disadvantages of the two methods based on the analysis of solution space. The dynamic programming is employed to provide high-quality initial solutions for the intelligent optimization algorithm by reducing the computation time greatly. To sum up, the presented architecture is a new attempt to understand the problem domain knowledge and broaden the solving idea, which can also provide new theories and technologies to manufacturing system optimization and promote the applications of the theoretical results.


2018 ◽  
Vol 25 (10) ◽  
pp. 1331-1338 ◽  
Author(s):  
Jeffrey G Klann ◽  
Lori C Phillips ◽  
Christopher Herrick ◽  
Matthew A H Joss ◽  
Kavishwar B Wagholikar ◽  
...  

Abstract Objective Healthcare organizations use research data models supported by projects and tools that interest them, which often means organizations must support the same data in multiple models. The healthcare research ecosystem would benefit if tools and projects could be adopted independently from the underlying data model. Here, we introduce the concept of a reusable application programming interface (API) for healthcare and show that the i2b2 API can be adapted to support diverse patient-centric data models. Materials and Methods We develop methodology for extending i2b2’s pre-existing API to query additional data models, using i2b2’s recent “multi-fact-table querying” feature. Our method involves developing data-model-specific i2b2 ontologies and mapping these to query non-standard table structure. Results We implement this methodology to query OMOP and PCORnet models, which we validate with the i2b2 query tool. We implement the entire PCORnet data model and a five-domain subset of the OMOP model. We also demonstrate that additional, ancillary data model columns can be modeled and queried as i2b2 “modifiers.” Discussion i2b2’s REST API can be used to query multiple healthcare data models, enabling shared tooling to have a choice of backend data stores. This enables separation between data model and software tooling for some of the more popular open analytic data models in healthcare. Conclusion This methodology immediately allows querying OMOP and PCORnet using the i2b2 API. It is released as an open-source set of Docker images, and also on the i2b2 community wiki.


Author(s):  
Pablo Martin Vera

Current MDD methodologies are complex to use and require doing lots of models and configurations. Usually after all that effort only some part of the application source code can be automatically created. It would be desirable to have a more simple technique, but powerful enough for automatically creating a fully functional application. This works introduces a component based model driven development approach where a set of user interface components will be configured to define system behavior. Component configuration will be direct, simple and supported by a modeling tool which also includes automatic transformations for reducing the modeling task. The methodology requires the designer to build only two models: a class diagram, representing the data model of the application and a component diagram defining the user interface and the system navigation. Both components are based on UML extended with stereotypes and tagged values allowing configuring the system behavior.


Author(s):  
Héctor Morano ◽  
Vicente Borja ◽  
Marcelo López ◽  
Álvaro Ayala

Abstract Product models come from the analysis of the data requirements to support the design and manufacture of products. These models are implemented in databases aimed at providing information to software applications that assist the concurrent design of products. This paper presents the requirements of a data model driven software system to aid the design of injection moulds and analyses two product models which were developed in different contexts but capable of representing injection moulded parts and moulds. A case study is used to show the application of each one of the models selected. Finally, some conclusions of the analysis are drawn in order to set the foundation of a new model.


2001 ◽  
Vol 39 (4) ◽  
pp. 667-687 ◽  
Author(s):  
Vicente Borja ◽  
Jennifer A. Harding ◽  
Rober T Bell

Sign in / Sign up

Export Citation Format

Share Document