Database

Posted by on in Data Modeling & Architecture
The Data Model Scorecard Steve Hoberman is a presenter, consultant, and the author of seven books on data modeling, including the bestseller Data Modeling Made Simple. One of Steve's frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique. Steve has just published the Data Model Scorecard book, which helps data professionals apply a scoring standard against their data models in order to assess their quality. This scoring tool contains ten categories aimed at impr...

Posted by on in Data Modeling & Architecture
Metadata Market Study Report   Recently, the Competence Center Corporate Data Quality (CC CDQ, a European consortium research program) engaged with Fraunhofer Institute for Material Flow and Logistics to produce a new Market Study report called METADATA MANAGEMENT TOOLS FOR ENTERPRISE DATA MANAGEMENT. This extensive market study describes the role of data management in today’s enterprise and provides a broad overview of over 30 software solutions available, including Embarcadero’s ER/Studio XE7. Embarcadero is honore...
Setting up Oracle for Embarcadero ER/Studio - Part 2 Howdy! Welcome to the next installment of the series. In today's series, we will explore the options for Oracle Client Setup needed for ER/Studio.  Install the clients needed for your environments. Reboot after installation.  [Verifying Environment Variables] 1) Navigate to the Environment Variables Path.  For more information on how to do it, check this article. http://www.computerhope.com/issues/ch000549.htm  Navigate to the PATH variable section and make sure that ...
Setting up Oracle for Embarcadero ER/Studio - Part 1 In this blog post, I will be covering how easy it is for one to setup Oracle, in order to successfully work with Embarcadero's leading Enterprise Data Modeling Tool, ER/Studio. [Pre-requisites] Oracle Database 32 / 64 bit Server Edition ER/Studio Data Architect 32 / bit  DBMS Client versions for the necessary ER/Studio product installed (if on a separate machine) You may download the above software from the following location http://www.oracle.com/technetwork/database/enterprise-e...
Data Modeling Tip for DBAs - by John Sterrett Database Administrators (DBAs) are given so many different tasks from creating maintenance plans, upgrading databases, fighting performance problems, and more. With so many tasks to be completed, some tasks tend to not get the attention to detail they deserve.  Commonly, I see DBAs making multiple mistakes with table design and data modeling.  Today, I am going to quickly show you an example where poor data modeling can directly impact your application’s performance. We are going to ...

Check out more tips and tricks in this development video: