SQL Server Management Studio Express Instalación

Instalación de SQL Server Management Studio Express en un MS Windows 7 Profesional.

SQL Server Management Studio Express 01

Primeros pasos en el uso de este programa cliente de acceso y administración de SQL Server. Este cliente, en su versión Express, es gratuito. El ejemplo del vídeo se conecta con un servidor remoto SQL Server 2008 R2.

SQL Server Management Studio Express 02

Segunda parte de los primeros pasos en el uso de este programa cliente de acceso y administración de SQL Server. Este cliente, en su versión Express, es gratuito. El ejemplo del vídeo se conecta con un servidor remoto SQL Server 2008 R2. Modificar tablas. Exportar definiciones del esquema. Resultados a cuadrícula o texto. Guardar resultados.

Transacciones en SQL Server

Una introducción a los objetivos y contenidos de la sesión 2 del curso de Bases de Datos dentro del Máster Universitario en Desarrollo de Aplicaciones y Servicios Web de la Universidad de Alicante. Se describe someramente qué se entiende por una transacción y se nombran los niveles de aislamiento en SQL Server. Todo enfocado a la realización de los ejercicios-demostraciones de esos niveles de aislamiento. Ingenuo y con fallos de encuadre e iluminación clamorosos, pero no tiene más ambiciones que la de dejar constancia de algunas de las cosas que se dijeron en clase.

Ejemplos de transacciones en SQL Server

Descripción de cómo facilitar la ejecución de los ejercicios de la sesión de transacciones del moodle de la asignatura. Se trata de reorganizar las ventanas y hacer espacio para tener dos consultas a la vista. En cada una de ellas se mantendrán una o varias transacciones que pretendemos ejecutar simultáneamente. De esta forma podremos ver qué transacciones esperan a las otras y pasar de una a otra consulta con facilidad.

Paginación en SQL Server

Una introducción a los objetivos y contenidos de la sesión 3 del curso de Bases de Datos dentro del Máster Universitario en Desarrollo de Aplicaciones y Servicios Web de la Universidad de Alicante. El trabajo que permite la calificación de esta primera parte del curso se basa, precisamente, en lo que se describe en este vídeo. La paginación de resultados es una técnica que pretende agilizar el manejo remoto de grandes cantidades de datos. El ejemplo clásico es la navegación por un catálogo de productos. Si es el servidor el que, por el procedimiento que sea, divide la lista completa en páginas y solo envía una de ellas al cliente, estamos ahorrando en tiempo y uso de red. En SQL Server, para esta tarea, es fácil encontrar opiniones que desaconsejan el uso de cursores puesto que se supone que el entorno objetivo es de alta concurrencia. No obstante, se puede usar TOP() y ROW_NUMBER(). La sesión consiste en una serie de ejemplos sobre todas estas herramientas.

Confronto di performance tra applicazioni web SQL e NoSQL su grandi quantità di dati

Lo scopo di questa tesi è di mettere a confronto le performance, su grandi quantità di dati, tra applicazioni web basate su database a modello relazionale, noti come RDBMS, e applicazioni web basate su database a modello non-relazionale, meglio conosciuti con l'appellativo NoSQL. Sono stati selezionati sette casi d'uso appartenenti ad una applicazione reale per effettuare il confronto di prestazioni tra i seguenti database: MySQL, Microsoft SQL Server, OrientDB, MongoDB e BaseX.

Improving trust and securing data accessibility for e-health decision making by using data encryption techniques

In the medical and healthcare arena, patients‟ data is not just their own personal history but also a valuable large dataset for finding solutions for diseases. While electronic medical records are becoming popular and are used in healthcare work places like hospitals, as well as insurance companies, and by major stakeholders such as physicians and their patients, the accessibility of such information should be dealt with in a way that preserves privacy and security. Thus, finding the best way to keep the data secure has become an important issue in the area of database security. Sensitive medical data should be encrypted in databases. There are many encryption/ decryption techniques and algorithms with regard to preserving privacy and security. Currently their performance is an important factor while the medical data is being managed in databases. Another important factor is that the stakeholders should decide more cost-effective ways to reduce the total cost of ownership. As an alternative, DAS (Data as Service) is a popular outsourcing model to satisfy the cost-effectiveness but it takes a consideration that the encryption/ decryption modules needs to be handled by trustworthy stakeholders. This research project is focusing on the query response times in a DAS model (AES-DAS) and analyses the comparison between the outsourcing model and the in-house model which incorporates Microsoft built-in encryption scheme in a SQL Server. This research project includes building a prototype of medical database schemas. There are 2 types of simulations to carry out the project. The first stage includes 6 databases in order to carry out simulations to measure the performance between plain-text, Microsoft built-in encryption and AES-DAS (Data as Service). Particularly, the AES-DAS incorporates implementations of symmetric key encryption such as AES (Advanced Encryption Standard) and a Bucket indexing processor using Bloom filter. The results are categorised such as character type, numeric type, range queries, range queries using Bucket Index and aggregate queries. The second stage takes the scalability test from 5K to 2560K records. The main result of these simulations is that particularly as an outsourcing model, AES-DAS using the Bucket index shows around 3.32 times faster than a normal AES-DAS under the 70 partitions and 10K record-sized databases. Retrieving Numeric typed data takes shorter time than Character typed data in AES-DAS. The aggregation query response time in AES-DAS is not as consistent as that in MS built-in encryption scheme. The scalability test shows that the DBMS reaches in a certain threshold; the query response time becomes rapidly slower. However, there is more to investigate in order to bring about other outcomes and to construct a secured EMR (Electronic Medical Record) more efficiently from these simulations.

