Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

SQL etc

Posted Aug 9, 2001

Beginning SQL Programming: Pt. 4

By DatabaseJournal.com Staff

Data Warehouse with Multiple SQL Requesters

Last, let us look at an example that is probably realistic for most businesses. We have one datastore for the enterprise that consists of several data servers and a mainframe, collectively called a Data Warehouse or a Distributed Data Processing system. That conglomerate of a datastore receives SQL requests for internal business operations from a business logic server. The business logic server is processing operations as directed by employees using PCs and front-end software on their desks.

The company also has a website serviced by a web server. The web server interacts with visitors and then sends SQL requests to the same enterprise data warehouse. Although there are many brands of software involved and many platforms they are all able to speak and understand SQL.

We can trace the information flow in this graphic by starting with the PCs on the right. They are connected to either the Department Server or the Web Server. These servers can then create a SQL request using their business logic software and pass the request to one or more of the Data Servers. This is usually done through a high-speed LAN which only connects servers (represented on the far left). After the SQL Request has been processed the results can return from left to right through the servers and to the PCs.

Data Warehousing Diagram
(Click image for full size)

SQL etc Archives

Latest Forum Threads
SQL etc Forum
Topic By Replies Updated
MySQL rollback UAL225 0 August 21st, 09:56 PM
Complex Search Query Galway 0 May 20th, 10:04 PM
change collation at once supercain 2 May 15th, 06:18 AM
SQL Features, tools and utilities question Neomite 1 April 10th, 09:13 AM