scholarly journals Application Research on Information System of Multimedia Catering Management Based on Relational Database

2015 ◽  
Vol 9 (1) ◽  
pp. 2811-2819
Author(s):  
Lin Xie
Keyword(s):  
Information System ◽  
Relational Database ◽  
Application Research

scholarly journals A generator of SQL schema specifications

2007 ◽  
Vol 4 (2) ◽  
pp. 81-100 ◽  
Author(s):  
Slavica Aleksic ◽  
Ivan Lukovic ◽  
Pavle Mogin ◽  
Miro Govedarica
Keyword(s):  
Information System ◽  
Normal Form ◽  
Relational Database ◽  
Sql Server ◽  
Database Schema ◽  
Intelligent Support ◽  
Case Tool ◽  
Design Environments ◽  
Data Constraints

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema according to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.

scholarly journals Using ontology merging for the integration of information systems and the production capacity planning system

2019 ◽  
pp. 401-408
Author(s):  
N Yarushkina ◽  
A Romanov ◽  
A Filippov ◽  
A Dolganovskaya ◽  
M Grigoricheva
Keyword(s):  
Information System ◽  
Information Systems ◽  
Relational Database ◽  
Data Model ◽  
Capacity Planning ◽  
Production Capacity ◽  
Semantic Integration ◽  
Data Sources ◽  
Planning System ◽  
Ontology Merging

This article describes the method of integrating information systems of an aircraft factory with the production capacity planning system based on the ontology merging. The ontological representation is formed for each relational database (RDB) of integrated information systems. The ontological representation is formed in the process of analyzing the structure of the relational database of the information system (IS). Based on the ontological representations merging the integrating data model is formed. The integrating data model is a mechanism for semantic integration of data sources.

Efficiency of JSON approach for Data Extraction and Query Retrieval

2016 ◽  
Vol 4 (1) ◽  
pp. 203 ◽  
Author(s):  
Mohd Kamir Yusof ◽  
Mustafa Man
Keyword(s):  
Information System ◽  
Relational Database ◽  
Execution Time ◽  
Database Management ◽  
Data Extraction ◽  
Extensible Markup Language ◽  
Markup Language ◽  
Huge Data ◽  
Extensible Markup ◽  
Database Technology

<p>Students’ Information System (SIS) in Universiti Sultan Zainal Abidin (UniSZA) handles thousands of records on the information of students, subject registration, etc. Efficiency of storage and query retrieval of these records is the matter of database management especially involving with huge data. However, the execution time for storing and retrieving these data are still considerably inefficient due to several factors. In this contribution, two database approaches namely Extensible Markup Language (XML) and JavaScript Object Notation (JSON) were investigated to evaluate their suitability for handling thousands records in SIS. The results showed JSON is the best choice for storage and query speed. These are essential to cope with the characteristics of students’ data. Whilst, XML and JSON technologies are relatively new to date in comparison to the relational database. Indeed, JSON technology demonstrates greater potential to become a key database technology for handling huge data due to an increase of data annually.</p>

The Research of Workflow Engine States

2013 ◽  
Vol 347-350 ◽  
pp. 2236-2240
Author(s):  
Yan Rong Shi ◽  
Tao Hou
Keyword(s):  
Information System ◽  
Full Advantage ◽  
Relational Database ◽  
Database Systems ◽  
Database System ◽  
Workflow Engine ◽  
Relational Database System ◽  
Logical Design ◽  
Relational Database Systems ◽  
The Cost

Based on the analysis of the workflow patterns, this paper designs the active state of the workflow, and puts forward the idea of the logical design of the engine driven. It can conveniently define the information model of the workflow based on relational database systems, it can effectively reduce the difficulty on the technical development of the workflow engine and take full advantage of existing relational database system to realize the information system that has the nature of the workflow and reduce the cost of the implementation.

scholarly journals Information System databases for Neuropsychology Tests: case study in Boston Naming Test

SISFORMA ◽  
2019 ◽  
Vol 6 (1) ◽  
pp. 28
Author(s):  
Shinta Estri Wahyuningrum ◽  
Augustina Sulastri ◽  
Ridwan Sanjaya
Keyword(s):  
Information System ◽  
Relational Database ◽  
Neuropsychological Test ◽  
Database Design ◽  
Boston Naming Test ◽  
Specific Data ◽  
Nosql Database ◽  
Sample Data ◽  
Naming Test

In the field of psychology, determining the psychological condition of a person’s can be done using various types of tests. Neuropsychology test is a battery test that means every person should be taken 11 test in a moment. Each test has a different objective, as an example, The Boston Naming test is used to measure a person's ability in the language domain. The data stored for each data in the Boston Naming Test (BNT) is around 130 fields. Each test has different specific data. This makes the data grow rapidly and requires a database design that can accommodate this need.There are many approaches can be done to store the database such a relational database and NoSQL database. When the data are stored using relational methods and amount of data are large, there can be a lack of time in both processing and tracking. This article proposes a system to store the result of the neuropsychological test using the NoSQL database approach with sample data in subtest BNT.

scholarly journals Using mixed reality technologies to explore the exhibits of the Kuzbass Botanical Garden

2021 ◽  
Author(s):  
Yu.I. Molorodov ◽  
E.D. Chernyavtsev
Keyword(s):  
Mathematical Modeling ◽  
Information System ◽  
Real Time ◽  
Relational Database ◽  
3D Model ◽  
Mixed Reality ◽  
Botanical Garden ◽  
Modeling Methods

The elements of mixed reality technology are described, which allow you to get acquainted with some of the exhibits of the Kuzbass Botanical Garden, Kemerovo. Elements of mixed reality are integrated with an information system based on a relational database. The developed algorithms for matching elements of a 3D model to objects from a relational database in real time require the use of analysis and mathematical modeling methods.

scholarly journals BUSINESS KNOWLEDGE EXTRACTION FROM LEGACY INFORMATION SYSTEMS

2006 ◽  
Vol 35 (3) ◽  
Author(s):  
Bronius Paradauskas ◽  
Aurimas Laurikaitis
Keyword(s):  
Information System ◽  
Information Systems ◽  
Reverse Engineering ◽  
Relational Database ◽  
Source Code ◽  
Knowledge Extraction ◽  
Legacy Systems ◽  
Program Understanding ◽  
Business Knowledge ◽  
Legacy Information Systems

This article discusses the process of enterprise knowledge extraction from relational database and source code of legacy information systems. Problems of legacy systems and main solutions for them are briefly described here. The uses of data reverse engineering and program understanding techniques to automatically infer as much as possible the schema and semantics of a legacy information system is analyzed. Eight step data reverse engineering algorithm for knowledge extraction from legacy systems is provided. A hypothetical example of knowledge extraction from legacy information system is presented.

Sign in / Sign up

Export Citation Format

Share Document