Este ítem es privado
Guide: PRASC SQL SBR technical guide
| dc.date.accessioned | 2023-09-25T18:02:45Z |
| dc.date.available | 2023-09-25T18:02:45Z |
| dc.format | Texto |
| dc.identifier.uri | https://hdl.handle.net/11362/68523 |
| dc.title | Guide: PRASC SQL SBR technical guide |
| dspace.entity.type | Publication |
| prasc.categories | Economic Statistics |
| prasc.contributor.entity | Statistics Canada |
| prasc.description.abstract | This document provides guidance and best practises for the maintenance of the code behind the SQL SBR system as well as maintenance considerations for the system itself. The intended audience of this document is developers / system administrators who are required to update the code in the system. |
| prasc.description.tableOfContents | 1. Introduction.--1.1 The Project for the Regional Advancement of Statistics in the Caribbean Statistical Business Register.--1.2 What is this technical guide?.--1.3 General overview of the Statistical Business Register (SBR) System.--1.4 PRASC Client Server Architecture.--2. System Installation.--2.1 General considerations / overview.--2.2 Database and SBR Installation(step-by-step):.--2.3 Backups.--2.4 Other environments.--3 SQL database.-- 3.1 General considerations / overview.--3.2 Coding Standards Rules.--3.3 Database Security.--3.4 Entity relationship model.--4. Excel templates.-4.1GeneralConsiderations.--4.2 Coding Standards Rules.--4.3 Excel Macros.--5 .NET Code.--5.1 General considerations / overview.--5.2 Code Structure.--5.3 User-based roles.--5.4 Hands-on example.--5.5 Naming Standards.--6 Error Handling.--7 New Release and preparing a Distribution Kit.--7.1 Deployment of the MSI package.--7.2 Generating the SQL script PrascGenericBR.sql – First time installation.--7.3 Generating the SQL scripts and patches.--7.4 Include ResettingPrascDatabase.sql,UpdateTblHostCountry.sql and U pdateTblInactivationCriteria.sql.--7.5 New Excel template.--7.6 Instructions and Release Notes. |
| prasc.keywords | Administrative data |
| prasc.keywords | Business survey |
| prasc.keywords | International Standard Industrial Classification (ISIC) |
| prasc.keywords | User guide |
| prasc.language.iso | en |
| prasc.methodsandprocesses | Frame and Sample Design |
| prasc.physicalDescription | 48 p. |
| prasc.publisher | Project for the Regional Advancement of Statistics in the Caribbean (PRASC) |
| prasc.relation.contentWebDescription | Tool: PRASC SQL Statistical Business Register |
| prasc.relation.contentWebDescription | Guide: PRASC SQL SBR user's guide |
| prasc.rights.coar | Disponible |
| prasc.subcategories | Statistical Business Register (SBR) |
| prasc.typeOfDocument | Reference guides |
Descargar
Bloque original
1 - 1 de 1
Cargando...
- Nombre:
- PRASC_Guide_SQL SBR Technical Guide_MAY2023.pdf
- Tamaño:
- 19.47 MB
- Formato:
- Adobe Portable Document Format
- Descripción: