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="">

Northwind Stock Report Dataset

This dataset was created by CHERGUELAINE Ayoub & BOUBEKRI Faycal for the purpose of document classification and analytics. The dataset contains monthly stock reports and monthly stock reports by category, extracted from the Northwind dataset. The Northwind dataset is a sample database that comes with Microsoft Access, and is commonly used as a demo database for learning SQL. The dataset contains data on a fictional company called "Northwind Traders"… See the full description on the dataset page: https://huggingface.co/datasets/AyoubChLin/northwind-Stock_rapport.

Data has been processed by NODC to the NODC standard Bathythermograph (MBT) (C128) format. The C128 format is used for temperature-depth profile data obtained using the mechanical bathythermograph (MBT) instrument. The maximum depth of MBT observations is approximately 285 m. Therefore, MBT data are useful only in studying the thermal structure of the upper layers of the ocean. Cruise information, date, position, and time are reported for each observation. The data record comprises pairs of temperature-depth values. Temperature data in this file are recorded at uniform 5 m depth intervals.

Dataset

This dataset was created by Oladayo Felix, Olatunji

Released under Database: Open Database, Contents: Database Contents

Contents

This dataset provides information about the number of properties, residents, and average property values for Northwind Court cross streets in Hammond, OR.

This dataset provides information about the number of properties, residents, and average property values for Northwind Cove cross streets in Florence, AL.

This dataset provides information about the number of properties, residents, and average property values for Northwind Lane cross streets in North Hills, CA.

Data has been processed by NODC to the NODC standard Bathythermograph (XBT) (C116) format. The C116/C118 format contains temperature-depth profile data obtained using expendable bathythermograph (XBT) instruments. Cruise information, position, date and time were reported for each observation. The data record was comprised of pairs of temperature-depth values. Unlike the MBT Data File, in which temperature values were recorded at uniform 5 m intervals, the XBT data files contained temperature values at non-uniform depths. These depths were recorded at the minimum number of points ("inflection points") required to accurately define the temperature curve. Standard XBTs can obtain profiles to depths of either 450 or 760 m. With special instruments, measurements can be obtained to 1830 m. Prior to July 1994, XBT data were routinely processed to one of these standard types. XBT data are now processed and loaded directly in to the NODC Ocean Profile Data Base (OPDB). Historic data from these two data types were loaded into the OPDB.

This dataset provides information about the number of properties, residents, and average property values for Northwind Circle cross streets in Northport, AL.

This dataset provides information about the number of properties, residents, and average property values for Northwind Drive cross streets in Honor, MI.

This dataset provides information about the number of properties, residents, and average property values for Northwind Way cross streets in Orangevale, CA.

This dataset provides information about the number of properties, residents, and average property values for Northwind Court cross streets in Bellingham, WA.

This dataset provides information about the number of properties, residents, and average property values for Northwind Court cross streets in Las Vegas, NV.

This dataset provides information about the number of properties, residents, and average property values for Northwind Drive cross streets in Chattanooga, TN.

This dataset provides information about the number of properties, residents, and average property values for Northwind Road cross streets in Louisville, KY.

The data in this accession was collected in Bay of Biscay from ship Northwind between October 8, 1988 and October 19, 1988. The real time data of water temperature at varying depth bathythermograph (XBT) was recorded in stripcharts by the US Coast Guard. These stripcharts and radio logs were submitted to NODC. The XBT data from these stripcharts have been digitized and is present in the current NODC data storage system in C116 file format.

Subscribers can find out export and import data of 23 countries by HS code or product’s name. This demo is helpful for market analysis.

Conductivity, Temperature, Depth (CTD) and other data from multiple ships and other platforms were collected from NE Pacific (limit-180) from February 26, 1982 to April 5, 1983. The data was collected as part of Coastal Ocean Dynamics Experiment and submitted by Oregon State University. The bathythermograph XBT data is in C-116 format of NODC while the CTD hi resolution data is in F-022 format. More information regarding this file format is available in the following URL:http://www.nodc.noaa.gov/General/NODC-Archive/f022.html

Stream Temperature: Site: Jennifer Branch at Northwind (JBNW):

   In the Baltimore urban long-term ecological research (LTER) project, (Baltimore Ecosystem Study, BES) we use the watershed approach to evaluate integrated ecosystem function. The LTER research is centered on the Gwynns Falls watershed, a 17,150 ha catchment that traverses a gradient from the urban core of Baltimore, through older urban residential (1900 - 1950) and suburban (1950- 1980) zones, rapidly suburbanizing areas and a rural/suburban fringe.

   Stream temperature is continuously measured throughout the Gwynns Falls watershed along with supplemental sites around Baltimore County/City. A total of 22 sites contain sensors (HOBO Pro v2 Water Temperature Data Logger - U22-001) that take an instantaneous temperature reading every 2 minutes. These data are downloaded on a monthly basis. 

   This dataset is for Jennifer Branch off Northwind Rd in Carney, MD. It is located close to the Cub Hill flux tower. The area draining this site is about 448 ha and is 19% forested and 20.5% impervious of both high and low density development. This site includes drainage from the other Jennifer Branch sites that are monitored. 

   Watershed information was taken from delineations created with USGS StreamStats at http://water.usgs.gov/osw/streamstats/maryland.html


   Purpose: Long-term monitoring of stream temperature in a suburban watershed. 

   Theme keywords: stream, watershed, temperature, suburban, Baltimore Ecosystem Study

   Coordinates: Lat/Long

   39.4075 (39 24 27)  -76.5037 (-76 30 13)


   Review process for BES stream temperature data:

   Raw data were recorded and logged every 2-minutes using HOBO Pro v2 Water Temperature Data Logger - U22-001. 

   Data are exported into Microsoft Excel documents. 

   Then organized by site and by month

   Each month's data were entered into a pivot table in Microsoft Excel and daily means and counts of daily data points were calculated. 

   Plots were graphed of sites with close geographic proximity on the same graph to illustrate possible outlier data. 

   Missing and odd data were flagged, and notes taken from the field visits are provided where applicable.

Temperature profile data were collected using bathythermograph (BT/XBT) casts from NORTHWIND in the Pacific Ocean from November 11, 1976 to November 15, 1976. Data were submitted by Scripps Institution of Oceanography as part of the Thermal Structure Monitoring Program in the Pacific (TRANSPAC) project. Data were processed by NODC to the NODC standard Universal Bathythermograph Output (UBT) format. Full BT descriptions are available at http://www.nodc.noaa.gov/General/NODC-Archive/bt.html.

The UBT format contains temperature-depth profile data obtained using expendable bathythermograph (XBT) instruments. Cruise information, position, date and time were reported for each observation. The data record was comprised of pairs of temperature-depth values. Unlike the MBT Data File, in which temperature values were recorded at uniform 5 m intervals, the XBT data files contained temperature values at non-uniform depths. These depths were recorded at the minimum number of points ("inflection points") required to accurately define the temperature curve. Standard XBTs can obtain profiles to depths of either 450 or 760 m. With special instruments, measurements can be obtained to 1830 m.