|By Govind Davis||
|August 7, 2014 03:24 PM EDT||
Data Sharing Features
Detailed below are three main ways that applications share data. The purpose of this article is not to detail the technical configuration of these features, but to explain their intended use, benefits, and risks.
Cross Application Relationships (Cross App)
Cross Apps allow a table in one QuickBase application to be shared to another application. The shared table, in effect, acts like a table in the shared-to application, even though it actually resides in another application. This has the benefit of allowing data into a single table and not having to re-enter or synchronize the data.
Table-to-Table Imports (TTI)
TTI are imports from one QuickBase table to another. TTIs can be within an application or across applications. The structure of the import can be saved and run manually. There is also an API, so the import can be programmatically executed. This is a great tool to synchronize data if a Cross App is not ideal.
Report Links are used on QuickBase forms to show data from other tables that are related by some key information. In most cases these are directly related tables, but they can also be configured to show data in other applications. This can be a good way to leverage organizational information from various applications on a rich form.
Application Clusters 101
QuickBase operates on a unique and proprietary technology framework. Applications run on a single server process that often has other applications running on it simultaneously. When data sharing features are used they cause the connected applications to act as a single application. This provides the benefit of having access to all of the data in memory and essentially functioning like a homogenous entity. The downside of this is that these application clusters can get very large and complex and may lead to performance challenges. They can also be quite difficult to unravel.
Over the years of developing QuickBase applications in highly complex environments, as well as dealing with some complex applications that have run into clustering issues, we feel a few common sense practices can help ensure the proper benefits of data sharing where appropriate and avoid risks.
- Make sure to plan and understand the use of data sharing features as well as clustering risk as part of an overall data architecture.
- Keep application clusters to well-defined and managed groups of applications that have a clear benefit from data sharing.
- Have other options available, such as programmatic synchronization of data using QuickBase API's where clustering may present a risk.
- Communicate clearly to application developers the risks associated with data sharing features and have a process to review and approve their use.
- Periodically check applications for clustering by adding ?a=listdependentdatabases to the url on any application home dashboard.
- Be cautious when copying applications as Cross Apps may be retained and Report Links will be retained which could cause a substantial increase in cluster size.
- Be very careful when adding previously built applications to a cluster as they may have complex networks of sharing in place that could suddenly grow the cluster far beyond what is expected.
- Understand that TTI will create what is called an Intermittent Dependency so the clustering only occurs when the TTI is run and will eventually decluster. This can help avoid clustering if planned properly during off-use hours, but can also be a source of unexplained performance issues if not managed properly.
MCFTech is a leading QuickBase Partner and highly experienced at handling complex scalability and system design challenges. For more information please visit our website at www.mcftech.com or complete our contact form and a client solutions representative will reach out to you.
SYS-CON Events announced today that Enzu, a leading provider of cloud hosting solutions, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to foc...
May. 26, 2016 04:15 PM EDT Reads: 2,151
SoftLayer operates a global cloud infrastructure platform built for Internet scale. With a global footprint of data centers and network points of presence, SoftLayer provides infrastructure as a service to leading-edge customers ranging from Web startups to global enterprises. SoftLayer's modular architecture, full-featured API, and sophisticated automation provide unparalleled performance and control. Its flexible unified platform seamlessly spans physical and virtual devices linked via a world...
May. 26, 2016 04:15 PM EDT Reads: 1,993
The IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discuss how businesses can gain an edge over competitors by empowering consumers to take control through IoT. We'll cite examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He'll also highlight how IoT can revitalize and restore outdated business models, making them profitable...
May. 26, 2016 04:15 PM EDT Reads: 2,720
SYS-CON Events announced today that BMC Software has been named "Siver Sponsor" of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2015 at the Javits Center in New York, New York. BMC is a global leader in innovative software solutions that help businesses transform into digital enterprises for the ultimate competitive advantage. BMC Digital Enterprise Management is a set of innovative IT solutions designed to make digital business fast, seamless, and optimized from mainframe to mo...
May. 26, 2016 04:00 PM EDT Reads: 2,027
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, will provide an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life ...
May. 26, 2016 04:00 PM EDT Reads: 1,859
As cloud and storage projections continue to rise, the number of organizations moving to the cloud is escalating and it is clear cloud storage is here to stay. However, is it secure? Data is the lifeblood for government entities, countries, cloud service providers and enterprises alike and losing or exposing that data can have disastrous results. There are new concepts for data storage on the horizon that will deliver secure solutions for storing and moving sensitive data around the world. ...
May. 26, 2016 04:00 PM EDT Reads: 1,201
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York and Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th Cloud Expo and will feature technical sessions from a rock star conference faculty ...
May. 26, 2016 03:45 PM EDT Reads: 2,486
Customer experience has become a competitive differentiator for companies, and it’s imperative that brands seamlessly connect the customer journey across all platforms. With the continued explosion of IoT, join us for a look at how to build a winning digital foundation in the connected era – today and in the future. In his session at @ThingsExpo, Chris Nguyen, Group Product Marketing Manager at Adobe, will discuss how to successfully leverage mobile, rapidly deploy content, capture real-time d...
May. 26, 2016 03:45 PM EDT Reads: 1,487
SYS-CON Events announced today that ContentMX, the marketing technology and services company with a singular mission to increase engagement and drive more conversations for enterprise, channel and SMB technology marketers, has been named “Sponsor & Exhibitor Lounge Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York. “CloudExpo is a great opportunity to start a conversation with new prospects, but what happens after the...
May. 26, 2016 03:45 PM EDT Reads: 975
SYS-CON Events announced today the How to Create Angular 2 Clients for the Cloud Workshop, being held June 7, 2016, in conjunction with 18th Cloud Expo | @ThingsExpo, at the Javits Center in New York, NY. Angular 2 is a complete re-write of the popular framework AngularJS. Programming in Angular 2 is greatly simplified. Now it’s a component-based well-performing framework. The immersive one-day workshop led by Yakov Fain, a Java Champion and a co-founder of the IT consultancy Farata Systems and...
May. 26, 2016 03:30 PM EDT Reads: 3,930
IoT generates lots of temporal data. But how do you unlock its value? How do you coordinate the diverse moving parts that must come together when developing your IoT product? What are the key challenges addressed by Data as a Service? How does cloud computing underlie and connect the notions of Digital and DevOps What is the impact of the API economy? What is the business imperative for Cognitive Computing? Get all these questions and hundreds more like them answered at the 18th Cloud Expo...
May. 26, 2016 03:30 PM EDT Reads: 2,186
Join us at Cloud Expo | @ThingsExpo 2016 – June 7-9 at the Javits Center in New York City and November 1-3 at the Santa Clara Convention Center in Santa Clara, CA – and deliver your unique message in a way that is striking and unforgettable by taking advantage of SYS-CON's unmatched high-impact, result-driven event / media packages.
May. 26, 2016 03:00 PM EDT Reads: 2,245
SYS-CON Events announced today that EastBanc Technologies will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. EastBanc Technologies has been working at the frontier of technology since 1999. Today, the firm provides full-lifecycle software development delivering flexible technology solutions that seamlessly integrate with existing systems – whether on premise or cloud. EastBanc Technologies partners with p...
May. 26, 2016 03:00 PM EDT Reads: 2,053
18th Cloud Expo, taking place June 7-9, 2016, at the Javits Center in New York City, NY, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Meanwhile, 94% of enterprises are using some...
May. 26, 2016 02:45 PM EDT Reads: 3,033
Companies can harness IoT and predictive analytics to sustain business continuity; predict and manage site performance during emergencies; minimize expensive reactive maintenance; and forecast equipment and maintenance budgets and expenditures. Providing cost-effective, uninterrupted service is challenging, particularly for organizations with geographically dispersed operations.
May. 26, 2016 02:30 PM EDT Reads: 1,800
SYS-CON Events announced today that Commvault, a global leader in enterprise data protection and information management, has been named “Bronze Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. Commvault is a leading provider of data protection and information management...
May. 26, 2016 01:30 PM EDT Reads: 2,962
What a difference a year makes. Organizations aren’t just talking about IoT possibilities, it is now baked into their core business strategy. With IoT, billions of devices generating data from different companies on different networks around the globe need to interact. From efficiency to better customer insights to completely new business models, IoT will turn traditional business models upside down. In the new customer-centric age, the key to success is delivering critical services and apps wit...
May. 26, 2016 01:00 PM EDT Reads: 1,071
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths in that visualization). In our opinion, the challenges stem from the technology diversity at each stage of the data pipeline as well as the lack of process around the analysis.
May. 26, 2016 01:00 PM EDT Reads: 1,324
SYS-CON Events announced today that Tintri Inc., a leading producer of VM-aware storage (VAS) for virtualization and cloud environments, will exhibit at the 18th International CloudExpo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA.
May. 26, 2016 11:45 AM EDT Reads: 2,202
Designing IoT applications is complex, but deploying them in a scalable fashion is even more complex. A scalable, API first IaaS cloud is a good start, but in order to understand the various components specific to deploying IoT applications, one needs to understand the architecture of these applications and figure out how to scale these components independently. In his session at @ThingsExpo, Nara Rajagopalan is CEO of Accelerite, will discuss the fundamental architecture of IoT applications, ...
May. 26, 2016 10:45 AM EDT Reads: 1,091