Ex ante evaluations of alternate data structures for end user queries: Theory and experimental test

The data structure of an information system can significantly impact the ability of end users to efficiently and effectively retrieve the information they need. This research develops a methodology for evaluating, ex ante, the relative desirability of alternative data structures for end user queries. This research theorizes that the data structure that yields the lowest weighted average complexity for a representative sample of information requests is the most desirable data structure for end user queries. The theory was tested in an experiment that compared queries from two different relational database schemas. As theorized, end users querying the data structure associated with the less complex queries performed better Complexity was measured using three different Halstead metrics. Each of the three metrics provided excellent predictions of end user performance. This research supplies strong evidence that organizations can use complexity metrics to evaluate, ex ante, the desirability of alternate data structures. Organizations can use these evaluations to enhance the efficient and effective retrieval of information by creating data structures that minimize end user query complexity.

Expression of HOXB2, a retinoic acid signaling target in pancreatic cancer and pancreatic intraepithelial neoplasia

Purpose: Despite significant progress in understanding the molecular pathology of pancreatic cancer and its precursor lesion: pancreatic intraepithelial neoplasia (PanIN), there remain no molecules with proven clinical utility as prognostic or therapeutic markers. Here, we used oligonucleotide microarrays to interrogate mRNA expression of pancreatic cancer tissue and normal pancreas to identify novel molecular pathways dysregulated in the development and progression of pancreatic cancer. Experimental Design: RNA was hybridized to Affymetrix Genechip HG-U133 oligonucleotide microarrays. A relational database integrating data from publicly available resources was created to identify candidate genes potentially relevant to pancreatic cancer. The protein expression of one candidate, homeobox B2 (HOXB2), in PanIN and pancreatic cancer was assessed using immunohistochemistry. Results: We identified aberrant expression of several components of the retinoic acid (RA) signaling pathway (RARa, MUC4, Id-1, MMP9, uPAR, HB-EGF, HOXB6, and HOXB2), many of which are known to be aberrantly expressed in pancreatic cancer and Pan IN. HOXB2, a downstream target of RA, was up-regulated 6.7-fold in pancreatic cancer compared with normal pancreas. Immunohistochemistry revealed ectopic expression of HOXB2 in 15% of early Pan IN lesions and 48 of 128 (38%) pancreatic cancer specimens. Expression of HOXB2 was associated with nonresectable tumors and was an independent predictor of poor survival in resected tumors. Conclusions: We identified aberrant expression of RA signaling components in pancreatic cancer, including HOXB2, which was expressed in a proportion of PanIN lesions. Ectopic expression of HOXB2 was associated with a poor prognosis for all patients with pancreatic cancer and was an independent predictor of survival in patients who underwent resection.

A design pattern for efficient retrieval of large data sets from remote data sources

Retrieving large amounts of information over wide area networks, including the Internet, is problematic due to issues arising from latency of response, lack of direct memory access to data serving resources, and fault tolerance. This paper describes a design pattern for solving the issues of handling results from queries that return large amounts of data. Typically these queries would be made by a client process across a wide area network (or Internet), with one or more middle-tiers, to a relational database residing on a remote server. The solution involves implementing a combination of data retrieval strategies, including the use of iterators for traversing data sets and providing an appropriate level of abstraction to the client, double-buffering of data subsets, multi-threaded data retrieval, and query slicing. This design has recently been implemented and incorporated into the framework of a commercial software product developed at Oracle Corporation.