At the conference, the companies will demonstrate Tom Sawyer Perspectives, graphics-based software used for building visual analysis applications, and InfiniteGraph, the leading distributed graph database. Applications built with Tom Sawyer Perspectives using InfiniteGraph’s distributed graph database technology enable enterprise and government organizations to identify complex patterns and relationships in Big Data to address emerging opportunities and threats.
To read the full release visit Tom Sawyer Software
Contributed by Brian Clark, VP Product Management
Scalable and distributed graph databases, like InfiniteGraph, are designed to manage the relationships and connections between data points, like patient records and treatment options.
There are many common modeling patterns when storing applications data in a database. Much of the data fits neatly into rows and columns of a relational database (RDBMS); modeling relationships as joins between two tables.
In cases where there is a “many-to-many” relationship, such as a customer buys many products, a product is bought by many customers – a join table is used to show those relationships. Information about patients, drugs, and specific patient reactions to medication fall into this type of many-to-many relationship scenario, as shown in the diagrams following.
Upon further analysis, there may be a need to define the many-to-many relationship as an object itself that has its own data, e.g. date, symptoms, etc. In graph terms, the relationship is known as an Edge. Navigating through the encounter is an easy operation. However, if the number of joins or the number of tables used in a query get very large this can become a problem for a relational database.
Patient allergic reactions to a drug’s ingredients.
In this use case a patient is prescribed drug medications. Each drug is made from a number of different ingredients. A patient may have allergic reactions to any of the ingredients in the drug. The doctor needs to know if prescribing the drug will cause an allergic reaction.
This is a variation of the many-to-many problems. In this case we need to calculate the intersection of the ingredients in the drug and the ingredients the patient has allergic reactions to. Performing traversals from the patient, through the drug allergy and ingredient, to the drug will render if the prescription is safe or not.
Objectivity, Inc. will be releasing a sample of this functionality using InfiniteGraph which generates 100,000 patients using random name data from the Census Bureau, and drug information downloaded from the FDA National Drug Code database. A number of patients are randomly chosen and for each patient we create 5 allergic reactions to 5 randomly chosen ingredients. Then we try to prescribe a drug medication to a patient, and the system tells us straight away if the drug contains an ingredient that the patient is allergic to.
This can be performed in code using iterators (similar to a SQL SELECT and a cursor) to perform the traversal. A more natural way using a graph database is to set up a navigator and then use qualifiers to control the navigation. In InfiniteGraph the navigator and qualifiers can be provided as plugins that can be re-used by the InfiniteGraph visualizer.
In the visualizer we can look up an index of MMI (patient ids) to find a specific patient and display the graph of all connections from the patient. As you can see below this is a lot of data. However, using the plugin capabilities of InfiniteGraph and the visualizer we can perform the specific query looking for allergic reactions to a prescribed drug for a specific patient .
After using the navigator plugin to filter the query we see that there is an allergic reaction to the prescribed drug.:
The World Health Organization estimates that 60% of adverse drug reactions are avoidable. The implications of having this type of application widely accessible could easily help to save lives from deadly allergic reactions that may remain unknown otherwise.
“Adverse Reactions to Drugs Cause Hospitalization of 1.5 Million Americans Each Year” (http://www.worstpills.org/public/page.cfm?op_id=4)
With applications like this one from InfiniteGraph, medical practitioners everywhere would be able to reduce adverse reactions to prescription drugs, improving treatment outcomes.
Interested in learning more about graph databases and how to get started? We have just released the first set of tutorials that highlight how to download the free version of Objectivity’s scalable and distributed graph database, InfiniteGraph. In these 4-6 minute video tutorials, we walk you through the quick steps to downloading our software and show how to get started with our FlightPlan sample application code. If you haven’t seen the tutorials yet, you can see them here!
For access to additional free sample applications, visit our InfiniteGraph Wiki and check out the list of sample application codes available for download here.
Visit Objectivity at upcoming shows to learn more! Check out our calendar!
Advanced Features Make It Easy for Developers to Create, Define, Repeat, and Visualize Results in Minutes
SUNNYVALE, CA–(Marketwire – February 21, 2012) – Objectivity, Inc. announced today the additions of a new Plugin Framework, integrated Visualizer, and support for Tinkerpop Blueprints in their graph database InfiniteGraph. These advanced features are designed to allow application developers to get started quicker, make queries reusable, and receive query results interactively. With InfiniteGraph, Objectivity brings to market commercially proven Big Data Analytics that complement existing infrastructure.
“Of the numerous varieties of NoSQL databases, graph databases have the potential to significantly alter the analytics sector by enabling companies to unlock value based on understanding and analyzing the relationships between data,” said Matt Aslett, research management, data management and analytics, 451 Research. “The new additions to Objectivity’s InfiniteGraph enable developers to achieve results in real time and also realize additional value by making the queries repeatable.”
InfiniteGraph’s Plugin Framework provides developers with the ultimate in flexibility and supports the creation, import, and repeated use of plugins that modularize useful functionality. Developers can leverage successful queries, adjust parameters when appropriate, test queries and gain real-time results. A Navigator plugin bundles components that assist in navigation queries, e.g. result qualifiers, path qualifiers, and guides. The Formatter plugin formats and outputs results of graph queries. These plugins can be loaded and used in the InfiniteGraph Visualizer, and reused in InfiniteGraph applications.
Enhanced IG Visualizer:
The Visualizer is now tightly integrated with InfiniteGraph’s Plugin Framework allowing indexing queries for edges and export of GraphML and JSON (built-in) or other user-defined plugin formats. The Visualizer allows users to easily load plugins with enhanced control and navigation. Developers can parameterize plugins to control runtime behavior. Now every part of the graph is fully customizable and delivers a sophisticated result display for each query.
Support for Tinkerpop Blueprints:
InfiniteGraph provides a clean integration with Tinkerpop Blueprints, a popular property graph model interface with provided implementations, and is well-suited for applications that want to traverse and query graph databases using Gremlin.
Release 2.1 also provides placement configuration tools for updates, such as adding new servers and additional storage. Additionally, Objectivity offers two Professional Service Pack (PSP) options to assist clients in migrating applications to the InfiniteGraph architecture seamlessly from single-server architecture applications or to quickly get started with evaluating a proof of concept.
“We have been solving the Big Data problem for decades,” said Jay Jarell, President and CEO of Objectivity. “InfiniteGraph’s new features and functionality allow developers greater flexibility when building applications to leverage complex data, without losing our real-time performance advantage. Removing complexity and reducing time to results is a priority for Objectivity. We are excited to help customers maximize their existing infrastructure investments by continuously improving our complementary solution for advanced Big Data Analytics.”
About Objectivity, Inc.
Since 1988 Objectivity, Inc. has been the Enterprise NoSQL leader, helping customers harness the power of Big Data. Our leading-edge technologies: InfiniteGraph, a unique distributed, scalable graph database and Objectivity/DB, a distributed and scalable object management database, enable organizations to discover hidden relationships for improved Big Data analytics and develop applications with significant time-to-market advantages and technical cost savings, achieving greater return on data-related investments.
Objectivity, Inc. is committed to our customers’ success, with representatives worldwide. Our clients include: AWD Financial, CUNA Mutual, Drager Medical, Ericsson, McKesson, IPL, Siemens and the US Department of Defense. Visit http://www.objectivity.com.
# # #
Note to editors: Objectivity, Inc., Objectivity/DB and InfiniteGraph are trademarks of Objectivity, Inc. All other company, organization, product or alliance names mentioned herein remain the property of their respective owners.
For more information contact:
Press Contact: Objectivity Public Relations
Contributed by Victor Nelson, InfiniteGraph Product Management Team
The fact that a business is constantly changing means that the IT technologies it depends on need to accommodate a wide variety of circumstances. Of course you plan, but the future is fuzzy so best to build in some leeway. Scalability of architecture and individual components is a practical design consideration, and I was reminded of that in a paragraph from author Mike Loukides, VP of Content Strategy for O’Reilly Media, Inc.
“Whether you’re building a customer-facing application or doing internal analytics, scalability is a big issue. Vertical scalability (buy a bigger, faster machine) always runs into limits. Now that the laws of physics have stalled Intel-architecture clock speeds in the 3.5GHz range, those limits are more apparent than ever. Horizontal scalability (build a distributed system with more nodes) is the only way to scale indefinitely. You’re scaling horizontally even if you’re only buying single boxes: it’s been a long time since I’ve seen a server (or even a high-end desktop) that doesn’t sport at least four cores. Horizontal scalability is tougher when you’re scaling across racks of servers at a colocation facility, but don’t be deceived: that’s how scalability works in the 21st century, even on your laptop. Even in your cell phone. We need database technologies that aren’t just fast on single servers: they must also scale across multiple servers.”
Most NOSQL databases are highly scalable and InfiniteGraph is no exception. As number of transactions or other business metrics grow the database grows. The database can be distributed over a number of networked systems, and threads can make use of multiple cores. Strength in numbers. There are other benefits to a distributed architecture besides scalability, but that’s for another blog posting.
BTW, you can read the whole of Mike’s article at http://radar.oreilly.com/2012/02/nosql-non-relational-database.html.