Bøger af Stefan Ardeleanu

Lots of SQL code illustrate a simple but not exotic example of a software application: a data transfer between two computer systems. An SQL exercise, a practical example to show the simplicity and power of this so popular language, which, used correctly, can still work wonders. A non-fiction book with elements of fiction is one of the paradoxes of this book written by an SQL programmer who loves to write and does not necessarily have an extremely technical style. This combination of elements makes the book enjoyable, not only useful. Here you can find a book full of SQL scripts, using perhaps the most popular database systems: SQL Server and Oracle. As Stefan calls it, this SQL exercise can be helpful in many categories of people, programmers of all kinds who use the SQL language, students at computer science universities, analysts or testers in IT companies, etc. Because, despite its age, the SQL language is still very current. And another big paradox is that the quality of SQL code is often poor enough to create severe problems in many computer systems. In a way, this book is a continuation of the previous one, Relational Database Programming: A Set-Oriented Approach, where the author tries to promote the set-based style of development in the relational database. This style is considered the default here, and this SQL exercise illustrates this programming paradigm. Today, the SQL language is somehow hidden in the shadows, like the balrog of the "Lord of the Rings." A programmer like Gandalf could use his walking stick and bring to the light what is best in this language. That's what Stefan is trying to do in this book. Nowadays, a lot of SQL code is written and maintained by application developers like Java or C#. Sometimes this is not an issue, but quite often, it is. However, certain types of systems only manipulate data in a relational format, and it would be a bad idea not to use anything else than SQL. Speedy is a kind of such system.Now, in the age of the cloud, artificial intelligence, and the attack of new technologies, is SQL still relevant? Despite more than half a century of existence, the SQL language is still present almost everywhere. Almost everyone uses this language. This broad applicability seems to be the cause of many performance issues, as the simplicity of the language is only apparent. It is effortless for any programmer to write sub-optimal SQL code, which causes excessive execution times and even blockages of all kinds.This SQL exercise will be an active-passive one. If one wants, the reader can practice because Stefan challenges the user to continue his work on one side or another. This SQL exercise is an open one, and the reader has the freedom and is encouraged to continue Stefan's work. There is some homework inside the book, and the author hopes that some readers will effectively use what's here in their projects. Apart from the main book goal, the SQL knowledge, the author gives a specific note to his work, partially narrative and fictional. The series of fictional characters who live in the book "Speedy" provide a splash of color to a technical book and, on the other hand, once again confirms the pragmatic note of the SQL language, such a natural and intuitive language. Just see the main keywords of SQL and see such common words as select, insert or delete. Master Johnny and Jean-Luc, Angelique, and Joanna are not just simple characters of a software company. These characters are reflections of the language, after all.

Dieser Band präsentiert die erste pan-mediterrane Synopsis spätantiker Bestattungspraktiken, welche eine Fülle von archäologischen und epigraphischen Zeugnissen kombiniert und kontextualisiert. In 17 Beiträgen erörtert eine Gruppe internationaler Fachleute Grabbefunde aus 14 spätantiken Landschaften, um sowohl die große Vielfalt mikroregionaler und lokaler Praktiken in den Bestattungskulturen als auch die Bedeutung globaler Trends aufzuzeigen. In diesem Band werden verschiedene neue methodische Ansätze angewandt: die Materialität von Epitaphien und Gräbern, ihre Sichtbarkeit, ihre Zugänglichkeit, ihre Wahrnehmung, ihre Einbettung in sich ver-ändernde räumliche Umgebungen sowie ihre entscheidende Rolle im Rahmen sozialer Verhandlungsprozesse werden berücksichtigt. Das Buch stellt unser Verständnis der Bestattungsgewohnheiten und des Totengedenkens in der Übergangsphase der ,Langen' Spätantike auf eine völlig neue Grundlage.

Learn the best way of writing code to run inside a relational database. This book shows how a holistic and set-oriented approach to database programming can far exceed the performance of the row-by-row model that is too often used by developers who haven't been shown a better way. Two styles of programming are encountered in the database world. Classical programming as taught in many universities leads to an atomic, row-oriented, and procedural style inspired by the structured models of programming. In short, many application developers write in the relational database exactly like in the user interface. The other style of programming is holistic, data set oriented, and coded mainly in SQL. This is the style of the database developer.The set based and holistic style of development is not promoted enough in universities, and many application developers are not fully aware of it. There are many performance issues all over the world in relational databases due to the use of the atomic and inappropriate style of programming. This book compares the two styles, and promotes the holistic style of development as the most suitable one. Examples are given to demonstrate the superiority of a set-based and holistic approach.Compares the two styles of developmentShows the performance advantages of set-based developmentSolves example problems using both approachesWho This Book Is ForTwo Styles of Database Development is aimed at application developers willing to adapt their programming styles in return for better-performing applications. It's for students and new developers wanting to position themselves as having database expertise and build a reputation for developing highly-performant database applications.