An ingenious decision support system for remote health monitoring of pregnant women

Maternal deaths have been a critical issue for women living in rural and remote areas. The need to travel long distances, the shortage of primary care providers such as physicians, specialists and nurses, and the closing of small hospitals have been problems identified in many rural areas. Some research work has been undertaken and a few techniques have been developed to remotely measure the physiological condition of pregnant women through sophisticated ultrasound equipment. There are numerous ways to reduce maternal deaths, and an important step is to select the right approaches to achieving this reduction. One such approach is the provision of decision support systems in rural and remote areas. Decision support systems (DSSs) have already shown a great potential in many health fields. This thesis proposes an ingenious decision support system (iDSS) based on the methodology of survey instruments and identification of significant variables to be used in iDSS using statistical analysis. A survey was undertaken with pregnant women and factorial experimental design was chosen to acquire sample size. Variables with good reliability in any one of the statistical techniques such as Chi-square, Cronbach’s á and Classification Tree were incorporated in the iDSS. The decision support system was developed with significant variables such as: Place of residence, Seeing the same doctor, Education, Tetanus injection, Baby weight, Previous baby born, Place of birth, Assisted delivery, Pregnancy parity, Doctor visits and Occupation. The ingenious decision support system was implemented with Visual Basic as front end and Microsoft SQL server management as backend. Outcomes of the ingenious decision support system include advice on Symptoms, Diet and Exercise to pregnant women. On conditional system was sent and validated by the gynaecologist. Another outcome of ingenious decision support system was to provide better pregnancy health awareness and reduce long distance travel, especially for women in rural areas. The proposed system has qualities such as usefulness, accuracy and accessibility.

An ingenuous Decision Support System (iDSS) approach for remote area pregnant women

This paper addresses development of an ingenious decision support system (iDSS) based on the methodology of survey instruments and identification of significant variables to be used in iDSS using statistical analysis. A survey was undertaken with pregnant women and factorial experimental design was chosen to acquire sample size. Variables with good reliability in any one of the statistical techniques such as Chi-square, Cronbach’s α and Classification Tree were incorporated in the iDSS. The ingenious decision support system was implemented with Visual Basic as front end and Microsoft SQL server management as backend. Outcome of the ingenious decision support system include advice on Symptoms, Diet and Exercise to pregnant women.

Clinical data warehousing for evidence based decision making

Large volumes of heterogeneous health data silos pose a big challenge when exploring for information to allow for evidence based decision making and ensuring quality outcomes. In this paper, we present a proof of concept for adopting data warehousing technology to aggregate and analyse disparate health data in order to understand the impact various lifestyle factors on obesity. We present a practical model for data warehousing with detailed explanation which can be adopted similarly for studying various other health issues.

Assessment of existing information on Atlantic coastal fish habitats: development of a web-based spatial bibliography, query tools, and data summaries

