Databases Reference
In-Depth Information
SELECT
cd.CustomerID, cd.CustomerName, ad.City, ad.
Country
FROM
CustomerData
AS
cd, AddressData
AS
ad
WHERE
cd.CustomerID = @CustomerID
AND
cd.AddressID = ad.AddressID;
Listing 4.8
Display customer details
SELECT
p.ProductID, p.ProductType, p.IndustrySector,
pd.ProductDescription
FROM
ProductData
AS
p, ProductDescription
AS
pd
WHERE
pd.Language = "English"
AND
p.ProductID = @ProductID
AND
p.ProductID = pd.ProductID;
Listing 4.9
Display product details
tables. An example for the SQL statements is given in Listing
4.8
, selecting
customer data by ID using a join of the customer data and address data tables, and
Listing
4.9
, selecting product data by ID from the product data table and product
description table.
4.3.2
Analytical Queries
For analytics, the benchmark includes queries that are used for strategic report-
ing and queries showing operational reporting behavior. Through parameteriza-
tion, mainly the period of the analysis, the queries can be varied between operational
reporting and strategic reporting. The set of queries for the benchmark includes:
1. “Daily flash” reporting
2. Average order processing time
3. Order delivery fulfillment
4. Days sales outstanding
Daily flash reporting is composed of two queries that are executed intra-daily and
can be seen as purely operational reporting. The second and third queries collect
statistics that provide the basis to ensure customer satisfaction. If these numbers are
known, a company can set thresholds to provide early interventions in case improve-
ment is needed, heading in the direction of proactive instead of reactive decision
making according to Frolick and Ariyachandra [
63
]. Days sales outstanding is a
strategic reporting query about customer payment behavior.
Search WWH ::
Custom Search