Capítulo 1. Introducción
Power*Architect from SQL Power Group is a visual data modeling tool designed for data architects, DBAs, analysts, designers, and other professionals. Quickly design every aspect of your data model using diagrams and a hierarchical view of your model structure. Your data model remains platform-independent, allowing you to maintain a single database schema that works well with multiple database platforms.
Power*Architect is also well-suited to data warehouse and data mart design. You can open multiple source databases concurrently, then drag and drop objects (such as schemas, tables, and columns) into Power*Architect's data modeling playpen to create a new model. After fine-tuning the data model in the playpen, you can forward engineer the data model into new database on platforms such as Oracle, SQL Server, DB2, PostgreSQL, or MySQL. Power*Architect also creates ETL (Extract, Transform, Load) procedures you can use with Pentaho's popular open source Kettle ETL tool to populate the new database.
Power*Architect provides you with a variety of tools to view and compare data structures and mappings.
For example, you can compare the structure of any two databases, highlighting the differences and similarities and generating the required DDL statements to synchronize them. You can also create a visual mapping report listing the source tables used in your data model, or create an easy-to-read profile summarizing the data contained in a database.
Whether you're building or maintaining a data model, Power*Architect provides the tools to help you design your model in a fraction of the time.
The Power*Architect User Guide provides step-by-step instructions for using Power*Architect and covers all of Power*Architect's features and capabilities.
The guide assumes you are familiar with basic database operations and terminology (please refer to Chapter 12, Glossary for a list of some common database terms). If you plan to use Kettle jobs, the guide assumes you have some knowledge about ETL (Extract, Transform, Load) procedures. If you are looking for more information about ETL, two books you may want to try are Building the Data Warehouse by W. H. Inmon and The Data Warehouse Toolkit: The Complete Dimensional Modeling by Ralph Kimball and Margy Ross.
Power*Architect is free and open source software, meaning that the source code is readily available.
Everyone is free to inspect, comment on, and modify Power*Architect's source code. Anyone who
modifies the program code is invited (but not required) to contribute their changes back to the project.
All contributions are subject to review and acceptance by the Power*Architect team. We always welcome
suggestions from Power*Architect users, in the spirit of making the application easier to use and providing
the features that matter the most to you.
Power*Architect is distributed to the public under the New BSD License. There is a large body of software
already available under this license, so its terms are already well understood.
Copyright (c) 2008, SQL Power Group Inc. All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
• Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
• Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
• Neither the name of SQL Power Group Inc. nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS;
OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR
OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.