Functional Dependencies in DB Design Theory DefinitionIf we have $$\forall t,u \in R,, t[A_1,\ldots,A_n] = u[A_1,\ldots,A_n] \implies t[B_1,\ldots,B_n] = u[B_1,\ldots,B_n]$$ that is "for every pair of tuples in the relation, if
Optimal Sequence Alignment Using Dynamic Programming The Needleman-Wunsch algorithm is the one of the most popular algorithms for global sequence alignment. Its variant, Smith-Waterman algorithm is used for local alignment. Needleman-WunschCreating the Matrix and Utility MethodsThe
Constructing Scoring Matrices for Optimal Sequence Alignment Constructing PAM1 MatrixFirst, we define the frequency \(f(j)\) and relative mutability \(m(j)\) of a given animo acid j as: $$ f(j)=\frac{n(j)}{N} $$ where \(n(j)
On SQL DDL TypesTable attributes have types. Here are some built-in types: CHAR(n): fixed-length string of n characters, padded with blanks if necessary.VARCHAR(n): variable length string of up to n characters.TEST: variable-length, unlimited.INT/INTEGER: integerFLOAT/REAL: floating point numbersBOOLEANDATE, TIME, TIMESTAMP: date
Tech Change to UWP Packaging and Signing Behavior in Visual Studio 2019 and Its Effect on Azure Pipelines In prior versions of Visual Studio, a temporary certificate file is automatically generated to sign the UWP package. The temporary certificate is named App_TemporaryKey.pfx. If we associate the
Thoughts Okay, here's the Surface Neo & Duo Finally, after years of waiting, Microsoft released its dual-screen tablet and phone-- Surface Neo and Surface Duo. That's nice! And honestly, I am very excited to see the launch of
Tech About GradeTree As a CPS student, I am very glad to see the debut of the brand-new student portal, namely Aspen, provided by Follett. Admittingly, the new portal provides students with a
Tech Windows's system media transport controls may unexpectedly convert some Japanese words to ligature The Windows's system media transport controls (i.e. the built-in media control when you play background music) seem to be attempting to convert some Japanese words into ligature characters which are obsolete in the modern Japanese writing system. This bug is found happening in
Tech CSAPP Datalab (New) CMU updated their lab questions for CSAPP last year, and many solutions online are actually outdated. I'm trying to figure out these questions and I'll post my solutions for the latest Data Lab with some explanations here. Hope this could be helpful if you
Tech Notes for Introduction to Computer Systems: Integer Representation Check out the course offered by CMU at https://www.cs.cmu.edu/afs/cs/academic/class/15213-f15/www/schedule.html Encoding byte values1 byte = 8 bitsRange from:Binary 00000000 to 11111111Decimal 0 to 255Hexidecimal 00 to FFBoolean algebraRelationship with set operationAnd (&) =>
Tech Hello, Composition World - Part 2 Congratulations! You have finished the effect part. Now, let's talk about something more interesting. Time to talk about some animations The Composition API provides a powerful animation engine which allows us to create quick and fluent animations with high performance. Developers can improve the
Tech Deploy Python web app to Azure Web Service Azure App Service provides us with a fully-managed platform for us to run our web apps. We can deploy ASP.NET web apps quickly to Azure without any complicated configurations.
Tech Hello, Composition World - Part 1 What's this post for?As one of the most important parts of UI/UX design in UWP platform, the significant of Composition API has been referred several times in the
Tech Connect to localhost in UWP apps (desktop) Note: Refer to the answer on Stackoverflow (http://stackoverflow.com/questions/17833232/cannot-connect-to-localhost-in-windows-store-application) By default Visual Studio adds an exception in the NetIsolation which permits and denies local loopback/localhost access. You need to add your app as an exception in this list, however
Tech Why does Device Portal keep crashing? During the development of Device Manager, a bug has bothered me for a long time. Every time I tried to call the APIs in Device Portal through 127.0.0.
Getting Started Quick Shutdown for Windows 10 Mobile [English] Quick Shutdown is an one-key device shutdown helper application. You can shut down your phone with one click using this app without clicking your power button. You need to
Tech Compute SHA1 of byte array in UWP HashAlgorithmProvider is provided in Windows.Security.Cryptography.Core, which allows developer to compute SHA1 values of byte arrays. First at all, we need to make reference to Windows.Security.Cryptography.Core using Windows.Security.Cryptography.Core; Then, create a reusable cryptography hash with the
Tech Generate random bytes with cryptography feature in WinRT(UWP) To generate random bytes in WinRT, we need to use the APIs provided in Windows.Security.Cryptography.CryptographicBuffer Use the following codes to generate a random buffer: Windows.Security.Cryptography.CryptographicBuffer.GenerateRandom(length); And use the IBuffer.ToArray() to convert the random buffer into
Tech Use Brokered WinRT Component in UWP To access legacy functionalities and APIs such as .NET APIs, we have a few ways: Using the Named Pipe or socket to interact with the exterior thread; using the runtime broker; Using rpcrt4. In this passage, I will talk about how to use runtime
Tech Use Reactive Extensions to do high-cost operation in TextChanged event We use TextChanged event to do some operations when the content of textbox changed. It's okay to do some easy operations in TextChanged event but if you want to do some high-cost operation like database querying or IO operating in frequent-triggered event like TextChanged