Database Management Articles
Quest Software, Inc., a Visual Studio Industry Partner and maker of Toad for Oracle, has announced the launch of Toad Extension for Visual Studio. Toad Extension for Visual Studio is a database schema provider that will support complete application lifecycle management (ALM) for Oracle in Visual Studio 2010, unifying Oracle developers with the rest of the Visual Studio development team.
Posted April 20, 2010
Greenplum Software, a data infrastructure company, has introduced what it calls the industry's first commercially available "Enterprise Data Cloud" platform. Called Greenplum Chorus, the solution offers self-service provisioning, data collaboration and data services features to complement traditional enterprise data warehouses. "Greenplum Chorus is a distributed software platform that is run on premises within an enterprise — potentially spanning multiple data centers and encompassing tens or hundreds of warehouses and marts," Ben Werther, director of product management for Greenplum, tells 5 Minute Briefing. The product is available under subscription or perpetual licensing models, Werther adds.
Posted April 13, 2010
The Independent Oracle Users Group (IOUG), has announced the availability of a virtual educational program that will run concurrently with the annual Oracle users event COLLABORATE. Presented jointly by the IOUG, as well as the Oracle Applications Users Group (OAUG) and Quest International Users Group (Quest), the COLLABORATE 10 conference will take place April 18-22 at the Mandalay Bay Hotel & Convention Center in Las Vegas.
Posted April 13, 2010
The COLLABORATE 10 - OAUG (Oracle Applications Users Group) Forum is planning more than 400 user-driven sessions featuring tips, techniques and best practices for Oracle Fusion, Oracle E-Business Suite, PeopleSoft, Agile, Hyperion, Oracle Communications and Siebel product families. The OAUG is co-hosting the COLLABORATE 10: Technology and Applications Forum for the Oracle Community conference in partnership with the Independent Oracle Users Group and Quest International Users Group, April 18-22, in Las Vegas.
Posted April 13, 2010
Far too often we all talk past one another. This cross talking, while not always drastic, remains perceived as an understood fuzziness. Much of the time we ignore these minor miscommunications because precision and clarity are not necessarily critical in all situations. If the general gist is effectively understood between those communicating, that generality may be all that is necessary. Those involved in the communication may feel comfortable that assumptions made to "fill in the gaps" will fall within an acceptable range. Although the lack of clarity in the message communicated may be acceptable, in other circumstances it may not be acceptable.
Posted April 07, 2010
As you work to protect your data in this day-and-age of data breaches and regulatory compliance, technology and software solutions to data and database security spring to the top of most people's minds. This is to be expected because, after all, most of our data is stored on computers so technology and software are required to protect the data from unauthorized access. This is a good thing: Technology is a crucial component of protecting your valuable business data. But it is not the only thing.
Posted April 07, 2010
The drivers and benefits of using open source in the enterprise have been widely documented. Ultimately, enterprise users adopt open source for two primary reasons: cost and vendor independence. These are the same drivers and benefits that apply to well-known categories such as operating systems, application servers and web browsers. However, because the database plays a role in all enterprise IT applications, the scrutiny and rigor that enterprises apply to the selection, implementation and deployment of open source databases is far more intense and deliberate.
Posted April 07, 2010
It's hard enough to lock down sensitive data when you know exactly which server the database is running on, but what will you do when you deploy virtualization and these systems are constantly moving? And making sure your own database administrators (DBAs) and system administrators aren't copying or viewing confidential records is already a challenge - how are you going to know when your cloud computing vendor's staff members are not using their privileges inappropriately? These are just two of the obstacles that any enterprise must overcome in order to deploy a secure database platform in a virtual environment, or in the cloud. In some cases, these concerns have been preventing organizations from moving to virtualization or cloud computing.
Posted April 07, 2010
The Rocket U2 team has set the dates for U2 University. The U.S. event will be November 9-11, 2010, in Denver, Colo. The U.K. and Australia events have been scheduled for the first quarter of 2011.
Posted April 07, 2010
Entrinsik Inc., a provider of operational reporting and analysis solutions, will present at this year's SugarCon event in San Francisco, being held April 12-14. SugarCon 2010, SugarCRM's fourth annual user and customer conference, brings together SugarCRM users, developers, partners and industry experts from around the world.
Posted April 07, 2010
NorthgateArinso (Northgate) and Nebraska Furniture Mart (NFM) have announced that they have extended their partnership agreement through 2016. "We are excited to have this level of partnership with Nebraska Furniture Mart," says Mark Pick, vice president, Reality, "and we don't take it lightly. Long-term relationships such as this show our commitment to our customers, Reality and to the MultiValue community."
Posted April 07, 2010
COLLABORATE 10 will at long last bring together Sun and Oracle users for the first time under one roof. Ian Abramson, president of the Independent Oracle Users Group, talks with DBTA about what the group is planning for the April conference in Las Vegas, and how the integration of customers and technology is being handled by Oracle and the IOUG.
Posted April 07, 2010
The latest release of Oracle Berkeley DB, the small footprint open source embeddable database engine for mission-critical "edge" applications, is now available for downloading. Oracle Berkeley DB 11g Release 2 introduces a new SQL API, based on SQLite, which is familiar to a large developer community, and paves the way to a wider array of applications that the database may be able to support.
Posted April 07, 2010
To help organizations chart the most efficient course to maximize the enterprise value of investments such as capital projects, software and systems development, new acquisitions and products, Oracle yesterday announced the availability of Oracle's Primavera Portfolio Management 8.
Posted April 07, 2010
Embarcadero Technologies has introduced DBArtisan XE, the newest addition to the DBArtisan family of heterogeneous database administration tools. With support for multiple database platforms "out of the box," DBArtisan XE enables database administrators (DBAs) to maximize the performance, availability and security of all major database management systems, including Oracle and MySQL, as well as SQL Server, IBM DB2, and Sybase from a single interface.
Posted April 06, 2010
Today Informatica Corporation announced the availability of a new independent research study entitled "Information, Unplugged: 2009 OAUG ResearchLine Survey on Enterprise Application Information Lifecycle Management." The report details the challenges IT is facing because of the surge in data flowing through today's enterprise applications and databases. "Inadequately managed data growth is fast becoming a problem of epic proportions, with some enterprise applications and databases increasing in size by as much as 50% a year," notes Adam Wilson, general manager, Information Lifecycle Management (ILM), Informatica.
Posted April 06, 2010
The latest release of Oracle Berkeley DB, the small footprint open source embeddable database engine for mission-critical "edge" applications, is now available for downloading. Oracle Berkeley DB 11g Release 2 introduces a new SQL API, based on SQLite, which is familiar to a large developer community, and paves the way to a wider array of applications that the database may be able to support.
Posted April 06, 2010
Entrinsik Inc., a provider of operational reporting and analysis solutions, will present at this year's SugarCon event in San Francisco, being held April 12-14. SugarCon 2010, SugarCRM's fourth annual user and customer conference, brings together SugarCRM users, developers, partners and industry experts from around the world.
Posted April 06, 2010
Embarcadero Technologies has introduced DBArtisan XE, the newest addition to the DBArtisan family of heterogeneous database administration tools. With support for multiple database platforms "out of the box," DBArtisan XE enables database administrators (DBAs) to maximize the performance, availability and security of all major database management systems, including Oracle and MySQL, as well as SQL Server, IBM DB2, and Sybase from a single interface.
Posted March 31, 2010
Attunity Ltd., a provider of real-time data integration and event capture software, has announced a new release of its change data capture (CDC) and operational data replication (ODR) software with support for SQL Server 2008 R2. The software is now available with the Attunity CDC Suite for SSIS (SQL Server Integration Services), and a free trial is available for download on the Attunity website.
Posted March 30, 2010
HiT Software, Inc., a provider of data integration, replication and transformation products, has announced that the newest version of DBMoto, its change data capture (CDC) and data replication solution, has been expanded to include multi-server synchronization. In addition, the release also offers a dynamic, configurable GUI, and provides updates for remote administration and advanced security options, as well as additional database support. DBMoto 7 will be released in the second quarter of 2010.
Posted March 30, 2010
Confio Software has announced availability of Ignite 8, a major expansion of its database performance solution. Ignite 8 expands the Ignite for Sybase, SQL Server, Oracle, and DB2 products to include comprehensive performance monitoring in combination with the response-time analysis for which Ignite has been known.
Posted March 25, 2010
Sybase has announced advanced spatial data functionality as part of the next release of its SQL Anywhere database and synchronization solution. According to Sybase, this release makes it the first vendor to enable development of data-driven spatial applications for leading smartphone devices and synchronize the on-device spatial data with spatial databases, application servers and enterprise systems.
Posted March 25, 2010
Sybase technical experts are planning a series of Developer Days throughout the United States and Europe to showcase the latest releases of its industry-leading development software. All seminars are free and run from 8:30am - 2pm local time (timing may vary slightly by location) with breakfast and lunch included.
Posted March 25, 2010
Application Security, Inc., a provider of database security, risk and compliance solutions for the enterprise, has announced an update for its products, AppDetectivePro for auditors and IT advisors, and DbProtect for the enterprise, in response to the Massachusetts Data Privacy Law 201 CMR 17 effective March 1, 2010.
Posted March 23, 2010
Rapid Insight Inc., a data analytics tool provider, announced the launch of a new integration tool that enables users to visually map where data is originating and where it's being applied. The solution, called Veera, is built upon an earlier Rapid Insight product, Data Integration 2.0, and is intended to help users overcome common barriers to data access, ad-hoc analysis, and report generation.
Posted March 23, 2010
NorthScale, Inc., a Silicon Valley software startup, has launched with the introduction of data infrastructure software optimized for the data management requirements of web applications and cloud computing environments. The company was founded by leaders of the memcached open source project, and NorthScale's technical team collectively represents about 60% of the lines of code behind the memcached project, James Phillips, co-founder and chief strategy officer of NorthScale, tells 5 Minute Briefing.
Posted March 23, 2010
SymSoft Corporation, a provider of governance, risk and compliance (GRC) solutions for SAP environments, has announced the release of ControlPanelGRC User and Role Change Analyzer. The new module, which is part of SymSoft's ControlPanelGRC suite of GRC solutions, provides security administrators with the ability to create additional documentation on the reasons changes were made on users and provide versioning of roles in SAP systems.
Posted March 23, 2010
Advancing Oracle's application-to-disk management strategy and delivering on Oracle's Sun integration roadmap, Oracle yesterday announced the availability of the newest addition in the Oracle Enterprise Manager, Oracle Enterprise Manager Ops Center, which offers extensive capabilities for managing physical and virtual Sun environments.
Posted March 17, 2010
NorthgateArinso (Northgate) has announced that Anderson Business Technology has gone live with its Reality system. Anderson Business Technology, an office equipment, supply and service provider, teamed up with Northgate to overhaul its system to a contemporary Reality database in a Microsoft Windows server environment. "There is no other sector that moves as fast as technology," says David Anderson, company president and grandson of the founder. "If you are not prepared to make the changes you need to keep pace, you don't survive."
Posted March 04, 2010
IBM acquired predictive analytics vendor SPSS in October 2009. Erick Brethenoux, predictive analytics strategist for SPSS, an IBM Company, talks about the growing importance of the technology in helping enterprises address customer needs, what is driving the demand for it now, and how it fits into IBM's idea for a Smarter Planet.
Posted March 04, 2010
The future of business intelligence is coming. The comment is rhetorical, but in many ways it is true. For the last few years the conversation has surrounded Web 2.0 or even BI 2.0. The concept has brought changes to the way that we look at information and the methods that we use to exchange information. BI 2.0 has brought us a plethora of new functionality that provides proactive support to organizations and a more interactive manner of sharing information. So where is this going, and how will today's technology support our needs as 2010 arrives, and with it a new decade?
Posted March 04, 2010
Primary keys come from candidate keys. Each candidate key consists of the attribute or attributes used to label a distinct row in a table. Every candidate key should contain the fewest number of attributes possible to identify rows individually and uniquely. Every entity within a design requires at least one candidate key.
Posted March 04, 2010
After the misery that was 2009, most of the SQL Server users I talk to are happy that 2010 started in languid fashion. Not that there isn't a lot of work to do; on the contrary, there's more work than ever. However, the long hours and multiple projects of 2009, compounded by freezes in all levels of spending, raised the general stress level to unhealthy heights. With the new year, stress levels dropped significantly, and many IT leaders see signs of improving prospects. What does that bode for 2010? I have a couple of predictions, though I doubt they'll surprise many people.
Posted March 04, 2010
The continuing acceptance and growing usage of Linux as an enterprise computing platform has enlivened the open source community. The term "open source" refers to software that users are free to run, copy, distribute, study, change, and improve. Often "open source" gets misinterpreted to mean free software. This is understandable, but the open source concept of free is closer to liberty than it is to no charge.
Posted March 04, 2010
An overwhelming challenge - expanding volumes of data - threatens to gum up any productivity improvements seen to date as a result of information technology deployments. All that data is coming in from systems, sensors, and storage area networks, pressuring organizations to expand database inventories, while grappling with associated licensing and hardware costs. Plus, many compliance mandates demand that this data be stored for long periods of time, but remain accessible to auditors and business end users.
Posted March 04, 2010
For many organizations, application information lifecycle management, or ILM, now offers expedient - and badly needed - measures for properly defining, managing, and storing data. Many enterprises are being stymied by a massive proliferation of data in their databases and applications. Growing volumes of transaction data are being digitally captured and stored, along with unstructured forms of data files such as email, video, and graphics. Adding to this tsunami are multiple copies of all this data being stored throughout organizations. At the same time, increasingly tight mandates and regulations put the onus on organizations to maintain this data and keep it available for years to come. Much of this data still resides on legacy systems, which are costly to operate and maintain.
Posted March 04, 2010
Faced with growing data volumes and limited budgets, companies, educational institutions, and government agencies are increasingly relying on IT to help them gain a competitive edge and better serve their customers and constituents. DBTA recently asked key MultiValue vendors to explain their strategies for enabling data integration from different repositories and for supporting business intelligence and analytics that provide meaningful insight for customers.
Posted March 04, 2010
Oracle has announced Oracle SOA Governance 11g, which consists of Oracle Enterprise Repository, Oracle Service Registry, SOA Management with Oracle Enterprise Manager, and Oracle Web Services Manager. "With the launch of Oracle SOA Governance 11g, Oracle becomes the only vendor to offer a unified management approach for both best-of-breed SOA and packaged applications within a single platform. This unified governance umbrella not only helps organizations to deliver new business capabilities more efficiency, but also helps ensure that they are closely aligned with key business objectives," states Amlan Debnath, senior vice president, Oracle Product Development.
Posted March 03, 2010
Confio Software yesterday announced availability of Ignite 8, a major expansion of its database performance solution. Ignite 8 expands the Ignite for SQL Server, Oracle, DB2 and Sybase products to include comprehensive performance monitoring in combination with the response-time analysis for which Ignite has been known.
Posted March 03, 2010
Sentrigo, Inc., a provider of database security software, has announced Repscan version 3.0, a major new release of its database vulnerability assessment and security scanning software. Version 3.0 incorporates new and improved features that allow users to more easily navigate, identify and interpret critical data within an enterprise. Among new product features is a graphical user interface, which has been redesigned to allow even security experts with limited database knowledge to run and interpret results. The whole user interface was redesigned from ground up to be more approachable by someone who was not necessarily a database expert, Andy Feit, vice president of marketing for Sentrigo, tells 5 Minute Briefing.
Posted March 03, 2010
Zmanda, a provider of open source and cloud-based backup solutions, has announced a product that enables Tivoli administrators to incorporate backups of MySQL databases as part of an enterprise-wide backup and disaster recovery strategy. The solution, Tivoli Storage Manager (TSM) Option for Zmanda Recovery Manager (ZRM) for MySQL, enables MySQL users to manage their data protection policies through Tivoli.
Posted March 03, 2010
Confio Software today announced availability of Ignite 8, a major expansion of its database performance solution. Ignite 8 expands the Ignite for SQL Server, Oracle, DB2 and Sybase products to include comprehensive performance monitoring in combination with the response-time analysis for which Ignite has been known.
Posted March 02, 2010
Sybase, Inc. recently reported financial results for the fourth quarter and full year ended December 31, 2009. "2009 was obviously a great year of major accomplishment for Sybase," stated John Chen, chairman, CEO and president, during the Q4 earnings call. "We are very pleased that we delivered consistent financial performance throughout the year," which culminated in "the best quarter of the company history in Q4 and a third consecutive year of record revenue, earnings, as well as cash flow." For the full year, he noted, revenue came in at $1.17 billion, the highest ever, and above the company's outlook as it entered into 2009, 12 months ago.
Posted February 25, 2010
Sybase has announced that its Sybase IQ column-based analytics server, in collaboration with solutions from HP and Red Hat, achieved the top data warehousing benchmark result among currently published non-clustered Linux and x86 systems in the TPC-H benchmark at the 1 TB scale factor.
Posted February 25, 2010
Sybase 365, a subsidiary of Sybase, has announced the availability of an expanded portfolio of mobile customer relationship management tools and services, enabling enterprises to engage customers throughout the entire customer lifecycle, using the mobile channel.
Posted February 25, 2010
To make it easier for application developers and data management professionals to access the software tools they need, while also reducing the cost and time associated with managing software tool licenses, Embarcadero has announced Embarcadero ToolCloud. "The ToolCloud is about a new way of letting IT departments make Embarcadero tools available to their end users," Philip Rathle, senior director of product management, Embarcadero, tells 5 Minute Briefing.
Posted February 25, 2010
NorthgateArinso (Northgate) has announced that Anderson Business Technology has gone live with its Reality system. Anderson Business Technology, an office equipment, supply and service provider, teamed up with Northgate to overhaul its system to a contemporary Reality database in a Microsoft Windows server environment. "There is no other sector that moves as fast as technology," says David Anderson, company president and grandson of the founder. "If you are not prepared to make the changes you need to keep pace, you don't survive."
Posted February 24, 2010
Rocket Software is planning a complimentary webcast series focused on the latest release of RocketU2 SystemBuilder Extensible Architecture (SB/XA). SB/XA is a Rapid Application Development (RAD) and deployment environment delivering up-to-the-minute interface design and portable reporting capabilities. Existing SB+ applications can automatically convert without requiring changes to the underlying code.
Posted February 24, 2010
Vertica announced today a new release of the Vertica Analytic Database, incorporating new features designed to increase performance and automate provisioning of computing resources. Vertica 4.0 is the latest version of the company's MPP columnar database, designed for large queries across large amounts of data.
Posted February 23, 2010