Modeling in a single integrated environment of : Data models : Conceptual Model, using extended entity relationship formalism (constraint, functional dependancy, inheritance, relative identification, rules, ...), Relational Logical Model with automatic transformation from the CDM, taking in account the modeling choices. Processing models : Flow Diagram, Conceptual, Organizational and Logical Models, Objects life cycle. Models customization and hierarchical decomposition available (refining).

KeepTool v8.1.7.5 (NEW) | 50.61 MB

The KeepTool 8 family gathers together three Oracle productivity tools, each addressing a specific purpose and available separately. But each of the three products - Hora, ER Diagrammer und PL/SQL Debugger - is also designed to work with the other two, and shares a common design philosophy. Our goal is to make our products easy and intuitive to use. KeepTool 8 is updated many times each year to enhance its existing functionality and to incorporate new features of the Oracle database.

Hora
Hora is KeepTool's flagship product for viewing and manipulating Oracle databases, and accommodates a variety of users. Primarily designed for both DBA's and developers, it can also help end users query data and generate simple reports. Thanks to its intuitive interface and the ability to preview SQL before execution, Hora does not require that you read the manual before using it.
Its object-oriented navigation system takes you to any database function within a few clicks.
Hora is compact. Everything you need to work with the database is in a single tool. Start-up time and resource usage are minimal.

DeZign for Databases is an intuitive database design tool for developers and DBA's that can help you model, create and maintain databases. DeZign for Databases uses entity relationship diagrams (ERDs) to graphically design databases and automatically generates the most popular SQL and desktop databases. DeZign for Databases offers a intuitive visual interface that allows you to accurately design your database. It uses entity relationship diagrams (ERDs) to graphically design databases and produces high quality database diagrams, enabling you to present your design at various levels of detail.

Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things work—and others don't.

Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what you can expect the results to look like. Throughout the book, critical features of Excel are highlighted, interesting uses of Excel graphics are explained, and dataflows and graphical representations of data processing are used to illustrate how SQL works.
Data Analysis Using SQL and Excel shares hints, warnings, and technical asides about Excel, SQL, and data analysis/mining.