
The article discusses the design of the database obtained in the process of diagnosis of submersible equipment. The analysis of the conditions that create an integrated information environment for all levels of the hierarchy of modern oil company. The basic aspects of structural modeling using SADT-methodology. It is shown that as a tool in the synthesis of the information system diagnostics submersible equipment appropriate to use IDEF1X-technology, which is a derivative of said standard methodology. The description of the information model of the subject area of diagnostics. On the basis of the information model formulates the necessary and sufficient requirements for the internal database structure of the diagnostic results of submersible equipment. It is shown that the model obtained using IDEF1X-technology allows to bring the scheme in line with the data requirements of the third normal form relational databases. This opens the possibility to design a database of diagnostic results submersible equipment among MS Access. As an illustration of this approach are described processes for creating data schema and organization of optimal relations between its elements. The examples of the necessary collection queries that are designed to provide a holistic scope of structured information, and details all screen forms of the database implements the interaction of the operator with the information system.
В статье рассмотрены вопросы проектирования базы данных, подученных в процессе диагностики погружного оборудования. Проведен анализ условий, позволяющих создать интегрированную информационную среду применительно ко всем уровням иерархии современной нефтяной компании. Рассмотрены основные аспекты структурного моделирования с применением SADT-методологии. Показано, что в качестве инструментального средства при синтезе информационной системы диагностики погружного оборудования целесообразно использовать IDEF1X-технологию, которая является производным стандартом указанной методологии. Приводится описание информационной модели рассматриваемой предметной области диагностики. На основе полученной информационной модели формулируются необходимые
ПОГРУЖНОЕ ОБОРУДОВАНИЕ, ДИАГНОСТИКА, ИНФОРМАЦИОННАЯ МОДЕЛЬ, IDEF1X-ТЕХНОЛОГИЯ, БАЗА ДАННЫХ, СХЕМА БАЗЫ ДАННЫХ, ТАБЛИЦА, СУЩНОСТЬ, ЗАПРОС, ФОРМА
ПОГРУЖНОЕ ОБОРУДОВАНИЕ, ДИАГНОСТИКА, ИНФОРМАЦИОННАЯ МОДЕЛЬ, IDEF1X-ТЕХНОЛОГИЯ, БАЗА ДАННЫХ, СХЕМА БАЗЫ ДАННЫХ, ТАБЛИЦА, СУЩНОСТЬ, ЗАПРОС, ФОРМА
| selected citations These citations are derived from selected sources. This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | 0 | |
| popularity This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network. | Average | |
| influence This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically). | Average | |
| impulse This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network. | Average |
