|
|
|
|
|
|
|
|
|
|
|
|
|
Marie Buretta Inc. is a consulting and training firm specializing in:
The firm has developed a methodology for designing databases in a distributed environment which addresses maintaining integrity, performance, availability, and consistency across multiple sites. They specialize in implementing data replication solutions in heterogeneous database environments. This includes using replication alternatives to implement data warehousing solutions that incorporate both OLAP tools and traditional report generators. The firm also specializes in data warehouse implementations. They have aided their clients in successful tool selection for data extraction and transformations, and OLAP query/reporting. Their expertise spans both relational and multidimensional database engines. They concentrate in dimensional modeling. This process incorporates the business user perspective when identifying dimensionality, hierarchical structures, attributes, and measures. They have successfully translated these logical structures into physical database designs. The firm conducts training sessions on replication technologies, and multidimensional modeling techniques for use in designing databases for data warehousing. |
|
|
|
|
|
|
|
Marie Buretta, Inc. - The firm specializes in consulting services and training. Concentrating its efforts in data distribution and replication alternatives, OLAP implementations, client/server computing, and database technology. Headquarters -
Ownership - Privately held firm founded in 1992. |
|
|
|
|
|
Designing Applications and Databases for Efficient Use of Replication Course Description: Producing efficient database designs and applications in a client/server environment lowers network costs, improves transaction response time, increases data availability, and enables consistent and effective administrative support. This course presents the issues and instructs in the techniques necessary to make intelligent decisions regarding: the placement of both sharable and non-sharable data resources, the choosing between various replication alternatives for maintaining consistency across redundantly stored data, the selection of appropriate database designs and configurations, the approaches for integrating multiple replication alternatives, and the procedures for ensuring effective replication administration. Intended Audience: Application developers, network and data architects, and anyone interested in gaining knowledge of the issues involved in designing applications and databases for use in environments that use replication techniques to maintain data consistency. Prerequisites: General understanding of the client/server environment. Duration: 2 days. Format: Lecture and paper exercises. Course Objectives: At the completion of this course, the student will be able to say: I have a thorough understanding of the issues related to distributing data and maintaining its consistency. Given the business requirements, I feel that I can choose the most appropriate replication alternative. I can design efficient distributed applications and databases that use replication techniques effectively. Business Dimensional Modeling for OLAP Solutions Course Description: Building high performance databases for use with the new OLAP query tools presents many challenges. Designs must by flexible, scalable and provide for high availability which implies fast database loading and recalculation of summarized items. An efficient database design will also improve query response time, lower network costs when data is accessed remotely, and enable consistent and efficient administrative support. This course presents the issues and instructs in the techniques necessary to build efficient dimensional business models, and translate them into robust database designs. Intended Audience: Application developers, database administrators, data architects, and anyone interested in gaining knowledge of the issues involved in designing databases for use in OLAP environments. Prerequisites: General understanding of database design techniques, and client/server environments. Duration: 1 day. Format: Lecture and paper exercises. Course Objectives: At the completion of this course, the student will be able to say: I have a thorough understanding of the issues and tasks involved with creating a dimensional business model. Given the business requirements, I feel that I can apply the appropriate techniques to create an accurate dimensional model. I can convert a business dimensional model into a physical database with a full understanding of the design trade-offs. |
|
|
|
|
|
Data Replication - Tools and Techniques for Managing Distributed Information by Marie Buretta, ISBN - 0471157546 Today most business firms maintain multiple copies of redundant data i.e. replicated data. These redundant copies are used to improve data availability and application performance at remote sites, for decision support systems that remove query processing from on-line production systems, and for warm standby recovery alternatives. Maintaining and administering these copies is complex and resource intensive. Data Replication: Tools and Techniques for Managing Distributed Information is a step-by-step guide to implementing data replication solutions. It covers everything from technologies and terms to architectural approaches used by major vendors and application design templates. It provides guidance on selecting the correct set of replication tools and designing and building databases that work effectively with these tools. The key to successfully using replication is two fold. The first is to strategically distribute data thereby optimizing network and hardware resources, and administrative skills. The second is to standardize the use of replication software thereby building it into a service that will ensure maximum flexibility and scalability across the firm's heterogeneous environment. It is in these areas of judicious distribution of data and establishment of firmwide procedures for replication software use that organizations will meet their greatest challenges. While vendor supplied documentation adequately defines their product usage, it does not address these two key topics. This book presents a tactical approach for data distribution and a strategic approach for building an in-house replication service. Data Warehouse - Practical Advice from the Experts By Joyce Bischoff and Ted Alexander ISBN - 0135773709 Marie Buretta is one of twenty contributing authors. |
