Category: Datawarehousing

Feed: Actian. Author: Sean Hughes. If you’re headed to Gartner Catalyst 2017 in San Diego, CA August 21 – 24, or if this is your first time at a Gartner event, here’s your essential guide to get the most out of the upcoming conference. We hope you find it useful.This is a conference for technical professionals. You’ll have plenty of opportunities to meet with your peers across all disciplines including CIOs, CTOs, solution architects, developers, database admins, data scientists, data engineers, business analysts and devops, amongst others. Gartner has lined up a host of hot topics and session tracks, so ... Read More

Feed: MemSQL Blog. Author: Gene Miguel. We regularly host meetups at MemSQL headquarters as a way to share what we have been working on, connect with the community, and get in-person feedback from people like you. We also invite partners and customers to join us as well. Recently, we had the pleasure of hosting a meetup with Zoomdata, where we shared two presentations on real-time streaming, analytics, and visualization using MemSQL and Zoomdata. The first presentation “Streaming in the Enterprise with MemSQL” is presented by MemSQL engineer, Neil Dahlke. Neil builds analytical and operational tools for MemSQL and our customers ... Read More

Feed: MemSQL Blog. Author: Mike Mohler. Data today moves in extremely large volumes at light speed all while requiring high levels of protection on the content. Traditional database and data warehouse technologies are unable to handle these workloads without the need for expensive hardware appliances. The NoSQL and Hadoop-based systems are very complex and unable to support real-time analysis. A new way to process fast-moving, structured content is needed to achieve this level of scale and security. Why not a highly secure and extreme scalable SQL-based approach? Imagine the volume of telemetry data that is required for processing a swarm ... Read More

Feed: Actian. Author: Alex Sherwood. One important trend in database management is integrating location data better to improve insights about events and activities that matter to your business. …Interest in analyzing geospatial/location data has increased over the past four years from 26% to 36%.” Source: Gartner Survey Analysis: Big Data Investments Begin Tapering in 2016, September 2016 Tracking customer location can be critical for offering location-based services, particularly for travelers (think Uber matching cars to riders, or restaurants making offers to customers nearby) and for shoppers (to optimize shelf locations for popular items and perhaps make realtime offers).  Tracking and managing ... Read More

Feed: MemSQL Blog. Author: Seth Luersen. Experience teaches us that when loading data into a database, in whatever form ― normalized, denormalized, schema-less, hierarchical, key-value, document, etc ― the devil is always in the data load. For enterprise companies in the real-time economy, every second saved means improved efficiency, productivity, and profitability. Thankfully, MemSQL Cloud makes your enterprise data fast to load and easy to access. You can spin up a cluster in MemSQL Cloud in minutes and load data very quickly using MemSQL Pipelines. MemSQL scales out for fast parallel processing of very large data sets. MemSQL Pipelines deliver ... Read More

Feed: James Serra's Blog. Author: James Serra. Microsoft has released a preview of the Azure Analysis Services web designer.  This is a browser-based experience that will allow developers to start creating and managing Azure Analysis Services (AAS) semantic models quickly and easily.  SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) will still be the primary tools for development, but this new designer gives you another option for creating a new model or to do things such as adding a new measure to a development or production AAS model. A highly requested feature is that you can import ... Read More

Feed: MemSQL Blog. Author: Rodrigo Gomes. At MemSQL, we are out to build awesome software and we’re always trying to solve hard problems. A few days ago, I uncovered a cool Linux mystery with some colleagues and fixed it. We thought sharing that experience might benefit others. The scene of the crimeWhile developing an internal tool to get stack traces, we decided to use the SYS_tgkill Linux system call to send signals to specific threads. The tgkill syscall sends a signal to a specific thread based on its “thread group” identifier (tgid) and thread identifier (tid). We store the thread identifier ... Read More

Feed: MemSQL Blog. Author: Carl Sverre. One of the main themes at DockerCon 2017 was the challenge of migrating legacy applications to containers. At MemSQL, we’re early adopters. We are already into our third year of running Docker at scale in production for our distributed software testing regime, where the performance, isolation, and cost benefits of containers are very attractive. The Challenge Before I take you through our journey to containers, let me start by outlining some of the general challenges of testing a distributed database like MemSQL. Our solutions are built for real-time data warehousing. Databases are really difficult ... Read More

Feed: MemSQL Blog. Author: Rodrigo Gomes. At MemSQL, we are out to build awesome software and we’re always trying to solve hard problems. A few days ago, I uncovered a cool Linux mystery with some colleagues and fixed it. We thought sharing that experience might benefit others. The scene of the crimeWhile developing an internal tool to get stack traces, we decided to use the SYS_tgkill Linux system call to send signals to specific threads. The tgkill syscall sends a signal to a specific thread based on its “thread group” identifier (tgid) and thread identifier (tid). We store the thread identifier ... Read More

Feed: Actian. Author: Greg Coates. I am excited to share news of our most recent release of DataConnect 11.1. This release wraps up a significant phase in that it provides backwards compatible support for our customers who use EDI x12, HIPAA, and HL7 connectors and components. If you use Data Integrator version 9 to process those documents, you can now begin your upgrade to version 11!Some other enhancements, fixes, and improvements include: Standalone engine for AIX for on-premise deployments Multi-mode table selector to quickly create schemas and build maps to relational databases Samples repository project for out-of-the-box, working examples to ... Read More