Northwind Database

La base de datos Northwind es una base de datos de muestra creada originalmente por Microsoft y utilizada como base para sus tutoriales en una variedad de productos de bases de datos durante décadas. La base de datos de Northwind contiene datos de ventas de una empresa ficticia llamada "Northwind Traders", que importa y exporta alimentos especiales de todo el mundo. La base de datos Northwind es un excelente esquema tutorial para un ERP de pequeñas empresas, con clientes, pedidos, inventario, compras, proveedores, envíos, empleados y contabilidad de entrada única. Desde entonces, la base de datos Northwind ha sido trasladada a una variedad de bases de datos que no son de Microsoft, incluido PostgreSQL.

El conjunto de datos de Northwind incluye datos de muestra para lo siguiente.

• Proveedores: Proveedores y vendedores de Northwind
• Clientes: Clientes que compran productos de Northwind
• Empleados: detalles de los empleados de los comerciantes de Northwind
• Productos: Información del producto
• Transportistas: los detalles de los transportistas que envían los productos desde los comerciantes a los clientes finales.
• Órdenes y detalles de la orden: transacciones de órdenes de venta que tienen lugar entre los clientes y la empresa.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F13411583%2Fa52a5bbc3d8842abfdfcfe608b7a8d25%2FNorthwind_E-R_Diagram.png?generation=1718785485874540&alt=media" alt="">

Chinook DataBase

Chinook es una base de datos de muestra disponible para SQL Server, Oracle, MySQL, etc. Se puede crear ejecutando un único script SQL. La base de datos Chinook es una alternativa a la base de datos Northwind, siendo ideal para demostraciones y pruebas de herramientas ORM dirigidas a servidores de bases de datos únicos o múltiples.

El modelo de datos Chinook representa una tienda de medios digitales, que incluye tablas para artistas, álbumes, pistas multimedia, facturas y clientes.

Los datos relacionados con los medios se crearon utilizando datos reales de una biblioteca de iTunes. La información de clientes y empleados se creó manualmente utilizando nombres ficticios, direcciones que se pueden ubicar en mapas de Google y otros datos bien formateados (teléfono, fax, correo electrónico, etc.). La información de ventas se genera automáticamente utilizando datos aleatorios durante un período de cuatro años.

¿Por qué el nombre Chinook? El nombre de esta base de datos de ejemplo se basó en la base de datos Northwind. Los chinooks son vientos en el interior oeste de América del Norte, donde las praderas canadienses y las grandes llanuras se encuentran con varias cadenas montañosas. Los chinooks son más frecuentes en el sur de Alberta en Canadá. Chinook es una buena opción de nombre para una base de datos que pretende ser una alternativa a Northwind.

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F13411583%2Fd856e0358e3a572d50f1aba5e171c1c6%2FChinook%20DataBase.png?generation=1718785749657445&alt=media" alt="">

Adult salmonid data collected from various areas within the Klamath basin watershed. Various tributaries are monitored using video systems (Bogus Creek, Shasta River, Scott River), other areas are monitored using redd/carcass surveys, and Iron gate Hatchery adult returns. The main purpose of the data is to estimate escapement of fall Chinook slamon, although data on other species (steelhead, coho salmon) also collected. For more information on the various collection methods, please view the specific metadata document included with the data download. This data and metadata were submitted by California Department of Fish and Wildlife (CDFW) Staff though the Data Management Plan (DMP) framework with the id: DMP000381. For more information, please visit https://wildlife.ca.gov/Data/Sci-Data.

Stream arcs with established or predicted Chinook Salmon presence throughout Pierce County. Please read metadata for additional information (https://matterhorn.co.pierce.wa.us/GISmetadata/pdbplan_chinook_presence.html). Any data download constitutes acceptance of the Terms of Use (https://matterhorn.co.pierce.wa.us/Disclaimer/PierceCountyGISDataTermsofUse.pdf).

Stream arcs with established or predicted Chinook Salmon presence throughout Pierce County.Please read the metadata (https://matterhorn.piercecountywa.gov/GISmetadata/pdbplan_chinook_presence.html) for additional information. Any data download constitutes acceptance of the Terms of Use (https://matterhorn.piercecountywa.gov/disclaimer/PierceCountyGISDataTermsofUse.pdf).

DWR has been working with USGS to develop ECO-PTM, an individual based juvenile salmonid migration and survival model. The Delta hydrodynamic input for the model is from a 15-minute-time-step hydrodynamic simulation, therefore the model is sensitive to tidal flows and SWP and CVP operations. The model can be used to quantitatively evaluate management actions that concern the survival of juvenile salmonid in the Sacramento River. Recently, the model has been used for the planning study of the Georgiana/Sutter-Steamboat Slough fish barriers.

A Conservation Unit (CU) is a group of wild Pacific salmon sufficiently isolated from other groups that, if extirpated, is very unlikely to recolonize naturally within an acceptable timeframe, such as a human lifetime or a specified number of salmon generations. Holtby and Ciruna (2007) provided a framework for aggregating the five species of salmon (genus Oncorhynchus) found on Canada’s Pacific coast into species-specific CUs based on three primary characteristics: ecotypology, life history and genetics. The first stage in the description of the Conservation Units is based solely on ecology. The ecotypologies used in this framework include a combined characterization of both freshwater and near-shore marine environments, and is termed “joint adaptive zone”. The second stage of the description involves the use of life history, molecular genetics, and further ecological characterizations to group and partition the first stage units into the final Conservation Units. The result is CUs that are described through the joint application of all three axes. It is important to note that CUs are distinct from other aggregates of Pacific salmon, such as designatable units (DUs) under the Species at Risk Act or management units (MUs). CU Counting Sites: Salmon spawner enumeration data in the Pacific Region is stored and managed in the New Salmon Escapement Database (NuSEDS). The term “escapement” is used to refer to the group of mature salmon that have ‘escaped’ from various sources of exploitation, and returned to freshwater to spawn and reproduce. This data is assigned to a “Counting Site”, which may be a complete watercourse with a marine terminus, a tributary to a larger watercourse, or a defined reach within a watercourse that may or may not encompass the entire population but represents an index of the abundance of that population. CU Status: CUs form the basic unit for assessment under Canada’s Policy for the Conservation of Wild Salmon Policy (WSP) (DFO 2005). The biological status of a CU is evaluated using a number of metrics (Holt et al. 2009; Holt 2009), which indicate a WSP status zone: Red (poor status), Amber (marginal status), or Green (healthy status). A final step then incorporates all metric and status-related information into a final integrated status for each CU, along with expert commentary to support the final status determination (e.g., DFO 2012; DFO 2016). This information is used as inputs to fisheries management processes to help prioritize assessment activities and management actions. Note: CU boundaries were reviewed in 2020-2021 and have been updated from the BC Freshwater Atlas 1:50,000 scale to the BC Freshwater Atlas 1:20,000 scale. The CU boundaries were last updated in March 2023. Please be aware that CUs may be reviewed and are subject to change without notice. Please refer to Conservation Unit Review Requests-Form and Summary for a list of CU review requests that are ongoing or have been finalized.