A novel approach to developing and applying databases with Visual C#.NET Practical database programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NE...
详细信息
ISBN:
(数字)9780470567845
ISBN:
(纸本)9780470467275
A novel approach to developing and applying databases with Visual C#.NET Practical database programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual *** and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features: Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers A real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle database 10g XE Release 2) used throughout the entire book Step-by-step details on designing and building a practical relational database Discussion and analysis of the new database query technique, LINQ API—which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML—and implementation in actual projects with line-by-line explanation Homework and selected solutions for each chapter to strengthen and improve learning and understanding An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download E-mail assistance from the author Readers who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields. To obtain instructor materials please send an email to pressbooks@*** Note: CD-ROM/DVD
database programming refers to the database side to complete the application business logic, database monitoring as well as their implementation and use of triggers, stored procedures and stored functions. The main tr...
详细信息
database programming refers to the database side to complete the application business logic, database monitoring as well as their implementation and use of triggers, stored procedures and stored functions. The main triggers are used to achieve the strengthening of table constraint, table synchronization, and audit functions. Both stored procedures and functions can be implemented by business logic related data, but the only difference between the two is that the stored function must have a return value, whereas the stored procedure does not. The process is referred to below those three collectively. The operation of database can be realized on the application side, as well as be achieved by the process on the database side. However, from the perspective of system performance, the database side can achieve superior implementations to the application-side.
This Paper outlines the use of Prolog for implementing object-oriented databases (OODBs), to indicate both the benefits and costs associated with Prolog as an implementation platform. The different roles which Prolog ...
详细信息
This Paper outlines the use of Prolog for implementing object-oriented databases (OODBs), to indicate both the benefits and costs associated with Prolog as an implementation platform. The different roles which Prolog can play in the implementation of an OODB are illustrated hy reference to example systems which, although they use Prolog as an implementation language, have significantly different architectures. These architectures are compared and assessed, both in terms of the functionality provided to users, and performance.
A substantial portion of the database programming efforts are invested in integrity constraints enforcement. Traditionally, both the constraint semantics and their enforcement were embedded inside application programs...
详细信息
A substantial portion of the database programming efforts are invested in integrity constraints enforcement. Traditionally, both the constraint semantics and their enforcement were embedded inside application programs. In recent years several studies have dealt with specifying integrity constraints as separate entities (e.g. rules), and relating the database consistency requirements to these rules. In this paper we deal with the complementary issue of stabilizing the database when update exceptions occur. While a simplistic approach is to abort any transaction that inflicts consistency violations, this is not always the desired action. We take advantage of the empirical observation that most of the exception-handling policies follow a small number of behavior patterns. Unlike some previous approaches that base their repair solution on syntactic analysis of the constraints and performance issues, we base our approach on the application semantics as reflected in these behavioral patterns. We describe a model that uses high-level abstractions called stabilizer types denoting these behavior patterns for consistency restorations, whose exact semantics is case dependent. It follows the fault tolerance's self-stabilization approach. An inference mechanism translates these abstractions into executable active rules. This approach provides high-level language to the exception handling portion of the application and substantially reduces the required programming. (C) 1998 Elsevier Science B.V. All rights reserved.
This paper presents an approach to the development of a deductive object-oriented database system, describing the key design decisions and their consequences for implementation. The approach is novel, in that it integ...
详细信息
This paper presents an approach to the development of a deductive object-oriented database system, describing the key design decisions and their consequences for implementation. The approach is novel, in that it integrates an object-oriented database system manipulated using an imperative programming language (ROCK) with a logic language for expressing queries and methods (ROLL). The integration is made seamless by deriving both the imperative and logic languages from a single formally defined data model, thereby avoiding impedance mismatches when they are integrated.
Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your databaseKey Features• Master advanced concepts of PostgreSQL 11 with real-world datasets and examples• Explore query parallelism, data r...
详细信息
ISBN:
(数字)9781789539172
ISBN:
(纸本)9781789537819
Master the capabilities of PostgreSQL 11 to efficiently manage and maintain your database
Key Features
• Master advanced concepts of PostgreSQL 11 with real-world datasets and examples
• Explore query parallelism, data replication, and database performance while working with larger datasets
• Extend the functionalities of your PostgreSQL instance to suit your organization’s needs with minimal effort
Book Description
This second edition of Mastering PostgreSQL 11 helps you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL, which enables database analysts to design both the physical and technical aspects of the system architecture with ease.
This book begins with an introduction to the newly released features in PostgreSQL 11 to help you build efficient and fault-tolerant PostgreSQL applications. You’ll examine all of the advanced aspects of PostgreSQL in detail, including logical replication, database clusters, performance tuning, monitoring, and user management. You will also work with the PostgreSQL optimizer, configuring PostgreSQL for high speed, and see how to move from Oracle to PostgreSQL. As you progress through the chapters, you will cover transactions, locking, indexes, and optimizing queries to improve performance. Additionally, you’ll learn to manage network security and explore backups and replications, while understanding the useful extensions of PostgreSQL so that you can optimize the speed and performance of large databases.
By the end of this book, you will be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.
What you will learn
• Get to grips with advanced PostgreSQL 11 features and SQL functions
• Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
• Work with stored procedures and manage backup and recovery
• Master replication and failover techniques
• Troubleshoot your PostgreSQL instance for
Active learning facilitated through interactive and adaptive learning environments differs substantially from traditional instructor-oriented, classroom-based teaching. We present a web-based e-learning environment th...
详细信息
Active learning facilitated through interactive and adaptive learning environments differs substantially from traditional instructor-oriented, classroom-based teaching. We present a web-based e-learning environment that integrates knowledge learning and skills training. How these tools are used most effectively is still an open question. We propose knowledge-level interaction and adaptive feedback and guidance as central features. We discuss these features and evaluate the effectiveness of this web-based environment, focusing on different aspects of learning behaviour and tool usage. Motivation, acceptance of the approach, learning organisation and actual tool usage are aspects of behaviour that require different evaluation techniques to be used.
Polyglot programming, the use of multiple programming languages during the development process, is common practice in modern software development. This study investigates this practice through a randomized controlled ...
详细信息
ISBN:
(纸本)9781450370431
Polyglot programming, the use of multiple programming languages during the development process, is common practice in modern software development. This study investigates this practice through a randomized controlled trial conducted under the context of database programming. Participants in the study were given coding tasks written in Java and one of three SQL-like embedded languages. One was plain SQL in strings, one was in Java only, and the third was a hybrid embedded language that was closer to the host language. We recorded 109 valid data points. Results showed significant differences in how developers of different experience levels code using polyglot techniques. Notably, less experienced programmers wrote correct programs faster in the hybrid condition (frequent, but less severe, switches), while more experienced developers that already knew both languages performed better in traditional SQL (less frequent, but more complete, switches). The results indicate that the productivity impact of polyglot programming is complex and experience level dependent.
This paper presents SELINKS, a programming language focused on building secure multi-tier web applications. SELINKS provides a uniform programming model, in the style of LINQ and Ruby on Rails, with language syntax fo...
详细信息
ISBN:
(纸本)9781605585543
This paper presents SELINKS, a programming language focused on building secure multi-tier web applications. SELINKS provides a uniform programming model, in the style of LINQ and Ruby on Rails, with language syntax for accessing objects residing either in the database or at the server. Object-level security policies are expressed as fully-customizable, first-class labels which may themselves be subject to security policies. Access to labeled data is mediated via trusted, user-provided policy enforcement functions. SELINKS has two novel features that ensure security policies are enforced correctly and efficiently. First, SELINKS implements a type system called Fable that allows a protected object's type to refer to its protecting label. The type system can check that labeled data is never accessed directly by the program without, first consulting the appropriate policy enforcement function. Second, SELINKS compiles policy enforcement code to database-resident user-defined functions that can be called directly during query processing. database-side checking avoids transferring data to the server needlessly, while still allowing policies to be expressed in a customizable and portable manner. Our experience with two sizable web applications, a model health-care database and a secure wiki with fine-grained security policies, indicates that cross-tier policy enforcement in SELINKS is flexible, relatively easy to use, and, when compared to a single-tier approach, improves throughput by nearly an order of magnitude. SELINKS is freely available.
This paper reports on our industry-academia project of using a functional language in business software production. The general motivation behind the project is our ultimate goal of adopting an ML-style higher-order t...
详细信息
ISBN:
(纸本)9781450328739
This paper reports on our industry-academia project of using a functional language in business software production. The general motivation behind the project is our ultimate goal of adopting an ML-style higher-order typed functional language in a wide range of ordinary software development in industry. To probe the feasibility and identify various practical problems and needs, we have conducted a 15 month pilot project for developing an enterprise resource planning (ERP) system in SML#. The project has successfully completed as we have planned, demonstrating the feasibility of SML#. In particular, seamless integration of SQL and direct C language interface are shown to be useful in reliable and efficient development of a data intensive business application. During the program development, we have found several useful functional programming patterns and a number of possible extensions of an ML-style language with records. This paper reports on the project details and the lessons learned from the project.
暂无评论