The primary objective of this project, “the Assessment of Existing Information on Atlantic Coastal Fish Habitat”, is to inform conservation planning for the Atlantic Coastal Fish Habitat Partnership (ACFHP). ACFHP is recognized as a Partnership by the National Fish Habitat Action Plan (NFHAP), whose overall mission is to protect, restore, and enhance the nation’s fish and aquatic communities through partnerships that foster fish habitat conservation. This project is a cooperative effort of NOAA/NOS Center for Coastal Monitoring and Assessment (CCMA) Biogeography Branch and ACFHP. The Assessment includes three components; 1. a representative bibliographic and assessment database, 2. a Geographical Information System (GIS) spatial framework, and 3. a summary document with description of methods, analyses of habitat assessment information, and recommendations for further work. The spatial bibliography was created by linking the bibliographic table developed in Microsoft Excel and exported to SQL Server, with the spatial framework developed in ArcGIS and exported to GoogleMaps. The bibliography is a comprehensive, searchable database of over 500 selected documents and data sources on Atlantic coastal fish species and habitats. Key information captured for each entry includes basic bibliographic data, spatial footprint (e.g. waterbody or watershed), species and habitats covered, and electronic availability. Information on habitat condition indicators, threats, and conservation recommendations are extracted from each entry and recorded in a separate linked table. The spatial framework is a functional digital map based on polygon layers of watersheds, estuarine and marine waterbodies derived from NOAA’s Coastal Assessment Framework, MMS/NOAA’s Multipurpose Marine Cadastre, and other sources, providing spatial reference for all of the documents cited in the bibliography. Together, the bibliography and assessment tables and their spatial framework provide a powerful tool to query and assess available information through a publicly available web interface. They were designed to support the development of priorities for ACFHP’s conservation efforts within a geographic area extending from Maine to Florida, and from coastal watersheds seaward to the edge of the continental shelf. The Atlantic Coastal Fish Habitat Partnership has made initial use of the Assessment of Existing Information. Though it has not yet applied the AEI in a systematic or structured manner, it expects to find further uses as the draft conservation strategic plan is refined, and as regional action plans are developed. It also provides a means to move beyond an “assessment of existing information” towards an “assessment of fish habitat”, and is being applied towards the National Fish Habitat Action Plan (NFHAP) 2010 Assessment. Beyond the scope of the current project, there may be application to broader initiatives such as Integrated Ecosystem Assessments (IEAs), Ecosystem Based Management (EBM), and Marine Spatial Planning (MSP).

HIRFL控制系统数据库系统设计

HIRFL（兰州重离子加速器）是我国第一个大型重离子物理研究装置。HIRFL控制系统是保证HIRFL系统正常高效运转的重要环节。本文利用数据库技术、网络技术设计了HIRFL控制系统数据库系统，实现了在网络环境中只使用一个应用程序就可对整个HIRFL系统控制进行控制的要求。论文首先介绍了数据库系统理论，然后对软件设计涉及的各部分基础知识进行了阐述，最后详细讨论了整个数据库系统设计中的数据库设计、应用程序人机界面设计等部分。数据库应用SQL Server 2000大型数据库，并使用ODBC技术作为数据库访问手段；人机界面部分使用面向对象编程技术进行Windows编程。整个论文工作在建立了一个包含整个控制系统各部分设备信息的数据库的同时，还提供了一套包含所有基本控制功能的HIRFL分布式控制软件，为HIRPL控制系统数据库系统的进一步完善提供了二次开发平台。

基于Geodatabase和Arcengine的海岛空间数据库的设计与实现

本文对山东省海岛进行了研究，认识了山东省不同地区海岛的自然环境、资源和开发利用的总体状况。通过对大量的海岛调查资料的整理、分析，提出了利用Geodatabase数据模型构建山东省海岛空间数据库来组织和存储海岛数据的方案，采用GIS软件平台ArcEngine和程序开发语言研发山东省海岛管理信息系统。 山东省是我国海岛资源比较丰富的省份。从整体来看，山东省海岛地理位置优越，气候条件好，海岛类型分为基岩岛、沙岛和人工岛，其中大部分海岛为基岩岛，沙岛主要分布在黄河三角洲北侧的滨州和潍坊昌邑。山东省海岛拥有丰富的渔业资源、水产资源、旅游资源、土地资源、港口资源、地下卤水资源、贝壳砂资源等，依据这些资源优势，海岛的开发也集中在养殖业开发、旅游开发、港口资源开发等。 Geodatabase数据模型能够有效地定义、组织空间数据，ArcSDE技术提供了空间数据存储在商业关系型数据库的通道，Geodatabase数据模型和ArcSDE技术使得使用同一大型的关系型数据库统一存储空间数据和属性数据成为可能。本文采用Geodatabase数据模型、ArcSDE技术、SQL Server数据库，设计了海岛数据的统一存储和管理模型，通过数据处理和入库建立了山东省海岛空间数据库。 本文还基于GIS软件平台ArcEngine组件和程序开发语言VB.NET完成了山东省海岛管理信息系统的开发。该系统实现了海岛数据的访问和加载、海岛地图的显示和操作、海岛数据的多种方式的查询显示、地图的几何量算功能以及海岛专题资料的集成与综合分析，同时系统也提供数据图层的标注、图层颜色的设置，图层的移动、删除功能。这些功能的实现对山东省海岛的开发、管理提供了有用的平台，为决策部门提供服务。

一个CIMS环境下的基于范例的船体装配CAPP系统

本文介绍了一个 CIMS环境下的基于范例的船体装配 CAPP系统 .包括 :CAPP系统在渤海造船厂 CIMS工程中的地位 ,基于范例的工艺规划 (范例的表达 ,范例的索引、存储、检索和适应 ) ,工艺定额和材料定额制定 ,分系统之间的信息集成 .系统采用 Power Builder和 SQL Server数据库中的 SQL语言编写 .目前 ,船体装配 CAPP系统已经在渤海造船厂的微机上连网运行