Oracle Clinical

Searching Google.com for e-clinical provides many vendors. Some of these are Oracle Clinical v4i from Oracle Corporation [34], DataLabsXC from DataLabs, Inc. [35], TrialMaster from OmniCommSystems [36], and Clin-Plus Data Management (CPDM) by DZS Software Solutions, Inc. [37]. 

Barkat, Mohammed. Quality assurance/quality control issues in gmp regulatory compliance. Drug Inf. J. 1997, 31, 765-769. Oracle clinical corp. In Oracle Clinical User Reference, Oracle Clinical Corp. Redwood Shores, CA 1-10. 

Errors and Inconsistencies in Formatting Dates. It is also necessary to use standardized formats to record dates. For example, Oracle stores a date as the number of seconds since January 1, 4712 BC, and then uses various functions to display the dates in more human-friendly formats. There are many different and personal ways for recording dates one of the authors (AS) has noted at least 25 different ways in a single clinical trial submitted for FDA review Should February 1,2007 be recorded as 1 February 2007,1 Feb 2007, 1 Feb 07, or 02/01/07 This problem still exists when data for numerical dates are extracted into software programs such as Excel that do not force the user to select a unique format for dates. 

In most cases, the data that you use for clinical trial analyses are found in some kind of computer file external to the SAS System. The data you need may be found in a permanent SAS data set, a relational database table found in Oracle or Microsoft SQL Server, a Microsoft Access or Excel file, a simple delimited ASCII text file, or even an XML file. In any case SAS provides a wide array of ways in which to import data files into SAS. We explore these tools and the advantages and disadvantages of each in this chapter. 

Most clinical data management systems used for clinical trials today store their data in relational database software such as Oracle or Microsoft SQL Server. A relational database is composed of a set of rectangular data matrices called tables that relate or associate with one another by certain key fields. The language most often used to work with relational databases is structured query language (SQL). The SAS/ACCESS SQL Pass-Through Facility and the SAS/ACCESS LIBNAME engine are the two methods that SAS provides for extracting data from relational databases. 

Private Practice, Oracle Dermatology Clinic, Seoul,... 

---