Runaway query in data Warehouse

Data warehouse. By: sarita531

The University of Arkansas BI/Data Warehouse is a data repository made up of over 270 tables of legacy and historical data such as financial (DART, UPS, BASIS, Payroll, etc.) and academic (ISIS) data that is separate and distinct from the mainframe production databases. Warehouse data is copied from the live production system, summarized, transformed and then loaded into the BI/Data Warehouse at regular intervals. Non-programmers will find easy access to this data from their desktops.

Accessing BI/Data Warehouse

Access to the BI/Data Warehouse requires an authorized signature from the department head (or person responsible for authorizing cost center expenditures) and is only available to academic and administrative users. No students will be authorized for access. The BI/Data Warehouse is accessible from 7 a.m. to 6 p.m. weekdays and on weekends when maintenance is not scheduled. Call the IT Services Data Center at 575-2303 to verify accessibility on weekends.

IT Services supports and recommends using Microsoft Access or SAS EG, but the BI/Data Warehouse can also be accessed with any ODBC (Open Data Base Connectivity) compliant software product. An ODBC driver must be installed, typically by the BI/Data Warehouse team, on the user's computer to connect to the BI/Data Warehouse.

Microsoft Access is the most common product used to access the BI/Data Warehouse. SAS EG is a sophisticated, client-server query and reporting system that provides access for non-technical users. With SAS EG, users can build queries and reports, as well as graphic elements and charts. Stored processes can be built to reproduce reports to be displayed on the Web as HTML. Faculty and non-administrative UARK users can purchase site licenses for SAS

Stopping a BI/Data Warehouse Query

If you build a BI/Data Warehouse query and submit it, but forget to provide any selection (or limit) criteria, a "runaway" query can be created if the table(s) have a lot of records. In this case, you will want to stop the query.

No Records Returned after BI/Data Warehouse Query

Double check what you used as selection criteria. Selection data is case sensitive. Look at a sampling of the data you are wanting. If you are using dates, check to see if you are using the same date format.

Example: If you entered 19990125 (YYYYMMDD) as the date, but the table date format is (MMDDYYYY) 01251999, you will not get any records returned. If you are using multiple tables, double check what fields you are linking on. You might want to remove all the tables and then start adding (and linking) a table at a time. This may identify the table that is causing the problem (or give you some insight as to what you were doing wrong).

You might also like

SQL Free Training - Designing a Data Warehouse
SQL Free Training - Designing a Data Warehouse
Data Warehouse Design - Healthcare
Data Warehouse Design - Healthcare
Fantasia Trading LLC Anker® 40W 5-Port Family-Sized Desktop USB Charger with PowerIQ™ Technology for iPhone 5s 5c 5; iPad Air mini; Galaxy S5 S4; Note 3 2; the new HTC One (M8); Nexus and More (White)
Wireless (Fantasia Trading LLC)
  • PowerIQ technology maximizes compatibility with Android, Apple and other devices by enabling charging speeds of up to 8 amps among 5 ports or 2.4 amps per port.
  • The size of a deck of playing cards (3.6 × 2.3 × 1.0in / 9.1 × 5.8 × 2.5cm) and unibody design for added portability.
  • Industrial-grade materials and premium circuitry ensure lifetime reliability.
  • 100-240 volt input ideal for international travel.
  • Package contents: Anker® 40W 5-Port Wall Charger, 5ft / 150cm detachable power cord, welcome guide, 18-month hassle-free warranty.

The Guinness World Record for the Largest Data Warehouse: A Q&A with Tom ..  — B-EYE-Network
Business unIntelligence—Insight and Innovation Beyond Analytics and Big Data Summary Is there still a need for the data warehouse? In this excerpt from his new book, Barry Devlin looks at why the data warehouse can no longer retain its old role of ..

Anker Anker® 2nd Gen Astro Mini 3200mAh Ultra-Compact Portable Charger Lipstick-Sized External Battery Power Bank with PowerIQ™ Technology for iPhone 6 5s 5c 5 4S, Galaxy S5 S4 S3 Note 3, 4, Nexus 4, HTC One M8, Nokia Lumia 520, 1020 and Other Smartphones (Black)
Wireless (Anker)
  • The Anker® Advantage: Join the 6 million+ powered by Amazon s #1 charging brand.
  • Exclusive PowerIQ™ Technology: Detects your device to deliver its fastest possible charge speed up to 1 amp.
  • High Capacity: Add one and a half charges (over 7 hours talktime) to an iPhone 5s, almost one full charge to a Galaxy S5 or one full charge (70+ hours of audio playback)...
  • Ultra Compact: Our original lipstick-shaped aluminum design (3.5 × 0.9 × 0.9in, 2.7oz). Recharges in 3-4 hours with a 0.8 amp adapter (not included) and the included...
  • What You Get: Anker® 2nd Generation Astro Mini 3200mAh External Battery, Micro USB cable, travel pouch, welcome guide, our fan-favorite 18-month warranty and friendly...
OPTOMA TECHNOLOGY Optoma EH500 1080p 4700 Lumen Full 3D DLP Network Projector with HDMI
  • Native 1080p high-definition resolution for crystal clear presentations
  • 4700 lumens bright output makes it ideal for use in large screen applications
  • Latest image controller technology and Full 3D compatibility for the most amazing immersive experiencer
  • Over the network management and control capability makes it the perfect projector for large installations
Robertson Worldwide ROBERTSON 2P20067 PSP242TRMVW/S Quik-Pak of 10 eBallast, Program Start, 1 or 2 Lamp, 4 Pin CFL (CFTR42W/GX24q), HPF, 120-277Vac.
Home Improvement (Robertson Worldwide)
  • Equivalent to: Fulham RH4-UNV-242-K, RH4-UNV-242-C, Keystone KTEB-242T-UV-TP-PSD-NL
  • Program Start, 1 or 2 Lamp, 4 Pin CFL (CFQ42W/GX24q), HPF,120-277Vac., -30C Min Start Temp
  • Also offered as a single quantity by ordering the ROBERTSON 3P20067 PSP242TRMVW/S
  • Take advantage of ROBERTSON s 60 years of electronic design and quality manufacturing experience.
  • Commerical grade. FIVE year warranty. Go to for complete technical data.
Anker Anker® 2nd Gen Astro 6000mAh External Battery Pack with PowerIQ™ Technology 2A Output Portable USB Charger Power Bank for Smart Devices (Green)
CE (Anker)
  • - PowerIQ™ technology maximizes compatibility with Android, Apple or other devices by enabling charge speeds of up to 2 amps.
  • - 6 mAh capacity and an efficiency rate 10% above previous generation Astros and standard alternatives charges the iPhone 3 times and the Galaxy S4 almost twice.
  • - Shake to start charge or display remaining power level on the ultra-low consumption 10-LED power meter (1 shakes consume less than 1%).
  • Sturdy construction and matte finish withstand bumps and drops. Grade A cells and premium chips ensure reliability. Input: 5V / 1.2A; Use a 1.2A adapter (not included)...
  • - Package contents: Anker® 2nd Generation Astro External Battery, micro USB cable, welcome guide.


How to write these two queries for a simple data warehouse, using ANSI SQL?

As noted in the comment above, I probably do not understand your model -- so here is a simple one to get started.