Open Library - открытая библиотека учебной информации

Открытая библиотека для школьников и студентов. Лекции, конспекты и учебные материалы по всем научным направлениям.

Категории

Менеджмент COUNTRY
просмотров - 101

CITY

ORGS

Структура хранилища

В процессе выполнения работ по проекту разработана структура хранилища информационных ресурсов с использованием организованного аппаратно-программного комплекса, размещенного в дата-центре. Структура хранилища включила в себя базовые компоненты, такие как сервер баз данных, сервер приложений и Веб-сервер (рис. 32).

 
 

Рис. 32 - Структура хранилища информационных ресурсов.

На основе анализа сведений о предметной области спроектирована структура таблиц хранилища (рис. 33), которая реализована с использованием отношений сущностей и связей.

Рис. 33 - Структура таблиц хранилища.

Логическая схема хранилища описана с помощью таблиц структур базы данных, фрагмент которой приведен в Таблица 2.

Таблица 2. Структура базы данных

№ п/п Имя столбца Тип данных Описание
1. org_id NUMBER(10) Идентификатор
2. city_id NUMBER(10) Внешний ключ city
3. country_id NUMBER(10) Внешний ключ country
4. name VARCHAR(255) Название организации
5. phone VARCHAR(255) Телœефон
6. fax VARCHAR(255) Факс
7. address VARCHAR(255) Адрес
8. web VARCHAR(255) Веб-сайт
9. email VARCHAR(255) E-mail
10. profil VARCHAR(255) Направление исследований
11. contact VARCHAR(255) Контактное лицо
№ п/п Имя столбца Тип данных Описание
1. city_id NUMBER(10) Идентификатор
2. city VARCHAR(255) Название города
№ п/п Имя столбца Тип данных Описание
1. country_id NUMBER(10) Идентификатор
2. country VARCHAR(255) Название страны


Читайте также


  • - Read the text and compare meals in England and in our country.

    Text 1. Meals in England Additional texts for reading Exercises 1. Answer the questions on the text: 1. Does Oleg like shopping and why? 2. What are the rules to be rational and economical? 3. What shops does he usually go to? 4. What is the difference between a self-service and non-self-service shop? 5. Where does he put the food while going round the supermarket? 6. What does he buy at a grocery‚ butchery‚ bakery‚ confectionery‚ dairy? 7. Why does he... [читать подробенее]


  • - OUR COUNTRY RUSSIA

    Exercise 4. Translate into English Exercise 3. Complete the sentences with a superlative and preposition. Model: It is a very nice room. It is the nicest room in the hotel. 1. It is a very cheap restaurant. It is … the town. 2. It was a very happy day. It was … my life. 3. She is a very intelligent student. She … the school. 4.It is a very valuable painting. It … the gallery.1. Лучшие студенты нашего института поедут в... [читать подробенее]


  • - My country

    I. Read and translate the text VIII. Retell your composition VI. Answer the questions Vocabulary ensemble - ансамбль military - военный peculiar - особенный defense - защита row - ряд cannon - пушка loop-hole - бойница dome - купол sentence - приговор to announce - провозглашать refectory - трапезная to attract - привлекать impression -... [читать подробенее]


  • - ID is different in every country

    Study the following information. V OVER TO YOU An identity document, or also called a piece of identification (ID), is a document which evidences aspects of a person's identity. The use of identity cards is supported by law enforcement officials who claim that it can make surveillance and identification of criminals much easier. Identity cards can be a useful administrative tool that can increase efficiency in dealings with both the government and private companies. Cards may... [читать подробенее]


  • - Country Language Capital

    I. WARMING UP Human Rights Quiz V. OVER TO YOU Prepare an application letter or a petition to the International Court of Justice or to the European Court of Human Rights about serious violations of the Universal Declaration of Human Rights or accordingly the European Convention on Human Rights in your country, referring to the articles of these international documents. IV.WRITING 1.Imagine that you are a reporter for a famous Ukrainian newspaper. Write a... [читать подробенее]


  • - The United States of America: the geographical position, climate and the political structure of the country

    UNIT 6 1. Do you know the historical significance of the following names: - “The Mayflower” - George Washington - Declaration of Independence - Uncle Sam - “The Stars and Stripes and old Glory” 2. Read and translate the text: The vast and varied expanse of the United States of America stretches from the industrial, metropolitan Atlantic seaboard, across the rich flat farms of the central plains, over the majestic Rocky Mountains to the fertile, densely populated west... [читать подробенее]


  • - The United Kingdom of Great Britain and Northern Ireland: the geographical position, climate and the political structure of the country

    UNIT 4 Moscow is a green city. T/F During the Napoleon’s occupation the city of Moscow surrended. T/F Moscow was founded by Prince Yury Dolgoruky. T/F Moscow’s name came after the name of Tsar’s daughter. T/F4. Moscow is called the city of students because the education there is free of charge. T/F5. Make up the plan of the text and retell it according to the plan (not less then 100 words).1. Answer the questions: · What do you know about Great Britain? Point out... [читать подробенее]


  • - The main types of fuel or processes used to generate energy in our country.

    Popular, universal, international, possible, important, better, worse, polluted, worried, interested in. Achieve j. noise, pollution Take i. a program, concept, theory Develop h. investments Make g. the center of, a part of Tal work Have f. study, research, experimen- Bring about e. measures Suffer from d. an effect on Упражнение7. Составьте, переведите и... [читать подробенее]


  • - Read the text about the flag and symbols of the country.

    Ask and answer the questions working in pairs. Make up six questions to the text. Name the adjectives from the text. Form degrees of comparisons Read the text. THE BRITISH CLIMATE Britain has a variable climate. The weather changes so frequently that it is difficult to forecast. Due to the geographical location the type of the climate is oceanic. There are no extreme contrasts in temperature in Britain because of the warm water flowing... [читать подробенее]


  • - Do one more text to check your knowledge of the country.

    Choose the correct answer from the variants listed below. 1. What is the official name of the country whose language you study? a) Great Britain; b) England; c) the United Kingdom of Great Britain and Northern Ireland. 2. How many countries does the United Kingdom consist of? a) four; b) three; c) two. 3. What is the capital of Scotland? a) Manchester; b) Edinburgh; c) Cardiff. 4. What is the capital of Wales? a) Edinburgh; b) Cardiff; c) Liverpool. 5. What is the capital of... [читать подробенее]