The Deductive Spreadsheet by Iliano Cervesato (auth.)

Posted by

By Iliano Cervesato (auth.)

This ebook describes contemporary multidisciplinary learn on the confluence of the fields of common sense programming, database idea and human-computer interplay. The objective of this attempt was once to boost the root of a deductive spreadsheet, a consumer productiveness program that enables clients with no formal education in machine technological know-how to make judgements approximately common facts within the comparable easy manner they at the moment use spreadsheets to make judgements approximately numerical info. the result's a sublime layout supported through the latest advancements within the above disciplines.

The first 1/2 the e-book specializes in the deductive engine that underlies this software, the principles that clients don't see. After giving a mathematical version of conventional spreadsheet functions, we expand them with operators to accomplish a few relational projects, just like the person view of a database yet in a spreadsheet context. Expressing this extension in a good judgment programming framework is a traditional step in the direction of giving it strong deductive features. the second one 1/2 the ebook bargains with the person interface, the a part of the appliance with which the person really interacts. We assessment the weather of the graphical consumer interface of conventional spreadsheet purposes and describe sensible methodologies for designing consumer interfaces borrowed from the sphere of cognitive psychology. We then suggest a layout that conservatively integrates mechanisms for a consumer to use the recent deductive features. this is often by means of the result of a few initial usability experiments.

The booklet will attract researchers and practitioners within the a number of components underlying this paintings. Researchers won't simply locate fascinating new advancements of their domain names, yet also will methods to in attaining a multidisciplinary concentration. Practitioners will locate totally constructed strategies to various difficulties that aren't simply solvable utilizing conventional spreadsheet applications.

Show description

Read Online or Download The Deductive Spreadsheet PDF

Best nonfiction_9 books

Challenges in Inflammatory Bowel Disease, Second Edition

Experiences centred subject matters – either medical and uncomplicated technology - within the fast-moving region of IBD, delivering emphasis at the present demanding situations confronted within the winning administration of the diseaseTurn to demanding situations in Inflammatory Bowel sickness (IBD) for those who desire knowledgeable opinion at the new, strange or arguable parts of IBD and never simply the attempted and proven details.

Differentiate or Die: Survival in Our Era of Killer Competition, Second Edition

A newly revised and accelerated version of the innovative enterprise vintage, Differentiate or Die, moment variation exhibits you the way to distinguish your items, providers, and enterprise with a purpose to dominate the contest. Veteran advertising guru Jack Trout makes use of real-world examples and his personal precise perception to teach you the way to bind clients on your items for long term good fortune and loyalty.

Reanalysis of the Original Test Data for the Taylor Standard Series: U.S. Navy Department

This booklet offers the result of the reanalysis of the Taylor regular sequence facts, given in a kind which employs a very non-dimensional illustration. the most important geometrical parameters used are beam-draft ratio, longitudinal prismatic coefficient, volumetric coefficient, and wetted-surface coefficient, the latter being redefinitions of Taylor’s displacement-length ratio and wetted-surface coefficient.

Handbook of Ambulatory Anesthesia

Surgical care has passed through a dramatic shift long ago few a long time clear of inpatient-hospital to ambulatory strategies. increasingly more, ambulatory surgical facilities became the power of selection for lots of varieties of operations. Advances in minimally invasive surgical procedure, anesthesia options and different technological advances will in simple terms bring up this pattern within the years forward.

Additional resources for The Deductive Spreadsheet

Sample text

4. A scalar or array formula may embed a logical formula, subject to the constraint that no other requirement is violated. 2 Cognitive Requirements This class of requirements has to do with the general experience of the user during his or her daily interactions with a tool. Therefore, issues that are addressed include the manner in which the graphical interface provides access to the underlying functionalities, the familiarity with respect to similar applications, and the effort involved in using the tool and discovering new features.

Therefore, this book designs the deductive spreadsheet as an extension of a traditional spreadsheet such as Microsoft Excel, Google Spreadsheet, or OpenOffice and LibreOffice Calc with powerful deductive capabilities that can assist an end-user with the process of making decisions and manipulating both symbolic and numerical data. 4 Approach 11 • Internally, this extension takes the form of a logic programming language with a bottom-up evaluation strategy. The deductive and traditional functionalities are smoothly integrated, so that logical reasoning can apply to cells with calculated values, and formulas can refer to cells produced by logical inference.

Recursion is now part of SQL, the standard database query language. There is clearly much inspiration that the design of the deductive spreadsheet can take from databases, and in particular deductive databases. It would be incorrect, however, to think that deductive databases already implement all the requirements of the deductive spreadsheet. Indeed, a database management system is primarily meant to provide efficient access to large amounts of data that necessarily reside on secondary storage.

Download PDF sample

Rated 4.82 of 5 – based on 41 votes