Data Modeling Articles
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
Changes and enhancement to solutions are hard, even under the best of circumstances. It is not usual that, as operational changes roll out into production, the business intelligence area is left uninformed, suggesting that data warehouses and business intelligence be categorized according to the view of the old comedian Rodney Dangerfield because they both "get no respect."
Posted January 07, 2014
The newest release of Oracle SQL Developer, Oracle's integrated development environment, optimizes development and database administration for Oracle Database 12c and expands automation of third-party migrations to Oracle. Addressing the need for user-friendly tools to speed and simplify development and data management activities, Oracle is seeking to increase productivity for database development tasks so organizations can fully capitalize on the power of enterprise data.
Posted December 23, 2013
SAP is strengthening its commitment to the developer community with key open source contributions, a real-time development experience for SAP HANA, and the publication of a new unified developer license.
Posted December 18, 2013
The latest release of CA ERwin Data Modeler, a solution for collaboratively visualizing and managing business data, addresses two major objectives - the need for organizations to manage more data across more platforms, and to easily share that data with an expanding number of users with a range of roles and skill sets.
Posted December 17, 2013
OpenText, a provider of Enterprise Information Management (EIM) software, has announced Project Red Oxygen, which the company describes as a "harmonized" release of new EIM software advancements designed to give CIOs the ability to extract value from their enterprise information and accelerate competitive advantage.
Posted December 02, 2013
Two new approaches to application quality have emerged: "risk-based testing" - pioneered in particular by Rex Black - and "exploratory testing" - as evangelized by James Bach and others. Neither claim to eradicate issues of application quality, which most likely will continue as long as software coding involves human beings. However, along with automation of the more routine tests, these techniques form the basis for higher quality application software.
Posted November 20, 2013
Changes to database structures should be performed in a coordinated fashion as the application processes that support the new functionality are rolled out into production. While the "work" involved in adding a column or a table to a relational database is actually minimal, often there are circumstances where developers and DBAs create additional columns and additional tables in anticipation of future needs. Sadly, this "proactive" effort results in databases littered with half-formed ideas, fits-and-starts, and scattered-about columns and tables that provide no meaningful content.
Posted November 13, 2013
Constantly changing tax rules can make payroll deductions and tax payments a time-consuming and costly endeavor for businesses. To get this onerous job done efficiently and cost-effectively, many utilize payroll software specialists that provide tools to support their in-house staff. Read how Revelation Software's OpenInsight and OpenInsight for Web are giving Ardbrook, a Dublin, Ireland-based software provider of payroll software, the agility it needs.
Posted October 23, 2013
Oracle has released the latest version of VM VirtualBox which provides a virtual multi-touch user interface, supports additional devices and platforms, and offers enhanced networking capabilities that allow developers to virtualize modern operating system features while maintaining compatibility with legacy operating systems. Designed for IT professionals, Oracle VM VirtualBox is cross-platform virtualization software that enables users to run multiple operating systems at the same time.
Posted October 16, 2013
How does one avoid the semantically wishy-washy use of NULL-surrogates and instead, actually design structures wherein NULLs are not necessary?
Posted October 09, 2013
A successful DBA must understand application development and the issues involved in programming and design. Here are some things that every DBA must know about application development and the design projects of their organization.
Posted October 09, 2013