Data Modeling & Architecture

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 ...
7 Dangerous Myths DBAs Believe about Data Modeling   How much does your DBA really know about data modeling? Data modeling can simplify routine tasks and provide valuable context for a database implementation – every data architect knows this. However, DBAs often have some preconceived notions of what they think data modeling can (or can’t) do for them, such as generating useful DDL code. Data professionals need to work together with DBAs to improve awareness and ensure data modeling stays r...
Data is the new Bacon!!! And Data Modeling is even cooler!  Yes, you read that right! Data is indeed The new Bacon!! We have been hearing about it all over the place.   So Rich in Information and still if done right cooked to Perfection! With Embarcadero's leading Data Modeling and Management tools! We know our audience! and have been doing this for decades! With the newest kid on the block of our enterprise offerings,  check out ER/Studio Enterprise Team Edition. ER/Studio Enterprise Team edition provides the fastest, easiest, and m...