Analytics Platform System

The Analytics Platform System (APS) evolved from what was once known as the SQL Server Parallel Data Warehouse (PDW). APS was developed to function within the data centers of businesses, acting as a robust repository for large data sets.

APS’s transition from PDW reflects a broader transformation within the field of data warehousing—from a basic storage system to a crucial component of business strategy. The system was conceived not just to store massive amounts of information but to provide meaningful analysis and insights from that data.

One notable aspect of APS was its integration with Microsoft’s suite of business intelligence tools. This was more than just a superficial compatibility; APS was designed to work closely with these tools, tapping into advanced reporting and data visualization capabilities. This feature was pivotal because it allowed businesses to process and interpret their data more effectively, creating detailed reports and graphs that could inform better decision-making.

The power of APS lay not just in data storage but in its capacity to help users understand and communicate the significance of that data. It was about finding patterns, translating numbers into narratives, and making the complex understandable. For those who already used Microsoft’s intelligence tools, the move to APS was relatively smooth, keeping the transition period short and reducing the time needed to train on a new system.

APS was more than a data warehouse; it was a sophisticated tool for data analysis. While its capabilities were significant, the intention was never to dazzle with complexity but rather to offer a reliable platform for data management and analysis.

The legacy of APS lay in its contribution to organizational intelligence strategies—its real value came from how it helped businesses navigate and utilize their data, turning it into a resource for innovation, strategic planning, and leadership.

Amazon RDS

data types we support

Integral
bigint
integer
smallint
decimal
decimal (dec, numeric, fixed)
double (float, double precision)
real (decfloat)
text
char (character)
clob (long varchar, character large object)
nchar (national character)
nclob (dbclob, national character large object)
nvarchar (national character varying)
varchar (longvar, vargraphic, vargraph, varg, longvarg, character varying)
Binary
binary (graphic)
varbinary (varbin, binary varying)
Date/Time
date
time
timestamp (timestmp)
timestz
Large objects
blob (binary large object)
clob (long varchar, character large object)
nclob (dbclob, national character large object)
xml
Other
boolean
uniqueidentifier