Data Modeling Articles
The "Internet of Things" (IoT) is opening up a new world of data interchange between devices, sensors, and applications, enabling businesses to monitor, in real time, the health and performance of products long after they leave the production premises. At the same time, enterprises now have access to valuable data—again, in real time if desired—on how customers are adopting products and services.
Posted February 18, 2015
In the early days of data warehousing, lines were very simple. The data warehouse reflected the business. In providing this reflection, data was summarized, data was cleansed, data was standardized, and data was even drastically reformatted for legibility and reporting usage. But, the big rule of thumb, the never-to-be-crossed line, was that the data warehouse did not create new data.
Posted February 11, 2015
Attunity recently added new capabilities to its solution suite with the acquisition of BIReady's data warehouse automation technology, which eliminates the complex, manual tasks of preparing data for BI and big data analytics. Lawrence Schwartz, Attunity's vice president of marketing, spoke with DBTA about BIReady and other Attunity solutions for customers dealing with big data projects.
Posted February 11, 2015
Microsoft is acquiring Revolution Analytics, a commercial provider of software and services for R, a programming language for statistical computing and predictive analytics using big data.
Posted January 23, 2015
Registration is now open for Data Summit 2015, providing the opportunity to connect with the best minds in the industry, learn what works, and chart your course forward in an increasingly data-driven world. The event is designed to offer a comprehensive educational experience designed to guide attendees through the key issues in data management and analysis today.
Posted January 21, 2015
SOA Software, a cloud services management vendor, announced an updated solution that provides broader support for API description languages including RAML, Swagger, WSDL, and WADL. The vendor's API Management platform now supports for multiple API Description Languages (API DL), intended to help enterprises secure, manage, and monetize APIs described in RAML, Swagger, WSDL, or WADL. "API DL languages are still evolving - new languages are emerging and as of now, there is no clear leader," said Alistair Farquharson, CTO of SOA Software.
Posted January 20, 2015
Embarcadero Technologies, a provider of software solutions for application and database development, has acquired Castalia for Delphi and Usertility from TwoDesk Software. Embarcadero will integrate the productivity features of Castalia into RAD Studio's integrated development environment (IDE) and also feature Usertility, a service for monitoring app usage.
Posted January 20, 2015
The manageability track at COLLABORATE 15 - IOUG Forum is designed to provide DBAs of every experience level and industry with the knowledge set to streamline IT management processes at their organization and accelerate their transformation to cloud.
Posted January 14, 2015
Many designers seem to approach a database design as if there is a single objective reality that circumscribes all truth and that happens to align with exactly how they see the world. Honestly, is it expected that there is an absolute truth for everything? And that single absolute truth goes from the highest level of abstraction to the lowest level of detail?
Posted January 07, 2015
Shunryu Suzuki, in his classic book, Zen Mind, Beginner's Mind, tells us that in the beginner's mind there are many possibilities, but in the expert's mind there are few. Both a beginner's and an expert's perspective have value, but bias toward either an expert or a beginner approach seems to consume an organization far too often.
Posted December 03, 2014
DBmaestro, a provider of DevOps for database solutions, has announced the availability of an open application programming interface (API), enabling customers and developers to connect to any release management system and continuous delivery product. According to the vendor, DBmaestro TeamWork will now automate and integrate with IBM, Microsoft, CA and others, allowing any release management manufacturer to offer database build and deploy automation and adding functionality to its product.
Posted December 02, 2014
IBM is bringing a greater level of control, security and flexibility to cloud-based application development and delivery with a single-tenant version of Bluemix, the company's platform-as-a-service. The new platform allows developers to build applications around their most sensitive data and deploy them in a dedicated cloud environment while avoiding the compliance, regulatory and performance issues that are presented with public clouds.
Posted November 21, 2014
Early bird registration for the ISUG-TECH 2015 conference in Atlanta is now open. The conference will be held March 29 - April 2, 2015, at the Hilton Atlanta in Atlanta, Georgia.
Posted November 20, 2014
Oracle has introduced a new release of its developer tool suite, Solaris Studio, with enhanced analysis tools and support for the latest programming language standards. "Oracle Solaris Studio engineers work closely with the Oracle Solaris and SPARC design teams to ensure the compilers generate the best possible code for Oracle servers," said Don Kretsch, senior director, Software Development, Oracle.
Posted November 19, 2014
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