Tag: SQL

Feed: Featured Blog Posts - Data Science Central. Author: sairam. Data Science has been coined everywhere, and everybody wants to express their views and thoughts on this subject even though they are a novice or lack adequate knowledge about data science! The idea that everyone can become a data scientist only by studying a few technological advances and solving any complicated problems cripples the world today.  Let us first understand the career perspectives of data science. Data science has three pillars: Business Expert - Data Analyst Technology Expert - Data Engineer Statistics & Algorithm - Data Scientist First, make it ... Read More

Feed: Featured Blog Posts - Data Science Central. Author: Sergey Lukyanchikov. InterSystems IRIS – the All-Purpose Universal Platform for Real-Time AI/ML Author: Sergey Lukyanchikov Challenges of real-time AI/ML computations We will start from the examples that we faced as Data Science practice at InterSystems: A “high-load” customer portal is integrated with an online recommendation system. The plan is to reconfigure promo campaigns at the level of the entire retail network (we will assume that instead of a “flat” promo campaign master there will be used a “segment-tactic” matrix). What will happen to the recommender mechanisms? What will happen to data ... Read More

Feed: Planet PostgreSQL. This diary-of-an-engineer post from our Citus open source engineering team was originally published on the Azure Postgres Blog. When working on the internals of Citus, an open source extension to Postgres that transforms Postgres into a distributed database, we often get to talk with customers that have interesting challenges you won’t find everywhere. Just a few months back, I encountered an analytics workload that was a really good fit for Citus. But we had one problem: the percentile calculations on their data (over 300 TB of data) could not meet their SLA of 30 seconds. To make ... Read More

Feed: Recent Announcements. If you are currently running SSRS on Amazon EC2, you can now save costs by running SSRS directly on the same RDS DB instance as your SQL Server database. SSRS is also already available on Amazon RDS for SQL Server 2017 on both the Standard and Enterprise editions. Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability ... Read More

Feed: Planet PostgreSQL. PL/Python can be a convenient and powerful way to take advantage of your PostgreSQL database. In an earlier post, I talked a little bit about how you can use modules included in the Python standard library with PL/Python functions. In this post, we'll try running NumPy in a simple user-defined function which also takes advantage of PL/Python database access functions. The function will show a working example of how to easily convert a data table in Postgres to a NumPy array ... Read More

Feed: AWS Big Data Blog. General Data Protection Regulation (GDPR) is an important aspect of today’s technology world, and processing data in compliance with GDPR is a necessity for those who implement solutions within the AWS public cloud. One article of GDPR is the “right to erasure” or “right to be forgotten” which may require you to implement a solution to delete specific users’ personal data.In the context of the AWS big data and analytics ecosystem, every architecture, regardless of the problem it targets, uses Amazon Simple Storage Service (Amazon S3) as the core storage service. Despite its versatility and ... Read More

Feed: Planet MySQL; Author: Aleks; When a table gets dropped, MySQL removes the respective .frm file. This post explains how to recover the table structure if the table was dropped. You need the table structure to recover a dropped table from the InnoDB tablespace. The B+tree structure of the InnoDB index doesn’t contain any information about field types. MySQL needs to know that in order to access records of the InnoDB table. Normally, MySQL gets the table structure from the .frm file. But when MySQL drops a table the respective frm file removed too. Fortunately, there’s one more place where ... Read More

Feed: R-bloggers. Author: Gary Hutson. Well, what can I say? It has been a blast over the past year and a half. In my time at the company I have managed to work on a number of fascinating projects, here is a list of just some of them:Data Science Platform – this has been the culmination of lots of machine learning projects, undertaken separately in R and Python, and has allowed for our Healthcare Data Science Platform to be developed. This, alongside skilled data scientists, data engineers and front end developers, we think we have developed something really specialClinical Outcome ... Read More

Feed: Recent Announcements. To use SQL Server native backup/restore, you specify the S3 bucket that you want to use for storing the backup files. Grant RDS access to this bucket by creating an AWS IAM role, then associate the IAM role with your RDS DB instance. Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability ... Read More

Feed: Planet MySQL; Author: Johannes Schlüter; Recently there was a question about which clients were connected to a server being asked in the MySQL Community Slack. The relevant information is available from performance schema, as most connectors will send information about themselves when connecting: select * from performance_schema.session_connect_attrs; +----------------+-----------------+------------------------+------------------+ | PROCESSLIST_ID | ATTR_NAME | ATTR_VALUE | ORDINAL_POSITION | +----------------+-----------------+------------------------+------------------+ | 130 | _pid | 17412 | 0 | | 130 | _platform | x86_64 | 1 | | 130 | _os | Linux-5.4.0 | 2 | | 130 | _source_host | maniacmansion | 3 | | 130 | _client_name ... Read More