Newsletters




Data Warehousing

Hardware and software that support the efficient consolidation of data from multiple sources in a Data Warehouse for Reporting and Analytics include ETL (Extract, Transform, Load), EAI (Enterprise Application Integration), CDC (Change Data Capture), Data Replication, Data Deduplication, Compression, Big Data technologies such as Hadoop and MapReduce, and Data Warehouse Appliances.



Data Warehousing Articles

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

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

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 August 10, 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

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 10, 2015

One of the side effects of the growth in data is the vast variety that data now comes in. While it presents advantages, the newer data types and sources also make data integration more complex. To highlight new technologies and techniques for overcoming data silos and enabling the delivery of information across the enterprise - where and when it is needed - Database Trends and Applications recently hosted a special roundtable webinar sponsored by Attunity, MarkLogic, and SnapLogic. The webinar covered the key big data integration issues facing enterprises and presented real-world solutions and best practices.

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

"Big Data," "Cloud," "Mobile," "IoT," "Social," "Real Time"—the stream of buzzwords seems unending. Helping Oracle customers stay on top of the latest technologies, deal with new challenges, and make the most of emerging opportunities, each fall Oracle presents OpenWorld, an event spanning the entirety of Oracle's offerings. The conference attracts tens of thousands of influential attendees who converge in San Francisco to learn about current and future technologies and trends from Oracle and the surrounding ecosystem.

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 IT industry continues to expand at a brisk pace with a steady influx of innovative products and technologies to help organizations extract value from data, integrate it with new and traditional sources, as well as ensure quality and security.

Posted August 04, 2015

With the continued increase in data over the recent years, data infrastructures are changing as well. The one-size-fits-all approach for data environments is going by the wayside due to the expanding range of data types. With the growing understanding that the world of big data is heterogeneous, businesses are now employing versatile hybrid data architectures. But while they provide the right tools for the myriad requirements of big data, hybrid architectures must be properly integrated and managed to deliver their full value.

Posted July 28, 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

Before enterprises create data architecture for business intelligence and analytics, there are a few key components they need to consider.

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

The Microsoft data platform team is on fire! It is delivering more updates and features faster and more thoroughly than ever before. If you're a data professional and you're using the Microsoft stack, this is a really exciting time to be involved. Here's a look at the top new capabilities in SQL Server 2016 Public Preview, SSIS Feature Packs For Azure, and Azure SQL Data Warehouse.

Posted July 08, 2015

As Agile development increases in popularity, companies have achieved faster time to market, reduced risk, and increased ability to manage changing priorities in their projects. However, what Agile means for the DBA team is more database deployments more often.

Posted July 08, 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

While the influx of data provides many benefits to an organization, it can come with some challenges as well. The cost and lack of elasticity due to the volume and multiple data sources have become difficult issues for businesses to deal with.

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

The world of information technology is often described as an ecosystem. And just like an ecosystem that exists in nature, IT is affected by internal and external factors. In this issue of Database Trends and Applications magazine, we introduce the third annual list of companies that matter in data, a reflection of the IT ecosystem as it exists now.

Posted June 01, 2015

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14

Sponsors