2010/10 - database architechs presentation
DESCRIPTION
Top database experts wide range of database focused services offeringsTRANSCRIPT
DATAbase ArchiTECHS
“Data Architecture for the Future”
October, 2010
Data Services
Consulting Focus Architecture/Database Consulting:
• Website Architecture
• Cloud/Virtual Enterprise Architecture
• Mobile Applications Architecture/Development
• Database Architecture
• Database Design
• Data Modeling & Data Analysis
• Database & SQL Performance & Tuning
• Distributed Data & Data Replication
• Data Integration & Transformation
• Data Warehouse & Business Intelligence
• Database High Availability
• Master Data Management
• Metadata Management
• Disaster Recovery & Business Continuity
• Database Security & Compliance
• Database Education & Training
• Database Performance & Tuning tools
High Availability Consulting:• HA Assessments• HA Design/Architecture• HA Build-outs• Mirroring, Snapshots …
Enterprise Architecture: • EA Tools• EA Organization, Roles and
Responsibilities• Architecture
Education and Training:• SQL training• Data Modeling• Performance & Tuning training• Data Replication training• Physical Database Design• Multi-dimensional OLAP• Process Modeling
Our services are database focused and include inexpensive 4-day assessments moving you down the path to:
• Reducing your overall costs.
• Achieving high availability and scalability.
• Meeting or exceeding your service level requirements.
• Allowing you to put off server and storage purchase because of better utilization of what you have.
• Enabling server and database consolidations.
• Using our data expertise surgically for short bursts with highly skilled and experienced data professionals.
• Optimally designing and architecting your data to meet your company's needs
Packaged Services
All of these Authors are Consultants at Database Architechs
Methodology Oriented“Data by Design”
Elaboration
Initial assessment- Project Planning- Project Sizing- Deliverables Identified- Schedules/milestones- High-Level Data needs
Requirements- Detail Requirements - Data details identified- Dirty data/cleansing
requirements- data integration identified
High-level Requirements/Prototyping- High-level requirements - Prototyping- Designs/integrations
Design- Detail DB/Architecture Designs- Data Integration designs/architecture
Early Code & Test- Early code and testing of integration/DB- Heavy use of Data prototypes/profiling
Code & Test- Code Dev/Unit Testing- Database Coding- Database Testing
System Test-Acceptance- Full Test/User Acceptance- Full Integration/ Verification/Acceptance
Implementation- Production Build/Implementation
Inception
Construction
Transition
Paul [email protected]• Database Architechs Founder and Advisor:
• Database Design• Performance & Tuning for MS SQL Server,
Sybase, DB2 and Oracle.• Data design expert with Dr. Peter Chen• Primary Author of SQL Server 2000, 2005 &
2008 Unleashed• Co-Author of ADO.NET in 24 hours• Author MS SQL Server High Availability• Author Sybase Performance & Tuning• Author Sybase Physical Database Design• Veritas SQL Server Performance Series
Thierry [email protected]
• Managing Principal & Co-owner:• Management • Research and Development• Database Design• Performance & Tuning for MS SQL Server, Sybase
and Oracle• European focus until recently, company
growth leader – multiple years• Expanding Database Architechs consulting
practices to USA and Asia• Sybase Performance & Tuning and DBA
Certified Professional• Contributor to SQL Server 2005 Unleashed
Database Architechs’ Principals
The experts of Database Architechs, based in Europe and USA (Nation wide), are offering you a range of services from Web to Cloud integration.
Website Architecture and DevelopmentDatabase Architechs has developed numerous websites: corporate, e-commerce, entertainment, luxury, press, education, job board... As a leading consulting firm, we choose the best and cost effective solutions to meet your business needs.
We design Business Architecture for the future – Website
We design Business Architecture for the future – Cloud
Cloud computing and SaaS allow to build a virtual and agile enterprise. Database Architechs helps you to take benefit of these technologies to improve your business and reduce your costs.
Cloud Computing/Virtual Enterprise Architecture
We design Business Architecture for the future – Mobile
Our world is mobile and Database Architechs helps you bringing your ideas into mobile devices. We develop rich content applications for iPhone and now for iPad
iPhone/iPad Mobile application Architecture and Development
We design Business Architecture for the future – Business Intelligence
BI is often described as "one version of the truth". At Database Architechs we focus our expertise on your Business needs and deliver you the right data at the right place and the right time.
Business Intelligence/Data Warehouse Architecture and Implementation
Using most major DBMS offerings from Microsoft, Oracle, IBM, Columnar DB, NoSQL Databases and others.
• Snow-flake• Star-schema• Multi-dimensional• OLAP cubes
Data Warehouse &Business Intelligence
Database Architecture
Complete or subset data architecture creation for current and the future (strategic) data architectures of any complexity.
Our data architects have done this for multi-billion dollar companies such as Symantec, Veritas, SGI, and others.
Database DesignOptimized database design and implementation of large and small, simple and complex database systems using:• DB2• Oracle• Microsoft SQL Server• Sybase• MySQL• Informix• PostgreSQL • Massively parallel database
architectures such as ParAccel, Green Plum, Netezza, and others
Working with the top database designers in the world.
Data Modeling & Data Analysis
Capturing even the most complex data requirements into well defined and robust data models coupled with full data analysis and validation of all objects/entities.
A few of our data modelers apprenticed under the originator of data modeling (Dr. Peter Chen – father of entity/relationship modeling).
Database & SQLPerformance & Tuning
Industry leading performance and tuning tools coupled with the deepest Performance and Tuning experts on most major database platforms. • Database tuning• Indexing strategies• Physical Database Design• SQL performance
Our experts excel in multi-site distributed solutions and design using various technology solutions from replication, to mirroring, to log shipping.
Mitigating architectures and load balancing.
Distributed Data & Data Replication
Database Consolidation
Using a proven step-by-step methodology, helping in:• Leveraging your existing IT architecture and investments. • Reengineering, Consolidating, and redesigning your data architecture to
better use what you have. • Optimizing your entire database layer for performance, stability, and
availability. • Reducing your IT expenses and putting off those planned server and
storage purchases. • Focusing on enabling you to better serve your internal and external
customers.
Database Consolidation
Decades of ETL, EAI and other data integration solutions for:• Data migration• Data warehouse• Data marts• Data synchronization requirements
Data Integration & Transformation
Five-9’s at the database tier via many different solutions, architectures, and technologies. Our consultants live by the mantra of “continuous uptime”.
We feature a high availability “assessment” for anyone serious about High Availability.
Database High Availability
Core data categories such as customer data and product data comprise the cornerstone of this practice offering.
A specialized MDM methodology geared towards an optimal MDM architecture and
solution is embodied in our delivery model for MDM. Often taking advantage of hub
and spoke architectures to enable MDM for major organizations.
Master Data Management
One of the forgotten elements of good data management is Metadata Management. Our consultants can help to implement a robust metadata repository and management framework to help you with:• Impact analysis • eDiscovery• Compliance• Data integrity• and data quality across your IT landscape
Metadata Management
Full Disaster Recovery and Business Continuity assessment and solution design for any companies’ disaster recovery/business continuity goals.
Fully automated/active-active patterns form the popular approaches we often recommend to customers.
Disaster Recovery &Business Continuity
Meeting global security and compliance regulations such as PII, PCI, SOX … and others are at the heart of this offering.
Creating the most secure framework and solutions will vary according to your needs and your industry requirements.
Database Security & Compliance
Database Architechs has proven its ability to optimize projects and to deliver programs and results that exceed customers’ expectations.
We bridge the gap between business needs and technology capabilities.
We are also known for being able to build excellent relationships at all levels of a company, from the CEO to the staff.
We make your company’s initiatives a success as we know how Project Management Organizations (PMO’s) and Project Management methodology work.
All of our project managers are PMI-certified.
Project Management
Our technical teams possess a deep understanding of current and emerging technology issues and have proven their ability to provide a cost-effective and timely delivery while maintaining the highest quality standards of the industry.
We are defining test cases and test criteria for Quality Assurance and validate if every project’s components before going production.
Quality, Tests &Validation
Offer several time tested and exciting database courses such as:• Multi-dimensional
database design• SQL Programming• Logical Data Modeling and
Database design• Performance and Tuning• Data Replication• Master Data Management
ramp up
Database Education & Training
Using our Perf. & Tuning Tools and a proven methodology, we are extending our database-focused services:• Available through a secured connection• Top database experts available as needed using a pool of hours
Remote Services
• Remote Physical Database Design:We have designed and deployed all kinds of systems, from OLTP databases to Decision support systems (Data warehouse, Business Intelligence and OLAP cube technologies). Our intervention quite often involves using advanced techniques such as data replication, clustering, and database mirroring.
• Remote Performance and Tuning:As part of any Performance & Tuning engagement, we use a detailed performance and tuning methodology that has been developed over many years to offer predefined deliverables that maximize the end-result of our customers.Typically, our results include an improvement in database throughput ranging from 100% to 750% as well as a massive reduction in response times.
for: Sybase ASE 11.5 to 15.5 Oracle 8i to 11g Microsoft SQL Server 2005 to 2008 R2
Strengths:• Designed and developed by the top Database experts.
• Highly “Graphic-Oriented” interactive design – drill-down through the graphs!
• Easily isolate performance issues in seconds.
• Optimization strategies can be implemented and verified.
• Safe “production” monitoring in real time.
• Performance counters utilized include OS level.
• Plug-and-play - no change to your IT architecture.
• Monitor, Isolate, Drill-down approach.
• Also runs in off-line mode with easy data export.
• Track Record – 10 years of SQL and Database performance and tuning tools.
Database Performance Monitoring Tool
Video Demonstration
Clients’ TestimonialsWe are using Database Architechs' Performance and Tuning tools in all our production and test environments. Thanks to these tools we can anticipate and fix any performance issues. Isolating and fixing performance issues is now 16 times faster (down from 2 days to 1 hour). We can also log all the database performance metrics and information to isolate any past performance issue and produce some monthly reports on specific metrics. In addition, Database Architechs Performance and Tuning tools are helping us in identifying users' behavior, anticipating the required tuning to optimize response time.
We are using Database Architechs' Performance and Tuning tools for the following: 1) Monitor applications' response time before moving to production. 2) Isolate poor performing SQL queries, stored procedures, triggers ... on production databases. Thanks to Database Architechs' Performance and Tuning tools we've been able to improve SQL queries performances from few minutes to few seconds. Database Architechs' Performance and Tuning tools has also helped us to isolate performance issues during our database migration process.
I'm using Database Architechs' Performance and Tuning tools since several years. I appreciate very much these tools for real-time database server monitoring. I appreciate particularly: - The GUI, to visualize and isolate any performance issue in seconds. - How easy and fast it is, to install the tools and start monitoring any database server. - The logging feature, to analyze past performance issues. - The batch mode, to log performance metrics automatically based on events.
Database PerformanceMonitoring Tools Download
Database Architechs’ new Website
www.dbarchitechs.com
Leveraging our database expertise our new Website includes:• Table-driven contents allowing
dynamic and real-time updates
• A full and automatic workflow for our Performance &Tuning Tools allowing to:
• Download the product
• Request and get in few minutes a free-trial license key
• Buy and get in few minutes a license key
• Manage technical support requests
Experience:• USA (20 years) • France (12 years)
Database/Data Architecture:• Sybase• Oracle• Microsoft SQL Server• DB2, PostgreSQL, MySQL, and others …
Database talent pool:• Top database experts from around the globe• Acclaimed Authors• Speakers to many events and conferences
Database Tools: • Performance & Tuning Tools - Highly graphical (Sybase, Oracle and MS SQL
Server)
Database Education & Training
Operations
Revenue per Service Lines
Architecture/Design31%
Design/Develop-
ment10%
Database Consolidation11%
Training0%
DBA0%
Perf. & Tuning16%
Business Intelligence31%
Architecture/Design
Design/Development
Database Consolidation
Training
DBA
Perf. & Tuning
Business Intelligence
Database Architechs global consulting team has delivered hundreds of high scale, high impact database, data architecture, high availability and performance and tuning engagements.
Our strengths are:
• Database Design and Data Analysis/Modeling
• Distributed Data Architectures/Data Replication
• Database Encryption/Security Frameworks
• High Availability, Disaster Recovery/Business Continuity
• Database and SQL Performance & Tuning
• Data Standards and Governance
• Delivery on time and within budget
• Extreme Quality of deliverables
• Knowledge Transfer and Education
Strengths
Data Management Association – SF, Dec 16
PASS Summit 2009 – Seattle, Nov 2-5
Oracle Open World – SF, Oct 11-15
MDM Summit – San Francisco, Aug 24-26
MS SQLSUG – San Diego, Aug 20
SQL Saturday – Portland, Jun 6MS SQL Server 2008 Migration WS – SF, Apr 29
MS SQLS UG – Portland, Apr 23
MS SQLS UG – Silicon Valley, Feb 17
MS SQLS UG – SF, Feb 11
PASS Summit 2010 – Seattle, Nov 2-5
MS SQLS UG – Silicon Valley, Oct 19
SQL Server 2008 R2 Unleashed – Sept 10
Events
Data Management Professionals – Santa Clara, Oct 21
Healthcare• AGIS Network• Breg International• Actelion
Finance• Visa International• Bank of America• Charles Schwab• Merrill Lynch• Wells Fargo
Insurance• CSAA
Education• Alliance Francaise• Aplia• Thomson Learning
Retail• Safeway Stores
And many others around the world …
High Tech Industry• Apple Computers• Applied Materials• Cisco• Intel• Juniper Networks• Metalinc• Silicon Graphics• Sybase• Symantec Corporation• Toshiba Computers• Veritas
Automotive Industry• Nissan Motors• Honda Motors
Others• Diligent Board Member• Federal Express• France Amerique• PG&E• Robert Half
Clients
Services Partners• Fusion Storm
• Samsung Services
• Ascent Services Group
• Computer Science Corporation (CSC)
• Cap Gemini Ernst & Young (CGEY)
• i2 Technologies
• Collaborative Consulting (Boston)
Joint Proposals, as a named sub, and as augmentation
High Tech Partners• Diginome
• HP / Mercury
• Microsoft
• ParAccel
• Solid Data
• Sybase
Partners
Overall send rate 41 % faster (2005 vs. 2008)Overall restore rate 52% faster (2005 vs. 2008)
Overall availability topology inherits the restore rate ~ 50% more available
Example:• 743 ms Transaction (in 2005 mirroring configuration)• 379 ms Transaction (in 2008 mirroring configuration)
In failover, what would have been 20 seconds before mirror becomes principal turns into roughly
8-10 seconds (or 3 seconds turns into 1.5 seconds, so on).
Database Mirroring BenchmarkSQL Server 2005 vs. 2008
Overall send rate 26 % faster (2008 Conventional versus SSD)
Overall restore rate 17% faster (2008 Conventional versus SSD)
Overall Database mirroring topology garners ~ 20% more availability
Examples:
10 min 17 seconds to complete
• 4:32:37am 4:43:00am (principal send’s)
• 4:32:48 am 4:43:05am (mirror restore’s)
8 min 38 seconds to complete
• 3:45:19am 3:53:20am (principal send’s)
• 3:45:20am 3:53:20am (mirror restore’s)
100% Transparent (zero DB & Application changes) !
Solid State Devices Benchmark
Feel free to ask questions
Thank you for your time and participation
To contact us : [email protected]