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 Inventory Control Accounting Computerization In J-Mart Karawang Based On Vb.Net 2008

2021 ◽  
Vol 1 (1) ◽  
pp. 43-55
Author(s):  
Indaryono Indaryono ◽  
Donny Apdian ◽  
Dudi Awalludin ◽  
Intan Ayu Nurhasanah
Keyword(s):  
Information System ◽  
Data Collection ◽  
Data Processing ◽  
Inventory Control ◽  
Inventory Management ◽  
Accounting Information ◽  
Sql Server ◽  
Reliable System ◽  
Accounting Information System ◽  
Collection Methods

When presented with an accounting information system based on a reliable system, it will certainly produce objective information as well. Inventory management and computerized goods reports are very beneficial for the company. J-Mart, which is a minimarket which still relies on Ms. So that data processing of reports cannot be fast and accurate. This study uses data collection methods in the form of observation, interviews and documentation. This application is designed to use Visual Basic.Net with SQL Server as the database. The output result obtained from this system is the inventory report. With the creation of this inventory system, it is hoped that it can make it easier to carry out the process of recording inventory, avoid input errors and can streamline the time of inputting and counting stock items in the warehouse.

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.

scholarly journals NETWORK MODELLING AND SEMANTIC 3D CITY MODELS: TESTING THE MATURITY OF THE UTILITY NETWORK ADE FOR CITYGML WITH A WATER NETWORK TEST CASE

2018 ◽  
Vol IV-4 ◽  
pp. 13-20 ◽  
Author(s):  
I. Boates ◽  
G. Agugiaro ◽  
A. Nichersu
Keyword(s):  
Relational Database ◽  
Data Model ◽  
Database Schema ◽  
Future Research ◽  
Physical Parameters ◽  
Test Case ◽  
Network Modelling ◽  
Complex Development ◽  
Relational Database Schema ◽  
Utility Network

<p><strong>Abstract.</strong> Recent advances in semantic 3D city modelling and a demand from utility network operators for multi-utility data models integration have contributed to the emergence of an open Application Domain Extension (ADE) of the CityGML data model tailored to multiple types of utility networks. This extension, called the Utility Network ADE, is still in active development. However, work is already well underway to create data samples and to develop methods of modelling thereupon. In this paper, a mapping of the Utility Network ADE data model to a relational database schema is introduced. A sample of a freshwater network using the Utility Network ADE and based on data from the city of Nanaimo, Canada, is also presented. This sample has also been imported into a relational database schema built upon the 3DCityDB (a database implementation of CityGML) extended with a schema of the Utility Network ADE. Further to this, a series of basic network analysis functions have been defined and implemented in SQL to interact with the database so as to carry out sample atomic processes involved in network modelling, such as reading semantic properties of elements, calculating composite physical parameters of the network as a whole, and performing simple topological routing to serve as a guiding example for further and more complex development. A brief outlook is also presented, suggesting areas with high potential for future research and development of this nascent data model.</p>

Sign in / Sign up

Export Citation Format

Share Document