Skip to main content
Article thumbnail
Location of Repository

Romancing Your Data: The Getting-to-Know-You Phase

By 

Abstract

The ability to gather and store large amounts of data has become commonplace. As these capabilities have grown, so has database complexity. The deluge of corporate acquisitions further complicates things, driving more undocumented data sources into the hands of new database users, often without the institutional knowledge to go with them. Thus, analysts must develop the ability to discover the complexity of a database on their own. This paper focuses on Oracle ® databases and use of SAS/ACCESS ® Interface to ORACLE to explore the Oracle Data Dictionary Views that contain the database metadata. We focus on metadata summaries of interest to a user new to the database. The metadata is presented through a series of programs that use Base SAS®, specifically the SQL Procedure, macro language, and the Output Delivery System (ODS). The target audience for this paper includes anyone who uses Oracle databases to solve business problems. Some basic understanding of Base SAS PROC SQL, macro language, and the SAS/ACCESS Interface to ORACLE product is helpful, but not required

Year: 2013
OAI identifier: oai:CiteSeerX.psu:10.1.1.353.4723
Provided by: CiteSeerX
Download PDF:
Sorry, we are unable to provide the full text but you may find it at the following location(s):
  • http://citeseerx.ist.psu.edu/v... (external link)
  • http://support.sas.com/resourc... (external link)
  • Suggested articles


    To submit an update or takedown request for this paper, please submit an Update/Correction/Removal Request.