Data Modeling Articles
CA Technologies has signed a definitive agreement to acquire Rally Software Development Corp. a provider of Agile development software and services, for approximately $480 million, net of cash acquired.
Posted May 27, 2015
Building on its native support for a variety of database platforms - including Apache Hive for Hadoop, MongoDB Enterprise, and traditional relational database management systems (RDBMS) - Embarcadero Technologies' data modeling tool, ER/Studio Data Architect version 10.0, has been certified by HortonWorks and Mongo DB Enterprise.
Posted May 21, 2015
Chartio, a cloud business intelligence service, is introducing a new solution called Data Stores for transforming and storing data for business intelligence in a more agile way. Data Stores will enable administrators to use Chartio's Data Pipeline to rapidly transform data and store it in the cloud, making it more useful and accessible for end users.
Posted May 20, 2015
RedPoint Global was founded in 2006 by Dale Renner, Lewis Clemmens, and George Corugedo, who previously had worked together at Accenture. Based in Wellesley, Mass., RedPoint collaborates with clients around the world in 11 different verticals. "We have always been very focused on the data, and recognize that a lot of business problems live and die by the quality of the data," says Corugedo.
Posted May 19, 2015
The objects and relationships identified within any database design need to match with the very subjective realities considered true within a given organization. An optimal data model must incorporate the semantics of the business and provide for a structural arrangement supporting the necessary corporate instrumentality. And that model should do so, even if in the details things within the model are contrary to what other organizations may consider to be the nature of their reality.
Posted May 14, 2015
Oracle has announced that Oracle SQL Developer version 4.1, Oracle SQL Developer Data Modeler 4.1, and Oracle REST Data Services version 3.0 are now generally available. A common theme across all three new releases is an emphasis on making developers lives easier, said Kris Rice, senior director of database tools, Oracle. "Everything revolves around the data."
Posted May 06, 2015
When databases are built from a well-designed data model, the resulting structures provide increased value to the organization. The value derived from the data model exhibits itself in the form of minimized redundancy, maximized data integrity, increased stability, better data sharing, increased consistency, more timely access to data, and better usability.
Posted May 06, 2015
Embarcadero Technologies, a provider of software solutions for application and database development, has unveiled the new XE7 version of ER/Studio, its flagship data architecture suite.
Posted April 28, 2015
NOAD, a provider of enterprise platform management for SAP BusinessObjects business intelligence (BI) solutions, has announced that following a rigorous testing process the software solution NOAD EQM4, version 3.3, has achieved certified integration with the SAP BusinessObjects BI platform, version 4.1. NOAD EQM4 3.3 provides developers working with the SAP BusinessObjects BI platform a reliable and stable solution to develop independently in a controlled environment.
Posted March 25, 2015
Oracle announced that fiscal 2015 Q3 total revenues were unchanged at $9.3 billion. Without the currency headwinds caused by the strengthening of the U.S. dollar, the company said total revenues would have been up 6% as measured in constant currency. "Oracle now has a cloud revenue run rate of well over $2 billion a year. We are already the world's second largest SaaS and PaaS company," said Oracle chairman and CTO Larry Ellison during a conference call discussing Oracle's third quarter financial results.
Posted March 18, 2015
COLLABORATE 15 - Technology and Applications Forum for the Oracle Community (hashtag #C15LV) is back in Las Vegas April 12-16, 2015 at the Mandalay Bay Resort and Casino, offering a wide variety of education and valuable opportunities for collaboration among peers. The more than 1250 planned education sessions in 17 tracks were sourced through the user communities of IOUG, OAUG and Quest and selected through a competitive process. The result is an agenda packed with relevant insights for functional as well as technical users, beginner to advanced.
Posted March 17, 2015
The 55,000+ member Quest International Users Group supports JD Edwards, PeopleSoft, Fusion, and many other Oracle edge application customers and offers tons of resources to make your job easier. Here are just a few reasons you should go Quest green at COLLABORATE 15.
Posted March 17, 2015
In information services, providing a solution that removes a user's pain can be a great boost to one's psyche. Being the hero, wins trust, and may even enhance job security. However, organizationally, too many sideline heroics create chaos. The day after the crisis has passed, things are left in a less than wonderful state.
Posted March 12, 2015
One of the trickiest aspects of relational database management can be dealing with missing information. The standard method of representing missing information is to set the "value" to null.
Posted March 12, 2015
Early bird pricing has been extended to February 28 for ISUG-TECH's 2015 conference taking place March 29-April 2 at the Hilton Atlanta in Atlanta, Georgia. "This conference provides a unique opportunity for attendees to take advantage of some really in-depth training that they don't typically get exposure to - especially when you talk about ASE, IQ, PowerBuilder, PowerDesigner, and HANA. The folks that are putting on the training sessions for us are the most senior product engineers," said Bryan Enochs, acting president at ISUG-TECH.
Posted February 25, 2015
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 25, 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