Data Modeling Articles
Big data tool vendors try to downplay the notion that data warehouses and data marts still need to exist, even in a big data world. Relational DBMSs are painted as "old-fashioned," "yesterday," and "inadequate." They beckon potential customers to take a dip in the refreshing data lake. The fact that big data, in all of its glory, is only part of a larger business intelligence solution is getting lost in the dialog.
Posted November 12, 2014
Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure optimal application performance when accessing data in a relational/SQL database is to create the correct indexes for your tables based on the queries your applications use. Of course, this is easier said than done. With the caveat that appropriate index creation can be complicated, let's look at the top 10 steps to building the right indexes on your tables.
Posted November 12, 2014
Kourier Integrator Release 4.2, the latest version of its enterprise integration and data management suite, includes improvements to the enterprise application integration (EAI) and extract-transform-load (ETL) capabilities of the product, as well as new support for SQL Server 2014, the latest version of Microsoft's RDBMS.
Posted November 12, 2014
Oracle has expanded its data integration portfolio with the addition of Oracle Enterprise Metadata Management, a platform to help organizations govern data across the enterprise including structured and unstructured data, and across Oracle and third-party data integration, database, and business analytics platforms. "This is the first time that we have made a comprehensive offering in the area of metadata management," said Jeff Pollock, vice president of product management for Oracle Data Integration.
Posted October 22, 2014
To help IT organizations extend the agility provided by continuous integration into continuous delivery, VMware also unveiled a major update of VMware vRealize Operations (formerly VMware vCenterOperations Management Suite. The new VMware vRealize Code Stream enables DevOps teams to deliver frequent, reliable software releases.
Posted October 14, 2014
It is fair to say that relational theory is the only solid framework for establishing a rational expression of data that falls anywhere inside the boundaries of formal logic. As people continue to laud the "death of relational" by coming up with one or other "new" physical implementations of coding or data engines, from object-oriented, XML, columnar, or anything else one might name, the primary short-coming is that these are physical implementations that avoid having any formalized logic underpinning them.
Posted October 08, 2014
"On occasion, the inmates actually do take over the asylum. Similarly, business personnel can be defeated by their IT peers," writes Todd Schraml. Although some might argue that such an unexpected role reversal cannot happen, it may indeed occur when data architects skilled in their craft can identify the options that help achieve the business goals, versus those alternatives that stifle the business goals. "A good data architect must also be a very good business analyst," he notes.
Posted September 10, 2014
Why do tens of thousands of Oracle customers, partners, and consultants descend on Moscone Center in San Francisco for the annual Oracle OpenWorld conference? Despite the proliferation of conferences and online events competing for attention, OpenWorld remains the single, central place for all things Oracle. Here, DBTA presents the annual Who to See @ Oracle OpenWorld special section.
Posted August 27, 2014
A healthy data warehouse environment can self-correct to accomplish the right things. And that self-correction is crucial, for no process is likely to be perfect from the start.
Posted August 05, 2014
Effective data modeling solutions help organizations construct high quality data models, modify existing structures as well as produce detailed documentation. And today, data modeling solutions also help companies visualize and manage business data across more platforms than ever before and extend that data to users with varying job roles and skill levels across geographies and time zones. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Data Modeling Solution.
Posted August 04, 2014
Database development solutions provide the necessary support to help database development teams achieve success by avoiding the risks posed by a range of potential problems—from software bugs, to geographically dispersed development teams, to varied code standards and skill sets. Here are the winners of the 2014 DBTA Readers' Choice Awards for Best Database Development Solution.
Posted August 04, 2014
Competitive differentiation in the mobile space depends only peripherally on the hardware - all modern smartphones have similar processing, display and networking capabilities. And, while some are notably superior in terms of a niche capability - cameras, for instance - it's the software, rather than the hardware, that separates the platforms.
Posted July 03, 2014
Lists help us to remember, impose order upon tasks, and provide guidance. Some lists have taken on great importance in the world and in our lives. The Bill of Rights is such a list. So is the Ten Commandments. But although we use lists to administer, program, and maintain our databases, there really is no overarching list of "things you should (or should not) do" to ensure an effective, accurate, well-designed database. So here is the list of Ten Database Commandments.
Posted July 03, 2014
Pythian, a provider of data management consulting and services, has acquired Blackbird.io, which has expertise in expertise in cloud, infrastructure as a service (SaaS), platform as a service (PaaS), big data, MySQL, NoSQL, and enterprise infrastructure ecosystems, as well as a focus on operational essentials, including orchestration, configuration management, operational visibility, continuous delivery, and 24/7 operations management.
Posted June 26, 2014
Embarcadero has introduced the latest release of Appmethod, which enables developers to use C++ to create complete apps for Android, iOS, Windows, and Mac OS X. The latest release of Appmethod now includes a "Free Forever" subscription plan that C++ developers can use to create Android apps to be published on any public app store such as Amazon App Store and Google Play.
Posted June 24, 2014
Serena Dimensions CM 14, the newest version of Serena Software's process-based software change and configuration management product, enables global collaborative parallel development, in which development teams streamline and automate their development practices, visualize and minimize conflicts, reduce compliance risk and assure a high degree of software release readiness.
Posted June 23, 2014
To speed up deployment of software as a service-based projects. CA Technologies has introduced a mobile-ready, SaaS-based IT Service Management (ITSM) solution called CA Cloud Service Management.
Posted June 23, 2014
A good analytical model should satisfy several requirements, depending on the application area. In order to achieve business relevance, it is of key importance that the business problem to be solved is appropriately defined, qualified, and agreed upon by all parties involved at the outset of the analysis.
Posted June 17, 2014
How does one tame the data beast to start making tangible progress toward an organization's business intelligence goals? For any progress to occur on the business intelligence-side, tasks, projects and goals need to be fashioned into small steps along a much larger path.
Posted June 11, 2014
Pick Cloud and Ladybridge Systems are presenting a series of web events to showcase the new features of OpenQM including exception handling and data collections.
Posted June 11, 2014
MarkLogic CEO Gary Bloom and his team brought the MarkLogic World Tour 2014 to Wall Street to showcase customer use cases and explain the key new features coming out in MarkLogic 8. The overarching theme for the new release is ease of use, said Bloom.
Posted June 04, 2014
OpenShift Enterprise 2.1, the next generation of Red Hat's on premise platform-as-a-service offering, adds improvements to further enable DevOps practices through the delivery of new capabilities that bring development and operations closer together.
Posted May 27, 2014
Organizations are dealing with pressure to bring new or upgraded applications to market sooner, and application teams must work in parallel to complete projects in less time but with higher quality. To address these challenges, Delphix and DBmaestro are partnering to give enterprise application teams the tools required to bring new applications to market faster.
Posted May 27, 2014
Henry Olson, director of product management, Embarcadero Technologies, tackled the cultural, technical and methodology gaps between the worlds of data architecture and agile development the challenge of retaining the benefit of data architecture and data modeling in the agile world in a lively presentation at DBTA's Data Summit in NYC that drew numerous follow-on questions from attendees.
Posted May 21, 2014
Delphix has formed a new partnership with DBmaestro to increase the speed and lower the cost of application development. According to the companies, teams or individual developers can work in parallel, with an enforced version control process, making sure best practices are followed, and integrating and merging their individual database changes, thus completing application development projects in less time and with lower cost.
Posted May 20, 2014
Finding the means to harmonize conflicting processing requirements is where a design comes alive. When done well, providing symmetry to a suite of processes greatly empowers those who develop and maintain those processes; changes and enhancement arise seemingly in the blink of an eye. In ETL, there are three key principles to driving exceptional design.
Posted May 08, 2014
Supporting a ‘develop once, deploy anywhere' approach, BlueFinity International has launched Evoke, a new product that provides developers with a toolset for all application delivery platforms.
Posted May 08, 2014
Quality Assurance testing is a critical component of the software development lifecycle (SDLC), and failing to allow sufficient time for thorough testing can mean the difference between a successful, revenue-driving application and a costly, reputation-damaging outage. The importance of comprehensive QA testing has been hammered into the brains of developers since the beginning of modern-day application development, but traditional approaches to QA are no longer viable. There are three things shaking up QA today.
Posted April 23, 2014
Embarcadero Technologies, a provider of software solutions for application and database development, has launched Embarcadero RAD Studio XE6, a multi-device, natively compiled app development platform for Windows, Android, iOS, and Mac.
Posted April 15, 2014
TeamWork, a database change management solution from DBMaestro, is now available for SQL Server as well as Oracle.
Posted April 09, 2014
Denormalization of a database design is a legitimate tool, when used appropriately. However, it is simply sad and sometimes even silly to see designs denormalized as a matter of course.
Posted April 04, 2014
The COLLABORATE 14-OAUG Forum provides the venue for Oracle Applications users to meet peers using Oracle products, share knowledge, and get energized to achieve results. COLLABORATE-OAUG Forum offers technical and functional content covering Oracle E-Business Suite, Fusion Applications, Hyperion, Primavera, EPPM, EBS Extensions for Endeca, CRM On Demand, Siebel, and more.
Posted March 28, 2014
To help financial institutions meet new requirements, accelerate statistical model development and deployment and reduce model management complexity, Oracle Financial Services introduced Oracle Financial Services Analytical Applications R Modeling Framework as a new component for Oracle Financial Services Analytical Applications Infrastructure.
Posted March 26, 2014
Describing it as the most significant upgrade to the Java programming model ever, Oracle announced Java Platform, Standard Edition 8, as well as Java Platform, Micro Edition 8, and additional releases of Oracle's Java Embedded products.
Posted March 25, 2014
Using a single codebase, Appmethod, a new application development platform from Embarcadero, allows developers to build multi-device applications up to 20 times faster. The new platform delivers an end-to-end solution that aims to alleviate the increasing pressure on developers to quickly deliver new apps that support multiple platforms and devices, including smartphones, tablets, PCs and laptops.
Posted March 19, 2014
Embarcadero, a provider of software solutions for application and database development, is acquiring CA Technologies' ERwin Data Modeling solution. The acquisition will provide Embarcadero additional channel partners. ERwin is sold almost exclusively through more than 500 partners in over 70 countries.
Posted March 17, 2014
Historical content within data structures increases their complexity. Making complexity "easy" for the initial developers and "harder" for the later users is a short-sighted approach.
Posted March 12, 2014
ISUG-TECH 2014 in Atlanta, April 14-17, will be the first technology event to explore the features and functionality in Sybase ASE 16. The conference will provide more than 150 hours of technical session, more than 60 hours of workshops, and more than 50 expert speakers, and a range of workshops, including the SAP ASE Quick Start for Oracle and SQL Server DBAs workshop which will double as a refresher course for people who had been Sybase DBAs but have not recently been in that role.
Posted February 26, 2014
The latest release of Embarcadero's portfolio of database tools adds first-class support for Teradata in addition to updating support for the latest releases of the major RDBMSs. Overall, a key theme for the XE5 releases is an emphasis on scale, as big data, with big models and big applications, requires close collaboration across big teams, said Henry Olson, Embarcadero director of product management.
Posted February 26, 2014
In many organizations, users find it hard to trust their own internal information technology (IT) group, leading them to try any possible option to solve problems own their own. The resulting stealth IT projects can lead to confusion or even complete chaos.
Posted February 10, 2014