Data Warehousing Articles
Shortly after the explosion of non-relational databases, around 2009, it became apparent that rather than being part of the problem, SQL would instead continue to be part of the solution. If the new wave of database systems excluded the vast population of SQL-literate professionals, then their uptake in the business world would be impeded. Furthermore, a whole generation of business intelligence tools use SQL as the common way of translating user information requests into database queries. Nowhere was the drive toward SQL adoption more clear than in the case of Hadoop.
Posted September 23, 2015
MapR Technologies, Inc., a provider of a distribution for Apache Hadoop, has extended its support for SAS, a provider of business analytics software and services. According to the vendors, the collaboration between SAS and MapR provides advanced analytics with ease of data preparation and integration with legacy systems, assurance of SLAs, and security and data governance compliance. Additionally, joint customers can cost-effectively grow their big data storage infrastructure without relying on storage area network (SAN) or network-attached storage (NAS).
Posted September 22, 2015
Whenever I get into a discussion about database standards I invariably bring up one of my favorite quotes on the topic: "The best thing about standards is that there are so many to choose from." It shouldn't be true, but it is.
Posted September 15, 2015
Data modelers face a choice when encountering multiple variations of a data item. Designers must focus on the longer term appropriateness of their decisions when choosing how their designs will play out; and going vertical or horizontal does have an impact over time.
Posted September 09, 2015
Birst, a provider of cloud BI and analytics software, has introduced a new technology it calls "Networked BI" to enable global governance with local execution. According to Birst, the new approach furthers its vision of trusted and agile collaboration between both centralized and decentralized teams.
Posted September 08, 2015
With the release of Oracle Cloud Platform 2015 and new Oracle Cloud Platform Services, things are clouding up across the Oracle landscape—but in a positive way. Larry Ellison, chairman and chief technology officer for Oracle, has made it clear in pronouncements that Oracle is in the cloud to stay.
Posted September 02, 2015
Magnitude Software, a provider of enterprise information management solutions, is introducing new additions to its technology suite designed to assist users in making informed business decisions faster and easier. The release of its Kalido Information Engine 9.1 SP2 makes a variety of advancements in data warehouse automation capabilities including increasing automation that accelerates the migration process and reduces overhead tasks when moving from development to production.
Posted September 01, 2015
Unless you've been living under a rock, you've heard Microsoft has introduced the initial release of Windows 10. Windows 10 has been a widely anticipated release on the part of consumers and business alike, with Microsoft aiming to deploy Windows 10 on more than one billion devices within the next few years. Here are 10 technical and market reasons why Windows 10 will become Microsoft's biggest release ever.
Posted August 26, 2015
The Independent Oracle Users Group is headed to San Francisco this October to join the Oracle technology community at Oracle OpenWorld 2015. Representing the voice of Oracle technology professionals, IOUG members will present more than 35 sessions on critical Oracle technology topics, including big data, cloud, Oracle Enterprise Manager 12c, and more. There is a lot to discuss with the Oracle database and technology community, and I am looking forward to connecting with Oracle professionals with similar interests to address challenges and solutions face-to-face.
Posted August 19, 2015
Data integration software provider Informatica has been acquired by a company controlled by the Permira funds and Canada Pension Plan Investment Board (CPPIB). Microsoft Corporation and Salesforce Ventures, Salesforce's corporate investment group, are also strategic investors in the company alongside the Permira funds and CPPIB. In making the announcement, Informatica said the new ownership would allow it continue to grow while taking a longer view rather than focusing on quarters.
Posted August 11, 2015
Google, whose name became synonymous with internet search, is reorganizing to maintain its innovation and competitiveness. The company is creating a new public holding company called Alphabet, with Google as well as other companies, housed within the new structure. According to Larry Page, CEO of Google, the reorganization is part of an effort to avoid getting "too comfortable," observing in a blog post that in the tech industry, "where revolutionary ideas drive the next big growth areas, you need to be a bit uncomfortable to stay relevant.
Posted August 11, 2015
Let's rephrase the question above: The next ticking time bomb is your database. Regardless of whether you run Oracle, Microsoft SQL Server, or MySQL, the odds lean toward your organization having a ticking time bomb. The only question to be posed is whether you are going to become collateral damage or diffuse the bomb before the damage happens.
Posted August 10, 2015
Addressing the need for more big data skills training, Apache Hadoop distribution provider MapR Technologies has announced availability of a complete Apache HBase design and development curriculum on its free Hadoop On-Demand Training program.
Posted August 06, 2015
Connect with Quest at Oracle OpenWorld, Oct. 25-29, 2015, and learn more about how you could get the answers and solutions you need to solve ERP challenges facing your business. At OpenWorld, you will have many opportunities to connect with the Quest team; from breakout sessions to SIG meetings to various networking opportunities, you'll be able to discover how Quest members leverage the community to achieve a higher satisfaction with their ERP.
Posted August 05, 2015
Each year during Oracle OpenWorld, OAUG Geos and SIGs present more than 50 sessions on Sunday. The user-led SIG sessions feature users and expert consultants sharing their firsthand knowledge and problem-solving tips and suggestions on a range of topics including EBS, Hyperion EPM, OBIEE, BI, and more. In addition, many Geos host Sunday sessions that offer attendees the opportunity to meet peers from their local community.
Posted August 05, 2015
Hortonworks, which provides and enterprise distribution of Hadoop, has signed a reseller agreement with EMC, to become a Select partner in EMC's Technology Connect Partner Program.
Posted August 04, 2015
The Oracle Applications Users Group (OAUG) will present the Best of COLLABORATE 15 - OAUG Forum eLearning series, which includes 40 live interactive webinars offered during a three-week period from Monday, August 10, to Friday, August 28, 2015.
Posted July 28, 2015
Attunity CloudBeam for Azure SQL Data Warehouse, a new cloud solution from Attunity, enables automated and optimized data loading from enterprise databases into the Azure SQL Data Warehouse. The new offering will simplify and accelerate data loading from enterprise databases, making it easier for customers to adopt the new Microsoft data warehouse service and benefit from big data analytics, according to Itamar Ankorion, executive vice president of business development and corporate strategy at Attunity.
Posted July 22, 2015
MicroStrategy is releasing a cloud solution that will combine all the capabilities of the MicroStrategy 10 Platform, plus data integration, validation, warehousing services, and application management support.
Posted July 21, 2015
No matter what the causes, a series of unfortunate events added up to a lot of bad news for data security and availability during one week in early July. In addition to an outage at the New York Stock Exchange, IT issues resulted in the grounding of United Airlines planes for 2 hours on the same day, and new revelations surfaced about a data breach at the U.S. Office of Personnel Management.
Posted July 21, 2015
Responding to a growing need to deliver more data to the right people at the right time, Cloudera and Teradata have announced the Teradata Appliance for Hadoop with Cloudera—the enterprise-ready Hadoop distribution.
Posted July 09, 2015
What matters most in data management in 2015? There are a lot of moving parts that data managers and professionals need to attend to in today's enterprises. Databases need to be wide open and accessible to all parts of the business, but at the same time, secure and free of tampering. Unstructured forms of data—such as log data, documents, graphics, video, and social data—need to be prepared and ready for analysis in the same way structured files have been ready for years.
Posted June 25, 2015
Syncsort is partnering with Dell and Cloudera to release a joint solution that will help enterprises reduce costs and improve business analytics. The partnership will create a Dell-Syncsort architecture that will combine Syncsort's Hadoop extract-transform-load tool, DMX-h, with Cloudera's Enterprise Data Hub, enabling customers to offload targeted ETL workloads and data from data warehouses to Cloudera's platform, increasing performance and freeing up valuable cycles in the EDW.
Posted June 23, 2015
IOUG offers webcasts on a range of topics including cloud computing, best practices, database security and many more.
Posted June 17, 2015
Oracle Database 12c includes lots of new functionality, some of which streamline management, improve capacity utilization, and increase overall storage performance. If you're ready to shrink your footprint and improve your application environments, storage optimization will be a key skill set.
Posted June 17, 2015
MapR Technologies is working with Microsoft to offer the MapR Distribution including Apache Hadoop on Azure cloud services. MapR is architected to provide a scalable and agile Hadoop platform and NoSQL database for big and fast data applications. The MapR Distribution will also be integrated with the Azure Data Lake, enabling users to deploy tiered analytical and storage capabilities in the cloud.
Posted June 10, 2015
Syncsort is working with Dell to help businesses improve operational efficiency and lower costs by shifting expensive workloads and associated data from enterprise data warehouses (EDW) to Hadoop.
Posted June 10, 2015
Kevin Kline, director of engineering services at SQL Sentry, Microsoft SQL Server MVP since 2004, founding board member of PASS, and DBTA columnist, is hitting the road this summer to reach cities across the country with large SQL Server user groups. The reason for the road trip is two-fold, said Kline.
Posted June 09, 2015
Map R is releasing version 5.0 of the MapR Distribution including Hadoop that will process big and fast data on a single data platform that enables a new class of real-time applications.
Posted June 09, 2015
The landscape for database management systems is changing more rapidly these days than it has since the earliest days of the relational DBMS. Not only do we have an onslaught of NoSQL database systems of various different forms (column, document, key/value, and graph databases), but we also see a burgeoning market for in-memory database management, where the DBMS relies on main memory instead of disk for data storage, management, and manipulation. But there is another "category" of DBMS evolving that is known as "NewSQL."
Posted June 09, 2015
Rackspace is launching a dedicated option for MongoDB customers called ObjectRocket for MongoDB databases. The solution, which combines the speed and scalability of the ObjectRocket platform with dedicated hardware and networking for compliance-dependent use cases is aimed at providing the the performance, security and compliance required in high-risk industries such as healthcare, financial services and insurance. "Today we're announcing a fully dedicated cabinet solution to provide a high level of isolation for our customers," said Chris Lalonde, co-founder of ObjectRocket. "On top of that, we are also announcing an on disk encryption for MongoDB."
Posted June 09, 2015
Entrinsik is showcasing the new capabilities in Informer 4.5, the latest version of the company's reporting and business intelligence software, which will be released on June 8. "With 4.5 we're really building on our SQL capabilities and adding more advanced options for users that are reporting on SQL platforms," stated Tim Nicholson, director of Informer services at Entrinsik.
Posted June 09, 2015
One day, corporations awoke to the fact that having data was not the same thing as having believable data. They awoke to discover the meaning of "data integrity." That was the day the enterprise data warehouse (EDW) was born. With an EDW, corporations had the bedrock data on which to make important and trustworthy decisions. Prior to the EDW, corporations had plenty of data, but the data was not believable.
Posted June 09, 2015
To help users extract insights from data lakes,Teradata has made a multi-year commitment to contribute to Presto's open source development. Based on a three-part roadmap, Teradata's says its contributions will be 100% open source under the Apache license and will advance Presto's code base, scalability, iterative querying, and ability to query multiple data repositories.
Posted June 08, 2015
Attunity Ltd., a provider of information availability software solutions, has introduced Attunity Replicate for MongoDB. The solution extends its capability to automate and accelerate data loading and replication between databases, data warehouses, Hadoop and MongoDB. According to Lawrence Schwartz, chief marketing officer at Attunity, new NoSQL integrations will be added in the future as well.
Posted June 03, 2015
New and emerging companies are taking aim at data management challenges to help customers get more value from their data. Here, DBTA showcases the approaches of 10 companies we think are worth watching.
Posted June 01, 2015
SAP has announced the cloud edition of SAP Business Suite 4 SAP HANA (SAP S/4HANA), which adds new simplification and innovations across core business functions. In addition, the new release gives customers the opportunity to deploy real hybrid scenarios — combining on-premise and cloud solutions.
Posted May 28, 2015
Helping to support enterprises' plans to implement SAP Business Suite 4 SAP HANA (SAP S/4HANA), BackOffice Associates, a provider of information governance and data modernization solutions, announced that its data management solutions are available to help enterprises orchestrate the data migration and modernization process for implementations of SAP S/4HANA.
Posted May 28, 2015
Cloudera is now offering support for Capgemini's new reference architecture for the SAP HANA platform and Cloudera Enterprise. "By bringing the power of Cloudera's enterprise data hub offering to the ecosystem in support of SAP HANA, we can enable Capgemini's clients to expand the amount of data they have within their environment in a cost-efficient manner," said Tim Stevens, vice president of corporate and business development at Cloudera.
Posted May 28, 2015
CA Workload Automation Advanced Integration 1.0 for SAP Business Warehouse has received SAP certification. Specifically, the SAP Integration and Certification Center has certified that CA Workload Automation Advanced Integration 1.0 integrates with SAP Business Warehouse to provide a unified view for jobs running in both SAP and non-SAP applications.
Posted May 28, 2015