Data Modeling Articles
There was a time when what you saw was what you got. Building up the components of a business intelligence area was very straight-forward. A staging area was a staging area; an operational data store was an operational data store. But like buying a pitcher of beer for $2, or gas for less than a dollar per gallon, those days are gone. The dynamics have changed, things are more federated, and IT must accept more than one standard tool.
Posted January 03, 2017
Java started its life in the early 1990s as an attempt to develop an architecture-independent language that could be used in consumer electronics and other embedded contexts. It found itself in the right place at the right time when the web exploded in the mid-1990s and over the next 10 years became one of the mainstays of web development. Today, Java remains as popular as ever. It's arguably the most popular programming language of our generation.
Posted January 03, 2017
The past year was a blockbuster one for those working in the data space. Businesses have wrapped their fates around data analytics in an even tighter embrace as competition intensifies and the drive for greater innovation becomes a top priority. The year ahead promises to get even more interesting, especially for data managers and professionals. Leading experts in the field have witnessed a number of data trends emerge in 2016, and now see new developments coming into view for 2017.
Posted January 03, 2017
Arcadia Data, provider of real-time modern business intelligence (BI) platforms, is releasing Arcadia Enterprise 3.3, making significant upgrades to uncover real-time insights. The new features - including Arcadia Smart Acceleration, advanced segmentation and cohort analytics, analytic extensions, and mobile and tablet support - unify real-time insights from streaming data with historical data discovery in a single view.
Posted December 20, 2016
IBM has announced new Bluemix services designed to simplify and speed app development in the cloud. With these new services, developers can now access and construct preconfigured toolchains using popular DevOps tools, including GitHub and Slack.
Posted December 12, 2016
Scribe Software is releasing the next generation of Scribe Online, offering a completely revamped user experience and an extended application programming interface. The new update simplifies and accelerates the process of creating and maintaining integrations between cloud services, on-premises applications, and databases.
Posted December 08, 2016
Terms such as "active," "inactive," and "canceled" may seem mundane and inconsequential, and when folks hear the term,"valid values," their eyes glaze and expectations of interest diminish. But exciting or not, reference values and an understanding of them are important to every organization.
Posted December 01, 2016
Yellowfin, business intelligence (BI) and analytics software vendor, is launching a virtualized data preparation module for analytics, fully integrating it into the metadata layer of its BI platform. Yellowfin's Data Preparation Module will enable organizations to model, profile, clean, shape, enrich, secure, and publish all data for reporting and analytics in a single BI environment.
Posted December 01, 2016
What's ahead for 2017 in terms of big data and IoT? IT executives reflect on the impact that Spark, blockchain, data lakes, cognitive computing,AI and machine learning, and other cutting-edge approaches may have on data management and analytics over the year ahead.
Posted November 30, 2016
Redgate, a Cambridge-UK based software company that develops SQL Server tools, has launched the beta of its new database cloning tool called SQL Clone that enables databases to be cloned quickly while saving up to 99% of disk space.
Posted November 28, 2016
Expanding the capabilities for customers to take advantage of the elasticity of Apache Hadoop and Apache Spark in the cloud to power new workloads and analytic applications, Hortonworks, Inc. has announced the availability of Hortonworks Data Cloud on the AWS Cloud.
Posted November 15, 2016
Why is there such pervasive abuse and misuse of database views today? Views are a helpful tool in building a business intelligence environment, yet many organizations establish practices that not only rob views of their full usefulness but present patterns that actually confuse issues instead.
Posted November 02, 2016
Data has become a disruptive force for global businesses and a catalyst for digital transformation. But data can only be leveraged for BI initiatives to the extent it can be accessed and trusted. And, while today's self-service BI and analytics tools satisfy a user's craving for more "consumerized" technology, they often leave an analyst stuck in neutral because the users, first and foremost, cannot find the data they need to perform any analysis.
Posted November 02, 2016
Trifacta, a provider of data wrangling solutions, is launching Wrangler Edge, a platform designed for analyst teams wrangling diverse data outside of big data environments. "We are packing the Trifacta product and adding enterprise features such as the ability to schedule jobs to handle larger data volumes to connect to diverse sources," said Will Davis, director of product marketing. "We also added collaboration and sharing features as well all without requiring organizations to manage a large Hadoop infrastructure."
Posted November 01, 2016
Compuware has unveiled new REST APIs for ISPW, the source code management and release automation solution that it acquired in January 2016. The new APIs are designed to help enable enterprises to integrate their numerous other mainframe and non-mainframe DevOps tools with ISPW to create their own custom cross-platform DevOps toolchains.
Posted October 17, 2016
Typically, most applications consist of both batch and online workloads. This is true even today, when most of our attention has turned to online and web-based interaction. Sure, online activities are the most obvious, in-your-face component of countless applications, but batch processing still drives many actions behind the scenes. This can include applying updates, processing reports, integrating input from multiple sources and locations, data extraction, database utility processing, and more.
Posted October 07, 2016
One symptom of an organization in the middle of a knowledge vacuum is evidenced by SQL that often includes what appears to be extravagant usage of the GROUP BY clause. Writing GROUP BYs here, there, and everywhere becomes a little SQL development dance step, a jitterbug to bypass the issue—moving but not really getting anywhere. Why do these kinds of circumstances exist? Well, maybe the only expert on the involved system has retired and no one else has picked up the torch, so no one is willing to touch the code.
Posted October 07, 2016
Vormetric, a Thales company, is releasing a new platform called Thales Orchestrator, to help reduce the cost of protecting data at rest across organizations. Thales Orchestrator's features include live data transformation, key management-as-a-service, Bring Your Own (encryption) Key management for AWS with Thales HSMs, vaultless tokenization, and Docker Encryption and Access Controls. Docker data-at-rest encryption and access controls that help to assure container images and file systems are controlled and secure.
Posted October 06, 2016
Syncsort is incorporating new open metadata management capabilities in its DMX-h data integration software that, along with its seamless integration with Cloudera Navigator, aim to make big data governance easier.DMX-h provides organizations with a single interface for accessing and integrating all enterprise data, including IBM z mainframes, and the flexibility to use the metadata repository that best meets their needs, on premise and in the cloud.
Posted October 04, 2016
MariaDB Corporation is updating its MaxScale platform, adding a data streaming integration with Kafka, enhanced security, and high availability capabilities. MariaDB MaxScale is a next-generation database proxy that manages administrative functions like security, scalability, data streaming and high availability, enabling the database to focus on core functionality to drive faster innovation.
Posted October 03, 2016
Database Brothers, Inc. (DBI) has released V6.3 of its flagship product, pureFeat Performance Management Suite for IBM DB2 LUW, which adds the Predictive Index Impact Analysis capability.
Posted September 27, 2016
In his keynote on Monday at Oracle OpenWorld 2016, Oracle CEO Mark Hurd showcased customer success stories and offered three new predictions for the future of cloud, which, he said, represents a generational shift in the IT market.
Posted September 21, 2016
Trifacta is releasing an enhanced version of its namesake platform, further boosting its data wrangling capabilities and bolstering the solution for more data sources and diverse users. The v4 release extends the ability of users to directly connect to a variety of enterprise data sources, including Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and Teradata, and expands support for customers deploying Trifacta in cloud environments such as Amazon Web Services, Google Cloud Platform, and Microsoft Azure.
Posted September 20, 2016
Percona, provider of MySQL and MongoDB solutions and services, is releasing an open source database performance analysis tool that will enable DBAs and application developers to optimize the performance of their MySQL and MongoDB databases.
Posted September 13, 2016
erwin Inc. has acquired UK-based Corso Ltd, a provider of enterprise architecture solutions. erwin has also announced general availability of erwin CloudCore, an integrated cloud bundle consisting of erwin Data Modeler and Corso Agile EA.
Posted September 12, 2016
Conventional wisdom insists that IT will migrate to the cloud entirely at some point. But practical experience shows that enterprises that have invested in legacy architecture that still has many years of life left in it are not likely to rip and replace, at potentially astronomical costs. Instead, implementing a Bimodal IT approach supported by SDDC on integrated systems will allow companies to address scalability needs with agility, while also ensuring the mission-critical functions of their legacy systems are not compromised.
Posted September 12, 2016
The Independent Oracle Users Group (IOUG) is excited to be joining the Oracle technology community in San Francisco once again at Oracle OpenWorld 2016, September 18-22. IOUG's 30,0000+ member community is comprised of the top Oracle technology experts from around the globe, several of whom will be presenting sessions on hot topics like Data Intelligence, iOT, Data Security, and Cloud migrations.
Posted September 07, 2016
Datawatch Corporation unveiled an enhanced version of its self-service data preparation solution, making the platform faster and more intuitive. Datawatch Monarch 13.5 empowers business users and data analysts to overcome traditional data access and preparation challenges by enabling them to easily and rapidly mine data from virtually any source and then manipulate, blend, enrich, and prepare it for use in analytics tools or optimizing manually intensive business processes.
Posted September 07, 2016
Programming is a literal sport. Code does exactly what it is configured to do, no compromises. When the definition of a task is fuzzy, it is up to the developer to do what they believe is correct. Does the code reflect what is desired? That answer is left open to interpretation. Sadly, developers may not have a clear understanding, and even the users requesting the solution may not be sure. The results can be very painful for an organization. Expectations may not align with the delivered solutions. Users will blame IT; IT will blame users.
Posted September 02, 2016
IBM has announced that Workday, a provider of enterprise cloud applications for finance and human resources, has adopted the IBM Cloud as part of a multi-year strategic partnership. IBM Cloud will become the foundation for Workday's development and testing environment. IBM Cloud will provide capacity expansion in support of Workday's development and testing requirements. "Workday will use IBM Cloud to continue accelerating Workday's internal development and testing efforts to support our ongoing global expansion," said Aneel Bhusri, co-founder and CEO of Workday.
Posted August 22, 2016
Nimbus Data is releasing a new all-flash platform for cloud, big data, virtualization, and massive digital content that will offer unprecedented scale and efficiency.
Posted August 09, 2016
Datameer is launching a newly redesigned Global Partner Program to recruit and enable a dynamic ecosystem of technology, services, and reseller partners. Datameer's new program introduces a rewards system that recognizes partners and helps form a trusted and easily accessible network for customers.
Posted August 09, 2016
Thousands of members of the Oracle Applications Users Group (OAUG) get the answers they need by sharing best practices, case studies and lessons learned. As the world's largest education, networking and advocacy forum for users of Oracle Applications, the OAUG helps members connect to find the solutions they need to do their jobs better and to improve their organizations' return on investment in Oracle Applications.
Posted August 04, 2016
Anyone who has ever attended Oracle OpenWorld knows that you must plan ahead. The conference held in San Francisco each fall is vast, and the upcoming conference, scheduled for September 18-22, 2016, promises to be equally expansive. Just as in years before, tens of thousands of attendees from well over 100 countries can be expected converge to learn more about Oracle's ever-expanding ecosystem of technologies, products and services during thousands of sessions held at the Moscone Center and multiple additional venues in downtown San Francisco. Here, Database Trends and Applications presents the annual Who to See @ Oracle OpenWorld special section.
Posted August 04, 2016
As one works through the normal forms, be it a journey to the placid shores of third normal, or the more arid climes of Boyce-Codd normal form, or even the cloudy peaks of fourth normal and beyond—and before one starts thinking about normalizing the design—the database designer has covered a lot of ground work already. Before thinking of normalizing, one needs to have conceptualized the relations that might be within the solution's scope.
Posted August 04, 2016
Oracle announced today that it is acquiring NetSuite in a transaction valued at approximately $9.3 billion. The transaction is expected to close in 2016. In a statement, Zach Nelson, CEO of NetSuite, said that NetSuite will benefit from Oracle's global scale and reach to accelerate the availability of its cloud solutions.
Posted August 03, 2016
To manage growing data volumes and pressing SLAs, many companies are leveraging Apache™ Kafka and award-winning Attunity Replicate with next-generation change data capture (CDC) for streaming data ingest and processing.
Posted August 03, 2016
The potential of your business intelligence or data processing application is limited without a comprehensive data connectivity solution. Staying competitive and relevant requires a breadth of data connectivity options.
Posted August 03, 2016
Our goal at Amazon Web Services (AWS) is to enable our customers to do things that were previously not possible, and make things that our customers can already do simpler and better at a much lower cost.
Posted August 03, 2016
It is both exciting and validating to be selected as the number 1 data modeling solution by DBTA's discerning readers for the third consecutive year in a row!
Posted August 03, 2016
Data replication advances a number of enterprise goals, supporting scenarios such as distribution of information as part of business intelligence and reporting initiatives, facilitating high availability and disaster recovery, and as part of a no-downtime migration initiative.
Posted August 03, 2016
Everyone knows the three Vs, volume, velocity, and variety, of big data but what's required is a solution that can extract valuable insights from new sources such as social networks email, sensors, connected devices as sensors, the web, and smartphones.
Posted August 03, 2016
Query and reporting solutions are part of a comprehensive business intelligence approach in every organization. As long as enterprises need to gather data, BI groups look to utilize query and report programs as primary applications that produce output from information systems
Posted August 03, 2016
As data grows, organizations are looking for ways to dig up insights from underneath layers of information. Data mining solutions provide the tools that enable them to view those hidden gems and facilitate better understanding of new business opportunities, competitive situations, and complex challenges.
Posted August 03, 2016
Business intelligence encompasses a variety of tools that enable organizations to collect data from internal systems and external sources, prepare it for analysis, develop, and run queries against the data, and create reports, dashboards and data visualizations.
Posted August 03, 2016
Data virtualization provides organizations with the ability to allow the business and IT sides of organizations to work closer together in a much more agile fashion, and helps to reduce the complexity.
Posted August 03, 2016
Data integration is critical to many organizational initiatives such as business intelligence, sales and marketing, customer service, R&D, and engineering. For many enterprises, however, the road to data-driven nirvana is stymied by the inflexible, calcified systems and processes that were laid out decades earlier and still control the data flow within many enterprises, according to Joe McKendrick, lead research analyst at Unisphere Research.
Posted August 03, 2016
The last thing companies want is tainted data merging with incorrect information. The process of maintaining data integrity enhances the reliability of information for use by a business. This is where tools to ensure data quality come in.
Posted August 03, 2016