Database Consulting

What are Data Clusters and What Can They do For You?

By | Azure, SQL Server
Learning to effectively manage large datasets is key to optimizing your data analytics. Using data clusters can help optimize your data management. It involves grouping data points with similar characteristics into the same cluster to speed up processing time and improve analysis. Consider starting an analysis project on customer spending habits by gender in different regions. Your time on the project would be maximized if you’re able to use statistical techniques to automatically organize the data into logical groups prior to analyzing. How do data clusters work? Data clustering allows you to partition large volumes of structured and unstructured data/observations into logical groupings. One way it does this is by analyzing all of the data in the data warehouse and comparing each data point with clusters created. You rely upon the clustering algorithms to sort and cluster the data in a logical way. In a perfect world, all data points in the same group should be highly similar in nature, while data points in different groups should be dissimilar. There are several different models and algorithms that guide the clustering process. Here are a few: Hierarchical Method: This method creates separate successive clusters using specific criteria. Partitioning Method: This method (more…)

SAP ASE Edge Edition

By | Preserved Content Pages | No Comments
This might be the biggest announcement from SAP you never heard of. After dropping the name Sybase from its product names last year, SAP is quietly reshaping its database platform offerings. And I mean this in a good way. Under the Sybase name there were 2 ASE products; Sybase ASE Enterprise Edition (EE) and Sybase ASE Small Business Edition (SBE). The Sybase ASE EE product was and still is the flagship and the most commonly known edition of Sybase. But it came with a hefty price ticket. To offer a Sybase ASE database server to the SMB market space, Sybase created ASE SBE, limited to 2 CPU sockets and 8 engines on a physical server, at a very low price. The server virtualization revolution has dramatically changed the server landscape and database servers made their transitions to the new world. The majority of newly deployed database servers are virtualized, either on premise or in the cloud. The Sybase ASE EE 15.7 database server enabled Sybase clients to make the move to the virtual servers with the introduction of the threaded kernel model. SAP ASE EE 16 continued the optimization for virtual servers and offers one of the most advanced database (more…)

New Articles Published

By | Company News, Sybase | No Comments

It’s been a while since I last wrote in my blog. Luckily Google does its magic and still sends visitors to my blog.

This post will be very brief. Recently I was contacted by Sybase to write a couple of articles exclusively for Sybase. I agreed to this and that’s another reason why my blog got neglected.

Read More