Newsletters




Database Management

Relational Database Management Systems (RDBMSs) continue to do the heavy lifting in data management, while newer database management systems are taking on prominent roles as well. NoSQL database systems such as Key-Value, Column Family, Graph, and Document databases, are gaining acceptance due to their ability to handle unstructured and semi-structured data. MultiValue, sometimes called the fifth NoSQL database, is also a well-established database management technology which continues to evolve to address new enterprise requirements.



Database Management Articles

Microsoft announced the first release candidate (a.k.a. RC1) for SQL Server 2017 on Monday, July 17th. Release candidates are not a final and finished product, but they are feature complete. No new features are expected after Microsoft moves into the RC phase, only adding polish (for example, brushing up the documentation and UI) and performance to the existing feature set. The full product release is planned for some time in the second half of 2017.

Posted August 09, 2017

You may think your company is behind the curve because you are not 100% in the cloud. Very few companies are there, and most won't make it all the way to 100% due to security, performance, or other strategic reasons. Most, however, are at least getting some workloads into the cloud for price, scalability, and competitive advantage. If you are just starting your journey, here are a few things to consider.

Posted August 09, 2017

Referential integrity (RI) is a method for ensuring the "correctness" of data within a DBMS. People tend to oversimplify RI, stating that it is merely the identification of relationships between relational tables. It is actually much more than this. RI embodies the integrity and usability of a relationship by establishing rules that govern that relationship.

Posted August 09, 2017

The emergence of cryptocurrencies and blockchain technology may prove to be almost as significant an innovation as the internet itself. Blockchain offers a mechanism for the mediation of any transactions that previously would have required trusted third parties, while cryptocurrencies such as Bitcoin may eventually become a significant alternative to traditional "fiat" (e.g., government-backed) currencies. These technologies could eventually revolutionize the global banking infrastructure which has underpinned global commerce for centuries.

Posted August 09, 2017

Poorly written SQL statements can cause significant performance problems in your database environment. According to some experts, poorly written SQL can cause up to 70% of performance problems overall. Adding resources can mask many issues surrounding poorly written SQL, but comes with a cost. Is writing good, quality SQL (including block code—stored procedures, packages, functions, etc.) a dying art? And if it's so important, why is that?

Posted August 09, 2017

Hackers are rarely far from the news these days, whether they're perpetrating cyber-intrusions into political campaigns or take-downs of major retail websites, social media sites, movie studios, or entertainment conglomerates. But some of the "hacking" headlines can be deceiving. In fact, a significant number of cybersecurity breaches around the digital world actually represent a kind of all-too-familiar crime that is as old as the abacus.

Posted August 09, 2017

Redgate Software, a Cambridge, UK-based database tools provider, has launched a new one-stop resource to help software professionals find the information and advice they need faster and easier.

Posted August 09, 2017

Time is very valuable when it comes to gaining insight and acting appropriately to respond to data. Users have to evaluate and ask questions about data that is based on timeframes and ranges. Time is no longer something added to data; it is constitutive of the data.

Posted August 07, 2017

DBAs need smarter tools to keep their database environments running efficiently so they can spend less time on menial tasks and more on strategic initiatives.

Posted August 07, 2017

BackOffice Associates, a provider of information governance, data stewardship, and data migration solutions, has announced that Bridge Growth Partners, a private equity firm, has signed an agreement to make a majority equity investment in the company.

Posted August 03, 2017

Accenture has acquired Search Technologies, a Herndon, Virginia-based technology services firm specializing in the design, implementation and management of big data and search analytics. Terms of the transaction were not disclosed. Kamran Khan, president and CEO of Search Technologies, will lead a new Content Analytics team within Accenture Analytics.

Posted August 03, 2017

Creative Media Works, operating as BBM Messenger has selected Pythian to help them migrate to the Google Cloud Platform. Pythian, a global IT services company that helps businesses adopt technologies to better compete, will help BBM Messenger move its mission-critical IT infrastructure for Android, iOS and Windows consumer BBM from BlackBerry on-prem data centers in Canada to Google Cloud Platform (GCP) in Asia.

Posted August 03, 2017

IDERA, a provider of database, development, and test management tools, announced it is acquiring AquaFold, a provider of cross-platform database tools. AquaFold will join IDERA's database development and management portfolio, enabling the company to expand its multi-platform support.

Posted August 02, 2017

Storage solutions run the gamut of assisting a variety of use cases including backup and archiving, content storage and distribution, big data analytics, static website hosting, could-native application data, and disaster recovery.

Posted August 02, 2017

Streaming data solutions can evaluate data quickly and enable predictive analytics based on sources of rapidly changing data—including social media, sensors, and financial services data, to head off future problems, machine failures, natural disasters, and take advantage of unfolding opportunities.

