Database Architecture
4Points' database architects will take a customer's data and processing requirements and turn them into optimized physical database designs and/or data warehouses/data marts. This includes various OLAP technologies from several different vendors. Our experts can deal with single site designs or complex distributed data designs and usually includes complete database backup/recovery strategies along with scalability/growth factors. 4Points utilizes a formal database design methodology that has been developed over many years. Most of our database consultants are certified on one or more database platforms and our experts are also noted authors and mentors in the database arena including:
4 Author of Sybase's Performance and Tuning course
4 Author of Sybase's Physical Database Design course
4 Author of Dr. Peter Chen's Logical Data Modeling & Database Design course
4 Author of the popular book series "SQL Server 2000 Unleashed"
4 Author of "ADO.NET in 24Hours"
In addition, 4Points Technologies does database design reviews, database conversions & migrations (from one dbms to another), database re-engineering and data integrity & data cleansing projects. All of our consultants are experienced in both J2EE and .NET framework essentials.
Our data replication offering has matured rapidly after many successful complex,world-wide data replication implementations for various fortune 500 companies such as Intel Corporation, Applied Materials and JDS Uniphase. Our expertise covers Microsoft SQL Server, Sybase SQL Server, and Oracle data replication techniques. Our data replication specialists can take a customer's data and processing requirements and turn them into optimized data replication scenario's that will best fit the customer's needs. These are typically multi-site, multi-continent implementations. These solutions will also include complete data recovery and backup procedures. 4 Points utilizes a formal data design methodology that has been enhanced to cover all data replication characteristics needed to make the best design decisions.
Typical Project: 1 week - 4 months depending on complexity
Estimated Team: 1-3 member teams.
4 Physical Database Design specialist/architect
4 Logical Data Modeler/designer (when needed)
4 Data Base Engineer/Analyst