Posted August 02, 2017

Change data capture (CDC) is a function within database management software that makes sure data is uniform throughout a database. CDC identifies and tracks changes to source data anywhere in the database, and then applies those changes to target data in the rest of the database.

Posted August 02, 2017

In today's always-on economy, database downtime can inflict a mortal wound on the life of a business. That's why having a trusted backup solution that can ensure that databases can be back up and running quickly in the event of an outage is critical. Today, close to one-fourth of organizations have SLAs of four nines of availability or greater, meaning they require less than 52 minutes of downtime per year, according to a recent Unisphere Research survey.

Posted August 02, 2017

If data is the new oil, then getting that resource pumped out to more users faster with fewer bottlenecks is a capability that must be achieved. The issue of under-performing database systems cannot be seen as simply an IT problem. Remaining up and running, always available and functioning with lightning speed today is a business necessity.

Posted August 02, 2017

Geographically spread-out development teams with varied skill levels and different areas of proficiency, ever-faster software development cycles, multiple database platforms—all this translates to a challenging development environment that database development solutions providers seek to streamline.

Posted August 02, 2017

In today's highly complex, data environments with multiple data platforms across physical data centers and the cloud, managing systems and processes manually is no longer sufficient. What is needed is the ability to manage and monitor business-critical assets with automated precision. Indeed, with so many technologies involved in enterprise data management today, the key words in database administration are "comprehensive" and "automated.

Posted August 02, 2017

As data stores grow larger and more diverse, and greater focus is placed on competing on analytics, processing data faster is becoming a critical requirement. In-memory technology has become a relied-upon part of the data world, now available through most major database vendors. In-memory can process workloads up to 100 times faster than disk-to-memory configurations, which enables business at the speed of thought.

Posted August 02, 2017

Addressing the need to store and manage increasingly large amounts of data that does not fit neatly in rows and columns, NoSQL databases can run on commodity hardware, support the unstructured, non-relational data flowing into organizations from the proliferation of new sources, and are available in a variety of structures that open up new types of data sources, providing ways to tap into the institutional knowledge locked in PCs and departmental silos.

Posted August 02, 2017

Cloud databases, also referred to as database as a service (DBaaS), can be SQL or NoSQL, open source or relational, and allow customers to choose the environment that is best suited for their particular use cases—whatever that may be, including support for streaming data pipelines or a data warehousing for analytics. Cloud is increasingly being used by organizations to support a range of users, including data managers, developers, and testers, who require almost instantaneous access to a database environment without going through their respective IT, finance, or top managers or needing to acquire new servers or storage arrays to support their efforts.

Posted August 02, 2017

The rise of new data types is leading to new ways of thinking about data, and newer data storage and management technologies, such as Hadoop, Spark, and NoSQL, are disruptive forces that may eventually result in what has been described as a post-structured world. But while Hadoop and NoSQL are undoubtedly growing in use, and a wider array of database management technologies in general is being adopted, the reality is that at least for now the relational database management system is still reigns supreme and is responsible for storing the great majority of enterprise data.

Posted August 02, 2017

Coined over a decade ago, the term "polyglot persistence" has come to be seen as a shorthand phrase in the database world for using the best tool for the job, or in other words, the right database for the data storage need at hand. Today, that might mean NoSQL, NewSQL, in-memory databases, and cloud databases—also known as database as a service—approaches.

Posted August 02, 2017

Oracle is adding hundreds of new capabilities to Oracle Cloud Applications with Release 13. Key enhancements are aimed at enhancing the user experience and supporting business users across the organization through greater personalization, productivity, insight, and collaboration. Supply chain is a key focus of the release.

Posted August 02, 2017

Workiva, a provider of solutions for enterprise productivity and Gold-level member of Oracle PartnerNetwork, has announced data integration between its Wdesk platform and more than 100 cloud, SaaS and on-premise applications, including Oracle Enterprise Resource Planning (ERP) Cloud.

Posted August 02, 2017

The desire to compete on analytics is driving the adoption of big data and cloud technologies that enable enterprises to inexpensively store and process large volumes of data. But, building a modern data architecture can be confusing and time-consuming. From NoSQL and in-memory databases, to Hadoop and Spark, technologies are available that offer new and distinct capabilities to the world of enterprise data management.

Posted July 27, 2017

TIBCO Software, a provider of integration, API management, and analytics, is acquiring nanoscale.io, a provider of microservices technology and tooling. The acquisition extends and enhances TIBCO's leadership in the development of microservices and APIs that connect and integrate with a more expansive on-premises or hybrid cloud environment, and bolster its Connected Intelligence platform.

Posted July 27, 2017

It's been long acknowledged that data is the most precious commodity of the 21st-century business, and that all efforts and resources need to be dedicated to the acquisition and care of this resource. Lately, however, executives have become enamored with the vision of transforming their organizations into "data-driven" enterprises, which move forward into the future on data-supported insights. So, what, exactly, does the ideal "data-driven enterprise" look like?

Posted July 27, 2017

EnterpriseDB has released EDB Postgres Enterprise Manager 7. Part of the EDB Postgres Platform, EDB Postgres Enterprise Manager 7 provides a new web client and tools to give DBAs greater ability to improve database performance across large installations.

Posted July 27, 2017

InfluxData has announced general availability of the InfluxData platform, version 1.3 of its open source platform built from the ground up for metrics and events.

Posted July 24, 2017

Southbank Software has launched its first product, dbKoda, an open source database development and administration platform, initially available for MongoDB. MongoDB was targeted first because of its rapid growth and popularity among full stack developers, according to Guy Harrison, Southbank's founder.

Posted July 24, 2017

Datavail, a provider of managed services for applications, business intelligence, and databases, is acquiring Accelatis, an enterprise performance management software platform company.

Posted July 19, 2017

The data manager now sits in the center of a revolution swirling about enterprises. In today's up-and-down global economy, opportunities and threats are coming in from a number of directions. Business leaders recognize that the key to success in hyper-competitive markets is the ability to leverage data to draw insights that predict and provide prescriptive action to stay ahead of markets and customer preferences. For that, they need to keep up with the latest solutions and approaches in data management. Here are 12 of the key technologies turning heads—or potentially opening enterprise wallets—in today's data centers.

Posted July 19, 2017

Microsoft's SQL Server platform has been on a roll lately, with its smooth and feature-rich SQL 2016 release gaining accolades across the industry, including the DBMS of the Year award from db-engines.com. The company's increased focus on cloud, strong BI tool set, impressive functionality and emerging cross-platform capability with SQL on Linux has made this RDBMS a staple of database shops around the world.

Posted July 14, 2017

OpenText, a provider of enterprise information management (EIM) solutions, is unveiling a new artificial intelligence (AI) platform that combines open source machine learning with advanced analytics. The platform, named Magellan will acquire, merge, manage and analyze big data and big content. Magellan's cognitive computing platform offers users machine-assisted decision making, automation, and business optimization, in an easy to use and affordable package.

Posted July 12, 2017

Centerbridge Partners, L.P., a private investment firm, is acquiring enterprise software providers Syncsort and Vision Solutions from Clearlake Capital Group, L.P. Upon completion of the $1.26 billion transaction, Syncsort and Vision will be combined, creating what Centerbridge calls a "big iron to big data" platform investment controlled by Centerbridge, and operating under the Syncsort name.

Posted July 06, 2017

Oracle DBAs are inundated with constant work and it's becoming more difficult to keep up with it all. Sometimes, in the rush to balance the workload, an Oracle DBA can forget some fundamental steps which actually might help them stay ahead of the game. Some are tasks to perform just once when the database is initially deployed, others are routine tasks that should be scheduled at regular intervals, and still others are tasks outside the database itself.

Posted July 05, 2017

Often, when working with technical people, they get excited over the latest and greatest piece of software or hardware. They try and get their management excited, but it seems as if their management just doesn't "get" how good it is.

Posted July 05, 2017

MicroStrategy, a provider of enterprise analytics and mobility software, is releasing MicroStrategy 10.8, updating critical capabilities across enterprise analytics, enterprise mobility, embedded analytics, enterprise cloud, and enterprise IoT.

Posted July 05, 2017

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really like focus on adaptive query processing. These new features speed processing of workloads, especially those that have historically been the hardest to tune.

Posted July 05, 2017

For everyone normalizing their designs, just remember: There ain't no such thing as a partial foreign key. When a project pretends that partial foreign keys are a valid concept, the end result is a database model that either lies to viewers, or does not give them the necessary information to readily join tables together.

Posted July 05, 2017

MongoDB has become a favorite among developers in no small part because of its alignment with modern software development practices. Its flexible schemas are compatible with agile software development and the JSON-based document structure is well-matched with modern JavaScript-centric web architectures. However, databases don't exist solely for the convenience of software developers: Data in a database is a critical business asset.

Posted July 05, 2017

Many organizations are now embracing the cloud in order to help reduce their operational costs, but the notion of migrating an Oracle 12c multi-tenancy database from on-premise to the Oracle Cloud may seem like a daunting proposition.

Posted June 29, 2017

Pages
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

Sponsors